using libmysql with a eggdrop module

techie · Post by **techie** » Mon Sep 16, 2002 12:55 pm

i did try to compile a eggdrop module with the mysql lib,
but it justs crashes.

this is the makefile:

# Makefile for src/mod/woobie.mod/
# $Id: Makefile,v 1.9 2000/07/09 14:10:49 fabian Exp $

srcdir = .


doofus:
	@echo ""
	@echo "Let's try this from the right directory..."
	@echo ""
	@cd ../../../ && make

static: ../sheep.o

modules: ../../../sheep.$(MOD_EXT)

../sheep.o:
	$(CC) -I/usr/local/include $(CFLAGS) $(CPPFLAGS) -DMAKING_MODS -c $(srcdir)/sheep.c
	@rm -f ../sheep.o
	mv sheep.o ../

../../../sheep.$(MOD_EXT): ../sheep.o
	$(LD) -lmysqlclient -L/usr/local/lib/mysql/ -o ../../../sheep.$(MOD_EXT) ../sheep.o
	$(STRIP) ../../../sheep.$(MOD_EXT)

depend:
	$(CC) $(CFLAGS) $(CPPFLAGS) -MM $(srcdir)/woobie.c > .depend

clean:
	@rm -f .depend *.o *.$(MOD_EXT) *~
distclean: clean

#safety hash
../sheep.o: .././woobie.mod/woobie.c ../../../src/mod/module.h \
 ../../../src/main.h ../../../src/lang.h ../../../src/eggdrop.h \
 ../../../src/flags.h ../../../src/proto.h ../../../lush.h \
 ../../../src/misc_file.h ../../../src/cmdt.h ../../../src/tclegg.h \
 ../../../src/tclhash.h ../../../src/chan.h ../../../src/users.h \
 ../../../src/compat/compat.h ../../../src/compat/inet_aton.h \
 ../../../src/compat/snprintf.h ../../../src/compat/memset.h \
 ../../../src/compat/memcpy.h ../../../src/compat/strcasecmp.h \
 ../../../src/mod/modvals.h ../../../src/tandem.h

stdragon · Post by **stdragon** » Mon Sep 16, 2002 1:13 pm

$(LD) -lmysqlclient -L/usr/local/lib/mysql/ -o ../../../sheep.$(MOD_EXT) ../sheep.o

Have you added /usr/local/lib/mysql to the LD_LIBRARY_PATH environment variable?

In .bash_profile add the command:

export LD_LIBRARY_PATH=/usr/local/lib/mysql

techie · Post by **techie** » Mon Sep 16, 2002 1:18 pm

i added it now..
same thing happend...

<tech> .tcl loadmodule cocacola
<TNet> [13:17] * Last context: tclhash.c/677 [Tcl proc: *dcc:tcl, param: $_dcc1 $_dcc2 $_dcc3]
<TNet> [13:17] * Please REPORT this BUG!
<TNet> [13:17] * Check doc/BUG-REPORT on how to do so.
<TNet> [13:17] * Wrote DEBUG
<TNet> [13:17] * SEGMENT VIOLATION -- CRASHING!

stdragon · Post by **stdragon** » Mon Sep 16, 2002 1:21 pm

Use gdb to figure out the exact cause of the error as suggested in the other thread.

techie · Post by **techie** » Mon Sep 16, 2002 1:34 pm

could u help me?

ive tryed, but couldnt get it to work

stdragon · Post by **stdragon** » Mon Sep 16, 2002 1:44 pm

1. Change to your bot's dir.

2. Type "ls" and look for a core file.

3. Type "gdb eggdrop corefilename" (where corefilename is the name of the core file)

4. In gdb, if it says "(no debugging symbols found)..." then you do not have debugging enabled. Read the INSTALL file to find out how to enable debugging.

5. Type "where" in gdb to find out where the bot crashed.

If this is too hard, then try debugging your code with "putlog". You can see which putlogs succeed and which fail. Then you can narrow down where your module is crashing.

techie · Post by **techie** » Mon Sep 16, 2002 2:51 pm

whats a core file? the .so file?

Mo-Ize · Post by **Mo-Ize** » Mon Sep 16, 2002 5:54 pm

usualy the core file name is simply "core"; but you must have compiled your eggdrop doing "make debug".
I bet there are nice introductions to gdb on the web.

stdragon · Post by **stdragon** » Mon Sep 16, 2002 5:54 pm

No it's a filed called "core" or "core.pid" like I said above. If you don't have it, then you don't have debugging turned on.

Either recompile eggdrop with debugging, or add your own putlogs for debugging.

egghelp/eggheads community

using libmysql with a eggdrop module

using libmysql with a eggdrop module

yes

blah

hmm