[support] Recent move Drupal 6.22, PHP5.3, PostGresql 8.4 doesn't work - continuing

[Max Pyziur]

On Sun, 24 Mar 2013, Jamie Holly wrote:

> Apache doesn't have anything to do with the database. That's PHP and
> Drupal. Since you're getting the site offline error, there's a problem
> within the database. Check your PHP/Apache error logs and see what's
> being reported there.

I did four fresh installs of Drupal (6.14, 6.16, 6.22, and 6.28), each 
with a different user on the CentOS 6 system (PHP5.3, Postgresql 8.4). 
Each system works correctly.

None of the existing Drupal sites (about eight) (all updated to Drupal 
6.22 on CentOS 5) that were migrated from CentOS 5 (PHP 5.1, Postgresql 8.1) (that means pg_dump and restore) are 
working. Looking at the overal database structure, there are 47 tables. My 
sense is that there is a data point somewhere in the database that is 
governing all of this, and making the sites report 503 errors in Apache 
(meaning that the site is temporarily unavailable).

I'm not familiar with the Drupal database topology; would anyone know 
into which table to look?

Much thanks,

> Jamie Holly
> http://www.intoxination.net
> http://www.hollyit.net

Max Pyziur
pyz at brama.com

> On 3/24/2013 4:29 PM, Max Pyziur wrote:
>>> Are you running Varnish? If so, is the new server configured properly in
>>> terms of Varnish listening on 80 and the vhosts on 8080, and 8080 being a
>>> configured port?
>>
>> No.
>>
>> As a test, I did a fresh install of Drupal 6.28 for a test user. The site
>> runs. The sites that were restored from a pg_dump do not.
>>
>> I'm checking a variety of configuration settings:
>> e.g. 47 Tables in the new database, 47 in an existing site.
>>
>> Perhaps it is an Apache configuration?
>>
>> fyi,
>>
>> MP
>> pyz at brama.com
>>
>>
>>> On Mar 24, 2013, at 2:18 PM, Max Pyziur <pyz at brama.com> wrote:
>>>
>>>>
>>>> Greetings,
>>>>
>>>> Due an emergency (failing disk) we moved our whole server from a CentOS
>>>> 5
>>>> machine to a CentOS 6.
>>>>
>>>> In the process, newer software versions were installed by default;
>>>> relevant to Drupal
>>>> CentOS 5 had PHP 5.1; CentOS 6 now has PHP 5.3
>>>> CentOS 5 had Postgresql 8.1.x; CentOS 6 has Postgresql 8.4.x
>>>>
>>>> The way I restored the Postgresql databases was through pg_dumpall to a
>>>> huge text file, and then psql postgres < AllPostgresDatabases.out on the
>>>> PG 8.4 system.
>>>>
>>>> Our Drupal installations were local from tarballs, not from RPMs. In
>>>> most
>>>> cases they are Drupal 6.22
>>>>
>>>> The sites all show Drupal's blue page - site offline.
>>>>
>>>> The Apache logs show that the page returns a 503 Error.
>>>>
>>>> I'm in the process of trying to debug and in a bit of a rush. Usually, I
>>>> try and research this in detail before posting.
>>>>
>>>> Much thanks for any advice on returning these sites to status quo.
>>>>
>>>> Max Pyziur
>>>> pyz at brama.com
>>>> --
>>>> [ Drupal support list | http://lists.drupal.org/ ]
>>> --
>>> [ Drupal support list | http://lists.drupal.org/ ]
>>>
>>
>
> -- 
> [ Drupal support list | http://lists.drupal.org/ ]
>