On Sun, 18 Jul 2004, Jim Ginn wrote: > 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?
I am using the one that is in MP3/UP3.... # php --version PHP 4.3.6 (cli) (built: May 12 2004 21:48:27) Copyright (c) 1997-2004 The PHP Group Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies > > 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] > > > > > > > -- 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]
