Re: [Postfixadmin-devel] upgrade problem

[<me...@td...>]

On Sun, 11 Jan 2009, David Goodwin wrote:

> me...@td... wrote :
>> Hi,
>>
>> I am attempting to upgrade from pfa 2.1.1 to svn509. The 509 install is being
>> installed on a new machine that I took the old db and installed it on the new
>> machine. I configured config.inc.php and ran setup.php. Below is the output
>> of setup.php.
>>
>> Postfix Admin Setup Checker
>>
>> Running software:
>>
>>      * PHP version 5.1.6
>>      * Apache/2.2.3 (CentOS)
>>
>> Checking for dependencies:
>>
>>      * Warning: Magic Quotes: ON (internal workaround used)
>>      * Depends on: presence config.inc.php - OK
>>      * Checking $CONF['configured'] - OK
>>      * Depends on: MySQL 3.23, 4.0 - OK
>>      * Depends on: MySQL 4.1 - OK
>>      * Depends on: PostgreSQL - OK (change the database_type to 'pgsql' in config.inc.php!!)
>>      * Testing database connection - OK - mysqli://postfix:xxxxx@localhost/postfix
>>      * Depends on: session - OK
>>      * Depends on: pcre - OK
>>      * Depends on: multibyte string - OK
>>      * Depends on: IMAP functions - OK
>>
>> Everything seems fine... attempting to create/update database structure
>>
>> Updating database:
>>
>> - old version: 0; target version: 509
>>
>> updating to version 1 (MySQL)...   done
>>
>> updating to version 2 (MySQL)...   done
>>
>> updating to version 3 (MySQL)...   done
>>
>> updating to version 4 (MySQL)...   done
>>
>> updating to version 5 (MySQL)...   done
>>
>> updating to version 79 (MySQL)...   done
>>
>> updating to version 81 (MySQL)...   done
>>
>> updating to version 90 (all databases)...   done
>>
>> updating to version 169 (MySQL)...   done
>>
>> updating to version 318 (MySQL)...
>>
>> DEBUG INFORMATION:
>> Invalid query: Can't create table './postfix/vacation_notification.frm' (errno: 150)
>>
>> As you can see the db is not being updated properly. Can someone help me get
>> this upgraded?
>>
>
> Hi Tom,
>
> Yes; I'm desperate to fix these MySQL errors. Would you be able to
> give ma  dump of your database schema from BEFORE you did the upgrade?
> If not, could you give me a dump of the database schema as it is now?

Cool!! I will give you what ever you want. Just tell me the commands to run.
I am a mysql novice. I know how to dump the whole db and restore it but I do
not know how to dump the schema. I can give you information from both old and
new as the old one is still in production and the new one is obviously semi
b0rked.

FWIW the old db is running on mysql-4.1.22-2.el4 the new one is running on
mysql-5.0.45-7.el5. I do not know if that matters or not but I thought I would
include it in case it does.

Regards,

-- 
Tom			me...@td...		Spamtrap address	 		me...@td...