egghelp/eggheads community

Problems with mysql.mod

2005-11-18T05:47:33-04:00

Wonderfull demond! It's working great!

Thank you so much !!

Buffy

Statistics: Posted by Buffy_25 — Fri Nov 18, 2005 5:47 am

Problems with mysql.mod

2005-11-17T23:43:04-04:00

yeah there should be libz.so link, if there isn't - create one in /usr/lib

Statistics: Posted by demond — Thu Nov 17, 2005 11:43 pm

Problems with mysql.mod

2005-11-17T12:45:47-04:00

Hi demond,

I did a find / -name *libz* and i got the following:

/usr/lib/libz.so.1 (linked to libz.so.1.1.4)
/usr/lib/libz.so.1.1.4
/usr/lib/libzvt.so.2 (linked to libzvt.so.2.2.10)
/usr/lib/libzvt.so.2.2.10

Should there be also a libz.so file? Or is this a normal config?

Buffy

Statistics: Posted by Buffy_25 — Thu Nov 17, 2005 12:45 pm

Problems with mysql.mod

2005-11-16T04:16:33-04:00

there is something wrong with your gcc installation

anyway.. proceed as before, locate libz and copy it to /usr/lib

Statistics: Posted by demond — Wed Nov 16, 2005 4:16 am

Problems with mysql.mod

2005-11-15T12:54:48-04:00

Hi demond.

Thnx for your reply.

I copied all my mysql lib & links (/usr/lib/mysql/) into /usr/lib/
(i had to recreate a link from libmysqlclient.so and libmysqlclient.so.10 to libmysqlclient.so.10.0.0 and same for libmysqlclient_r.so and libmysqlclient_r.so.10 link to libmysqlclient_r.so.10.0.0)

But now i got a different error:

gcc -pipe -shared -nostartfiles -o ../../../mysql.so ../mysql.o `mysql_config --libs`
/usr/bin/ld: cannot find -lz
collect2: ld returned 1 exit status
make[2]: *** [../../../mysql.so] Error 1
make[2]: Leaving directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/mysql.mod'
make[1]: *** [mysql.mod_so] Error 2
make[1]: Leaving directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod'
make: *** [modules] Error 2

Maybe we are already a step further ?

Thank you for your assistance.

Buffy

Statistics: Posted by Buffy_25 — Tue Nov 15, 2005 12:54 pm

Problems with mysql.mod

2005-11-15T04:27:30-04:00

copy mysql libs & links (and fix the links if necessary) to /usr/lib

Statistics: Posted by demond — Tue Nov 15, 2005 4:27 am

Problems with mysql.mod

2005-11-13T04:34:16-04:00

Hi demond,

I looked for the libmysql* files, and i have the following:

/usr/lib/mysql/libmysqlclient.so.10.0.0
/usr/lib/mysql/libmysqlclient.so.10
/usr/lib/mysql/libmysqlclient_r.so.10.0.0
/usr/lib/mysql/libmysqlclient_r.so.10
/usr/lib/mysql/libmysqlclient.a
/usr/lib/mysql/libmysqlclient.so
/usr/lib/mysql/libmysqlclient_r.a
/usr/lib/mysql/libmysqlclient_r.so

I checked the link on libmysqlclient.so (it's linking to libmysqlclient.so.10.0.0)
And the file permissions for the dir /usr/lib/mysql are:

owner: rxw
group: rx
other: rx

Additionally, I checked for the Makefile (in mysql.mod) to change that setting, but i couldn't find the -shared in that makefile. Also, it couldn't be found in the Makefile of:
- eggdrop1.6.17/src/mod/
- eggdrop1.6.17/src/

But, i found that -shared setting in the Makefile in /eggdrop1.6.17/
I changed that into -Bshareable But i still got the same error:

make[2]: Leaving directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/megahal.mod'
make[2]: Entering directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/mysql.mod'
gcc -pipe -Bshareable -nostartfiles -o ../../../mysql.so ../mysql.o `mysql_config --libs`
/usr/bin/ld: cannot find -lmysqlclient
collect2: ld returned 1 exit status
make[2]: *** [../../../mysql.so] Error 1
make[2]: Leaving directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/mysql.mod'
make[1]: *** [mysql.mod_so] Error 2
make[1]: Leaving directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod'
make: *** [modules] Error 2

Since i got the same problem, i have put back -shared as setting.

Do you want me to post the content of each MakeFile i have in the different dir's of my eggdrop1.6.17?
(i didn't edit anything else, exept the things you told me to add...if still same error, i rechanged all as origine to avoid to screw it)

Are there any other possibilities that i could check why i'm getting this error?

Thanks.

Buffy

Statistics: Posted by Buffy_25 — Sun Nov 13, 2005 4:34 am

Problems with mysql.mod

2005-11-11T23:38:55-04:00

check /usr/lib/mysql/libmysql* files

maybe a link is broken (libmysqlclient.so should be a link), or file permissions are not right ones

and try what I said in my last post (replace -shared with -Bshareable in mysql.mod Makefile)

Statistics: Posted by demond — Fri Nov 11, 2005 11:38 pm

Problems with mysql.mod

2005-11-11T15:57:41-04:00

Hi demon.
Thanks for helping me with this.

But i got lost:
I edited the makefile in Eggdrop1.6.17 main dir.
So i had added the 2 lines below (bold in my previous msg)

CFLAGS=-I/usr/include/mysql
LDFLAGS=-L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm

I think you meant that i had to add those outputs to another makefile?
The one in source? or the one in mysql.mod?

So i deleted again the modifications i did to the makefile in eggdrop1.6.17 main dir.

Before i screw everything up, i'll wait for your confirmation (or further actions)

Thanks.

Buffy

Statistics: Posted by Buffy_25 — Fri Nov 11, 2005 3:57 pm

Problems with mysql.mod

2005-11-10T23:15:42-04:00

oops, your mysql.mod Makefile is screwed, fix it

try with -Bshareable instead of -shared

Statistics: Posted by demond — Thu Nov 10, 2005 11:15 pm

Problems with mysql.mod

2005-11-10T23:08:20-04:00

check out also src/Makefile

Statistics: Posted by demond — Thu Nov 10, 2005 11:08 pm

Problems with mysql.mod

2005-11-10T13:04:36-04:00

Hello demond,

So first i went back into my eggdrop1.6.17 dir and typed: make config
After this, i edited my Makefile (eggdrop1.6.17) as below:

#
# This is the Makefile for EGGDROP (the IRC bot)
# You should never need to edit this.
#
# $Id: Makefile.in,v 1.39 2004/07/25 11:17:33 wcc Exp $

SHELL = /bin/sh
top_srcdir = .
srcdir = .

prefix = ${HOME}/eggdrop
DEST = ${prefix}
EGGEXEC = eggdrop
EGGVERSION = 1.6.17

# things you can put here:
# -Wall if you're using gcc and it supports it
# (configure usually detects this anyway now)
#
# -DDEBUG_ASSERT to enable assert debugging
# -DDEBUG_MEM to be able to debug memory allocation (.debug)
# These can both be set by using 'make debug'
# or 'make sdebug'
CFLGS =

# ./configure SHOULD set these; however you may need to tweak them to
# get modules to compile. If you do, PLEASE let the development team know,
# so we can incorporate needed changes into the next release. You can
# contact us at eggdev@eggheads.org, as always.

# Compiler
CC = gcc -pipe
MOD_CC = gcc -pipe
SHLIB_CC = gcc -pipe -fPIC
CFLAGS=-I/usr/include/mysql
LDFLAGS=-L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm

# Linker
LD = gcc -pipe
MOD_LD = gcc -pipe
SHLIB_LD = gcc -pipe -shared -nostartfiles

# Stripping
...

After this, i run the command : Make
But i got the same error:

# make
make: *** Warning: File `Makefile' has modification time in the future (2005-11-10 17:52:12 > 2005-11-10 12:53:38.961234)
make[1]: Entering directory `/home/Buffy/mydir/eggdrop1.6.17/src'
This may take a while. Go get some runts.

make[2]: Entering directory `/home/Buffy/mydir/eggdrop1.6.17/src/md5'
make[2]: Nothing to be done for `md5'.
make[2]: Leaving directory `/home/Buffy/mydir/eggdrop1.6.17/src/md5'
make[2]: Entering directory `/home/Buffy/mydir/eggdrop1.6.17/src/compat'
make[2]: Nothing to be done for `compat'.
make[2]: Leaving directory `/home/Buffy/mydir/eggdrop1.6.17/src/compat'

---------- Yeah! That's the compiling, now the linking! ----------

Linking eggdrop (standard build).

gcc -pipe -o ../eggdrop bg.o botcmd.o botmsg.o botnet.o chanprog.o cmds.o dcc.o
dccutil.o dns.o flags.o language.o match.o main.o mem.o misc.o misc_file.o modules.o net.o rfc1459.o tcl.o tcldcc.o tclhash.o tclmisc.o tcluser.o userent.o userrec.o users.o -L/usr/local/lib -ltcl8.4 -lm -ldl -lnsl md5/md5c.o compat/*.o `cat mod/mod.xlibs`
touch ../eggdrop

Successful compile: eggdrop

make[1]: Leaving directory `/home/Buffy/mydir/eggdrop1.6.17/src'
make[1]: Entering directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod'
make[2]: Entering directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/assoc.mod'
make[2]: Nothing to be done for `modules'.
make[2]: Leaving directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/assoc.mod'
make[2]: Entering directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/blowfish.mod'
make[2]: Nothing to be done for `modules'.
make[2]: Leaving directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/blowfish.mod'
make[2]: Entering directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/channels.mod'
make[2]: Nothing to be done for `modules'.
make[2]: Leaving directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/channels.mod'
make[2]: Entering directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/console.mod'
make[2]: Nothing to be done for `modules'.
make[2]: Leaving directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/console.mod'
make[2]: Entering directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/ctcp.mod'
make[2]: Nothing to be done for `modules'.
make[2]: Leaving directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/ctcp.mod'make[2]: Entering directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/dns.mod'make[2]: Nothing to be done for `modules'.
make[2]: Leaving directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/dns.mod'
make[2]: Entering directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/filesys.mod'
make[2]: Nothing to be done for `modules'.
make[2]: Leaving directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/filesys.mod'
make[2]: Entering directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/irc.mod'make[2]: Nothing to be done for `modules'.
make[2]: Leaving directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/irc.mod'
make[2]: Entering directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/megahal.mod'
make[2]: Nothing to be done for `modules'.
make[2]: Leaving directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/megahal.mod'
make[2]: Entering directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/mysql.mod'
gcc -pipe -shared -nostartfiles -o ../../../mysql.so ../mysql.o `mysql_config --libs`
/usr/bin/ld: cannot find -lmysqlclient
collect2: ld returned 1 exit status
make[2]: *** [../../../mysql.so] Error 1
make[2]: Leaving directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod/mysql.mod'
make[1]: *** [mysql.mod_so] Error 2
make[1]: Leaving directory `/home/Buffy/mydir/eggdrop1.6.17/src/mod'

Did i edited the makefile wrongly?

Thanks in advance.

Buffy

Statistics: Posted by Buffy_25 — Thu Nov 10, 2005 1:04 pm

Problems with mysql.mod

2005-11-09T23:43:49-04:00

add --cflags output to CFLAGS options and --libs output to LDFLAGS options in bot's Makefile (after make config and before make)

Statistics: Posted by demond — Wed Nov 09, 2005 11:43 pm

Problems with mysql.mod

2005-11-09T14:51:51-04:00

In my config i have the following:

# mysql_config
Usage: /usr/bin/mysql_config [OPTIONS]
Options:
--cflags [-I'/usr/include/mysql']
--libs [-L'/usr/lib/mysql' -lmysqlclient -lz -lcrypt -lnsl -lm]
--socket [/var/lib/mysql/mysql.sock]
--port [3306]
--version [3.23.58]
You have new mail in /var/spool/mail/root

Shouldn't i change something in the makefile file from eggdrop1.6.17?
I read something about LDFLAGS,... but i'm not sure though

Can someone help me a bit more please? (or did i forget any steps to check)

Thanks.

Buffy

Statistics: Posted by Buffy_25 — Wed Nov 09, 2005 2:51 pm

Problems with mysql.mod

2005-11-06T05:48:47-04:00

I thought i found the problem, after echo'ing a variable:

echo $LD_LIBRARY_PATH
:/usr/lib/mysql:/usr/lib/mysql:/usr/lib/mysql

So i did :

export LD_LIBRARY_PATH=/usr/lib/mysql
echo $LD_LIBRARY_PATH
/usr/lib/mysql

After this i retried 'make config' and then 'make' in my eggdrop1.6.17 dir,
But in vain

Thank you for your assistance.

Buffy

Statistics: Posted by Buffy_25 — Sun Nov 06, 2005 5:48 am