[Geocoding] Nominatim data import error: DB Error: connect failed

[Nyx]

I am now getting the error:

Create DB
Setup DB
unable to find /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql

----

I looked into setup.php and see the line

pgsqlRunScriptFile(CONST_Path_Postgresql_Postgis.'/postgis.sql');

This is probably what's defining
`/usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql`. However I
believe I have postgis 2 installed (yum list
postgis2*). /usr/share/postgresql/ does not exist. How should this link be
fixed? Thank you once again! :)


On Wed, Sep 12, 2012 at 6:18 PM, Sarah Hoffmann <lonvia at denofr.de> wrote:

> On Wed, Sep 12, 2012 at 04:51:05PM -0400, Nyx wrote:
> > I tried commenting out the line `passthru('createlang plpgsql
> > '.$aDSNInfo['database']);`. When I run the import command, I get the
> ouput:
> >
> > Create DB
> > Setup DB
> > unable to start pgsql
> >
> > ----
> >
> > When I tried running `psql -p 5432 -d nominatim` I am able to connect to
> > the database `nominatim`.
>
> If that works from the command line then the only other thing I could think
> of is that your php configuration does not allow psql to be executed or
> cannot
> find it. Also the script writes to /dev/null. Make sure that your user and
> php are allowed to do that.
>
> > However when I check the contents of the database `nominatim`, I still do
> > not see anything added to the table.
>
> That is normal because the setup process dies before doing anything useful.
>
> Sarah
>
>
> >
> > On Wed, Sep 12, 2012 at 12:17 PM, Sarah Hoffmann <lonvia at denofr.de>
> wrote:
> >
> > > On Wed, Sep 12, 2012 at 03:46:47PM +0200, Frederik Ramm wrote:
> > > > Hi,
> > > >
> > > > On 09/12/12 15:34, Nyx wrote:
> > > > >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"
> > > >
> > > > 9.x versions of PostgreSQL have plpgsql activated by default. I
> > > > don't know if that is a problem but maybe you should comment out the
> > > > line that executes the "createlang" command.
> > >
> > > This error can be ignored. The setup actually went past it. The
> interesting
> > > error was this one:
> > >
> > > > unable to start pgsql
> > >
> > > This means that psql still does not work correctly. What it tries is
> this:
> > >
> > > psql -p 5432 -d nominatim
> > >
> > > Sarah
> > >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20120913/34722de9/attachment.html>