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? -------------------------------------------------------- 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. -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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 iEYEARECAAYFAkiW+vEACgkQ3ULkMS4OADlFdACgllFrueK6io2PZQDDZJw1uFuM OLYAoNQLcqTqVo4trac8mjccBmLaA5C9 =y5XW -----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
