Re: Mac OSX issues continued

[Jigme Datse Yli-Rasku <..hidden..>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sat May 26 17:22:20 2012, Jigme Datse wrote:
> On Sat, May 26, 2012 at 4:40 PM, Chris Travers <..hidden..> wrote:
>> On Sat, May 26, 2012 at 1:05 PM, Jigme Datse Yli-Rasku
>> <..hidden..> wrote:
>> PostgreSQL 9.1 then?
>
> Yes.
>
>> How did you install it?  If from source go back to your source
>> directory and cd to contrib, make, and make install.
>
> MacPorts.
>
>> I checked and the contrib directory structure is the same on 9.1 as
>> 9.0.  So you may find the following article helpful:
>>
>> https://wiki-bsse.ethz.ch/display/ITDOC/Get+PostgreSQL+contrib+modules+on+Mac+OS+X
>
> That looks like it will give me what I need.

This got me further.  Now I've got to creating the database, setting up
everything and when it goes to create the database (after selecting
what template to use) I get:

Error!

42883:ERROR: function public.person__list_salutations() does not exist
LINE 1: SELECT * FROM "public"."person__list_salutations"() ^ HINT: No
function matches the given name and argument types. You might need to
add explicit type casts.

And in error_log:

[Sat May 26 20:56:15 2012] [error] [client 127.0.0.1] DBI
connect('dbname=datsemultimedia','postgres',...) failed: FATAL:
database "datsemultimedia" does not exist at LedgerSMB/Database.pm line
271, referer: http://localhost/ledgersmb/setup.pl
[Sat May 26 20:56:33 2012] [error] [client 127.0.0.1] 2012/05/26
20:56:33 - INFO - LedgerSMB::Scripts::setup::create_db --
create_and_load rc=1, referer: http://localhost/ledgersmb/setup.pl
[Sat May 26 20:57:03 2012] [error] [client 127.0.0.1] DBD::Pg::st
execute failed: ERROR:  function public.person__list_salutations() does
not exist, referer: http://localhost/ledgersmb/setup.pl
[Sat May 26 20:57:03 2012] [error] [client 127.0.0.1] LINE 1: SELECT *
FROM "public"."person__list_salutations"(), referer:
http://localhost/ledgersmb/setup.pl
[Sat May 26 20:57:03 2012] [error] [client 127.0.0.1]
    ^, referer: http://localhost/ledgersmb/setup.pl
[Sat May 26 20:57:03 2012] [error] [client 127.0.0.1] HINT:  No
function matches the given name and argument types. You might need to
add explicit type casts. at LedgerSMB.pm line 828., referer:
http://localhost/ledgersmb/setup.pl
[Sat May 26 20:57:03 2012] [error] [client 127.0.0.1] 2012/05/26
20:57:03 - ERROR - LedgerSMB::dberror LedgerSMB.pm (1085) -- Logging
SQL State 42883, error 7, string ERROR:  function
public.person__list_salutations() does not exist, referer:
http://localhost/ledgersmb/setup.pl
[Sat May 26 20:57:03 2012] [error] [client 127.0.0.1] LINE 1: SELECT *
FROM "public"."person__list_salutations"(), referer:
http://localhost/ledgersmb/setup.pl
[Sat May 26 20:57:03 2012] [error] [client 127.0.0.1]
    ^, referer: http://localhost/ledgersmb/setup.pl
[Sat May 26 20:57:03 2012] [error] [client 127.0.0.1] HINT:  No
function matches the given name and argument types. You might need to
add explicit type casts., referer: http://localhost/ledgersmb/setup.pl
[Sat May 26 20:57:03 2012] [error] [client 127.0.0.1] Issuing
rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db
handle dbname=datsemultimedia at /usr/local/ledgersmb/setup.pl line 8.,
referer: http://localhost/ledgersmb/setup.pl
[Sat May 26 20:57:03 2012] [error] [client 127.0.0.1] Directory index
forbidden by Options directive: /usr/local/ledgersmb/css/, referer:
http://localhost/ledgersmb/setup.pl
[Sat May 26 20:57:03 2012] [error] [client 127.0.0.1] File does not
exist: /Library/WebServer/Documents/favicon.ico

I'm not sure where to look.  I've put enough work in for tonight I
think.  More time tomorrow of course.

Jigme Datse Yli-Rasku

-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.18 (Darwin)
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJPwafvAAoJEPTTlG5JFW+7N0kIAIaAYwzvkahwjGS8clg5QAPj
USDYJf4/nLLKaPfi4q550upV61ytt9DMcoaBEAe/iP/5HbWGIl4Jn6VIzsNAm5Bp
HIoYgWyGu/d2yvQ7NOKLVNUqu1e0jNLoGIxg7lro2zL6d1JZbdm0IwRjeooZ+GxY
kyuZ5QdBsx6zO/oZgrAOoqeETGQVqZyu1K5baNVZmduesXevQUmPtrKdueLhUdk7
C7otGolHxAfSD8qW/KvoZvOSMm/54XaniryhVHihQea06JdyElqYiL6AfgBLiDz0
ssdRz8E23vtJmQRa0qudxUqupT2eBIpGd7B2+zuUG1FB1NgA3BYoavEdpeu7gtI=
=HbNY
-----END PGP SIGNATURE-----


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users