Re: php 4.03pl1 + mysql 3.23.27-beta won't communicate

> On Tue, 31 Oct 2000, Kevin McGuinness wrote: > > Have you compiled MySQL into PHP, this needs to be done for PHP to > > recognise mysql functions. > > > > --with-mysql=/<location of mysql> > > yep, I did that... the problem is that it seems to be looking for something > in mySQL which it cannot find. I had this problem with snort as well (an > unidentifed symbol being called) and this I fixed by adding -lm to LDFLAGS in > the Makefile, tried this with PHP but sadly it didn't work. Perhaps you have > any other ideas that I can work on? Hi, I had similar problem with MySQL : the DSO couldn't find two symbols -compress and uncompress. The problem was (I suppose) that headers didn't match exactly the libs. The way I used to solve the problem is the following: -first do not build PHP as a DSO -you can do this later, when it will work. -when PHP is ok, build apache and activate the module : --activate-module. -then if there's unresolved symbols -and there is- the build of apache should fail, but the difference is that you'll have more explicit error messages.Like the caller of the function. After this, the only method I found to make PHP working was to build MySQL from the source, and restart the process from the beginning. It's really strange, and the first time I dealt with such a problem... You can also try -I don't know if you have this on FreeBSD- the command: ldd -d libphp4.so It should display the broken dependencies. bye > > > Mikael Schmidt wrote: > > > Hello, > > > > > > I have installed PHP 4.03pl1 and earlier I had apache 1.3.14 with modssl > > > and mysql 3.23.27-beta up and running perfectly on the machine. However, > > > I cannot get PHP to communicate with my mySQL database. I am running > > > OpenBSD 2.7 on an i386 architecture. This is from my apache error_log; > > > > > > /usr/libexec/ld.so: Undefined symbol "_mysql_init" called from > > > httpd:/usr/local/paket/apache/libexec/libphp4.so at 0x403cd1e0 > > > > > > PHP is compiled as a DSO. > > > > > > Grateful for ideas on what can be the error so that I can start searching > > > and fixing the problem. > > > > > > -- > > > Mikael Schmidt - mikael.schmidt@ldc.lu.se > > > tfn: +46(0)46 - 222 47 35 > > > mob: +46(0)707 - 46 60 56 > > > > > > - > > -- > > Kevin McGuinness > > Software Developer > > iTouch Ireland > > 3050 Lake Drive > > City West Digital Park > > Co.Dublin