On Wednesday, May 7, 2014 5:47:43 PM UTC-7, A.D. Sevigny wrote: > > I am in the process of having my team's Trac installation migrated to a > new linux server with a newer version of Trac and MySQL. The domain data > was copied over from the old server to the new. The mysql install is in a > non-standard location. > > Trac is running, mysql is running, the db can be accessed via command line > but not via Trac. I've tried modifying the database entry in the trac.ini > file, but to no avail. > > Old server info: > Red hat Linux 2.6.9-5.ELsmp > Trac 0.11 > MySQL 4.1 > MySQLdb 1.2.1 > Apache httpd 1.3 > > New server info: > Red Hat Linux 2.6.32-358.2.1.el6.x86_64 > Trac 1.01 > MySQL 5.6.14-debug > MySQLdb 1.2.3 > Apache httpd 2.4.7 > > The standard mysql install for the server is at /usr/bin/mysql > (v.5.1.67). The non-standard install that we are using for Trac is at > /ots/sw/mysql/bin/mysql. > > Using this database entry: > > database = mysql://tracuser:xxxxxx@localhost/trac_mvicd > > I get this error: > > TimeoutError: Unable to get database connection within 0 seconds. > (OperationalError: (2002, "*Can't connect to local MySQL server through > socket '/var/lib/mysql/mysql.sock'* (2)")) > > My process invocations: > > /bin/sh /ots/sw/mysql/bin/mysqld_safe --datadir=/ots/sw/mysql/data > --pid-file=/ots/sw/mysql/data/servername.pid > > /ots/sw/mysql/bin/mysqld --basedir=/ots/sw/mysql > --datadir=/ots/sw/mysql/data --plugin-dir=/ots/sw/mysql/lib/plugin > --user=mysql --log-error=/ots/sw/mysql/data/servername.err > --pid-file=/ots/sw/mysql/data/servername.pid > > /ots/sw/python-2.7.6/bin/python /ots/sw/python-2.7.6/bin/tracd > /local/disk/public_html/trac/mvicd -p 8000 --base-path=/ -d -s > > I am looking for insights or solutions. Let me know if there is more > information I can provide that would aid in identifying the problem. > Thanks in advance for any help! > > <w: > ...
You can specify connection parameters in the database connection string. The supported parameters are listed here: http://trac.edgewall.org/wiki/DatabaseBackend#MySQL I don't have much experience configuring MySQL, but I'm guessing you need to append unix_socket to point to the location of mysql.sock on your filesystem. -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/trac-users. For more options, visit https://groups.google.com/d/optout.
