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

[Steven Marshall <..hidden..>]

On Nov 4, 2011, at 5:20 PM, "David A. Bandel" <..hidden..> wrote:

> 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?
>

I confirmed my postgresql-contrib directory existed and was properly
entered in Ledgersmb.conf.  Looking at dblog_stderr it appears to be
bombing in Pg-database.sql during the table creation of
account_link_description where it is inserting values.

>
>> 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
> --
> Two things are infinite: the universe and human stupidity; and I'm not
> sure about the the universe. -- Albert Einstein
> Visit my web page at: http://david.bandel.us/
>
> ------------------------------------------------------------------------------
> 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