[horde] Mysql database & horde

[Johan de Vries]

Edit line 102 of the /www/htdocs/horde/lib/Prefs/sql.php  file and delete the IsWarning part
This is not supported by the latest version of pear
See also the Horde FAQ

Johan

> -----Oorspronkelijk bericht-----
> Van: donovan at biochem.ucl.ac.uk [mailto:donovan at biochem.ucl.ac.uk]
> Verzonden: dinsdag 21 januari 2003 14:07
> Aan: horde
> Onderwerp: [horde] Mysql database & horde 
> 
> 
> 
> 
> 
>  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
> 
> -- 
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>