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.
Thanks, RjOllos. I gave that a shot but unfortunately the error remains
unchanged.
--
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.
