On Fri, May 30, 2014 at 2:22 PM, A.D. Sevigny <[email protected]> wrote:
> > > 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. > Please describe the changes that you tried. -- 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.
