Channel Logging to mySQL

[jonlar]

Edit: got it working. thx

[Szajbus]

i se one error

When im

logsearch -exp -chan #Sz4jbus

i error

Code: Select all

Tcl error [log:search]: mysql::sel/db server: Can't find FULLTEXT index matching the column list

[Dandy]

You need to add `nick`, `arg` as a fulltext index.

ALTER TABLE `log` ADD FULLTEXT (
`nick` ,
`arg`
);

[Seth]

Hello

I'm trying to get this working but I've run into some problems.

I installed the newest version of mysqltcl (3.05), instead of 3.02.
To make the script run, I had to change the first line of

Code: Select all

load /usr/lib/mysqltcl-3.02/libmysqltcl3.02.so

to

Code: Select all

load /usr/lib/tcltk/mysqltcl-3.05/libmysqltcl3.05.so

Now when I try to start eggbot, I get this error:

Code: Select all

 Tcl error in file 'eggdrop.conf':
 invalid command name "b"
    while executing
"b"
    invoked from within
"mysql::connect -host localhost -user [b]user[/b]  -password [b]password[/b] -db [b]da
    invoked from within
"set db_handle [mysql::connect -host localhost -user [b]user[/b]  -password [b]passwor
    (file "scripts/logging.tcl" line 28)
    invoked from within
"source scripts/logging.tcl"
    (file "eggdrop.conf" line 1385)
 * CONFIG FILE NOT LOADED (NOT FOUND, OR ERROR)

Should I have to use version 3.02 to get this running, or is there a simple change I can make to the code to get it working?? (also if there are any easier/newer scripts available for logging to a mysql database, feel free to let me know)

[Cristian]

this is just a guess on my part, but did you leave the [b] and [/b] in there?

Code: Select all

set db_handle [mysql::connect -host localhost -user [b]user[/b]  -password [b]password[/b] -db [b]database[/b]]

after you edit it, it should look like this

Code: Select all

set db_handle [mysql::connect -host localhost -user USENAME-HERE  -password PASSWORD-HERE -db DATABASE-NAME-HERE]

I hope it helps