Channel Logging to mySQL

Release your script here.
State:
- Author
- What it does
- Perhaps a little guide.
- Also, if the snippet is of any use to the community, it has a chance of getting posted on the main page, so don't hesitate to submit/ask!

Re: Channel Logging to mySQL

Postby jonlar » Wed Apr 22, 2009 12:45 pm

Edit: got it working. thx
jonlar
 

Re: Channel Logging to mySQL

Postby Szajbus » Fri Aug 21, 2009 12:31 pm

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
Szajbus
 

Re: Channel Logging to mySQL

Postby Dandy » Sat Sep 05, 2009 10:11 pm

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

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

Re: Channel Logging to mySQL

Postby Seth » Wed Aug 03, 2011 1:46 pm

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)
Seth
 

Re: Channel Logging to mySQL

Postby Cristian » Thu Aug 04, 2011 12:25 pm

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
Cristian
proof of advance
proof of advance
 
Posts: 282
Joined: Sun Nov 04, 2007 3:02 pm
Location: Denmark
Authnick: Sumsar

Previous

Return to TCL Scripting Release

Who is online

Users browsing this forum: No registered users and 3 guests

cron