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

[Astrid Emde (WhereGroup)]

Hello Kartsten,

please try

app/console mapbender:config:check

https://doc.mapbender.org/en/customization/commands.html#app-console-mapbender-config-check

Looks like Mapbender can not create the connection to the database.

Is everything installed?

sudo apt install php-gd php-curl php-cli php-xml php-sqlite3 sqlite3 
php-apcu php-intl openssl php-zip php-mbstring php-bz2


Try also to connect to your database via psql

psql -U mydbuser

(maybe create the database mapbender and try to connect)
psql -U mydbuser mapbender

Astrid

Am 2020-07-03 07:28, schrieb Härtel:
> 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# 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
>> 
>> https://lists.osgeo.org/mailman/listinfo/mapbender_users
> 
> --
> 
> -----------------------------------------
> 
> Aufwind durch Wissen!
> 
> Qualifizierte Open-Source-GIS-Schulungen
> 
> bei der www.foss-academy.com [1]
> 
> -----------------------------------------
> 
> 
> Links:
> ------
> [1] http://www.foss-academy.com
> _______________________________________________
> Mapbender_users mailing list
> Mapbender_users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapbender_users

-- 
Mit freundlichen Grüßen

Astrid Emde
GIS-Consultant

  -----------------------------------
  Aufwind durch Wissen!
  Jetzt neu: Webinare und Online-Schulungen
  bei der www.foss-academy.com
  -----------------------------------

   Astrid Emde
   WhereGroup GmbH
   Eifelstraße 7
   53119 Bonn
   Germany

   Fon: +49(0)228 90 90 38 - 22
   Fax: +49(0)228 90 90 38 - 11

   astrid.emde at wheregroup.com
   www.wheregroup.com

   Folgen Sie der WhereGroup auf twitter:
http://twitter.com/WhereGroup_com

Geschäftsführer:
Olaf Knopp, Peter Stamm
Amtsgericht Bonn, HRB 9885
-------------------------------