RE: MySQL problems on FBSD 5.2.1
I have it working, but don't know if it is the right answer. Some of the info I got hinted at rebuilding in a different order. So I uninstall apache2, mod_php4, and mysql4. Then rebuilt the ports in this order MySQL, then apache, and last mod_php. The problem still existed. I found another port /usr/ports/databases/php4-mysql. After a reboot that solved the problem. Is the right way to fix my problem I don't know, but it does appear to of fixed the problem. Thanks all for their input. Steve B. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of steveb99 > Sent: Friday, November 19, 2004 9:39 AM > To: [EMAIL PROTECTED] > Subject: MySQL problems on FBSD 5.2.1 > > I installed mod_PHP which installed Apache 2 from ports. All that > works fine. I then install MySQL4 port and have it working fine > standalone. What I can't get to work is calling MySQL from > PHP code. > The code hits the call to MySQL functions and does nothing, > just stops > at that line and the web server puts up a blank screen. I > have looked > at http error logs and nothing. I have put debug statements > in the PHP code and it does execute up to the first MySQL > line trying to connect. > > $db = MySQL_pconnect('localhost', 'mysqlacct', 'mysqlpw'); > > What am I missing. I have been reading articles on the internet and > everything is talking about old versions or doing it from source not > ports. I assume this can be done from ports? From reading > I get the > feeling I installed in the wrong order, or there is more > configuration I am missings. > > Can someone help point me to what I am missing here. > ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: MySQL problems on FBSD 5.2.1
Hi steveb99, Friday, November 19, 2004, 6:39:01 PM, you wrote: > I installed mod_PHP which installed Apache 2 from ports. All that > works fine. I then install MySQL4 port and have it working fine > standalone. What I can't get to work is calling MySQL from PHP code. > The code hits the call to MySQL functions and does nothing, just stops > at that line and the web server puts up a blank screen. I have looked > at http error logs and nothing. I have put debug statements in the PHP > code and it does execute up to the first MySQL line trying to connect. > $db = MySQL_pconnect('localhost', 'mysqlacct', 'mysqlpw'); > What am I missing. I have been reading articles on the internet and > everything is talking about old versions or doing it from source not > ports. I assume this can be done from ports? From reading I get the > feeling I installed in the wrong order, or there is more configuration I > am missings. > Can someone help point me to what I am missing here. do you have php4(5?)-extensions port installed with mysql support? if not, install it and then notice... > Thanks, np > Steve B. -- Best Regards, +--==/\/\==--+ (__) FreeBSD | DanGer <[EMAIL PROTECTED]> |\\\'',) The | [EMAIL PROTECTED] ICQ261701668 | \/ \ ^Power | http://danger.homeunix.org | .\._/_)To +--==\/\/==--+ Serve [ A man without religion is like a fish without a bicycle. ] ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: MySQL problems on FBSD 5.2.1
Daniel Bye wrote: On Fri, Nov 19, 2004 at 06:49:37PM +0100, Zeroke wrote: Don't know if the ports automaticly compile PHP with MySQL support. No - it doesn't. Look for the entry tagged 20040719 in /usr/ports/UPDATING. It will tell you all about it. A good debugging technique here is to make a .php file with the following in it: Then look at it in a web browser. It will display information about your php installation. Normally, if you haven't compiled in myswl support, you'll get a Call to unknown function type error rather than a hang, though. If you haven't got mysql support in there, fix that first (install the databases/php[4|5]-mysql port). If you still have probs, mail the list again. Peter. -- the circle squared network systems and software http://www.circlesquared.com ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: MySQL problems on FBSD 5.2.1
On Fri, Nov 19, 2004 at 06:49:37PM +0100, Zeroke wrote: > Don't know if the ports automaticly compile PHP with MySQL support. No - it doesn't. Look for the entry tagged 20040719 in /usr/ports/UPDATING. It will tell you all about it. Dan -- Daniel Bye PGP Key: ftp://ftp.slightlystrange.org/pgpkey/dan.asc PGP Key fingerprint: 3B9D 8BBB EB03 BA83 5DB4 3B88 86FC F03A 90A1 BE8F _ ASCII ribbon campaign ( ) - against HTML, vCards and X - proprietary attachments in e-mail / \ pgpSzjdnoSR99.pgp Description: PGP signature
Re: MySQL problems on FBSD 5.2.1
Don't know if the ports automaticly compile PHP with MySQL support. Maybe install PHP from source with the --with-mysql parameter? (Since version 5 of PHP it does not include MySQL support from its own.) Good luck, Zeroke [EMAIL PROTECTED] - Original Message - From: "steveb99" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 19, 2004 6:39 PM Subject: MySQL problems on FBSD 5.2.1 I installed mod_PHP which installed Apache 2 from ports. All that works fine. I then install MySQL4 port and have it working fine standalone. What I can't get to work is calling MySQL from PHP code. The code hits the call to MySQL functions and does nothing, just stops at that line and the web server puts up a blank screen. I have looked at http error logs and nothing. I have put debug statements in the PHP code and it does execute up to the first MySQL line trying to connect. $db = MySQL_pconnect('localhost', 'mysqlacct', 'mysqlpw'); What am I missing. I have been reading articles on the internet and everything is talking about old versions or doing it from source not ports. I assume this can be done from ports? From reading I get the feeling I installed in the wrong order, or there is more configuration I am missings. Can someone help point me to what I am missing here. Thanks, Steve B. ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]" ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
MySQL problems on FBSD 5.2.1
I installed mod_PHP which installed Apache 2 from ports. All that works fine. I then install MySQL4 port and have it working fine standalone. What I can't get to work is calling MySQL from PHP code. The code hits the call to MySQL functions and does nothing, just stops at that line and the web server puts up a blank screen. I have looked at http error logs and nothing. I have put debug statements in the PHP code and it does execute up to the first MySQL line trying to connect. $db = MySQL_pconnect('localhost', 'mysqlacct', 'mysqlpw'); What am I missing. I have been reading articles on the internet and everything is talking about old versions or doing it from source not ports. I assume this can be done from ports? From reading I get the feeling I installed in the wrong order, or there is more configuration I am missings. Can someone help point me to what I am missing here. Thanks, Steve B. ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"