-----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?
| * *
|
|
|
| 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
