Re: PHP and MySQL

Victor, I was having the same (or similar) linking problems under Solaris 8. What confused me was that Apache with PHP and MySQL had compiled perfectly on our production machine under Solaris 2.6 in an installation from a couple of years ago (Apache 1.3.0 and PHP 3.0.15 with MySQL 3.21.33). So to test a hypothesis, I tried compiling Apache 1.3.12, PHP 4.0.0 with MySQL 3.21.33 (MySQL was from the pre-compiled binary tarball) on our production machine. As it turns out, Apache/PHP/MySQL compiles perfectly under Solaris 2.6. Some more investigation revealed that Solaris 8 was using a newer version of the ELF libraries. I'm thinking that it's either a problem with the ELF libraries themselves or with the setup of the libraries in Solaris 8. Under Solaris 2.6, I just ran the configure scripts for PHP and Apache as prescribed in the plethora of resources out there, and it worked just fine. We did, however, add a symlink in /usr/local/mysql/lib called mysql and point it to ./ . This seemed to solve a single linking error (not the same ones as I was getting under Solaris 8) in PHP, but otherwise, it wasn't complaining about anything else. My sysadmin is right now going back over my footsteps to see if I missed anything when I was trying to compile under Solaris 8. I'll keep you up-to-date on our progress...that is, if we find anything. Good luck! Stephen. P.S.--I'm glad to know that I'm not the only one having this problem. Victor wrote: > > Hi, I sometime have problems compiling PHP with MySQL. I get errors > relating to linking to MySQL libraries. I do not like to use the > included mysql libs as they cause frequent errors when working with > mysql (dropping connections and etc) (at least on the Solaris 7 > platform). I've heard numerous complaints on this list about php > problems with solaris. I have a feeling it has something to do with > library setup and locations. > > However when compiling with links to real libs, there are problems. How > do explicitly specify mysql location? > > include ? > libs ? > > MySQL in in /usr/local/mysql > Libs in /usr/local/mysql/libs > Inlcude /usr/local/mysql/include > > I use --with-mysql=/usr/local/mysql > > Is that right? > Is LD_LIBRARY_PATH supposed to have /usr/local/mysql/libs ?? > > What are the MYSQL_INCLUDE, MYSQL_LIBS, MYSQL_LFLAGS variables? I can't > find any documentation about them anywhere. > > Thanks for any info. > If you have links to docs from TCX ro PHP that describe these issues, > please post them too. I am aware of the docs on --with-mysql, those do > not answer my question though. > > Victor > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- Computer Terms: Programmer - A red-eyed, mumbling mammal capable of conversing with inanimate objects. Stephen Hui, ARL:UT, Austin, TX