egghelp/eggheads community

mysql.mod problem with

2005-06-15T19:11:31-04:00

fixed, is used a wrong rowname

Tnx

D4RkViP3R

Statistics: Posted by D4RkViP3R — Wed Jun 15, 2005 7:11 pm

mysql.mod problem with

2005-06-14T12:56:56-04:00

sorry, I don't help privately on ICQ (unless you don't mind me charging you a fee for my consulting services)

try your SQL command from mysql client utility

Statistics: Posted by demond — Tue Jun 14, 2005 12:56 pm

mysql.mod problem with

2005-06-14T12:43:24-04:00

I've replaced the variable with the string.
The error doesn't change

May you help my over ICQ to solve the problem ?

Statistics: Posted by D4RkViP3R — Tue Jun 14, 2005 12:43 pm

mysql.mod problem with

2005-06-14T12:39:17-04:00

most likely $scriptname is empty string

Statistics: Posted by demond — Tue Jun 14, 2005 12:39 pm

mysql.mod problem with

2005-06-14T12:36:16-04:00

same error

Code:

[18:37] Tcl error [testin]: mysqlquery/db server: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM allow_in_channels' at line 1

Statistics: Posted by D4RkViP3R — Tue Jun 14, 2005 12:36 pm

mysql.mod problem with

2005-06-14T12:30:48-04:00

it's not the underscores, it's the single quotes

remove single quotes:

Code:

set sql_cmd "SELECT $scriptname FROM allow_in_channels"

Statistics: Posted by demond — Tue Jun 14, 2005 12:30 pm

mysql.mod problem with

2005-06-14T10:46:43-04:00

Hi demond,

I do this and it's the same problem.
Now I take the mysqltcl module and its works very fine
But one problem I have with this.

I have a database named 'eggdrop' and a table named 'allow_in_channels'.
If I want to query the table with following proc:

Code:

proc allow_in_channel {current_channel} {    global scriptname db_handle    set sql_cmd "SELECT $scriptname FROM 'allow_in_channels'"    set result [mysqlquery $db_handle $sql_cmd]    while {[set row [mysqlnext $result]] != ""} {        #set allow_in_channel_id [lindex $row 0]        set allow_in_channel_script [lindex $row 1]        set allow_in_channel_channel [lindex $row 2]        if {$allow_in_channel_script == $scriptname} {            if {$allow_in_channel_channel == $current_channel} {                return $allow_in_channel_channel            }        }    }}

And call the "function"

Code:

bind pub - !testin testinproc testin {nick uhost hand chan arg} {    global scriptname    if {([allow_in_channel $chan] == $chan)} {        putchan $chan "Hallo"    }}

My eggdrop shows me this message:

Code:

[16:26] Tcl error [testin]: mysqlquery/db server: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM 'allow_in_channels'' at line 1

Doesn't support this script tablenames with underscores or what?

Regards,

D4RkViP3R

Statistics: Posted by D4RkViP3R — Tue Jun 14, 2005 10:46 am

mysql.mod problem with

2005-06-13T23:45:42-04:00

you messed up, start over - cleanup, untar eggdrop, untar mysqlmod, configure, make, install

Statistics: Posted by demond — Mon Jun 13, 2005 11:45 pm

mysql.mod problem with

2005-06-13T18:53:55-04:00

Code:

...Test run of ./eggdrop -v: /bin/sh: line 1: ./eggdrop: No such file or directory make: *** [modules] Error 127

the way it looks to me is that u didnt execute 'make', you do have to compile eggdrop itself before you compile the modules.

Code:

make[2]: Entering directory `/usr/src/eggdrop1.6.16/src/mod/server.mod' gcc -pipe -fPIC -g -O2 -Wall -I. -I../../.. -I../../.. -I../../../src/mod -DHAVE                                                           _CONFIG_H   -DMAKING_MODS -c .././server.mod/server.c ../server.mod/server.c: In function `next_server': ../server.mod/server.c:1047: warning: dereferencing type-punned pointer will bre                                                           ak strict-aliasing rules ../server.mod/server.c: At top level: ../server.mod/server.c:1341: warning: dereferencing type-punned pointer will bre                                                           ak strict-aliasing rules ../server.mod/server.c:1349: warning: dereferencing type-punned pointer will bre                                                           ak strict-aliasing rules mv server.o ../ gcc -pipe -shared -nostartfiles -o ../../../server.so ../server.o -L/usr/lib -lt                                                           cl8.4 -lm -lpthread -ldl -lnsl touch ../../../server.so make[2]: Leaving directory `/usr/src/eggdrop1.6.16/src/mod/server.mod'

The server.mod errors are warnings which you can ignore, everyone I know have them...

Code:

[00:11] * Last context: mysql:mysql.c/119 [] [00:11] * Please REPORT this BUG! [00:11] * Check doc/BUG-REPORT on how to do so. [00:11] * Wrote DEBUG [00:11] * SEGMENT VIOLATION -- CRASHING!

Wonder if anyone can think of what is wrong... Might be the login variables being setup wrong, no mysql server running on the host you specified. Or maybe you edited one of the files of the mod...

Statistics: Posted by Galadhrim — Mon Jun 13, 2005 6:53 pm

mysql.mod problem with

2005-06-13T18:18:26-04:00

Hi,

I found the failure. I used wrong mySQL-dev versions.
But now I have one other failure with the server.mod see below in codebox

Code:

vs245184:/usr/src/eggdrop1.6.16# make modulesmake[1]: Entering directory `/usr/src/eggdrop1.6.16/src/mod'make[2]: Entering directory `/usr/src/eggdrop1.6.16/src/mod/assoc.mod'make[2]: Nothing to be done for `modules'.make[2]: Leaving directory `/usr/src/eggdrop1.6.16/src/mod/assoc.mod'make[2]: Entering directory `/usr/src/eggdrop1.6.16/src/mod/blowfish.mod'make[2]: Nothing to be done for `modules'.make[2]: Leaving directory `/usr/src/eggdrop1.6.16/src/mod/blowfish.mod'make[2]: Entering directory `/usr/src/eggdrop1.6.16/src/mod/channels.mod'make[2]: Nothing to be done for `modules'.make[2]: Leaving directory `/usr/src/eggdrop1.6.16/src/mod/channels.mod'make[2]: Entering directory `/usr/src/eggdrop1.6.16/src/mod/compress.mod'make[2]: Nothing to be done for `modules'.make[2]: Leaving directory `/usr/src/eggdrop1.6.16/src/mod/compress.mod'make[2]: Entering directory `/usr/src/eggdrop1.6.16/src/mod/console.mod'make[2]: Nothing to be done for `modules'.make[2]: Leaving directory `/usr/src/eggdrop1.6.16/src/mod/console.mod'make[2]: Entering directory `/usr/src/eggdrop1.6.16/src/mod/ctcp.mod'make[2]: Nothing to be done for `modules'.make[2]: Leaving directory `/usr/src/eggdrop1.6.16/src/mod/ctcp.mod'make[2]: Entering directory `/usr/src/eggdrop1.6.16/src/mod/dns.mod'make[2]: Nothing to be done for `modules'.make[2]: Leaving directory `/usr/src/eggdrop1.6.16/src/mod/dns.mod'make[2]: Entering directory `/usr/src/eggdrop1.6.16/src/mod/filesys.mod'make[2]: Nothing to be done for `modules'.make[2]: Leaving directory `/usr/src/eggdrop1.6.16/src/mod/filesys.mod'make[2]: Entering directory `/usr/src/eggdrop1.6.16/src/mod/irc.mod'make[2]: Nothing to be done for `modules'.make[2]: Leaving directory `/usr/src/eggdrop1.6.16/src/mod/irc.mod'make[2]: Entering directory `/usr/src/eggdrop1.6.16/src/mod/mysql.mod'gcc -pipe -fPIC -g -O2 -Wall -I. -I../../.. -I../../.. -I../../../src/mod -DHAVE                                                           _CONFIG_H  -I/usr/src/mysql/include  -DMAKING_MODS -c .././mysql.mod/mysql.cmv mysql.o ../gcc -pipe -shared -nostartfiles -L/usr/src/mysql/lib/mysql -lmysqlclient -o ../.                                                           ./../mysql.so ../mysql.otouch ../../../mysql.somake[2]: Leaving directory `/usr/src/eggdrop1.6.16/src/mod/mysql.mod'make[2]: Entering directory `/usr/src/eggdrop1.6.16/src/mod/notes.mod'gcc -pipe -fPIC -g -O2 -Wall -I. -I../../.. -I../../.. -I../../../src/mod -DHAVE                                                           _CONFIG_H   -DMAKING_MODS -c .././notes.mod/notes.cmv notes.o ../gcc -pipe -shared -nostartfiles -o ../../../notes.so ../notes.o -L/usr/lib -ltcl                                                           8.4 -lm -lpthread -ldl -lnsltouch ../../../notes.somake[2]: Leaving directory `/usr/src/eggdrop1.6.16/src/mod/notes.mod'make[2]: Entering directory `/usr/src/eggdrop1.6.16/src/mod/seen.mod'gcc -pipe -fPIC -g -O2 -Wall -I. -I../../.. -I../../.. -I../../../src/mod -DHAVE                                                           _CONFIG_H   -DMAKING_MODS -c .././seen.mod/seen.cmv seen.o ../gcc -pipe -shared -nostartfiles -o ../../../seen.so ../seen.otouch ../../../seen.somake[2]: Leaving directory `/usr/src/eggdrop1.6.16/src/mod/seen.mod'make[2]: Entering directory `/usr/src/eggdrop1.6.16/src/mod/server.mod'gcc -pipe -fPIC -g -O2 -Wall -I. -I../../.. -I../../.. -I../../../src/mod -DHAVE                                                           _CONFIG_H   -DMAKING_MODS -c .././server.mod/server.c../server.mod/server.c: In function `next_server':../server.mod/server.c:1047: warning: dereferencing type-punned pointer will bre                                                           ak strict-aliasing rules../server.mod/server.c: At top level:../server.mod/server.c:1341: warning: dereferencing type-punned pointer will bre                                                           ak strict-aliasing rules../server.mod/server.c:1349: warning: dereferencing type-punned pointer will bre                                                           ak strict-aliasing rulesmv server.o ../gcc -pipe -shared -nostartfiles -o ../../../server.so ../server.o -L/usr/lib -lt                                                           cl8.4 -lm -lpthread -ldl -lnsltouch ../../../server.somake[2]: Leaving directory `/usr/src/eggdrop1.6.16/src/mod/server.mod'make[2]: Entering directory `/usr/src/eggdrop1.6.16/src/mod/share.mod'gcc -pipe -fPIC -g -O2 -Wall -I. -I../../.. -I../../.. -I../../../src/mod -DHAVE                                                           _CONFIG_H   -DMAKING_MODS -c .././share.mod/share.cmv share.o ../gcc -pipe -shared -nostartfiles -o ../../../share.so ../share.otouch ../../../share.somake[2]: Leaving directory `/usr/src/eggdrop1.6.16/src/mod/share.mod'make[2]: Entering directory `/usr/src/eggdrop1.6.16/src/mod/transfer.mod'gcc -pipe -fPIC -g -O2 -Wall -I. -I../../.. -I../../.. -I../../../src/mod -DHAVE                                                           _CONFIG_H   -DMAKING_MODS -c .././transfer.mod/transfer.cmv transfer.o ../gcc -pipe -shared -nostartfiles -o ../../../transfer.so ../transfer.o -L/usr/lib                                                            -ltcl8.4 -lm -lpthread -ldl -lnsltouch ../../../transfer.somake[2]: Leaving directory `/usr/src/eggdrop1.6.16/src/mod/transfer.mod'make[2]: Entering directory `/usr/src/eggdrop1.6.16/src/mod/uptime.mod'gcc -pipe -fPIC -g -O2 -Wall -I. -I../../.. -I../../.. -I../../../src/mod -DHAVE                                                           _CONFIG_H   -DMAKING_MODS -c .././uptime.mod/uptime.cmv uptime.o ../gcc -pipe -shared -nostartfiles -o ../../../uptime.so ../uptime.otouch ../../../uptime.somake[2]: Leaving directory `/usr/src/eggdrop1.6.16/src/mod/uptime.mod'make[2]: Entering directory `/usr/src/eggdrop1.6.16/src/mod/wire.mod'gcc -pipe -fPIC -g -O2 -Wall -I. -I../../.. -I../../.. -I../../../src/mod -DHAVE                                                           _CONFIG_H   -DMAKING_MODS -c .././wire.mod/wire.cmv wire.o ../gcc -pipe -shared -nostartfiles -o ../../../wire.so ../wire.otouch ../../../wire.somake[2]: Leaving directory `/usr/src/eggdrop1.6.16/src/mod/wire.mod'All modules compiled.make[1]: Leaving directory `/usr/src/eggdrop1.6.16/src/mod'Test run of ./eggdrop -v:/bin/sh: line 1: ./eggdrop: No such file or directorymake: *** [modules] Error 127

The mysql.mod area seems to be okay but when I start my eggdrop comes the following:

Code:

[00:11] * Last context: mysql:mysql.c/119 [][00:11] * Please REPORT this BUG![00:11] * Check doc/BUG-REPORT on how to do so.[00:11] * Wrote DEBUG[00:11] * SEGMENT VIOLATION -- CRASHING!

I don't know what to do

D4RkViP3R

Statistics: Posted by D4RkViP3R — Mon Jun 13, 2005 6:18 pm

mysql.mod problem with

2005-06-13T13:55:57-04:00

you probably got other errors before that one, let us know what are they

Statistics: Posted by demond — Mon Jun 13, 2005 1:55 pm

mysql.mod problem with

2005-06-13T07:27:02-04:00

Hi matteo,

may you help me to compile the mysql.mod?
I think I'm too stupid to do this.

I copied the mysql sourcecode to /usr/src/mysql and the eggdrop sourcecode to /usr/src/eggdrop1.6.16.
I also copied the mysql.mod tarball to /usr/src/eggdrop1.6.16/src/mysql.mod THEN the mysql include dir to /usr/src/eggdrop1.6.16/src/mysql.mod/mysql

- ./configure --with-mysql=/usr/src/mysql <- works fine
- make config <- works also fine
- make modules <- here some errors compiling the mysql.mod

Code:

In file included from ../mysql.mod/mysql/mysql.h:62,                 from ../mysql.mod/mysql.c:26:../mysql.mod/mysql/my_list.h:32: error: parse error before "int"make[2]: *** [../mysql.o] Error 1make[2]: Leaving directory `/usr/src/eggdrop1.6.16/src/mod/mysql.mod'make[1]: *** [mysql.mod_so] Error 2make[1]: Leaving directory `/usr/src/eggdrop1.6.16/src/mod'make: *** [modules] Error 2

Did I something wrong ?

Best regards,

D4RkViP3R

Statistics: Posted by D4RkViP3R — Mon Jun 13, 2005 7:27 am

mysql.mod problem with

2004-11-05T12:20:26-04:00

yes I got that. Actually I did not do any modification to mysql.mod. I was just interested in the logging to mySQL part.
Yet it doesn't work "out of the box", I was just wondering if I missed something

Statistics: Posted by Guest — Fri Nov 05, 2004 12:20 pm

mysql.mod problem with

2004-11-04T18:29:06-04:00

you have to escape it, and i think the mysql.mod have a function for it, mysql_escape or something like that.

Statistics: Posted by greenbear — Thu Nov 04, 2004 6:29 pm

mysql.mod problem with

2004-11-04T17:40:25-04:00

Hi, I'm trying to use mysql.mod with an eggdrop 1.6.15. It works great, except that it doesn't log messages that contain one or more apostrophees (the ' character).
Any idea what could be involved ? thx in advance

Statistics: Posted by Guest — Thu Nov 04, 2004 5:40 pm