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.
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 6th July 2008, 00:07
c0mrade c0mrade is offline
Junior Member
 
Join Date: May 2008
Posts: 17
Thanks: 3
Thanked 0 Times in 0 Posts
Default Mail Server Setup With Exim, MySQL, Cyrus-Imapd, Horde Webmail On Centos 5.1 - issue

Hi all,

This howto is really great by the way.. and I think I did everything properly .. I double checked the tutorial .. and done everything twice and I get the same result.. so maybe someone can tell me what did I do wrong?
Quote:
A fatal error has occurred
Could not connect to database for SQL SessionHandler.
Details have been logged for the administrator.
I get this message when I try to run the horde mail for the first time .. you can see it yourself here I used google to look up some possible solutions .. came up with this link but still it didn't help. I'm stuck and really don't know what to do next .. here is my horde.log file
Code:
Jul 04 19:16:05 HORDE [emergency] [horde] Could not connect to database for SQL SessionHandler. [on line 319 of "/usr/share/horde/lib/Horde/S
essionHandler/mysql.php"]
Jul 04 19:16:07 HORDE [emergency] [horde] Could not connect to database for SQL SessionHandler. [on line 319 of "/usr/share/horde/lib/Horde/S
essionHandler/mysql.php"]
Jul 04 19:16:43 HORDE [emergency] [horde] Could not connect to database for SQL SessionHandler. [on line 319 of "/usr/share/horde/lib/Horde/S
essionHandler/mysql.php"]
Jul 04 19:19:01 HORDE [emergency] [horde] Could not connect to database for SQL SessionHandler. [on line 319 of "/usr/share/horde/lib/Horde/S
essionHandler/mysql.php"]
Jul 04 19:20:59 HORDE [emergency] [horde] Could not connect to database for SQL SessionHandler. [on line 319 of "/usr/share/horde/lib/Horde/S
essionHandler/mysql.php"]
Jul 04 19:24:07 HORDE [emergency] [horde] Could not connect to database for SQL SessionHandler. [on line 319 of "/usr/share/horde/lib/Horde/S
essionHandler/mysql.php"]
Jul 04 19:24:23 HORDE [emergency] [horde] Could not connect to database for SQL SessionHandler. [on line 319 of "/usr/share/horde/lib/Horde/S
essionHandler/mysql.php"]
Jul 04 19:25:04 HORDE [emergency] [horde] Could not connect to database for SQL SessionHandler. [on line 319 of "/usr/share/horde/lib/Horde/S
essionHandler/mysql.php"]
Jul 05 12:59:32 HORDE [emergency] [horde] Could not connect to database for SQL SessionHandler. [on line 319 of "/usr/share/horde/lib/Horde/S
essionHandler/mysql.php"]
Jul 05 15:03:24 HORDE [emergency] [horde] Could not connect to database for SQL SessionHandler. [on line 319 of "/usr/share/horde/lib/Horde/S
essionHandler/mysql.php"]
Jul 05 15:04:50 HORDE [emergency] [horde] Could not connect to database for SQL SessionHandler. [on line 319 of "/usr/share/horde/lib/Horde/S
essionHandler/mysql.php"]
Jul 05 15:06:48 HORDE [emergency] [horde] Could not connect to database for SQL SessionHandler. [on line 319 of "/usr/share/horde/lib/Horde/S
essionHandler/mysql.php"]
here is content of line 319 of /usr/share/horde/lib//Horde/S
essionHandler/mysql.php
Code:
 if (!$this->_db = @$connect($this->_params['hostspec'],
                                    $this->_params['username'],
                                    $this->_params['password'])) {
            Horde::fatal(PEAR::raiseError('Could not connect to database for SQL SessionHandler.'), __FILE__, __LINE__);
        }
I really can't figure out what is wrong, maybe my admin.sql ? here it is
Code:
USE horde;
REPLACE INTO horde_users (user_uid,user_pass)
    VALUES (
        'emir@mail.panel.komentari.info',
        md5('ccc1234xxx'),
);
and I get this error from
Code:
ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5
so I changed admin.sql to this
Code:
USE horde;
REPLACE INTO horde_users (user_uid,user_pass)
    VALUES ('emir@mail.panel.komentari.info',md5('ccc1234xxx'));
and it executed without sql error .. so that is possible error but I really can't figure out what went wrong .. Any hints ? Thank you in advance

Last edited by c0mrade; 6th July 2008 at 00:17.
Reply With Quote
Sponsored Links
 

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
MySQL problem satimis Server Operation 5 25th June 2008 15:41
Filtering emails using Spamassassin and Clamav for Exchange 2000 Server Rocky Server Operation 19 11th March 2008 08:27
Install ISPConfig on CentOS Server, in brief gfts Tips/Tricks/Mods 11 4th April 2006 08:29
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs ebbay Installation/Configuration 9 4th March 2006 11:47
The Perfect Setup Suse 9.3 - Postfix problems new_bee05 HOWTO-Related Questions 20 25th November 2005 02:30


All times are GMT +2. The time now is 20:00.


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