Modify

Opened 4 years ago

Closed 4 years ago

#6841 closed defect (invalid)

Is plugin MySQL compatible?

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

Description

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 4 years ago by Blackhex

  • Status changed from new to assigned

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

comment:2 Changed 4 years ago by anonymous

  • Cc easteregg@… added
  • Priority changed from normal to high
  • Severity changed from normal to critical
  • Trac Release changed from 0.11 to 0.12
  • Type changed from enhancement to defect

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 4 years ago by Blackhex

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

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

Have you seen BugReporting nad TracLogging?

comment:6 Changed 4 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/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

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

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 4 years ago by anonymous

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

comment:10 Changed 4 years ago by Blackhex

  • Resolution set to invalid
  • Status changed from assigned to closed

Then it's invalid.

Add Comment

Modify Ticket

Action
as closed .
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.