Angel Velásquez writes:

On Tue, Feb 2, 2010 at 7:44 AM, Ashish SHUKLA wrote:

...

Hi,

I'd recently updated php, mysql, and php-apache packages to following versions:

php 5.3.1-4 mysql 5.1.43-1 php-apache 5.3.1-4

After update my existing webapps started showing error: Unable to connect to database, with nothing changed on the webapps side. After assuming that recent update cause them to break, I downgraded all related packages, and then upgraded them one-by-one. Following is the final combination which worked for me:

php 5.3.1-4 mysql 5.1.43-1 php-apache 5.3.1-3

If anyone also exhibits this behaviour, then I can report this as bug.

Thanks Ashish SHUKLA -- They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety.  -- Benjamin Franklin, Memoirs of the life and writings of Benjamin Franklin

would you like to paste in someplace your php.ini config and your pacman -Ql | grep php

The only change in php.ini is the values of upload_max_filesize, error_reporting and display_errors settings, which I don't think will cause any breakage.

what database are you using, I guess mysql, right?,

Right. Thanks Ashish SHUKLA -- They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety. -- Benjamin Franklin, Memoirs of the life and writings of Benjamin Franklin

Nilesh Govindarajan writes:

On 02/02/2010 04:14 PM, Ashish SHUKLA wrote:

...

Hi,

I'd recently updated php, mysql, and php-apache packages to following versions:

php 5.3.1-4 mysql 5.1.43-1 php-apache 5.3.1-4

After update my existing webapps started showing error: Unable to connect to database, with nothing changed on the webapps side. After assuming that recent update cause them to break, I downgraded all related packages, and then upgraded them one-by-one. Following is the final combination which worked for me:

php 5.3.1-4 mysql 5.1.43-1 php-apache 5.3.1-3

If anyone also exhibits this behaviour, then I can report this as bug.

Thanks Ashish SHUKLA

Did you get any start-up errors after upgrading PHP ?

Nop, I didn't get any errors in error_log of httpd, if thats what you meant. And also nor any errors during upgrade.

You should upgrade php-mysql as well. Because you're changing the version of libmysqlclient (mysql) whereas php-mysql is linked to some other version.

There is no 'php-mysql' package in the repositories. You probably mean this: #v+ abbe [~] chateau.d.if % sudo pacman -Ql php |fgrep mysql php /usr/lib/php/modules/mysql.so php /usr/lib/php/modules/mysqli.so php /usr/lib/php/modules/pdo_mysql.so #v- Ashish -- They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety. -- Benjamin Franklin, Memoirs of the life and writings of Benjamin Franklin

On 02/05/2010 05:20 AM, Nilesh Govindarajan wrote:

On 02/04/2010 11:43 PM, Ashish SHUKLA wrote:

...

Nilesh Govindarajan writes:

...

On 02/02/2010 04:14 PM, Ashish SHUKLA wrote:

...

Hi,

I'd recently updated php, mysql, and php-apache packages to following versions:

php 5.3.1-4 mysql 5.1.43-1 php-apache 5.3.1-4

After update my existing webapps started showing error: Unable to connect to database,

<snip> Checking my simple web log on my Arch server, LAMP is working with the following versions installed: 08:16 archangel:~> pmq php mysql apache php 5.3.1-5 mysql 5.1.42-2 apache 2.2.14-2 Process is good in both directions, data collection & display web->php->mysql <==> mysql->php->web These were the packages installed with both testing and community-testing enabled. -- David C. Rankin, J.D.,P.E. Rankin Law Firm, PLLC 510 Ochiltree Street Nacogdoches, Texas 75961 Telephone: (936) 715-9333 Facsimile: (936) 715-9339 www.rankinlawfirm.com

On 02/02/10 15:11, Mark Foxwell wrote:

...

I'd recently updated php, mysql, and php-apache packages to following versions:

php 5.3.1-4 mysql 5.1.43-1 php-apache 5.3.1-4

After update my existing webapps started showing error: Unable to connect to database, with nothing changed on the webapps side. After assuming that recent update cause them to break, I downgraded all related packages, and then upgraded them one-by-one. Following is the final combination which worked for me:

php 5.3.1-4 mysql 5.1.43-1 php-apache 5.3.1-3

If anyone also exhibits this behaviour, then I can report this as bug.

Yes I was having the same problems with MythWeb and a FluxBB local install - both php & mysql based.

Downgrading php-apache to 5.3.1-3 has now fixed it.

Thanks!

Same problem, and same fix, here.