[Mapbender-users] error with app/consoledoctrine:database:create

[Härtel, Connor]

Hi Karsten,

is postgres extension for php correctly installed and active on the machine?
Can you login and connect to any database from command line?

Cheers,
Connor

Von: Mapbender_users [mailto:mapbender_users-bounces at lists.osgeo.org] Im Auftrag von karsten
Gesendet: Dienstag, 30. Juni 2020 12:14
An: 'Mapbender User List'
Betreff: Re: [Mapbender-users] error with app/consoledoctrine:database:create

Hi David,

thanks I tried but got same error :(
I also reinstalled postgres (now version 9.6 ) to no avail

Any other hints ?

Cheers
Karsten


________________________________
From: Mapbender_users [mailto:mapbender_users-bounces at lists.osgeo.org] On Behalf Of David Patzke
Sent: Tuesday, June 30, 2020 02:27
To: mapbender_users at lists.osgeo.org
Subject: Re: [Mapbender-users] error with app/consoledoctrine:database:create

Hi Karsten,

can you try 127.0.0.1 instead of localhost. localhost is not treaten the same as 127.0.0.1 in the default  pg_hba.conf.

David
On 30.06.20 11:23, karsten wrote:
Hi All,

I am trying to install mapbender 3.08 (also tried 3.0.5) on an Ubuntu 16 server

I have tried the versions from git the zip and the *.gz version , I can run and connect to teh mapbender installation when using the demo.sqlite file Db but when I am trying to use postgres as the database - No matter what version I used I am always getting the following error when running  app/console doctrine:database:create

user1 at terraxyz:/var/www/mapbender<mailto:user1 at terraxyz:/var/www/mapbender># app/console doctrine:database:create

  [Doctrine\DBAL\Exception\ConnectionException]
  An exception occured in driver: SQLSTATE[08006] [7] timeout expired

  [Doctrine\DBAL\Driver\PDOException]
  SQLSTATE[08006] [7] timeout expired

  [PDOException]
  SQLSTATE[08006] [7] timeout expired

This is in my   parameters.yml

    database_driver:   pdo_pgsql
    database_host:     localhost
    database_port:     5432
    database_name:     mapbender
    database_path:     ~
    database_user:     mydbuser
    database_password: supersecret

    mailer_transport:  smtp
    mailer_host:       localhost
    mailer_user:       ~
    mailer_password:   ~
There are no messages opr errors in the postgresql.log file ...

Any ideas what si wrong and how to fix it ?

Cheers
Karsten Vennemann

Terra GIS LTD



_______________________________________________

Mapbender_users mailing list

Mapbender_users at lists.osgeo.org<mailto:Mapbender_users at lists.osgeo.org>

https://lists.osgeo.org/mailman/listinfo/mapbender_users

--

-----------------------------------------

Aufwind durch Wissen!

Qualifizierte Open-Source-GIS-Schulungen

bei der www.foss-academy.com<http://www.foss-academy.com>

-----------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20200703/34c45338/attachment.html>