Edgewall Software
Modify

Opened 4 years ago

Closed 4 years ago

Last modified 4 years ago

#12589 closed defect (cantfix)

MySQL Connection String Failes

Reported by: shannon.j.chaney@… Owned by:
Priority: normal Milestone:
Component: general Version: 1.0-stable
Severity: normal Keywords: mysql
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description (last modified by Jun Omae)

Hello: Currently running the following:

Distributor ID:	Ubuntu 16.04 xenial
apache2: Installed: 2.4.18-2ubuntu3.1
mysql-server: Installed: 5.7.15-0ubuntu0.16.04.1

Services:
apache2.service - LSB: Apache2 web server
   Loaded: loaded (/etc/init.d/apache2; bad; vendor preset: enabled)
  Drop-In: /lib/systemd/system/apache2.service.d
           └─apache2-systemd.conf
   Active: active (running) since Fri 2016-09-16 14:59:00 EDT; 45min ago
     Docs: man:systemd-sysv-generator(8)
  Process: 28298 ExecStart=/etc/init.d/apache2 start (code=exited, status=0/SUCC
   CGroup: /system.slice/apache2.service
           ├─28314 /usr/sbin/apache2 -k start
           ├─28315 /usr/sbin/apache2 -k start
           └─28316 /usr/sbin/apache2 -k start

Sep 16 14:59:00 GRSLW16080193L systemd[1]: Starting LSB: Apache2 web server...
Sep 16 14:59:00 GRSLW16080193L apache2[28298]:  * Starting Apache httpd web serv
Sep 16 14:59:00 GRSLW16080193L apache2[28298]: AH00558: apache2: Could not relia
Sep 16 14:59:00 GRSLW16080193L apache2[28298]:  *
Sep 16 14:59:00 GRSLW16080193L systemd[1]: Started LSB: Apache2 web server.

mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: en
   Active: active (running) since Fri 2016-09-16 14:11:04 EDT; 1h 33min ago
 Main PID: 21921 (mysqld)
   CGroup: /system.slice/mysql.service
           └─21921 /usr/sbin/mysqld

Sep 16 14:11:03 GRSLW16080193L systemd[1]: Starting MySQL Community Server...
Sep 16 14:11:04 GRSLW16080193L systemd[1]: Started MySQL Community Server.

mysql -u tracuser -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.7.15-0ubuntu0.16.04.1 (Ubuntu)

sudo trac-admin /usr/share/trac/projects/my-project initenv
Database connection string [sqlite:db/trac.db]> mysql://tracuser:letmein@localhost:3306/trac

Creating and Initializing Project
Initenv for '/usr/share/trac/projects/my-project' failed. 
Failed to create environment.
Cannot load Python bindings for MySQL
Traceback (most recent call last):
  File "build/bdist.linux-x86_64/egg/trac/admin/console.py", line 463, in do_initenv
    options=options)
  File "build/bdist.linux-x86_64/egg/trac/core.py", line 124, in __call__
    self.__init__(*args, **kwargs)
  File "build/bdist.linux-x86_64/egg/trac/env.py", line 280, in __init__
    self.create(options)
  File "build/bdist.linux-x86_64/egg/trac/env.py", line 603, in create
    DatabaseManager(self).init_db()
  File "build/bdist.linux-x86_64/egg/trac/db/api.py", line 250, in init_db
    connector, args = self.get_connector()
  File "build/bdist.linux-x86_64/egg/trac/db/api.py", line 339, in get_connector
    raise TracError(connector.error)
TracError: Cannot load Python bindings for MySQL

Used MySQL connection string from TracEnvironment and MySqlDb.

What is the proper way to make the connection to MySQL?

Attachments (0)

Change History (2)

comment:1 by Jun Omae, 4 years ago

Description: modified (diff)
Keywords: mysql added; MySQL DB connection removed
Milestone: 1.0.14
Resolution: cantfix
Status: newclosed
Version 0, edited 4 years ago by Jun Omae (next)

comment:2 by Jun Omae, 4 years ago

Description: modified (diff)

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.