#16 Won't compile with MySQL 4.0.18 Gentoo Linux

[Brave Cobra]

cc tclient.o tproduct.o tservice.o tinstance.o tjob.o
tclientconfig.o tconfig.o tparameter.o tparamtype.o
tperiod.o tstatus.o tauthorize.o tserviceglue.o
tinvoice.o tpaid.o tinvoiceitems.o tinvoicestatus.o
ttemplate.o tconfiguration.o tpayment.o tshipping.o
tproducttype.o main.o cgi.o -o mysqlISP.cgi
/usr/lib/mysql/libmysqlclient.a -lz -lcrypt -lm
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x2a):
In function `report_errors':
: undefined reference to `ERR_get_error_line_data'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0xac):
In function `vio_ssl_read':
: undefined reference to `SSL_read'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0xd2):
In function `vio_ssl_read':
: undefined reference to `SSL_get_error'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x102):
In function `vio_ssl_write':
: undefined reference to `SSL_write'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x2a1):
In function `vio_ssl_close':
: undefined reference to `SSL_shutdown'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x2b1):
In function `vio_ssl_close':
: undefined reference to `SSL_free'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x3ed):
In function `sslaccept':
: undefined reference to `SSL_new'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x44b):
In function `sslaccept':
: undefined reference to `SSL_clear'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x459):
In function `sslaccept':
: undefined reference to `SSL_get_session'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x46c):
In function `sslaccept':
: undefined reference to `SSL_SESSION_set_timeout'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x480):
In function `sslaccept':
: undefined reference to `SSL_set_fd'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x48e):
In function `sslaccept':
: undefined reference to `SSL_set_accept_state'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x49c):
In function `sslaccept':
: undefined reference to `SSL_do_handshake'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x4b2):
In function `sslaccept':
: undefined reference to `SSL_get_peer_certificate'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x4c0):
In function `sslaccept':
: undefined reference to `X509_get_subject_name'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x4d8):
In function `sslaccept':
: undefined reference to `X509_NAME_oneline'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x4e8):
In function `sslaccept':
: undefined reference to `X509_get_issuer_name'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x500):
In function `sslaccept':
: undefined reference to `X509_NAME_oneline'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x510):
In function `sslaccept':
: undefined reference to `X509_free'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x52e):
In function `sslaccept':
: undefined reference to `SSL_get_shared_ciphers'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x548):
In function `sslaccept':
: undefined reference to `SSL_free'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x5c5):
In function `sslconnect':
: undefined reference to `SSL_new'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x622):
In function `sslconnect':
: undefined reference to `SSL_clear'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x630):
In function `sslconnect':
: undefined reference to `SSL_get_session'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x640):
In function `sslconnect':
: undefined reference to `SSL_SESSION_set_timeout'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x654):
In function `sslconnect':
: undefined reference to `SSL_set_fd'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x662):
In function `sslconnect':
: undefined reference to `SSL_set_connect_state'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x670):
In function `sslconnect':
: undefined reference to `SSL_do_handshake'
/usr/lib/mysql/libmysqlclient.a(viossl.o)(.text+0x689):
In function `sslconnect':
: undefined reference to `SSL_free'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x8):
In function `get_dh512':
: undefined reference to `DH_new'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x2a):
In function `get_dh512':
: undefined reference to `BN_bin2bn'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x49):
In function `get_dh512':
: undefined reference to `BN_bin2bn'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x61):
In function `get_dh512':
: undefined reference to `DH_free'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x96):
In function `report_errors':
: undefined reference to `ERR_get_error_line_data'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0xd5):
In function `vio_set_cert_stuff':
: undefined reference to `SSL_CTX_use_certificate_file'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0xf6):
In function `vio_set_cert_stuff':
: undefined reference to `SSL_CTX_use_PrivateKey_file'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x102):
In function `vio_set_cert_stuff':
: undefined reference to `SSL_CTX_check_private_key'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x151):
In function `vio_set_cert_stuff':
: undefined reference to `ERR_print_errors_fp'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x1ad):
In function `vio_set_cert_stuff':
: undefined reference to `ERR_print_errors_fp'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x1ef):
In function `vio_verify_callback':
: undefined reference to `X509_STORE_CTX_get_current_cert'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x1f9):
In function `vio_verify_callback':
: undefined reference to `X509_STORE_CTX_get_error'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x201):
In function `vio_verify_callback':
: undefined reference to `X509_STORE_CTX_get_error_depth'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x20f):
In function `vio_verify_callback':
: undefined reference to `X509_get_subject_name'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x223):
In function `vio_verify_callback':
: undefined reference to `X509_NAME_oneline'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x258):
In function `vio_verify_callback':
: undefined reference to `X509_get_issuer_name'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x26c):
In function `vio_verify_callback':
: undefined reference to `X509_NAME_oneline'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x2f2):
In function `new_VioSSLConnectorFd':
: undefined reference to `TLSv1_client_method'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x2fd):
In function `new_VioSSLConnectorFd':
: undefined reference to `SSL_CTX_new'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x319):
In function `new_VioSSLConnectorFd':
: undefined reference to `SSL_CTX_set_cipher_list'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x333):
In function `new_VioSSLConnectorFd':
: undefined reference to `SSL_CTX_set_verify'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x36c):
In function `new_VioSSLConnectorFd':
: undefined reference to `SSL_CTX_load_verify_locations'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x37a):
In function `new_VioSSLConnectorFd':
: undefined reference to `SSL_CTX_set_default_verify_paths'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x3a3):
In function `new_VioSSLConnectorFd':
: undefined reference to `SSL_CTX_ctrl'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x3ab):
In function `new_VioSSLConnectorFd':
: undefined reference to `DH_free'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x3d0):
In function `new_VioSSLConnectorFd':
: undefined reference to `SSL_load_error_strings'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x3e1):
In function `new_VioSSLConnectorFd':
: undefined reference to
`OPENSSL_add_all_algorithms_noconf'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x434):
In function `new_VioSSLAcceptorFd':
: undefined reference to `TLSv1_server_method'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x43f):
In function `new_VioSSLAcceptorFd':
: undefined reference to `SSL_CTX_new'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x45b):
In function `new_VioSSLAcceptorFd':
: undefined reference to `SSL_CTX_set_cipher_list'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x47d):
In function `new_VioSSLAcceptorFd':
: undefined reference to `SSL_CTX_ctrl'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x497):
In function `new_VioSSLAcceptorFd':
: undefined reference to `SSL_CTX_set_verify'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x4b0):
In function `new_VioSSLAcceptorFd':
: undefined reference to `SSL_CTX_set_session_id_context'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x4e9):
In function `new_VioSSLAcceptorFd':
: undefined reference to `SSL_CTX_load_verify_locations'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x4f7):
In function `new_VioSSLAcceptorFd':
: undefined reference to `SSL_CTX_set_default_verify_paths'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x520):
In function `new_VioSSLAcceptorFd':
: undefined reference to `SSL_CTX_ctrl'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x528):
In function `new_VioSSLAcceptorFd':
: undefined reference to `DH_free'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x54d):
In function `new_VioSSLAcceptorFd':
: undefined reference to `SSL_load_error_strings'
/usr/lib/mysql/libmysqlclient.a(viosslfactories.o)(.text+0x55e):
In function `new_VioSSLAcceptorFd':
: undefined reference to
`OPENSSL_add_all_algorithms_noconf'
collect2: ld returned 1 exit status
make: *** [mysqlISP.cgi] Error 1

This is recent Gentoo installation with a 2.6.5 kernel.
MySQL version = 4.0.18

[Admin Role]

Logged In: YES
user_id=61124

Your bug has been assigned.

How quickly it is acted on depends on several factors. The most
important are:
1. How detailed you were in describing your problem.
2. Background information like OS and Databases.
3. Including the circumstances which will reproduce the errors.
4. The potential number of users effected by this bug.
5. How serious the bug is ( operational versus cosmetic ).

Please keep the assigned bug number for reference. If you later
post a patch, please also reference this bug number.

Thank you for your help! Good software requires good bug reports.

[Admin Role]

Logged In: YES
user_id=61124

Seems to be a mysql distribution problem on that linux
distro. I would try using the client libs directly from
www.mySQL.com. Also check the mysql versions installed and
where.

[Brave Cobra]

Logged In: YES
user_id=221652

I solved it by removing the SSL support from mysql (in
Gentoo this is just a USE flag -ssl).
I suggest to either add this information to the install doc
or make the code compatible.

[Admin Role]

Logged In: YES
user_id=61124

Thanks! For your great bug report and solution! We will fix
shortly.

[Brave Cobra]

Logged In: YES
user_id=221652

If those files don't include SSL support it'll probably
work. However I see no point in excluding functionality in a
3rd party package just to make this one work. Lots of other
packages depend on MySQL and some insist on SSL support. It
should be possible to adapt this one too.

[Admin Role]

Logged In: YES
user_id=61124

Solution edit makefile and link to libssl with womthing like

-lssl