Hey all--
I can't post a patch for various reasons beyond my control (sigh...),
but updating plague to use a mysql backend was trivial. (Not that I
don't like postgresql -- mysql is just easier for me in this
environment.)
1) yum install MySQL-python
2) edit /usr/share/plague/server/DBManager.py:
* copy the pgdbEngineClass definition verbatim, renaming it to
'mysqlEngineClass'
* the correct type for mysql in get_uid_field_type is
- "int(11) NOT NULL auto_increment PRIMARY KEY"
* connect parameters are slightly different in _connect():
- host=host, db=database, user=user, passwd=password
* add the new class to the db_engines array
* add a try statement to importing the MySQLdb class
3) update your plague-server.cfg with a "[mysql Engine]" section
And, of course, create your mysql db somewhere, etc, etc.
Hope that helps someone! :)
-Chris
Show replies by thread