-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Donnelly, Michael (OFT) wrote: | The database is intact .. details .. connected to appropriate port with | Username + password as specified .. | | mysql> show tables; | +--------------------+ | | Tables_in_eventsdb | | +--------------------+ | | attributes | | | events | | +--------------------+ | 2 rows in set (0.00 sec) | | mysql> describe events; | +------------+------------------+------+-----+---------+---------------- | + | | Field | Type | Null | Key | Default | Extra | | | +------------+------------------+------+-----+---------+---------------- | + | | event_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | | | starttime | int(10) | NO | | | | | | | stoptime | int(10) | YES | | NULL | | | | | updatetime | int(10) | NO | | | | | | | level | varchar(32) | NO | | | | | | | profile | varchar(100) | NO | | | | | | | type | varchar(32) | NO | | | | | | +------------+------------------+------+-----+---------+---------------- | + | 7 rows in set (0.01 sec) | | mysql> describe attributes; | +--------------+------------------+------+-----+---------+-------------- | --+ | | Field | Type | Null | Key | Default | Extra | | | +--------------+------------------+------+-----+---------+-------------- | --+ | | attribute_id | int(10) unsigned | NO | PRI | NULL | | auto_increment | | | event_id | int(10) unsigned | YES | MUL | NULL | | | | | name | varchar(32) | YES | | NULL | | | | | value | varchar(64) | YES | | NULL | | | | +--------------+------------------+------+-----+---------+-------------- | --+ | 4 rows in set (0.00 sec) | -------------------------------------- | | Also mysql connection log is not showing any attempts to connect to the | database other than my manual connections.. Apache log has nothing | Interesting, and syslog shows the only good message, which is the | subject | Line.. what other actions can I take / logs can I review?
nfsen and its plugins write debug information to the syslog, but these are ignored by default. If you use the syslog logger, you can enable the messages by adding: - --- *.=debug /var/log/debug - --- to /etc/syslog.conf. If you use metalog, you can these lines to /etc/metalog.conf: - --- Debug : ~ facility = "*" ~ minimum = 7 ~ logdir = "/var/log/debug" - --- After that you can reload your logger, and messages should start to appear in /var/log/debug. Regards, Werner | | | | | | | -------------------------------------------------------- | This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system. | | | -----Original Message----- | | From: Werner Schram [mailto:[EMAIL PROTECTED] | Sent: Monday, August 04, 2008 8:50 AM | To: Donnelly, Michael (OFT) | Cc: [email protected] | Subject: Re: [Nfsen-discuss] Problem with events plugin: Can't call | method "prepare" on unblessed reference . Events.pm line 385, <STDIN> | line 9. | | Hi Michael, | | Donnelly, Michael (OFT) wrote: | | <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal | {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times | | New Roman";} a:link, span.MsoHyperlink {color:blue; | text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed | {color:purple; text-decoration:underline;} span.EmailStyle17 | {mso-style-type:personal-compose; font-family:Arial; color:windowtext;} | @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in;} | div.Section1 {page:Section1;} --> | | | | I'm trying to implement the events plugin , using mysql .. I receive | the following syslog | | | | error each time I so much as visit the plugins->events plugin tab. | | | | | | | | nfsen[3060]: PANIC Comm Server dies: Can't call method "prepare" on | unblessed reference at /usr/local/nfsen/plugins/Events.pm line 385, | <STDIN> line 13 | | | | | | | | I suspect the db related entries in the nfsen.conf file are at the | root of the problem, since | | | | The mysql related entries were commented out in the example posted to | | the forum and | | | | Most of the DBI examples I found on the web have format | differences.. | | | | . .. My nfsen.conf entries are | | | | * * | | | | [EMAIL PROTECTED] = (* | | | | * # profile # module* | | | | * [ '!', 'Events' ],* | | | | *);* | | | | * * | | | | *%PluginConf = (* | | | | * events => {* | | | | * db_connection_string => | "DBI:mysql:database=eventsdb;host=localhost;port=3306",* | | | | * db_user => "root",* | | | | * db_passwd => "xxxxxxxx",* | | | | * },* | | | | *);* | | | My connection string is: | "DBI:mysql:database=eventsdb;host=localhost;port=3306", but I am not | sure if that is the cause of the problem, as the plugin should fail to | load if the connection to the database is not made. | | Are all the tables in the database there? If so, could you check if | there are messages in your debug-log? | | The database is intact .. details from mysql : | | | * * | | | | | | | | Line 385 in Events.pm is : | | | | * my $query = $dbh->prepare("SELECT count(ev.event_id) | "._get_where_clause($opts)); * | | | | | | | | Mysql shows no queries in its log, so I'm real sure this is dying at | the perl level | | | | Can someone spot a syntax error here, or post a working nfsen.conf | with mysql ? | | | | | | | | Thank for a great application by the way .. | | | | | | | | Mike D | | | Regards, | Werner -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkiXFA4ACgkQ3ULkMS4OADkYagCgkj4Uxpn4xaNvRzBhIxxMFwTU 9KEAoLNJxk9hArYgjwvXWtF9YAwx72Lh =1MbU -----END PGP SIGNATURE----- ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Nfsen-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/nfsen-discuss
