phpBB3, php5 and mysql
I'm in the process of moving a phpBB3 forum to a new machine (formerly 5.2, now 7.1). I also was so keen to move to php5 (was running php4 before, I believe). I have the phpBB3 forum directory copied back into the DocumentRoot. Mysql 4.1 is running, The database is there, I can log in to mysql and view the database. I can get phpinfo. Only I can't get the hell out of the phpBB3 forum. When I invoke the index.php I get a blank page with an incomplete xml header. I have no idea were to look at the moment. It looks a bit like php5 is not accessing the database (mysql) or something. Is there some module or driver to be compiled in? I installed php5 now from ports with the apache mod_php5 module being installed. Any help welcome, -- Christoph Kukulies ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: phpBB3, php5 and mysql
On Tuesday 24 March 2009 18:35:56 Christoph Kukulies wrote: Only I can't get the hell out of the phpBB3 forum. When I invoke the index.php I get a blank page with an incomplete xml header. I have no idea were to look at the moment. It looks a bit like php5 is not accessing the database (mysql) or something. Is there some module or driver to be compiled in? I installed php5 now from ports with the apache mod_php5 module being installed. If you installed phpBB3 from ports, php5-mysql should've been installed. Php5 has been split into modules. You may want to visit lang/php5-extensions for the meta port and install what you need. -- Mel ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: phpBB3, php5 and mysql
Christoph Kukulies wrote: I'm in the process of moving a phpBB3 forum to a new machine (formerly 5.2, now 7.1). I also was so keen to move to php5 (was running php4 before, I believe). I have the phpBB3 forum directory copied back into the DocumentRoot. Mysql 4.1 is running, The database is there, I can log in to mysql and view the database. I can get phpinfo. Only I can't get the hell out of the phpBB3 forum. When I invoke the index.php I get a blank page with an incomplete xml header. I have no idea were to look at the moment. Wherever PHP places its errors? On my installations, it's /var/log/httpd_error_log. This might be configurable via PHP's ini file, or PHP's ini_set(), or from the system's syslog.conf ... not certain. It looks a bit like php5 is not accessing the database (mysql) or something. Is there some module or driver to be compiled in? I installed php5 now from ports with the apache mod_php5 module being installed. PHP is great about telling what's wrong ... if it's configured to do so. Once you have an error message, it'll be easier to know how to fix it. Kevin Kinsey -- Ever wonder if taxation without representation might have been cheaper? ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
RE: PHP5 and MySQL
So it seems that my ports collectionwas indeed out of date, even though I installed FreeBSD 6.1 only two weeks back. Lesson learnt: always update ports collection after installing FreeBSD. I am doing MySQL 5.0 instead of 5.1, I do not want a beta release, and I am comparing and doing an analysis against a propreitary DB. I have used MySQL in the past, and believe it is a better choice for our case. Thanks for all the help, esp Gerard, Matthew fbsd. I am going to try and build/install everything. If I run into problems again and I run out of everything, I will come back here. Thanks folks! Best Wishes, Omer -Original Message- From: Gerard Seibert [mailto:[EMAIL PROTECTED] Sent: Sunday, August 27, 2006 4:18 PM To: Muhammad Omer Iqbal Subject: Re: PHP5 and MySQL It certainly sounds like you have an old version of the ports tree installed. They this and see if it corrects things. Have you ever run 'portsnap'? If not, now is a good time to start. As root, run the following: portsnap fetch portsnap extract portsnap update The extract command will take awhile, but it only has to be run once. After this, anytime you want to update the ports tree you would simply run: portsnap fetch update The three commands I gave you will rebuild build your ports tree with the latest updates. Now, ,migrate to /usr/ports/databases/mysql51-server and run: make install make clean If it complains about any other version being installed you will have to navigate to that directory and run make deinstall to remove it manually. Then return and run the above command again/ Next, navigate to the /usr/ports/lang/php5 directory and run make config Make sure that the Build Apache Module is checked Leave the others at there default settings. Make sure you do 'tab' to OK and hit return to save the settings. Now, enter: make install make clean When finished, everything should be running correctly. If you have not done so already, you must place: mysql_enable=YES in the /etc/rc.conf file. Now reboot the system and all should be well. Ciao! -- Gerard Seibert [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
PHP5 and MySQL
Hi folks, I have problems with PHP5 and MySQL running together. I know this is a freebsd mailing list, not PHP/MySQL, but I am unable to find an appropriate mailing list for getting my problem resolved. Can someone help and let me know what the right mailing list is? Thanks Omer (Please do include me in the reply as I am not on the freebsd-questions mailing list.) ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: PHP5 and MySQL
Muhammad Omer Iqbal wrote: I have problems with PHP5 and MySQL running together. I know this is a freebsd mailing list, not PHP/MySQL, but I am unable to find an appropriate mailing list for getting my problem resolved. Can someone help and let me know what the right mailing list is? http://www.php5forum.com/index.php http://www.mysql.com/ Have you just tried Googling for a possible solution? It might help if you actually posted exactly what your problem is. Perhaps someone here might be able to assist you. -- Gerard Seibert [EMAIL PROTECTED] Love does not consist in gazing at each other but in looking together in the same direction. Antoine de Saint-Exupéry smime.p7s Description: S/MIME cryptographic signature
RE: PHP5 and MySQL
I have gone through the mysql and php docs and there are some possible solutions listed, none of those worked. Of course, I tried looking for a solution first before sending it here, this is like one of the last resort places, don't want to bug people with something trivial or easily fixable. I can post the problem here, but again, I was not too sure if this is the right place to post the questions. Anyhow, here it is. PHP5 documentation says that mysql and mysqli libraries are no longer shipped with PHP and refers to MySQL page and documentation on how to install PHP support for MySQL. The precise solution is here: http://dev.mysql.com/doc/refman/5.0/en/php-mysql-mysqli.html I first tried to enable only mysql, and then both mysql and mysqli. I get the same error in both cases on my web-server (MySQL is installed on the same server too): Fatal error: Class 'mysqli' not found in /usr/local/www/apache22/data/test.php on line 7 Looking through phpinfo, I do not find mysql or mysqli installed, even though I have enabled, remade and reinstalled both MySQL and PHP5. In fact, I think that my PHP5 is no longer remade, it just reconfigures it and reinstalls it because the build date shows as Aug 22 even though I did it today and my server date shows as Aug 27. I installed both of these using the ports collection, but then I had to manually download MySQL because of versioning issues, and untar and install it using the command line. Thanks, Omer -Original Message- From: Gerard Seibert [mailto:[EMAIL PROTECTED] Sent: Sunday, August 27, 2006 4:25 AM To: freebsd-questions@freebsd.org Cc: Muhammad Omer Iqbal Subject: Re: PHP5 and MySQL Muhammad Omer Iqbal wrote: I have problems with PHP5 and MySQL running together. I know this is a freebsd mailing list, not PHP/MySQL, but I am unable to find an appropriate mailing list for getting my problem resolved. Can someone help and let me know what the right mailing list is? http://www.php5forum.com/index.php http://www.mysql.com/ Have you just tried Googling for a possible solution? It might help if you actually posted exactly what your problem is. Perhaps someone here might be able to assist you. -- Gerard Seibert [EMAIL PROTECTED] Love does not consist in gazing at each other but in looking together in the same direction. Antoine de Saint-Exupéry ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: PHP5 and MySQL
Muhammad Omer Iqbal wrote: I have gone through the mysql and php docs and there are some possible solutions listed, none of those worked. Of course, I tried looking for a solution first before sending it here, this is like one of the last resort places, don't want to bug people with something trivial or easily fixable. I can post the problem here, but again, I was not too sure if this is the right place to post the questions. Anyhow, here it is. PHP5 documentation says that mysql and mysqli libraries are no longer shipped with PHP and refers to MySQL page and documentation on how to install PHP support for MySQL. The precise solution is here: http://dev.mysql.com/doc/refman/5.0/en/php-mysql-mysqli.html I first tried to enable only mysql, and then both mysql and mysqli. I get the same error in both cases on my web-server (MySQL is installed on the same server too): Fatal error: Class 'mysqli' not found in /usr/local/www/apache22/data/test.php on line 7 Looking through phpinfo, I do not find mysql or mysqli installed, even though I have enabled, remade and reinstalled both MySQL and PHP5. In fact, I think that my PHP5 is no longer remade, it just reconfigures it and reinstalls it because the build date shows as Aug 22 even though I did it today and my server date shows as Aug 27. I installed both of these using the ports collection, but then I had to manually download MySQL because of versioning issues, and untar and install it using the command line. Please don't top post! What version issue are you referring to? I am assuming that you installed both MySQL and PHP5 from an updated ports collection. Did you run: 'make config' in the PHP5 directory before building the port? -- Gerard Seibert [EMAIL PROTECTED] 'Marijauna' was the Mexican name given to cannabis. smime.p7s Description: S/MIME cryptographic signature
RE: PHP5 and MySQL
I am sorry, being a newbie, I do not know what this means: Please don't top post! What version issue are you referring to? As for this: I am assuming that you installed both MySQL and PHP5 from an updated ports collection. Did you run: 'make config' in the PHP5 directory before building the port? I recently installed Apache 2.2, so it is as updated a ports collection as I could get. I did make config. Even if I just do make, or make install, it runs config first and then does the install. However, like I said, I did make config and then did a remake, that did not really work - my PHP make is still dated Aug 22. -Original Message- From: Gerard Seibert [mailto:[EMAIL PROTECTED] Sent: Sunday, August 27, 2006 5:26 AM To: freebsd-questions@freebsd.org Cc: Muhammad Omer Iqbal Subject: Re: PHP5 and MySQL Muhammad Omer Iqbal wrote: I have gone through the mysql and php docs and there are some possible solutions listed, none of those worked. Of course, I tried looking for a solution first before sending it here, this is like one of the last resort places, don't want to bug people with something trivial or easily fixable. I can post the problem here, but again, I was not too sure if this is the right place to post the questions. Anyhow, here it is. PHP5 documentation says that mysql and mysqli libraries are no longer shipped with PHP and refers to MySQL page and documentation on how to install PHP support for MySQL. The precise solution is here: http://dev.mysql.com/doc/refman/5.0/en/php-mysql-mysqli.html I first tried to enable only mysql, and then both mysql and mysqli. I get the same error in both cases on my web-server (MySQL is installed on the same server too): Fatal error: Class 'mysqli' not found in /usr/local/www/apache22/data/test.php on line 7 Looking through phpinfo, I do not find mysql or mysqli installed, even though I have enabled, remade and reinstalled both MySQL and PHP5. In fact, I think that my PHP5 is no longer remade, it just reconfigures it and reinstalls it because the build date shows as Aug 22 even though I did it today and my server date shows as Aug 27. I installed both of these using the ports collection, but then I had to manually download MySQL because of versioning issues, and untar and install it using the command line. Please don't top post! What version issue are you referring to? I am assuming that you installed both MySQL and PHP5 from an updated ports collection. Did you run: 'make config' in the PHP5 directory before building the port? -- Gerard Seibert [EMAIL PROTECTED] 'Marijauna' was the Mexican name given to cannabis. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: PHP5 and MySQL
Sorry, typo. I recently installed Apache 2.2, so it is as updated a ports collection as I could get. I meant to say I recently installed FreeBSD 6.0. -Original Message- From: Muhammad Omer Iqbal [mailto:[EMAIL PROTECTED] Sent: Sunday, August 27, 2006 5:42 AM To: 'freebsd-questions@freebsd.org' Subject: RE: PHP5 and MySQL I am sorry, being a newbie, I do not know what this means: Please don't top post! What version issue are you referring to? As for this: I am assuming that you installed both MySQL and PHP5 from an updated ports collection. Did you run: 'make config' in the PHP5 directory before building the port? I recently installed Apache 2.2, so it is as updated a ports collection as I could get. I did make config. Even if I just do make, or make install, it runs config first and then does the install. However, like I said, I did make config and then did a remake, that did not really work - my PHP make is still dated Aug 22. -Original Message- From: Gerard Seibert [mailto:[EMAIL PROTECTED] Sent: Sunday, August 27, 2006 5:26 AM To: freebsd-questions@freebsd.org Cc: Muhammad Omer Iqbal Subject: Re: PHP5 and MySQL Muhammad Omer Iqbal wrote: I have gone through the mysql and php docs and there are some possible solutions listed, none of those worked. Of course, I tried looking for a solution first before sending it here, this is like one of the last resort places, don't want to bug people with something trivial or easily fixable. I can post the problem here, but again, I was not too sure if this is the right place to post the questions. Anyhow, here it is. PHP5 documentation says that mysql and mysqli libraries are no longer shipped with PHP and refers to MySQL page and documentation on how to install PHP support for MySQL. The precise solution is here: http://dev.mysql.com/doc/refman/5.0/en/php-mysql-mysqli.html I first tried to enable only mysql, and then both mysql and mysqli. I get the same error in both cases on my web-server (MySQL is installed on the same server too): Fatal error: Class 'mysqli' not found in /usr/local/www/apache22/data/test.php on line 7 Looking through phpinfo, I do not find mysql or mysqli installed, even though I have enabled, remade and reinstalled both MySQL and PHP5. In fact, I think that my PHP5 is no longer remade, it just reconfigures it and reinstalls it because the build date shows as Aug 22 even though I did it today and my server date shows as Aug 27. I installed both of these using the ports collection, but then I had to manually download MySQL because of versioning issues, and untar and install it using the command line. Please don't top post! What version issue are you referring to? I am assuming that you installed both MySQL and PHP5 from an updated ports collection. Did you run: 'make config' in the PHP5 directory before building the port? -- Gerard Seibert [EMAIL PROTECTED] 'Marijauna' was the Mexican name given to cannabis. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: PHP5 and MySQL
Muhammad Omer Iqbal wrote: Looking through phpinfo, I do not find mysql or mysqli installed, even though I have enabled, remade and reinstalled both MySQL and PHP5. In fact, I think that my PHP5 is no longer remade, it just reconfigures it and reinstalls it because the build date shows as Aug 22 even though I did it today and my server date shows as Aug 27. I installed both of these using the ports collection, but then I had to manually download MySQL because of versioning issues, and untar and install it The PHP5 port has been divided into a fairly large number of modules. To add MySQL support within PHP5, simply install the databases/php5-mysql port. (Or php5-mysqli, but only if you're running mysql-4.1.x) Note that php5-mysql will cause one of the mysql-client ports to be installed as a dependency -- unless you install one of the other versions before hand, that will get you the mysql 5.0.x client. You will still need to install one of the mysql server ports, unless your DB is physically hosted on a different machine. Oh -- and the other trap for newbies is that you need to 'make config' in the lang/php5 port and make sure the 'Apache' box is checked before you'll get the Apache PHP5 module built and installed. Cheers, Matthew -- Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate Kent, CT11 9PW signature.asc Description: OpenPGP digital signature
RE: PHP5 and MySQL
I just installed PHP5 Mysql5 from the ports collection without any problems. And yes this is correct place to ask question about installing PHP5 Mysql5 on Freebsd 6.1 system. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Muhammad Omer Iqbal Sent: Sunday, August 27, 2006 6:08 AM To: freebsd-questions@freebsd.org Subject: PHP5 and MySQL Hi folks, I have problems with PHP5 and MySQL running together. I know this is a freebsd mailing list, not PHP/MySQL, but I am unable to find an appropriate mailing list for getting my problem resolved. Can someone help and let me know what the right mailing list is? Thanks Omer (Please do include me in the reply as I am not on the freebsd-questions mailing list.) ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: PHP5 and MySQL
My installation also completed without any problems. However, it is the php5-mysql/mysqli libraries that are missing. This will show up as a problem only when you try to connect to mysql from a php web-page. Otherwise, my server runs php just fine, and I am also able to run mysql and issue queries to it from a command line. -Original Message- From: fbsd [mailto:[EMAIL PROTECTED] Sent: Sunday, August 27, 2006 7:31 AM To: Muhammad Omer Iqbal; freebsd-questions@freebsd.org Subject: RE: PHP5 and MySQL I just installed PHP5 Mysql5 from the ports collection without any problems. And yes this is correct place to ask question about installing PHP5 Mysql5 on Freebsd 6.1 system. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Muhammad Omer Iqbal Sent: Sunday, August 27, 2006 6:08 AM To: freebsd-questions@freebsd.org Subject: PHP5 and MySQL Hi folks, I have problems with PHP5 and MySQL running together. I know this is a freebsd mailing list, not PHP/MySQL, but I am unable to find an appropriate mailing list for getting my problem resolved. Can someone help and let me know what the right mailing list is? Thanks Omer (Please do include me in the reply as I am not on the freebsd-questions mailing list.) ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: PHP5 and MySQL
hello, there are some mailing lists which may suit your needs. http://www.php.net/mailing-lists.php my recommendation is general user list. regards, ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: PHP5 and MySQL
Thank you for the help! It seems strange to have to install it again especially when I installed php5-extensions with mysql and mysqli extensions. When I tried to make, it tries to fetches MySQL 4.1 whereas I have 5.0 installed. How can I update the version? I have updated Makefile.ext in PHP5 directory with DEFAULT_MYSQL_VER=50, but to no avail. -Original Message- From: Matthew Seaman [mailto:[EMAIL PROTECTED] Sent: Sunday, August 27, 2006 7:13 AM To: Muhammad Omer Iqbal Cc: freebsd-questions@freebsd.org Subject: Re: PHP5 and MySQL Muhammad Omer Iqbal wrote: Looking through phpinfo, I do not find mysql or mysqli installed, even though I have enabled, remade and reinstalled both MySQL and PHP5. In fact, I think that my PHP5 is no longer remade, it just reconfigures it and reinstalls it because the build date shows as Aug 22 even though I did it today and my server date shows as Aug 27. I installed both of these using the ports collection, but then I had to manually download MySQL because of versioning issues, and untar and install it The PHP5 port has been divided into a fairly large number of modules. To add MySQL support within PHP5, simply install the databases/php5-mysql port. (Or php5-mysqli, but only if you're running mysql-4.1.x) Note that php5-mysql will cause one of the mysql-client ports to be installed as a dependency -- unless you install one of the other versions before hand, that will get you the mysql 5.0.x client. You will still need to install one of the mysql server ports, unless your DB is physically hosted on a different machine. Oh -- and the other trap for newbies is that you need to 'make config' in the lang/php5 port and make sure the 'Apache' box is checked before you'll get the Apache PHP5 module built and installed. Cheers, Matthew -- Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate Kent, CT11 9PW ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: PHP5 and MySQL
I have HTML/php5 web site that connects to mysql5 database and adds new records, deletes records and searches. Sounds to me like you did not do make options and select php-mysql interface of php5 before doing make install. For some reason in Freebsd 6.1 they removed php-mysql interface as default. This was discussed in detail before on questions list. Check archives for the details. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Muhammad Omer Iqbal Sent: Sunday, August 27, 2006 10:41 AM To: [EMAIL PROTECTED]; freebsd-questions@freebsd.org Subject: RE: PHP5 and MySQL My installation also completed without any problems. However, it is the php5-mysql/mysqli libraries that are missing. This will show up as a problem only when you try to connect to mysql from a php web-page. Otherwise, my server runs php just fine, and I am also able to run mysql and issue queries to it from a command line. -Original Message- From: fbsd [mailto:[EMAIL PROTECTED] Sent: Sunday, August 27, 2006 7:31 AM To: Muhammad Omer Iqbal; freebsd-questions@freebsd.org Subject: RE: PHP5 and MySQL I just installed PHP5 Mysql5 from the ports collection without any problems. And yes this is correct place to ask question about installing PHP5 Mysql5 on Freebsd 6.1 system. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Muhammad Omer Iqbal Sent: Sunday, August 27, 2006 6:08 AM To: freebsd-questions@freebsd.org Subject: PHP5 and MySQL Hi folks, I have problems with PHP5 and MySQL running together. I know this is a freebsd mailing list, not PHP/MySQL, but I am unable to find an appropriate mailing list for getting my problem resolved. Can someone help and let me know what the right mailing list is? Thanks Omer (Please do include me in the reply as I am not on the freebsd-questions mailing list.) ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: PHP5 and MySQL
And by the way, I already have MySQL 5.0 as a .tar in the mysql folder, so probably all I need to do is let php5-mysql extension know how to access that .tar file. -Original Message- From: Muhammad Omer Iqbal [mailto:[EMAIL PROTECTED] Sent: Sunday, August 27, 2006 9:48 AM To: 'Matthew Seaman' Cc: 'freebsd-questions@freebsd.org' Subject: RE: PHP5 and MySQL Thank you for the help! It seems strange to have to install it again especially when I installed php5-extensions with mysql and mysqli extensions. When I tried to make, it tries to fetches MySQL 4.1 whereas I have 5.0 installed. How can I update the version? I have updated Makefile.ext in PHP5 directory with DEFAULT_MYSQL_VER=50, but to no avail. -Original Message- From: Matthew Seaman [mailto:[EMAIL PROTECTED] Sent: Sunday, August 27, 2006 7:13 AM To: Muhammad Omer Iqbal Cc: freebsd-questions@freebsd.org Subject: Re: PHP5 and MySQL Muhammad Omer Iqbal wrote: Looking through phpinfo, I do not find mysql or mysqli installed, even though I have enabled, remade and reinstalled both MySQL and PHP5. In fact, I think that my PHP5 is no longer remade, it just reconfigures it and reinstalls it because the build date shows as Aug 22 even though I did it today and my server date shows as Aug 27. I installed both of these using the ports collection, but then I had to manually download MySQL because of versioning issues, and untar and install it The PHP5 port has been divided into a fairly large number of modules. To add MySQL support within PHP5, simply install the databases/php5-mysql port. (Or php5-mysqli, but only if you're running mysql-4.1.x) Note that php5-mysql will cause one of the mysql-client ports to be installed as a dependency -- unless you install one of the other versions before hand, that will get you the mysql 5.0.x client. You will still need to install one of the mysql server ports, unless your DB is physically hosted on a different machine. Oh -- and the other trap for newbies is that you need to 'make config' in the lang/php5 port and make sure the 'Apache' box is checked before you'll get the Apache PHP5 module built and installed. Cheers, Matthew -- Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate Kent, CT11 9PW ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: PHP5 and MySQL
Review the questions archives for details on how to correct this problem. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Muhammad Omer Iqbal Sent: Sunday, August 27, 2006 12:48 PM To: 'Matthew Seaman' Cc: freebsd-questions@freebsd.org Subject: RE: PHP5 and MySQL Thank you for the help! It seems strange to have to install it again especially when I installed php5-extensions with mysql and mysqli extensions. When I tried to make, it tries to fetches MySQL 4.1 whereas I have 5.0 installed. How can I update the version? I have updated Makefile.ext in PHP5 directory with DEFAULT_MYSQL_VER=50, but to no avail. -Original Message- From: Matthew Seaman [mailto:[EMAIL PROTECTED] Sent: Sunday, August 27, 2006 7:13 AM To: Muhammad Omer Iqbal Cc: freebsd-questions@freebsd.org Subject: Re: PHP5 and MySQL Muhammad Omer Iqbal wrote: Looking through phpinfo, I do not find mysql or mysqli installed, even though I have enabled, remade and reinstalled both MySQL and PHP5. In fact, I think that my PHP5 is no longer remade, it just reconfigures it and reinstalls it because the build date shows as Aug 22 even though I did it today and my server date shows as Aug 27. I installed both of these using the ports collection, but then I had to manually download MySQL because of versioning issues, and untar and install it The PHP5 port has been divided into a fairly large number of modules. To add MySQL support within PHP5, simply install the databases/php5-mysql port. (Or php5-mysqli, but only if you're running mysql-4.1.x) Note that php5-mysql will cause one of the mysql-client ports to be installed as a dependency -- unless you install one of the other versions before hand, that will get you the mysql 5.0.x client. You will still need to install one of the mysql server ports, unless your DB is physically hosted on a different machine. Oh -- and the other trap for newbies is that you need to 'make config' in the lang/php5 port and make sure the 'Apache' box is checked before you'll get the Apache PHP5 module built and installed. Cheers, Matthew -- Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate Kent, CT11 9PW ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: PHP5 and MySQL
Muhammad Omer Iqbal wrote: And by the way, I already have MySQL 5.0 as a .tar in the mysql folder, so probably all I need to do is let php5-mysql extension know how to access that .tar file. A .tar of what? The sources? Better put them into /usr/ports/distfiles. It seems strange to have to install it again especially when I installed php5-extensions with mysql and mysqli extensions. Hmmm... Well that should have installed the php5-mysql port for you, certainly. When I tried to make, it tries to fetches MySQL 4.1 whereas I have 5.0 installed. How can I update the version? Hmmm... Seems you have a version of the ports tree which is a few months out of date. I have updated Makefile.ext in PHP5 directory with DEFAULT_MYSQL_VER=50, but to no avail. As a basic rule you should never have to directly edit any file within the port directory. To make mysql-5.0.x the default version on your system, edit /etc/make.conf and add: WITH_MYSQL_VER= 50 Then do a 'make clean' in the php-mysql port and try again. Cheers, Matthew -- Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate Kent, CT11 9PW signature.asc Description: OpenPGP digital signature