captnswing wrote: > Hello all, > I would like to log messages to a database (mysql) > I found the example log_test14.py that comes with python logging > module http://www.red-dove.com/python_logging.html > but that example is a bit greek for me ... :) and it doesnt work with > mysql
Have you used mysql from Python before? I looked at that example and it is not that complex if you understand how to program a database. I think what you have to do is - install MySQL and create the database table that you want to log to. The SQL statement in the example shows the fields you might want, or you can use a subset of those fields if you don't need so much information. - modify the example program a little: change import mx.ODBC.Windows to the correct import for the MySQL driver change self.conn = mx.ODBC.Windows.connect(self.dsn, self.uid, self.pwd) to the correct statement to connect to MySQL change the SQL statement to correspond to your database schema If you *haven't* used MySQL from Python before, you should probably learn a little about the basics first. BTW the example is vulnerable to SQL injection attacks - if any of the log messages contain text from user input you should fix that. But get it working first, then come back and ask for help again. Kent -- http://www.kentsjohnson.com _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
