egghelp/eggheads community

Use Mysql server from Eggdrop

2003-01-03T21:39:02-04:00

Google.

If you click the "I feel lucky" button, you are zipped tot he homepage.

Statistics: Posted by ppslim — Fri Jan 03, 2003 9:39 pm

Use Mysql server from Eggdrop

2003-01-03T19:41:06-04:00

my friend have FreeBSD and i need mysqltcl where can i find that ?

Statistics: Posted by Guest — Fri Jan 03, 2003 7:41 pm

Use Mysql server from Eggdrop

2002-05-02T20:55:00-04:00

intel pentium 233 with mmx extentions o/

Statistics: Posted by Guest — Thu May 02, 2002 8:55 pm

Use Mysql server from Eggdrop

2002-05-02T20:45:00-04:00

What kind of processor do you have? Usually bus errors are caused by misaligned memory access on strict cpus.

For instance, say you have a structure defined like this:
struct blah {
char flag;
int something;
};

The structure is aligned properly, but when you try to access the "something" variable, that int isn't aligned properly unless your compiler automatically adds padding to the char field.

But on Intel processors, misaligned access doesn't cause a bus error, only a time penalty (2 accesses instead of 1).

I don't know, it might be caused by something else, but I'm just curious.

Statistics: Posted by stdragon — Thu May 02, 2002 8:45 pm

Use Mysql server from Eggdrop

2002-05-02T20:39:00-04:00

On 2002-04-30 08:03, Mad0nna wrote:
Hello
I'm running:
-Freebsd4.5 (i386)
-mysql Ver 11.15 Distrib 3.23.47, for -freebsd4.5 (i386)
-Eggdrop v1.6.9: 5 users (mem: 88k)
-TCL8.3

I need to access the Mysql server from the eggdrop, and make standard
SQL queries like SELECT, INSERT, UPDATE etc.

As mentioned, those are the versions 'm running. I'll try to update the things you mentioned, and see if it helps. thanx.

Statistics: Posted by Guest — Thu May 02, 2002 8:39 pm

Use Mysql server from Eggdrop

2002-05-02T20:30:00-04:00

First of all, what OS are you using? It's pretty clear that it's non-standard, or at least that you didn't set up the development environment correctly.

If your OS uses a package-based system for things like the compiler, try getting the latest upgrades to gcc, make, libtool, configure, and libc. See if you can get the packages to install in standard locations, instead of weird stuff like /usr/lib/compat/linux or wherever.

If you don't have a package mechanism... well, maybe install a different OS I think you'll find things are a lot easier if you install linux or even windows.

What you really need to do is contact the authors of these libraries you're trying to install. This forum is primarily for eggdrop help. These aren't eggdrop modules you're compiling, they're tcl modules. As such, chances are that nobody here knows very many specifics about them, including odd things you run into when compiling them, especially when you're on an unfamiliar OS.

Statistics: Posted by stdragon — Thu May 02, 2002 8:30 pm

Use Mysql server from Eggdrop

2002-05-02T15:15:00-04:00

As for the tcl-sql package, I got a bit further, but when I try to compile it now I get:

[pluppa@bsd:~/madonna/tcl-sql/tcl-sql]gmake clean ; gmake
Cleaned
cc -c -I/usr/local/include/mysql -I/usr/local/include/tcl8.3/generic -Wall -o obj/sql-mysql.o sql-mysql.cc
cc -c -I/usr/local/include/mysql -I/usr/local/include/tcl8.3/generic -Wall -o obj/sql.o sql.cc
cc -c -I/usr/local/include/mysql -I/usr/local/include/tcl8.3/generic -Wall -o obj/sql-manager.o sql-manager.cc
g++ obj/sql-mysql.o obj/sql.o obj/sql-manager.o -L/usr/lib -lmysqlclient -shared -lg++ -lstdc++ -lm -lgcc_pic -o sql.so
/usr/libexec/elf/ld: cannot find -lg++
gmake: *** [sql.so] Error 1

I saw in the group Mordred linked to ( http://groups.yahoo.com/group/tclsql/me ... threaded=1 ), that this means it can't find the libg++ library.. I've done some searches for libg++ and added the paths I found to the makefile but still the same error. Can someone tell me how to locate the correct path ? Or how to make the compiler find the needed library ?

[ This Message was edited by: Mad0nna on 2002-05-02 13:16 ]

Statistics: Posted by Guest — Thu May 02, 2002 3:15 pm

Use Mysql server from Eggdrop

2002-05-02T13:23:00-04:00

When I set the LD_LIBRARY_PATH (which was previously unset) to:
[bsd:~/madonna]export LD_LIBRARY_PATH="/usr/compat/linux/lib"
which is the path of the libnsl.so.1, but when i try to:

% load /usr/local/lib/libmysqltcl.so
Bus error (core dumped)

and it exits tclsh..

As for the ld.so.conf, i found it in /usr/compat/linux/etc and i edited it and put the path of libnsl.so.1 in it. I seem to be unable to find the mysql libs though.. nothing in /usr/local/lib or /usr/lib. The mysql client & server are both installed. Where can I find them ?

Statistics: Posted by Guest — Thu May 02, 2002 1:23 pm

Use Mysql server from Eggdrop

2002-05-02T11:17:00-04:00

As for the mysqltcl package, you might want to follow the all important step, of not just editing the Makefile.org, but ranmining it to Makefile.

It's all well and good editing a file to your needs, but there aint much point unless you expect a program to know whats on your mind.

Statistics: Posted by ppslim — Thu May 02, 2002 11:17 am

Use Mysql server from Eggdrop

2002-05-01T14:07:00-04:00

Stdragon is correct. You might also like to check their forums, linked from their main page.

http://groups.yahoo.com/group/tclsql/

It doesnt show much sign of life any more, but I have seen an old thread mentioning similar to your problem.

Statistics: Posted by Guest — Wed May 01, 2002 2:07 pm

Use Mysql server from Eggdrop

2002-05-01T01:10:00-04:00

If it can't find libnsl.so.1, then you should install that library. It should be on your computer already, at /lib/libnsl.so.1, unless you don't have a recent version of glibc installed.

Maybe it's installed in /usr/local/lib instead, for some reason, and your LD_LIBRARY_PATH variable doesn't include that directory. Is /usr/local/lib in your /etc/ld.so.conf? As well as the location of the mysql libs?

Statistics: Posted by stdragon — Wed May 01, 2002 1:10 am

Use Mysql server from Eggdrop

2002-04-30T20:26:00-04:00

Thank you and no I haven't, it looks nice and well documented.
After I edit the Makefile and set the right paths, I try to run "make clean ; make". I get the following error:

[madonna@bsd:~/tcl-sql]make clean ; make
Cleaned
make: don't know how to make obj/sql-mysql.o. Stop

Any suggestions ?
I noticed the package included precompiled versions for lunix and solaris, would it be possible to just download a precompiled one ?

Statistics: Posted by Guest — Tue Apr 30, 2002 8:26 pm

Use Mysql server from Eggdrop

2002-04-30T19:49:00-04:00

Have you tried this TCL-SQL package? Works fine here. With docs etc.

http://www.bluetitan.com/~tdarugar/tcl-sql/

Statistics: Posted by Guest — Tue Apr 30, 2002 7:49 pm

Use Mysql server from Eggdrop

2002-04-30T17:02:00-04:00

I won't bother listing all the steps I've taken so far, so I've started over. I downloaded a fresh copy of mysqltcl-2.0rc11.tar.gz, unpacked, edited Makefile.org and set the following paths:

# paths to -> tcl.h mysql.h
INCLUDE=-I/usr/local/include/tcl8.3 -I/usr/local/include/mysql

These paths are correct to the best of my knowledge. Still, I get this error when i run ./configure (after running about 20 secs):

------
checking for tcl.h... no
configure: error: Can't find tcl.h which is needed to build MySQLTcl. Consult README and
INSTALL to fix it.
--------
I've tried messing around with the parameters it suggests, but no luck.

If the configure script doesn't work, the INSTALL file suggests copying config.org -> config.h and then running "make -f Makefile.org". I've done this, and it resulted in a libmysqltcl.so around 4kb in size. I've copied this to the /usr/local/lib dir (as this is where it was supposed to be copied by the configure script, i think).
When i try to load the libmysqltcl.so from the regular tclsh:
% load /usr/local/lib/libmysqltcl.so
couldn't load file "/usr/local/lib/libmysqltcl.so": Shared object "libnsl.so.1" not found

I'm guessing this is because the configure script never got to do whatever it's doing ?

Is it correct to assume that once i get the libmysqltcl.so working in tclsh, it should be easy to load it in the eggdrop's tcl scripts ?

Statistics: Posted by Guest — Tue Apr 30, 2002 5:02 pm

Use Mysql server from Eggdrop

2002-04-30T13:07:00-04:00

Can you list the steps you took, to which led you to the conclusion "They don't work"?

I have used all 3 of the above Tcl packages without fail.

What errors do you get?
How you tried obtaining support for these errors?
How exactly are you trying to load the packages in to Tcl?
Have you sat and read the documentation.

Statistics: Posted by ppslim — Tue Apr 30, 2002 1:07 pm