Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 12th March 2011, 13:50
Ashlacoste Ashlacoste is offline
HowtoForge Supporter
 
Join Date: Mar 2011
Posts: 2
Thanks: 0
Thanked 1 Time in 1 Post
Default Howto ledgersmb ubuntu 10.04 - admin.pl error message

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
Reply With Quote
Sponsored Links
  #2  
Old 13th March 2011, 09:44
Ashlacoste Ashlacoste is offline
HowtoForge Supporter
 
Join Date: Mar 2011
Posts: 2
Thanks: 0
Thanked 1 Time in 1 Post
 
Smile Howto ledgersmb ubuntu 10.04 - admin.pl error message

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
Reply With Quote
The Following User Says Thank You to Ashlacoste For This Useful Post:
falko (13th March 2011)
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Vmware server 2.0.2-x with Ubuntu server 10.04 VMware Remote Console Plug-in letsharehowto HOWTO-Related Questions 12 6th December 2011 20:23
postfix-policy pb with How to:iRedMail 0.6.1: Open Source Mail Server On Ubuntu 10.04 snarf77 HOWTO-Related Questions 9 17th September 2010 11:35
Problem send/receive Courier+Postfix+Squirrelmail Pirk Installation/Configuration 2 21st May 2010 13:26
Connection timed out on intermail outgoing mails gouravgarg Server Operation 6 5th March 2010 20:31
Unbale to login to Postfix from webmail wasimriz HOWTO-Related Questions 5 6th April 2009 13:49


All times are GMT +2. The time now is 17:29.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.