Is plugin MySQL compatible?

[m.baker@…]

The documentation states 'For now sqlite version 3 or PostgreSQL is required as SQL backend for running this plugin'.

Googling appears to show people using the plugin who are running on MySQL.

Could you confirm whether the documentation is correct, or out of date?

[Radek Bartoň]

I don't know, never tried it with MySQL. Please try and report if it works.

[anonymous]

wont work for me. after enabling the plugin i have to upgrade env and this fails with the following error message

OSError: [Errno 2] No such file or directory

[Radek Bartoň]

Thanks for reporting but detailed debug log would be more usefull.

[anonymous]

there is no futher log messages... trac itself says something from upgrading env and if i use trac-admin to achive this, it fails with this message i posted already. if you can tell me how to produce more informations, i will do so :)

[anonymous]

Have you seen BugReporting nad TracLogging?

[anonymous]

2010-09-07 01:43:19,256 Trac[console] ERROR: Exception in trac-admin command:
Traceback (most recent call last):
  File "build/bdist.linux-x86_64/egg/trac/admin/console.py", line 107, in onecmd
    rv = cmd.Cmd.onecmd(self, line) or 0
  File "/usr/lib/python2.5/cmd.py", line 218, in onecmd
    return self.default(line)
  File "build/bdist.linux-x86_64/egg/trac/admin/console.py", line 257, in default
    return cmd_mgr.execute_command(*args)
  File "build/bdist.linux-x86_64/egg/trac/admin/api.py", line 123, in execute_command
    return f(*fargs)
  File "build/bdist.linux-x86_64/egg/trac/env.py", line 790, in _do_upgrade
    self.env.upgrade(backup=no_backup is None)
  File "build/bdist.linux-x86_64/egg/trac/env.py", line 528, in upgrade
    self.backup(backup_dest)
  File "build/bdist.linux-x86_64/egg/trac/env.py", line 500, in backup
    return DatabaseManager(self).backup(dest)
  File "build/bdist.linux-x86_64/egg/trac/db/api.py", line 180, in backup
    return connector.backup(dest)
  File "build/bdist.linux-x86_64/egg/trac/db/mysql_backend.py", line 202, in backup
    p = Popen(args, env=environ, stderr=PIPE, close_fds=close_fds)
  File "/usr/lib/python2.5/subprocess.py", line 594, in __init__
    errread, errwrite)
  File "/usr/lib/python2.5/subprocess.py", line 1149, in _execute_child
    raise child_exception
OSError: [Errno 2] No such file or directory

[anonymous]

the rest:

debian lenny apache + mysql backend

System InformationTrac 0.12 Genshi 0.6 mod_python 3.3.1 MySQL server: "5.0.51a-24+lenny4-log", client: "5.0.51a", thread-safe: 1 MySQLdb 1.2.2 Python 2.5.2 (r252:60911, Jan 24 2010, 18:02:01) [GCC 4.3.2] pytz 2008c setuptools 0.6c11 Subversion 1.5.1 (r32289) jQuery: 1.4.2

[Radek Bartoň]

Thank you, this is much more helpfull. Nevertheless, this indicates that the error is not caused in the DiscussionPlugin but that you don't have properly configured mysqldump_path TracIni configuration option. In your case, trac-admin is trying to backup the database to non-existing path. You can also disable backup with -b option.

I'll leave the ticket open for now and if you manage to configure your MySQL server, please report if the plugin is working well with it and I'll close it then.

[anonymous]

allrights, after using this switch, there is no problem with using the board.

[Radek Bartoň]

Then it's invalid.