I've run a site for years with apache 1.x.x, more recently with mod_perl and very recently with mod_auth_mysql, with no problems even after repeated re-installs on newer scavenged HW!
However I'm now close to being at my wits end after trying numerous combinations to include mod_ssl in this, and after being unable to figure the correct order to compile each without breaking the others, gave up on mod_ssl to make way for apache 2, mod_perl 2 and mod_auth_mysql 2.8.1.
To my horror, even this is now a problem, as mod_auth_mysql.so has the following problem:
$ /usr/local/apache2/bin/apachectl restart
Syntax error on line 233 of /usr/local/apache2/conf/httpd.conf:
Cannot load /usr/local/apache2/modules/mod_auth_mysql.so into server: ld.so.1: /usr/local/apache2/bin/httpd: fatal: relocation error: file /usr/local/apache2/modules/mod_auth_mysql.so: symbol __cmpdi2: referenced symbol not found
I've found similar postings of this error message on PHP installs, for which the solution seemed to be to compile with --enable-libgcc, so I've verified that libgcc is in /usr/local/lib and added -L etc, but these break compilation rather than improve anything.
Any clues would be greatly appreciated - I hate to have to go back to apache 1.3.x just because I can't get mod_auth_mysql loaded - but I do really need to use it!
Thanks!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Sorry - I meant to also add that I'm on Solaris 8, using gcc 3.3.2, mysql 4.1.8 binary 32 bit standard (used to have 64 bit, re-installed 32 to see if it helps!), perl 5.8.3...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Well finally, I do know it's only happening with MySql 4.1.8 - 4.0.18 doesn't suffer the same problem. Shame, because I'm really excited about sub-selects!!!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I've been using MySQL 4.1.7 (on Debian) with no problems. 4.1.8 is new enough that I haven't tried it yet. But I'm not sure what might have changed between 4.1.7 and 4.1.8.
The --enable-libgcc is a configure script command. You might try adding the -lgcc flag to the first apxs statement.
If this doesn't work, what other errors do you get?
Jerry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Whenever I add that I get an error that the library is not found. libgcc delivers libgcc_s.so into /usr/local and there is no libgcc.so. I tried various positions for -lgcc, they all result in:
My setup seems to be similar to yours - I have libgcc.a and libgcc_s.so, but no libgcc.so. However, I don't have mysql 4.1.8 working yet. I do know 4.1.7 works fine on Debian with these files, so I suspect it's something else - perhaps with the way they generated 4.1.8.
I'll take a look at the new version, but it may be a couple of days; I'm behind on some other things due to the holidays :-(.
In the mean time, if you're interested, you might try the 4.1.7 version; it should be available from the same places as 4.1.8 via FTP (you might have to manually ftp into the site).
But I will get back to you as soon as I have a chance to check out 4.1.8.
Jerry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I haven't found 4.1.7 - although 4.1.8 is easy to find! But will keep looking, since I would like to use sub-selects. Will be down a few days though: due to failure of gd installation also (it loaded but failed to produce anything worthwhile in png output), I ran out of options and time and decided to start from scratch. Will try 4.1.7 when I have a working system again.
Thanks for your help this far.
/Dave
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Sorry to hear about your installation problems; hope you can get it going again quickly.
You may have to manually ftp to one of the ftp mirrors; that's how I've gotten older releases. Usually there are several releases (and versions) in the download directory.
I may have a little time to look at MySQL 4.1.8 tomorrow; otherwise it will be Thursday.
Jerry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I've run a site for years with apache 1.x.x, more recently with mod_perl and very recently with mod_auth_mysql, with no problems even after repeated re-installs on newer scavenged HW!
However I'm now close to being at my wits end after trying numerous combinations to include mod_ssl in this, and after being unable to figure the correct order to compile each without breaking the others, gave up on mod_ssl to make way for apache 2, mod_perl 2 and mod_auth_mysql 2.8.1.
To my horror, even this is now a problem, as mod_auth_mysql.so has the following problem:
$ /usr/local/apache2/bin/apachectl restart
Syntax error on line 233 of /usr/local/apache2/conf/httpd.conf:
Cannot load /usr/local/apache2/modules/mod_auth_mysql.so into server: ld.so.1: /usr/local/apache2/bin/httpd: fatal: relocation error: file /usr/local/apache2/modules/mod_auth_mysql.so: symbol __cmpdi2: referenced symbol not found
I've found similar postings of this error message on PHP installs, for which the solution seemed to be to compile with --enable-libgcc, so I've verified that libgcc is in /usr/local/lib and added -L etc, but these break compilation rather than improve anything.
Any clues would be greatly appreciated - I hate to have to go back to apache 1.3.x just because I can't get mod_auth_mysql loaded - but I do really need to use it!
Thanks!
Sorry - I meant to also add that I'm on Solaris 8, using gcc 3.3.2, mysql 4.1.8 binary 32 bit standard (used to have 64 bit, re-installed 32 to see if it helps!), perl 5.8.3...
Well finally, I do know it's only happening with MySql 4.1.8 - 4.0.18 doesn't suffer the same problem. Shame, because I'm really excited about sub-selects!!!
Hello, Dave,
I've been using MySQL 4.1.7 (on Debian) with no problems. 4.1.8 is new enough that I haven't tried it yet. But I'm not sure what might have changed between 4.1.7 and 4.1.8.
The --enable-libgcc is a configure script command. You might try adding the -lgcc flag to the first apxs statement.
If this doesn't work, what other errors do you get?
Jerry
Hi Jerry,
Whenever I add that I get an error that the library is not found. libgcc delivers libgcc_s.so into /usr/local and there is no libgcc.so. I tried various positions for -lgcc, they all result in:
/usr/local/apache2/bin/apxs -c -lgcc -L/usr/local/mysql-standard-4.1.8-sun-solaris2.8-sparc/lib -I/usr/local/mysql-standard-4.1.8-sun-solaris2.8-sparc/include -lmysqlclient -lm -lz mod_auth_mysql.c
/usr/local/apache2/build/libtool --silent --mode=compile gcc -prefer-pic -DAP_HAVE_DESIGNATED_INITIALIZER -DSOLARIS2=8 -D_POSIX_PTHREAD_SEMANTICS -D_REENTRANT -pthreads -I/usr/local/apache2/include -I/usr/local/apache2/include -I/usr/local/apache2/include -I/usr/local/mysql-standard-4.1.8-sun-solaris2.8-sparc/include -c -o mod_auth_mysql.lo mod_auth_mysql.c && touch mod_auth_mysql.slo
/usr/local/apache2/build/libtool --silent --mode=link gcc -o mod_auth_mysql.la -I/usr/local/mysql-standard-4.1.8-sun-solaris2.8-sparc/include -L/usr/local/mysql-standard-4.1.8-sun-solaris2.8-sparc/lib -lgcc -lmysqlclient -lm -lz -rpath /usr/local/apache2/modules -module -avoid-version mod_auth_mysql.lo
ld: fatal: library -lgcc: not found
ld: fatal: File processing errors. No output written to .libs/mod_auth_mysql.so
apxs:Error: Command failed with rc=65536
So I think I'm not getting the command right still.
I also upgraded to gcc 3.4.2 last night in further attempts...
/Dave
Dave,
My setup seems to be similar to yours - I have libgcc.a and libgcc_s.so, but no libgcc.so. However, I don't have mysql 4.1.8 working yet. I do know 4.1.7 works fine on Debian with these files, so I suspect it's something else - perhaps with the way they generated 4.1.8.
I'll take a look at the new version, but it may be a couple of days; I'm behind on some other things due to the holidays :-(.
In the mean time, if you're interested, you might try the 4.1.7 version; it should be available from the same places as 4.1.8 via FTP (you might have to manually ftp into the site).
But I will get back to you as soon as I have a chance to check out 4.1.8.
Jerry
Hi Jerry,
I haven't found 4.1.7 - although 4.1.8 is easy to find! But will keep looking, since I would like to use sub-selects. Will be down a few days though: due to failure of gd installation also (it loaded but failed to produce anything worthwhile in png output), I ran out of options and time and decided to start from scratch. Will try 4.1.7 when I have a working system again.
Thanks for your help this far.
/Dave
Dave,
Sorry to hear about your installation problems; hope you can get it going again quickly.
You may have to manually ftp to one of the ftp mirrors; that's how I've gotten older releases. Usually there are several releases (and versions) in the download directory.
I may have a little time to look at MySQL 4.1.8 tomorrow; otherwise it will be Thursday.
Jerry