On Monday, November 13, 2017 at 2:12:02 PM UTC-5, torgeriedel wrote:
>
> Am 13.11.2017 um 12:55 schrieb RjOllos:
>
>
>
> On Sunday, November 12, 2017 at 12:12:11 PM UTC-5, torgeriedel wrote:
>>
>> Ok, one more test, since trac is using MySQLdb I searched the code and
>> extracted this short test code. And it works:
>>
>> # python
>> Python 2.7.12 (default, Nov 19 2016, 06:48:10)
>> [GCC 5.4.0 20160609] on linux2
>> Type "help", "copyright", "credits" or "license" for more information.
>> >>> from trac.util import get_pkginfo
>> >>> import MySQLdb
>> >>> import MySQLdb.cursors
>> >>> mysqldb_version = get_pkginfo(MySQLdb).get('version',
>> MySQLdb.__version__)
>> >>> print("MySQLdb.version = {}".format(mysqldb_version))
>> MySQLdb.version = 1.3.7
>> >>> con = MySQLdb.connect('localhost', 'tracuser', 'thung0hohF6no3ah',
>> 'trac')
>> >>> cur = con.cursor()
>> >>> cur.execute("SHOW TABLES")
>> 19L
>> >>> for (table_name) in cur:
>> ... print("- {}".format(table_name))
>> ...
>> - ('attachment',)
>> - ('auth_cookie',)
>> - ('cache',)
>> - ('component',)
>> - ('enum',)
>> - ('milestone',)
>> - ('node_change',)
>> - ('permission',)
>> - ('report',)
>> - ('repository',)
>> - ('revision',)
>> - ('session',)
>> - ('session_attribute',)
>> - ('system',)
>> - ('ticket',)
>> - ('ticket_change',)
>> - ('ticket_custom',)
>> - ('version',)
>> - ('wiki',)
>> >>> cur.close()
>> >>> con.close()
>> >>> quit()
>>
>
>
> Here is another command to try from the Python shell:
> >>> from trac.db.mysql_backend import has_mysqldb
> >>> has_mysqldb
> True
> >>> from trac.db.mysql_backend import mysqldb_version
> >>> mysqldb_version
> '1.2.5'
>
> You might have the wrong MySQL database bindings installed. You need this
> one:
> https://pypi.python.org/pypi/MySQL-python
>
> Going from version numbers, it looks like you have this one:
> https://pypi.python.org/pypi/mysqlclient/1.3.7
>
> Side note, for the forthcoming Trac 1.4 release we've switched to PyMySQL:
> https://trac.edgewall.org/wiki/MySqlDb#Trac1.3.2
>
> and the following may be relevant to your situation:
> https://trac.edgewall.org/ticket/12821#comment:13
>
> - Ryan
>
> --
> 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 trac-users+unsubscr...@googlegroups.com.
> To post to this group, send email to trac-users@googlegroups.com.
> Visit this group at https://groups.google.com/group/trac-users.
> For more options, visit https://groups.google.com/d/optout.
>
> Hi Ryan,
>
> you are right it is the "wrong" database binding.
>
> But taking a look at https://pypi.python.org/pypi/MySQL-python/1.2.5 I
> see, that this is really old (2014-01-02) and does not support MySql > 5.5
> (as I understand). But Ubuntu 16.04 LTS comes with MySQL 5.7.
>
> Taking a look at https://pypi.python.org/pypi/mysqlclient I read, that
> this is a fork of the other binding and supports MySQL >= 5.5 and py2.7.
>
> That's why this binding (1.3.7) is installed when I execute apt-get
> install python-mysqldb and not the older one (1.2.5).
>
> Imho my feeling is that there is currently no chance to get trac running
> with MySQL on Ubuntu 16.04? Is there any chance to patch "my" Trac 1.2.2 in
> a way to work with the newer binding?
>
> Regards
> Torge
>
It might be possible to make mysqlclient work with Trac 1.2.x. If you
follow Jun's guidance in generating debug output, the issue you are
experiencing might become more obvious.
Your other option would be to install Trac 1.3.2 with PyMySQL, however the
warnings about of running a 1.3.x release apply:
https://trac.edgewall.org/wiki/TracDownload#LatestDevRelease
- Ryan
--
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 trac-users+unsubscr...@googlegroups.com.
To post to this group, send email to trac-users@googlegroups.com.
Visit this group at https://groups.google.com/group/trac-users.
For more options, visit https://groups.google.com/d/optout.
