egghelp/eggheads community

fbsql help

2003-02-11T15:48:58-04:00

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.

Statistics: Posted by ppslim — Tue Feb 11, 2003 3:48 pm

fbsql help

2003-02-11T15:26:49-04:00

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?

Statistics: Posted by svahn — Tue Feb 11, 2003 3:26 pm

fbsql help

2003-02-10T21:57:47-04:00

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?

Statistics: Posted by svahn — Mon Feb 10, 2003 9:57 pm

fbsql help

2003-02-10T15:16:19-04:00

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.

Statistics: Posted by stdragon — Mon Feb 10, 2003 3:16 pm

fbsql help

2003-02-10T14:38:34-04:00

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:

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.

Statistics: Posted by svahn — Mon Feb 10, 2003 2:38 pm

fbsql help

2003-02-10T12:03:57-04:00

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?

Statistics: Posted by ppslim — Mon Feb 10, 2003 12:03 pm

fbsql help

2003-02-10T11:57:38-04:00

Yes i have looked at that site.

But i have another problem now.

when i start my eggdrop and the scripts run:

Code:

set conn [sql connect ip user pass]

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

Statistics: Posted by svahn — Mon Feb 10, 2003 11:57 am

fbsql help

2003-02-10T05:34:15-04:00

Code:

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

Statistics: Posted by ppslim — Mon Feb 10, 2003 5:34 am

fbsql help

2003-02-09T21:08:23-04:00

Hello,

I having some trouble with the sql-tcl commands.

in PHP i write:

Code:

$srlat_check = mysql_num_rows($sql_srlat_check);

how should that line look like in tcl?

Statistics: Posted by svahn — Sun Feb 09, 2003 9:08 pm