Hi all I followed your howto install ledgersmb published on the website: http://www.howtoforge.com/ledgersmb_debian_etch OS: ubuntu 10.04 However when I logon using http://localhost/ledgersmb/admin.pl It goes through successfully but when I enter my password it pops out the following error message below: Error! LedgerSMB/Session/DB.pm:187: Fetch sequence id: ERROR: function md5(double precision) does not exist LINE 1: SELECT nextval('session_session_id_seq'), md5(random()); ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Any suggestion will highly appreciated Thanks Ashlacoste
Hi all I managed to solve my problem after a sleepless night yesterday. What I did is: I went to the directory "/usr/local/ledgersmb/LedgerSMB/Session" and found the DB.pl file. Opened the file for editing and where it says: $dbh->prepare("SELECT nextval('sessione_session_id_seq'), md5(random());"); change to $dbh->prepare("SELECT nextval('session_session_id_seq'), md5(random()::text);"); obviously you need to have privileges to edit the file. Then the last step was to restart the apache server. Walaah! it worked like charm. Thanks Ashlacoste