[horde] Initial Configuration of 'Stable Horde' - Unable to connect to SQL server

[Katie Scott]

Hi Again,

 I am reading the searchable archive at marc.theaimsgroup.com.  Thank 
you so much for that capability.  Things are becoming clearer.  However, 
my horde installation still doesnt work.  I get "Unable to connect to 
SQL server" complaints. 

 I am using mysql as the native database.  I want to use it as the 
workhorse for all horde authentication, preferences, contacts, etc.  I'm 
trying to limit the number of possible variables.  Perhaps this is 
'premature optimization' and a bad idea.

 I had to 'fix' the permissions on the mysql directory (/var/lib/mysql - 
in my version) and can now issue the 'mysql' command from my personal 
account.  I can connect as both horde and root.  The mysql directory was 
originally installed with mode 700.  I changed it to 711.

 I can see and modify all the tables that horde is trying to access.

 I am trying to have horde authenticate the users so I added a bunch of 
'auth' lines in horde.php (and added a user katie by hand).  They look 
like the 'prefs' lines.

 I still need to prove that I can connect to mysql through php outside 
of horde.

 Questions:

 1)  Any ideas?  I will paste the diff between my horde.php config file 
and the dist file at the bottom of this message along with version info. 

 2)  Are the passwords in the config file really supposed to be 'in the 
clear'?  I have the permission on those files as root:www and apache 
(running as group www) is not logging any complaints - only accesses.

 3)  Can you tell me how to get php to be chatty about its errors?

 4) Can you tell me how to get mysql to be more chatty about what it's 
doing?  I see nothing appear in the /var/log/mysqld.log file when I connect.

Thanks,

Katie
---------------------------
I have installed versions:
horde-2.2.4 
turba-1.2.1


and I expect to install
-----------------------
imp-3.2.2
kronolith-1.1
mnemo-1.1.tar.gz



---------------------------------
diff horde.php horde.php.dist (with 'in the clear' passwords removed)

---------------------------------
97,98c97
< // Katie Changed this to sql - Wed Oct 22 20:55:18 PDT 2003
< $conf['auth']['driver'] = 'sql';
---
 > $conf['auth']['driver'] = '';
103,109d101
< // Katie added these - Wed Oct 22 21:03:52 PDT 2003
< $conf['auth']['params']['phptype'] = 'mysql';
< $conf['auth']['params']['hostspec'] = 'localhost';
< $conf['auth']['params']['username'] = 'horde';
< $conf['auth']['params']['password'] = 'REMOVED';
< $conf['auth']['params']['database'] = 'horde';
< $conf['auth']['params']['table'] = 'horde_users';
152c144
< $conf['log']['priority'] = LOG_DEBUG;
---
 > $conf['log']['priority'] = LOG_NOTICE;
170,171c162
< // Katie changed this from 'none;' to 'sql' - Wed Oct 22 20:59:19 PDT 2003
< $conf['prefs']['driver'] = 'sql';
---
 > $conf['prefs']['driver'] = 'none';
180,187c171,176
<  $conf['prefs']['params']['phptype'] = 'mysql';
<  $conf['prefs']['params']['hostspec'] = 'localhost';
< // protocol added by Katie - Wed Oct 22 16:21:36 PDT 2003
<  $conf['prefs']['params']['protocol'] = unix;
<  $conf['prefs']['params']['username'] = 'horde';
<  $conf['prefs']['params']['password'] = 'REMOVED';
<  $conf['prefs']['params']['database'] = 'horde';
<  $conf['prefs']['params']['table'] = 'horde_prefs';
---
 > // $conf['prefs']['params']['phptype'] = 'mysql';
 > // $conf['prefs']['params']['hostspec'] = 'localhost';
 > // $conf['prefs']['params']['username'] = 'horde';
 > // $conf['prefs']['params']['password'] = '*****';
 > // $conf['prefs']['params']['database'] = 'horde';
 > // $conf['prefs']['params']['table'] = 'horde_prefs';
-------------------------------------------