Boyd Lyn Gerber: Not sure why we can get PHP-MySQL functions working?
We're using PHP: php4/4.3.6a (SCO build) Are you using same build of PHP? Thanks! Jim > 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] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
