fbsql help

svahn · Post by **svahn** » Sun Feb 09, 2003 9:08 pm

Hello,

I having some trouble with the sql-tcl commands.

in PHP i write:

$srlat_check = mysql_num_rows($sql_srlat_check);

how should that line look like in tcl?

ppslim · Post by **ppslim** » Mon Feb 10, 2003 5:34 am

Code: Select all

set number_of_rows [sql numrows]

Will return the number of rows returned in the last query.

Please see the manual pages and documentation for this (avilable HERE).

svahn · Post by **svahn** » Mon Feb 10, 2003 11:57 am

Yes i have looked at that site.

But i have another problem now.

when i start my eggdrop and the scripts run:

Code: Select all

set conn [sql connect ip user pass]

the bot stops responding and i cant get in to partyline, why is that?

ppslim · Post by **ppslim** » Mon Feb 10, 2003 12:03 pm

First off, with fbsql, you don't need to capture a socket handle or any such thing. Thus the "set conn" and the ][ can be dropped.

Second, how laggy is the connection between the bots system, and the MySQL server?

This maybe where the issue lies. Other things include issues with the version of libmysql.dll

Are yous ure this is where the bot is stopping? Have your tried putlog log lines either side of the command, to test what is and isn't taking place?

svahn · Post by **svahn** » Mon Feb 10, 2003 2:38 pm

It doesnt matter now, i guess something was wrong with the eggdrop because it doesnt stop now.

I have the MySQL server and eggdrop on the same computer, so it should not lagg.

I've tried that one with putlog's.

in PHP i use 127.0.0.1 as host, use it in the tcl script too, but it doesnt work.

the line is now:

Code: Select all

sql connect 127.0.0.1 user passwd

in partyline i get:

Error 2003 (Can't connect to MySQL server on '127.0.0.1' (111))

I cant get it.. why it cant connect, it works perfectly in PHP with 127.0.0.1.
I'm out of ideas.

stdragon · Post by **stdragon** » Mon Feb 10, 2003 3:16 pm

Could it be a user permissions issue? Your eggdrop process probably isn't running with the same UID as your web server. Also, try looking in the mysql logs for connection attempts/failures, that may provide helpful information.

svahn · Post by **svahn** » Mon Feb 10, 2003 9:57 pm

Yes its something with my MySQL server, because i tried to connect to my friends MySQL server and i got that it was the wrong user and so.. but i reached the server anyway..

I couldnt find anything in the localhost.err file or did you mean any other logfile?

the user i'm trying to connect with have ALL privileges, but i dont think its a user permissions fault.

Do you think it would work if i run the mysqlserver and the eggdrop under the same user?

svahn · Post by **svahn** » Tue Feb 11, 2003 3:26 pm

I know what the problem is now.

My MySQL server runs on port 3310 and the default port is 3306, and i think fbsql thinks my server has the port 3306 too.

Can i modify that somewhere?

ppslim · Post by **ppslim** » Tue Feb 11, 2003 3:48 pm

You can easier restart the MySQL server on the correct port, or you will have to re-comoile the fbsql library, changing the source code to use the correct port.