[horde] Mysql database & horde

[donovan at biochem.ucl.ac.uk]

 Hi to you all,

 I hope you can help me. I have Horde and imp running. I am able to view, send
 and receive mail.  

 My first problem is when I edit horde.php to use sql as my preferences driver
 ($conf['prefs']['driver'] = 'sql';)  I get a error message. 

(DB Error: connect failed [line 102 of /www/htdocs/horde/lib/Prefs/sql.php]) 

 At a guess I think it is to do with horde trying to access the database. If i
 reset it back to ($conf['prefs']['driver'] = 'sessions';) all is fine during
login. 

 $conf['prefs']['params']['phptype'] = 'mysql';
 $conf['prefs']['params']['hostspec'] = 'localhost';
 $conf['prefs']['params']['username'] = 'root';
 $conf['prefs']['params']['password'] = 'mypass';
 $conf['prefs']['params']['database'] = 'horde';
 $conf['prefs']['params']['table'] = 'horde_prefs';

I have looked in mysql and listed the horde database files.
  
 -rw-rw----    1 mysql    mysql        8632 Jan 16 18:12
 horde_categories_categories.frm
 -rw-rw----    1 mysql    mysql           0 Jan 16 18:12
 horde_categories_categories.MYD
 -rw-rw----    1 mysql    mysql        1024 Jan 16 18:12
 horde_categories_categories.MYI
 -rw-rw----    1 mysql    mysql        8820 Jan 16 18:12 horde_categories.frm
 -rw-rw----    1 mysql    mysql           0 Jan 16 18:12 horde_categories.MYD
 -rw-rw----    1 mysql    mysql        1024 Jan 16 18:12 horde_categories.MYI
 -rw-rw----    1 mysql    mysql        8668 Jan 16 18:12 horde_prefs.frm
 -rw-rw----    1 mysql    mysql           0 Jan 16 18:12 horde_prefs.MYD
 -rw-rw----    1 mysql    mysql        1024 Jan 16 18:12 horde_prefs.MYI
 -rw-rw----    1 mysql    mysql        8596 Jan 16 18:12 horde_users.frm
 -rw-rw----    1 mysql    mysql           0 Jan 16 18:24 horde_users.MYD
 -rw-rw----    1 mysql    mysql        3072 Jan 16 18:27 horde_users.MYI

I know when working  the  prefs.MYD file is updated. 

My second problem is that I have also used sql for  authenticating users to Horde.
 ($conf['auth']['driver'] = 'sql';)
I searched on google and someone else had a simular problem and added this to
his horde.php file.

$conf['auth']['params'] = array();
$conf['auth']['params']['phptype'] = 'mysql';
$conf['auth']['params']['hostspec'] = 'localhost';
$conf['auth']['params']['username'] = 'horde';
$conf['auth']['params']['password'] = 'mypass';
$conf['auth']['params']['database'] = 'horde';
$conf['auth']['params']['table'] = 'horde_users';



 Is the  horde_users.MYD  file supposed to update when new users  log on to
horde or other modules?



 Any pointers will be truly greatfull

 Donovan......



 My horde configuration from the test.php 

 Horde Versions

       Horde: 2.1 
       IMP: 3.1 (run IMP tests) 
        

  PHP Version

       View phpinfo() screen 
       PHP Version: 4.2.3 
       PHP Major Version: 4.2 
       PHP Minor Version: 3 
       PHP Version Classification: release 
       You are running a supported version of PHP.

  PHP Module Capabilities

       FTP Support: No 
       Gettext Support: Yes 
       IMAP Support: Yes 
       LDAP Support: No 
       MCAL Support: No 
       Mcrypt Support: No 
       MySQL Support: Yes 
       PostgreSQL Support: No 
       XML Support: Yes 

  Miscellaneous PHP Settings

       short_open_tag enabled: Yes 
       magic_quotes_runtime set to Off: Yes 
       file_uploads enabled: Yes 

  PHP Sessions

       Session counter: 1 
       To unregister the session: click here 

  PEAR

       PEAR - Yes 
       Recent PEAR - Yes 
       Mail::RFC822 - Yes 
       Log - Yes 
       DB - Yes 


-------------------------------------------------
This mail sent through Webmail: http://webdatab