ReportServer Forum

palacio

Member

Registered: 2018-06-27

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)

eduardo

Administrator

Registered: 2016-11-01

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

palacio

Member

Registered: 2018-06-27

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

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??

Regards,

eduardo

Administrator

Registered: 2016-11-01

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

palacio

Member

Registered: 2018-06-27

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

Regards,

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Initialize the ReportServer Database

Hi palacio,

and under schemas: do you see the reportserver tables ?

Regards,
Eduardo

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Initialize the ReportServer Database

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

eduardo

Administrator

Registered: 2016-11-01

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

palacio

Member

Registered: 2018-06-27

Re: Initialize the ReportServer Database

Hi palacio,

and under schemas: do you see the reportserver tables ?

Regards,
Eduardo

No

palacio

Member

Registered: 2018-06-27

Re: Initialize the ReportServer Database

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

eduardo

Administrator

Registered: 2016-11-01

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

palacio

Member

Registered: 2018-06-27

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

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

   

See you. Have a good day

abhijitsen

Member

Registered: 2018-11-26

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