On Sun, 18 Jul 2004, Jim Ginn wrote: > First - Thanks again for your help.
Your welcome. > Second - Installed SCO release supplements, Apache 1.3.31, PHP Version > 4.3.6 (--with-mysql=shared), and MySQL 4.1.3-beta. > > MySQL is running fine. PHP is recognized Apache. But PHP is not able to > find the the MySQL shared libraries. Simple PHP MySQL function request > are not found ? > > Have you had any luck in interfacing PHP and MySQL on SCO Openserver? I do not have any problems... I do have the following <VirtualHost hostname> SetEnv PATH "/bin:/usr/bin:/usr/local/bin:/usr/local/mysql/bin:" SetEnv LD_LIBRARY_PATH "/usr/lib:/lib:/usr/local/lib:/usr/local/mysql/lib/mysql:/usr/local/bdb:/usr/local/ssl/lib:" PassEnv PATH LD_LIBRARY_PATH ... #options I want for this virtual host </VirtualHost> > Thanks Again, > > Jim > > Our Configure Command > './configure' '--with-apxs=/usr/lib/apache/bin/apxs' '--prefix=/usr' > '--with-exec-dir=/usr/lib/php/bin' '--with-config-file-path=/usr/lib/php' > '--with-png-dir=/usr' '--with-xpm-dir=/usr' '--with-zlib-dir=/usr' > '--with-jpeg-dir=/usr' '--with-tiff-dir=/usr' '--with-freetype-dir=/usr' > '--with-expat-dir=/usr' '--with-xslt-sablot=/usr' '--with-sablot-js=/usr' > '--with-openssl=shared,/usr' '--with-zlib=shared,/usr' > '--with-bz2=shared,/usr' '--with-curl=shared,/usr' '--with-gdbm=shared' > '--with-ndbm=shared' '--with-db4=shared,/usr' '--with-flatfile=shared' > '--with-dom=shared,/usr' '--with-dom-xslt=shared,/usr' > '--with-dom-exslt=shared,/usr' '--with-iconv=shared' > '--with-gettext=shared,/usr' '--with-gd=shared,/usr' '--with-ttf-dir=/usr' > '--with-freetype=shared,/usr' '--with-ldap=shared,/usr' '--with-regex=php' > '--with-pcre-regex=/usr' '--with-mm=/usr' '--with-ttf=shared' > '--with-zlib=shared' '--with-dbm=shared' '--with-readline=shared,/usr' > '--with-mysql=shared' '--with-pgsql=shared,/usr' '--with-expat-dir=/usr' > '--enable-calendar=shared' '--enable-dba=shared' '--enable-dbase=shared' > '--enable-dbx=shared' '--enable-dio=shared' '--enable-exif=shared' > '--enable-filepro=shared' '--enable-ftp=shared' '--enable-gd-native-ttf' > '--enable-trans-id' '--enable-shmop=shared' '--enable-sockets=shared' > '--enable-sysvmsg=shared' '--enable-sysvsem=shared' > '--enable-sysvshm=shared' '--enable-wddx=shared' > '--enable-mbstring=shared' '--enable-tokenizer=shared' > '--enable-expat=shared' '--enable-xslt=shared' '--enable-magic-quotes' > '--enable-inline-optimization' '--enable-sigchild' '-- > > > On Tue, 13 Jul 2004, Jim Ginn wrote: > >> Much better but it complains about max_allowed_packet? It is set to the > >> default 1M ... > > > > I have my stune set as follows. > > > > NODE "osr507" > > EVDEVS 96 > > EVQUEUES 88 > > NSPTTYS 64 > > NUMSP 256 > > NSTREAM 4352 > > NHINODE 1024 > > GPGSLO 1000 > > GPGSHI 3000 > > NSTRPAGES 4000 > > NAIOPROC 50 > > NAIOREQ 400 > > NAIOBUF 400 > > NAIOHBUF 100 > > NAIOREQPP 400 > > NAIOLOCKTBL 50 > > MAX_PROC 10000 > > MAXUMEM 1048576 > > NCALL 256 > > NCLIST 512 > > NSTREVENT 14848 > > NUMTIM 1888 > > NUMTRW 1888 > > SDSKOUT 64 > > SEMMAP 8192 > > SEMMNI 8192 > > SEMMNS 8192 > > SEMMSL 150 > > SEMMNU 150 > > SHMMAX 2147483647 > > TTHOG 4096 > > SECLUID 0 > > SECSTOPIO 1 > > SECCLEARID 1 > > MAXUP 4096 > > NOFILES 4096 > > SHMMNI 200 > > > > > >> Installing all prepared tables > >> Fill help tables > >> ERROR: 1153 Got a packet bigger than 'max_allowed_packet' bytes > >> 040713 17:43:07 Aborting > >> > >> 040713 17:43:07 ./bin/mysqld: Shutdown complete > >> > >> > >> > >> > On Tue, 13 Jul 2004, Jim Ginn wrote: > >> >> Updated to (your) 4.1.3-beta and now get: > >> >> > >> >> ./bin/mysqld --skip-grant & > >> >> dynamic linker : ./bin/mysqld : could not open libssl.so.0.9.6m > >> >> > >> >> Check in /usr/lib and see: > >> >> > >> >> l /usr/lib/libssl* > >> >> -r-xr-xr-x 3 bin bin 191812 Sep 20 2003 > >> >> /usr/lib/libssl.so@ > >> >> -r-xr-xr-x 3 bin bin 191812 Sep 20 2003 > >> >> /usr/lib/libssl.so.0@ > >> >> -r-xr-xr-x 3 bin bin 191812 Sep 20 2003 > >> >> /usr/lib/libssl.so.0.9.6@ > >> >> -r--r--r-- 1 bin bin 38044 Sep 20 2003 > >> /usr/lib/libsso.a@ > >> > > >> > I am currently using openssl-0.9.6m. You will find a complete static > >> and > >> > binary of what I am using in openssl-0.9.6m-osr5.tar.gz > >> > > >> > ftp://ftp.zenez.com/pub/zenez/prgms/openssl-0.9.6m-osr5.tar.gz > >> > > >> > I usually install it in /usr/local/ssl. Most people install it in > >> > /usr/lib. You can also put links from /usr/local/ssl/lib to /usr/lib/ > >> > > >> > > >> > > >> >> > On Tue, 13 Jul 2004, Jim Ginn wrote: > >> >> >> Trying to get MySQL running on SCO Openserver 5.0.7 and get this > >> >> >> message: > >> >> >> > >> >> >> dynamic linker: ./bin/mysqld: binder error: symbol not found: > >> >> >> pthread_key_delete; referenced from: ./bin/mysqld > >> >> > > >> >> > This was an error for some versions of MySQL. This is fixed in > >> >> > MySQL-4.0.19 forward. You will need FSU-threads-3.14 or new. > >> >> > > >> >> >> And I have FSU threads installed ... > >> >> > > >> >> > I made a special version of FSU-threads for this but then worked > >> with > >> >> > MySQL on a better solution as the creator of FSU-threads did not > >> want > >> >> to > >> >> > make changes and release a new version. > >> >> > > >> >> > Good Luck, > >> >> > > >> >> > -- > >> >> > Boyd Gerber <[EMAIL PROTECTED]> > >> >> > ZENEZ 1042 East Fort Union #135, Midvale Utah 84047 > >> >> > > >> >> > > >> >> > >> > > >> > -- > >> > Boyd Gerber <[EMAIL PROTECTED]> > >> > ZENEZ 1042 East Fort Union #135, Midvale Utah 84047 > >> > > >> > > >> > > > > -- > > Boyd Gerber <[EMAIL PROTECTED]> > > ZENEZ 1042 East Fort Union #135, Midvale Utah 84047 > > > > > -- Boyd Gerber <[EMAIL PROTECTED]> ZENEZ 1042 East Fort Union #135, Midvale Utah 84047 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]