 |
|
|
|
Next: PHP Mail
|
| Author |
Message |
External
Since: Feb 12, 2005
Posts: 4
|
(Msg. 1) Posted: Sat Feb 12, 2005 9:24 am
Post subject: php + MySQL problems
Archived from groups: alt>php>sql (more info?)
|
|
|
I'm trying to get php + MySQL running on my web server.
I tested the setup on an old RH8 server install that I was going to
upgrade; everything worked fine. So I wiped out the old RedHat, installed
Fedora Core 2, and repeated the installation. No dice.
MySQL works fine. Apache works fine. PHP works fine - at lease I can
pull up php pages on my server, and the server logs show that apache is
properly serving php pages.
But php won't talk to MySQL...
I'm trying to install two apps - phpgroupware (www.phpgroupware.org) and
wordpress (www.wordpress.org); neither one can talk to the database,
although the databases for the apps are properly set up.
I've tried this with the standard FC2 RPMs - MySQL 3.x and php 4.x - no
dice.
So I upgraded MySQL to 4.1.9 from the MySQL website. Again, no dice.
I compiled php 5.0.3 from source; again, no dice. PHP pages are served,
but no communication with the database.
Something is hosed, but I'm not that experienced with apache, MySQL, or
PHP, so I'm groping in the dark.
I'm guessing that it's a simple config issue somewhere, but I have no idea
where to look.
I've been through the various installation manuals, done the basic tests,
and everything seems to check out, but they just won't talk to each other.
So, could someone please tell me how to turn on php debugging logs, or
perhaps where I can find a simple mysql php test app that will let me see
the dialog between php and mysql.... I'm stuck, and I need to get this up
and running this weekend.
TIA,
--Yan |
|
| Back to top |
|
 | |
External
Since: Dec 01, 2003
Posts: 190
|
(Msg. 2) Posted: Sat Feb 12, 2005 12:40 pm
Post subject: Re: php + MySQL problems [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Captain Dondo wrote:
> I'm trying to get php + MySQL running on my web server.
>
> I tested the setup on an old RH8 server install that I was going to
> upgrade; everything worked fine. So I wiped out the old RedHat, installed
> Fedora Core 2, and repeated the installation. No dice.
>
> MySQL works fine. Apache works fine. PHP works fine - at lease I can
> pull up php pages on my server, and the server logs show that apache is
> properly serving php pages.
>
> But php won't talk to MySQL...
You need to install the mod_php (php_mod), which has been this far as it's own
RPM.
> I'm trying to install two apps - phpgroupware (www.phpgroupware.org) and
> wordpress (www.wordpress.org); neither one can talk to the database,
> although the databases for the apps are properly set up.
>
> I've tried this with the standard FC2 RPMs - MySQL 3.x and php 4.x - no
> dice.
>
> So I upgraded MySQL to 4.1.9 from the MySQL website. Again, no dice.
No, don't use the RPMs from MySQL.com, those WILL break dependency on your system.
I recommend you to use the official RPMs. Keep in mind that you need to go to
fedoralegacy.org to get updates to FC2, or else you may end up with a hacked
box. You can of course upgrade to FC3.
//Aho |
|
| Back to top |
|
| |
External
Since: Dec 01, 2003
Posts: 190
|
(Msg. 3) Posted: Sat Feb 12, 2005 12:40 pm
Post subject: Re: php + MySQL problems [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Captain Dondo wrote:
> I'm trying to get php + MySQL running on my web server.
>
> I tested the setup on an old RH8 server install that I was going to
> upgrade; everything worked fine. So I wiped out the old RedHat, installed
> Fedora Core 2, and repeated the installation. No dice.
>
> MySQL works fine. Apache works fine. PHP works fine - at lease I can
> pull up php pages on my server, and the server logs show that apache is
> properly serving php pages.
>
> But php won't talk to MySQL...
>
> I'm trying to install two apps - phpgroupware (www.phpgroupware.org) and
> wordpress (www.wordpress.org); neither one can talk to the database,
> although the databases for the apps are properly set up.
>
> I've tried this with the standard FC2 RPMs - MySQL 3.x and php 4.x - no
> dice.
>
> So I upgraded MySQL to 4.1.9 from the MySQL website. Again, no dice.
Install only official Fedora version of mysql and php (or else you will be
having dependency problems), and see to install php-mysql RPM too.
FC2 is now replaced by FC3, update or get updates as fast as possible from
fedoralegacy.org.
//Aho >> Stay informed about: php + MySQL problems |
|
| Back to top |
|
| |
External
Since: Feb 11, 2005
Posts: 3
|
(Msg. 4) Posted: Sun Feb 13, 2005 4:09 pm
Post subject: Re: php + MySQL problems [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Feb 12, 2005
Posts: 4
|
(Msg. 5) Posted: Sun Feb 13, 2005 6:10 pm
Post subject: Re: php + MySQL problems [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Sun, 13 Feb 2005 15:09:49 -0500, phpcode wrote:
> Check your logs for messages that point to why connection to mysql fails.
>
> If you have error messages posted here, someone may be able to assist you.
OK, for posterity:
I am using php4 (the latest fedora core 2 version) and MySQL 4.1.9, from
mysql.org.
I did have to do a bit of a dance around dependencies and save some
libraries, but everything installed and works.
Apparently there was a change in the way MySQL handles passwords, and if
you're using php4 with MySQL 4 you need to use the OLD_PASSWORD option
to create the database passwords, otherwise authentication will fail. >> Stay informed about: php + MySQL problems |
|
| Back to top |
|
| |
External
Since: Jan 26, 2005
Posts: 2
|
(Msg. 6) Posted: Mon Feb 14, 2005 10:40 am
Post subject: Re: php + MySQL problems [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Sat, 12 Feb 2005 08:24:12 -0800, Captain Dondo wrote in 41 Lines :
>I'm trying to get php + MySQL running on my web server.
>
>I tested the setup on an old RH8 server install that I was going to
>upgrade; everything worked fine. So I wiped out the old RedHat, installed
>Fedora Core 2, and repeated the installation. No dice.
>
>MySQL works fine. Apache works fine. PHP works fine - at lease I can
>pull up php pages on my server, and the server logs show that apache is
>properly serving php pages.
>
>But php won't talk to MySQL...
>
>I'm trying to install two apps - phpgroupware (www.phpgroupware.org) and
>wordpress (www.wordpress.org); neither one can talk to the database,
>although the databases for the apps are properly set up.
>
>I've tried this with the standard FC2 RPMs - MySQL 3.x and php 4.x - no
>dice.
>
>So I upgraded MySQL to 4.1.9 from the MySQL website. Again, no dice.
>
>I compiled php 5.0.3 from source; again, no dice. PHP pages are served,
>but no communication with the database.
>
>Something is hosed, but I'm not that experienced with apache, MySQL, or
>PHP, so I'm groping in the dark.
>
>I'm guessing that it's a simple config issue somewhere, but I have no idea
>where to look.
>
>I've been through the various installation manuals, done the basic tests,
>and everything seems to check out, but they just won't talk to each other.
>
>So, could someone please tell me how to turn on php debugging logs, or
>perhaps where I can find a simple mysql php test app that will let me see
>the dialog between php and mysql.... I'm stuck, and I need to get this up
>and running this weekend.
>
>TIA,
>
>--Yan
Try to put next line into your config file of the MySQL server;
#Use old password encryption method (needed for 4.0 and older clients).
old-passwords
and restart.
Pieter [NL] >> Stay informed about: php + MySQL problems |
|
| Back to top |
|
| |
External
Since: Feb 12, 2005
Posts: 4
|
(Msg. 7) Posted: Mon Feb 14, 2005 10:40 am
Post subject: Re: php + MySQL problems [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Mon, 14 Feb 2005 16:04:55 +0100, Pieter wrote:
> Try to put next line into your config file of the MySQL server;
>
> #Use old password encryption method (needed for 4.0 and older clients).
> old-passwords
>
> and restart.
Yup, I found this out after some serious googling. I was never able to
find the correct place/syntax for this in the my.cnf file.
I ended up just rebuilding the databases using OLD_PASSWORD (not a big
deal; each database only had two users and were otherwise emply....)
Could you please let me the correct syntax and the correct place in the
my.cnf file for this?
Thanks.
--Yan >> Stay informed about: php + MySQL problems |
|
| Back to top |
|
| |
External
Since: Jan 26, 2005
Posts: 2
|
(Msg. 8) Posted: Mon Feb 14, 2005 5:40 pm
Post subject: Re: php + MySQL problems [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Mon, 14 Feb 2005 07:26:01 -0800, Captain Dondo wrote in 21 Lines :
>On Mon, 14 Feb 2005 16:04:55 +0100, Pieter wrote:
>
>> Try to put next line into your config file of the MySQL server;
>>
>> #Use old password encryption method (needed for 4.0 and older clients).
>> old-passwords
>>
>> and restart.
>
>Yup, I found this out after some serious googling. I was never able to
>find the correct place/syntax for this in the my.cnf file.
>
>I ended up just rebuilding the databases using OLD_PASSWORD (not a big
>deal; each database only had two users and were otherwise emply....)
>
>Could you please let me the correct syntax and the correct place in the
>my.cnf file for this?
>
>Thanks.
>
>--Yan
I just put it in the SERVER section under port=..., before basedir=....
Works like a charm for me.
I found this out when updating too from 4.0.x to a 4.1.x.
In the MySQL forum itself it was also one discusion about
problem logging into the SQL server.
Note: MySQL Administrator can take care of this in the 'Startup vatiables'
the Tab 'Security'.
There is a checkbox with 'Use old passwords'.
Pieter [NL] >> Stay informed about: php + MySQL problems |
|
| Back to top |
|
| |
| Related Topics: | problems with php / database - Hi, I have problems with php / database See this: The problem is your hosting has a limitation on time of running of PHP scripts and the DB is not unpacked within this time. You should find out if your hoster have some methods of unpacking huge ..
problems with sprintf and escaping % - i have the following query: $query = "SELECT * FROM cds WHERE $campo LIKE ('%$busqueda%') ORDER BY $ordenada"; which i'm trying to change to sprintf to use mysql_real_escape_string since i've heard that it's better and a more secure way to do...
Accounts in Mysql - Hello, Learning about Mysql Accounts, there is something I like to ask for. I have made some database tests as root mysql with [gastonv@telenetPC ~]$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL....
php and mySql - I get an error message while trying to follow these procedures: http://www.howtoforge.com/intrusion-...on-ubuntu-7.10 Here is the error: Fatal error: Call to undefined function mysql_connect() in /var/www/adodb5/drivers/adodb-mysql.inc.php on line 363..
[MySQL] hierachy problem ... - Hello, I have a table which have these fields: - id - idParent - label I would like to display each field and his children but each parent may have no child. Example: A AA AB AC B C CA CB .... I can't write the request, could you help me?.... |
|
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
