[sam] MySQL

[Devin Drown]

I've been using MySQL with Sam for about 1 month and have had no issues.  The 
database script for creating the table is in CVS and I only modified the 
config/conf.php file to be appropriate for mysql:

$conf['storage']['params']['phptype'] = 'mysql';
$conf['storage']['params']['hostspec'] = 'localhost';
$conf['storage']['params']['username'] = 'horde_example_user';
$conf['storage']['params']['password'] = '********';
$conf['storage']['params']['database'] = 'horde_example_database';
$conf['storage']['params']['table'] = 'userpref';


Quoting Brian Clark <blclark@gci.net>:

> I am having a heck of a time with PostgreSQL.  No matter what I do I am 
> not able to authenticate to it via sam.  I have been doing a lot of 
> research but still cannot find what I am doing wrong.  I have changed 
> the auth_type in psql from ident to password and back and I can see the 
> change in the horde.log but still I am no closer.  Running sam with 
> MySQL is what I would really prefer but I need help in doing that, it 
> looks to me like there are a minimum of 3 files that need to be 
> modified if not more.  Can anyone help with this?
> 
> Barry
> 
> 
> Jul 21 20:56:42 HORDE [notice] [imp] Login success for barry 
> [209.112.157.162] to {localhost:143} [on lin
> e 81 of "/var/www/horde/imp/redirect.php"]
> Jul 21 20:57:24 HORDE [emergency] [sam] DB Error: connect failed:  
> [nativecode=
> Warning:  Unable to connect to PostgreSQL server:  FATAL 1:  Password 
> authentication failed for user "pos
> tgres"
> 
>  in /usr/share/pear/DB/pgsql.php on line 116
> ] ** Array [on line 86 of "/var/www/horde/sam/lib/Driver/sql.php"]
> Jul 21 20:58:24 HORDE [notice] [imp] Logout for barry [209.112.157.162] 
> from {localhost:143} [on line 34
> of "/var/www/horde/imp/login.php"]