Koozali.org: home of the SME Server

Obsolete Releases => SME VoIP (Asterisk, SAIL etc) => Topic started by: chris burnat on October 20, 2006, 10:37:45 AM

Title: SAIL - Database error: pconnect(localhost in CDR report
Post by: chris burnat on October 20, 2006, 10:37:45 AM

After doing a restore of users on a freshly installed server,  the CDR panel in SAIL no longer works [https://my-server/stst]  .  The error shown is:

Database error: pconnect(localhost, asterisk, $Password) failed.
MySQL Error: ()
Database error: pconnect(localhost, asterisk, $Password) failed.
MySQL Error: ()
Database error: pconnect(localhost, asterisk, $Password) failed.
MySQL Error: ()
Database error: pconnect(localhost, asterisk, $Password) failed.
MySQL Error: ()
Database error: next_record called with no query pending.
MySQL Error: ()

I am at a loss on this one.  Tried to uninstall and reinstall SAIL etc to no avail.
Any pointer would be apppreciated. Thanks. chris.

Title: SAIL - Database error: pconnect(localhost in CDR report
Post by: chris burnat on October 20, 2006, 11:31:29 AM

Found the solution.  Noticed that when reinstalling selintra, there was a warning about a database "asterisk" already existing .  Uninstalled again (rpm -e) all asterisk and selintra rpm and done a search:
find / -name asterisk -print

Deleting all dir and files name asterisk did the trick: reinstalled and its working now.
I think that the problem was one of the following, no time to repeat to identify culprit:

/usr/lib/asterisk
/usr/sbin/asterisk
/var/lib/asterisk
/var/lib/mysql/asterisk
/var/spool/asterisk
/etc/asterisk