Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

How does GF get mysql config info?

Quote Reply
How does GF get mysql config info?
Setting up GF on a shared web host (I own the host) to evaluate.

I have installed GF, installed mysql, created a new db (mysql_install_db) and attempted to configure GF. The problem is the mysql db is not in the default location (because there are multiple mysql db's running.) But GF keeps trying to access the default location:

Error: Could not connect to database. Reason: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

The socket is actually at a different location but I haven't figured out how to get GF to recognize the different location. Any hints?
Quote Reply
Re: [Snowdog] How does GF get mysql config info? In reply to
Could you not symlink the socket it is looking for to the proper socket?
Quote Reply
Re: [Paul] How does GF get mysql config info? In reply to
Technically, yes. But that doesn't make practical sense on a host that runs multiple mysql DB's.
Quote Reply
Re: [Snowdog] How does GF get mysql config info? In reply to
Could this be a question of using different ports for the different instances of mysql?

Ivan
-----
Iyengar Yoga Resources / GT Plugins
Quote Reply
Re: [Snowdog] How does GF get mysql config info? In reply to
Hi,

Gossamer Forum unfortunately does not support passing the extra arguments required to tell DBD::mysql to use a different socket for connections. This is mainly because the syntax for this has changed numerous times, and very few people used it.

You could try (untested) setting hostname to:

host=localhost;mysql_socket=/path/to/new/mysql.sock

and see if that works.

Cheers,

Alex
--
Gossamer Threads Inc.