[horde] Connection to remote mysql server failed

[Peter Abrahamsen]

Is mysqld listening on TCP port 3306? Are there any firewalls involved?
Check /etc/mysql/my.cnf under the [mysqld] section for the bind-address,
port, and skip-networking options. You can see if it's listening with:

# netstat -ptln | grep 3306

This should return a line very similar top:

tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN
25589/mysqld

Peter

On Wed, Oct 29, 2003 at 09:13:41AM -0500, Karen R McArthur wrote:
> I have a working Horde/IMP/Turba/MySQL system.  Due to the load on our web
> server, I'd like to move the Horde/IMP/Turba off of the primary web server
> to it's own Apache server - leaving the MySQL database on the primary web
> server.  Currently, Horde/IMP/Turba is set up to connect to MySQL via
> 'localhost'.  I have modified the MySQL database by adding permissions for
> horde at webdb the same as horde@% and horde at localhost (I modified and ran the
> mysql_create.sql script to do this) so now my horde permissions look like
> this:
> 
> mysql> use mysql
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
> 
> Database changed
> mysql> select * from user where user='horde';
> +-----------+-------+------------------+-------------+-------------+--------
> -----+-------------+-------------+-----------+-------------+---------------+
> --------------+-----------+------------+-----------------+------------+-----
> -------+
> | Host      | User  | Password         | Select_priv | Insert_priv |
> Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv |
> Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv |
> Index_priv | Alter_priv |
> +-----------+-------+------------------+-------------+-------------+--------
> -----+-------------+-------------+-----------+-------------+---------------+
> --------------+-----------+------------+-----------------+------------+-----
> -------+
> | %         | horde | xxxxxxxxxxxxxxx | N           | N           | N
> | N           | N           | N         | N           | N             | N
> | N         | N          | N               | N          | N          |
> | localhost | horde | xxxxxxxxxxxxxx | N           | N           | N
> | N           | N           | N         | N           | N             | N
> | N         | N          | N               | N          | N          |
> | webdb     | horde | xxxxxxxxxxxxxxx | N           | N           | N
> | N           | N           | N         | N           | N             | N
> | N         | N          | N               | N          | N          |
> +-----------+-------+------------------+-------------+-------------+--------
> -----+-------------+-------------+-----------+-------------+---------------+
> --------------+-----------+------------+-----------------+------------+-----
> -------+
> 3 rows in set (0.00 sec)
> 
> mysql>
> 
> I then modified
> ../horde/config/horde.php to reflect ['hostspec'] = 'webdb';
> ..horde/turba/config/sources.php to refect 'hostspec' => 'webdb',
> 
> When I try to connect, after typing in my uer name and password, I receive
> the following:
> 
>             A fatal error has occurred:
> 
>             DB Error: connect failed
> 
>             [line 108 of
> /usr/local/apache_1.3.28/webmail/htdocs/horde_2.2.3/lib/Prefs/sql.php]
> 
>             Details have been logged for the administrator.
> 
> When I change horde.php and sources.php back to localhost, everything works
> fine again.
> What piece am I missing?
> --
> Karen R McArthur, Systems Administrator
> Bates College, Information & Library Services
> 110 Russell Street, Lewiston, Maine 04240 USA
> ph:207-786-8236 fax: 207-786-6057 kmcarthu at bates.edu



> 
> -- 
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org


-- 
Peter Abrahamsen              Seattle, Washington, USA
CEP, Phil, iSchool            http://www.abrahamsen.com/peter/
University of Washington      206.525.2702 (home)
"I can't see the lines I used to think I could read between" - Eno