[Geocoding] Nominatim data import error: DB Error: connect failed
Nyx
nyxynyx at gmail.com
Wed Sep 12 14:34:15 BST 2012
Hi, thanks for the help so far. Some how I manage to get past that error.
Now when doing the import command, I get:
Create DB
Setup DB
createlang: language "plpgsql" is already installed in database "nominatim"
unable to start pgsql
----
I have already disabled open_basedir using WHM but is still getting this
error. I also see a database `nominatim` being created after running this
command, which I delete before retrying the import again. What should I try
next?
On Wed, Sep 12, 2012 at 8:54 AM, Frederik Ramm <frederik at remote.org> wrote:
> Hi,
>
>
> On 09/12/12 14:31, Nyx wrote:
>
>> > Yup it does, doing `psql postgres` got me in:
>> >
>> > psql (9.1.5)
>> > Type "help" for help.
>> >
>> > postgres=#
>>
>
> Actually, this will use the unix domain socket to connect, whereas PHP
> seems to have tried a TCP connection:
>
>
> > > > ["dsn"]=>
>> > > > array(9) {
>> > > > ["phptype"]=>
>> > > > string(5) "pgsql"
>> > > > ["dbsyntax"]=>
>> > > > string(5) "pgsql"
>> > > > ["username"]=>
>> > > > string(0) ""
>> > > > ["password"]=>
>> > > > bool(false)
>> > > > ["protocol"]=>
>> > > > string(3) "tcp"
>> > > > ["hostspec"]=>
>> > > > string(0) ""
>> > > > ["port"]=>
>> > > > bool(false)
>> > > > ["socket"]=>
>> > > > bool(false)
>> > > > ["database"]=>
>> > > > string(9) "nominatim"
>> > > > }
>>
>
> So, to properly simulate what PHP does you would have to try
>
> psql postgres -h localhost
>
> Bye
> Frederik
>
> --
> Frederik Ramm ## eMail frederik at remote.org ## N49°00'09" E008°23'33"
>
>
> ______________________________**_________________
> Geocoding mailing list
> Geocoding at openstreetmap.org
> http://lists.openstreetmap.**org/listinfo/geocoding<http://lists.openstreetmap.org/listinfo/geocoding>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20120912/161fb59a/attachment-0001.html>
More information about the Geocoding
mailing list