Opened 8 years ago

Closed 8 years ago

#6841 closed defect (invalid)

Is plugin MySQL compatible?

Reported by: m.baker@… Owned by: Radek Bartoň
Priority: high Component: DiscussionPlugin
Severity: critical Keywords: mysql
Cc: easteregg@… Trac Release: 0.12


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?

Attachments (0)

Change History (10)

comment:1 Changed 8 years ago by Radek Bartoň

Status: newassigned

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

comment:2 Changed 8 years ago by anonymous

Cc: easteregg@… added; anonymous removed
Priority: normalhigh
Severity: normalcritical
Trac Release: 0.110.12
Type: enhancementdefect

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

comment:3 Changed 8 years ago by Radek Bartoň

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

comment:4 Changed 8 years ago by 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 :)

comment:5 Changed 8 years ago by anonymous

Have you seen BugReporting nad TracLogging?

comment:6 Changed 8 years ago by 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/", line 107, in onecmd
    rv = cmd.Cmd.onecmd(self, line) or 0
  File "/usr/lib/python2.5/", line 218, in onecmd
    return self.default(line)
  File "build/bdist.linux-x86_64/egg/trac/admin/", line 257, in default
    return cmd_mgr.execute_command(*args)
  File "build/bdist.linux-x86_64/egg/trac/admin/", line 123, in execute_command
    return f(*fargs)
  File "build/bdist.linux-x86_64/egg/trac/", line 790, in _do_upgrade
    self.env.upgrade(backup=no_backup is None)
  File "build/bdist.linux-x86_64/egg/trac/", line 528, in upgrade
  File "build/bdist.linux-x86_64/egg/trac/", line 500, in backup
    return DatabaseManager(self).backup(dest)
  File "build/bdist.linux-x86_64/egg/trac/db/", line 180, in backup
    return connector.backup(dest)
  File "build/bdist.linux-x86_64/egg/trac/db/", line 202, in backup
    p = Popen(args, env=environ, stderr=PIPE, close_fds=close_fds)
  File "/usr/lib/python2.5/", line 594, in __init__
    errread, errwrite)
  File "/usr/lib/python2.5/", line 1149, in _execute_child
    raise child_exception
OSError: [Errno 2] No such file or directory

comment:7 Changed 8 years ago by 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

comment:8 Changed 8 years ago by 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.

comment:9 Changed 8 years ago by anonymous

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

comment:10 Changed 8 years ago by Radek Bartoň

Resolution: invalid
Status: assignedclosed

Then it's invalid.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Radek Bartoň.
The resolution will be deleted.

Add Comment

E-mail address and name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.