Re: Setup.pl fails on database setup on new installation

[Philippe Schelté <..hidden..>]

I have installed the package postgresql-contrib, I have given this path :

/usr/share/postgresql/9.1/extension

I have verrified it exists and have hundred sql scripts in.

I have always the same error as Steven.

Do I have to execute one of those script before upgrading ?

Best.

Philippe



Le 04/11/2011 20:19, David A. Bandel a écrit :
> On Fri, Nov 4, 2011 at 11:11, Steven Marshall
> <..hidden..>  wrote:
> > I have brand new installation of 1.3.3 with I believe all prereqs.
> >
> > 1. Created Postgresql superuser "ledgersmb"
> > 2. From browser navigate to http://localhost/ledgersmb/setup.pl
> > 3. On setup.pl screen enter ledgersmb/password/foo for SuperUser Credentials
> > and click Login button
> > 4. On the Confirm Operation screen I select "Yes" to create database and
> > click Next
> > 5. On the Database Management Console screen select Country Code "Br" and
> > click Next
> Did you check that you have postgresql-contrib (psql-contrib) and
> enter your contrib (extension) directory location?
>
>
> > 6. On next screen select General.sql and click Next
> >
> > Results:
> > Error!
> >
> > 42883:ERROR: function public.person__list_salutations() does not exist
> > HINT: No function matches the given name and argument types. You may need to
> > add explicit type casts.
> database load is incomplete or non-existent -- functions didn't get
> created.  this can happen if you don't have contribs (extensions) or
> didn't specify the correct directory (among other things)
>
> > I opened a bug on this, but wanted to see if anybody in the community has
> > already figured this out.
> >
> > Best Regards,
> > Steven Marshall
> > Sent from my iPad
> > ------------------------------------------------------------------------------
> > RSA(R) Conference 2012
> > Save $700 by Nov 18
> > Register now
> > http://p.sf.net/sfu/rsa-sfdev2dev1
> > _______________________________________________
> > Ledger-smb-users mailing list
> > ..hidden..
> > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
> David A. Bandel


--
http://www.migratis.net