#1 2018-07-09 13:57:39

palacio
Member
Registered: 2018-06-27
Posts: 32

Initialize the ReportServer Database

Hi,

Please I problem when I run this command.

cd /var/lib/tomcat7/webapps/ROOT/ddl/

psql -U reportserver -d reportserver -a -f reportserver-RS3.0.3-6003-schema-PostgreSQL_CREATE.sql


I have this error:
psql: FATAL:  Peer authentication failed for user "reportserver"


I use this topic to install reportserver to my local server: https://reportserver.net/en/tutorials/i … -practice/

How can I resolve it??


Regards,

Last edited by palacio (2018-07-09 14:07:08)

Offline

#2 2018-07-11 07:02:26

eduardo
Administrator
Registered: 2016-11-01
Posts: 829
Website

Re: Initialize the ReportServer Database

Hi palacio,

make sure you can connect to your database with your user "reportserver". Try to connect first from an external tool, e.g. PGAdmin https://www.pgadmin.org/
Are you trying to connect from the same host where your DB is installed?

Regards,
Eduardo

Offline

#3 2018-07-11 08:38:19

palacio
Member
Registered: 2018-06-27
Posts: 32

Re: Initialize the ReportServer Database

eduardo wrote:

Hi palacio,

make sure you can connect to your database with your user "reportserver". Try to connect first from an external tool, e.g. PGAdmin https://www.pgadmin.org/
Are you trying to connect from the same host where your DB is installed?

Regards,
Eduardo

Hi eduardo,

I done it. I get access for my DB "reportserver" to my local server.

Are you trying to connect from the same host where your DB is installed?: YES


I thing that the problem is here /etc/postgresql/9.6/main/pg_hba.conf. I'm trying to resolve it with many solutions I fund in internet but...

Is that my posgresql version?? hmm


Regards,

Offline

#4 2018-07-11 08:59:00

eduardo
Administrator
Registered: 2016-11-01
Posts: 829
Website

Re: Initialize the ReportServer Database

Hi palacio,

what do you see when you connect to your reportserver from within PGAdmin ? Which credentials do you use? "reportserver" and "reportserver" as password ? Can you paste some screenshots ? (use an online tool e.g. https://imgbb.com/ )

Regards,
Eduardo

Offline

#5 2018-07-11 09:27:20

palacio
Member
Registered: 2018-06-27
Posts: 32

Re: Initialize the ReportServer Database

eduardo wrote:

Hi palacio,

what do you see when you connect to your reportserver from within PGAdmin ? Which credentials do you use? "reportserver" and "reportserver" as password ? Can you paste some screenshots ? (use an online tool e.g. https://imgbb.com/ )

Regards,
Eduardo


r1.png
r2.png
r3.png
r4.png


Regards,

Offline

#6 2018-07-11 09:56:50

eduardo
Administrator
Registered: 2016-11-01
Posts: 829
Website

Re: Initialize the ReportServer Database

Hi palacio,

and under schemas: do you see the reportserver tables ?

Regards,
Eduardo

Offline

#7 2018-07-11 09:57:25

eduardo
Administrator
Registered: 2016-11-01
Posts: 829
Website

Re: Initialize the ReportServer Database

Please post also the complete JDBC URL you are using in reportserver (in persistence.properties )

Offline

#8 2018-07-11 09:58:38

eduardo
Administrator
Registered: 2016-11-01
Posts: 829
Website

Re: Initialize the ReportServer Database

You can execute your reportserver-RS3.0.3-6003-schema-PostgreSQL_CREATE.sql from within PGAdmin: just copy and paste the contents into a new query and run the query.

Regards,
Eduardo

Offline

#9 2018-07-11 10:36:22

palacio
Member
Registered: 2018-06-27
Posts: 32

Re: Initialize the ReportServer Database

eduardo wrote:

Hi palacio,

and under schemas: do you see the reportserver tables ?

Regards,
Eduardo


No
r6.png

Offline

#10 2018-07-11 10:42:49

palacio
Member
Registered: 2018-06-27
Posts: 32

Re: Initialize the ReportServer Database

eduardo wrote:

Please post also the complete JDBC URL you are using in reportserver (in persistence.properties )

r5.png

Offline

#11 2018-07-11 10:46:19

eduardo
Administrator
Registered: 2016-11-01
Posts: 829
Website

Re: Initialize the ReportServer Database

Hi palacio,

thanks for the screenshots.
Try to execute your reportserver-RS3.0.3-6003-schema-PostgreSQL_CREATE.sql from within PGAdmin: just copy and paste the contents into a new query and run the query.

Then you should have the tables.

Regards,
Eduardo

Offline

#12 2018-07-11 12:01:25

palacio
Member
Registered: 2018-06-27
Posts: 32

Re: Initialize the ReportServer Database

eduardo wrote:

Hi palacio,

thanks for the screenshots.
Try to execute your reportserver-RS3.0.3-6003-schema-PostgreSQL_CREATE.sql from within PGAdmin: just copy and paste the contents into a new query and run the query.

Then you should have the tables.

Regards,
Eduardo


Oooh Yes! Thank you @eduardo. Every thing is OK.

cool  cool  cool

See you. Have a good day

Offline

#13 2018-11-26 12:31:46

abhijitsen
Member
Registered: 2018-11-26
Posts: 1

Re: Initialize the ReportServer Database

I had same issue I fixed it by following the bellow mentioned steps:

Finally, since PostgreSQL on Ubuntu per default only allows to connect locally via the postgres user, we need to adapt the configuration file /etc/postgresql/9.3/main/pg_hba.conf. Here look for a line containing

local   all             all                                        peer
and replace it by

local   all             all                                        md5
Which allows users that provide a valid password hash to connect. For the changes to take effect we need to restart the postgres service:

$ service postgresql restart

Offline

Board footer

Powered by FluxBB