Re: [Postfixadmin-devel] upgrade problem

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

On Tue, 13 Jan 2009, David Goodwin wrote:

> me...@td... wrote :
>> Hi David,
>>
>>
>
> <snip>
>
>> updating to version 318 (MySQL)...
>>
>> DEBUG INFORMATION:
>> Invalid query: Can't create table './postfix/vacation_notification.frm' (errno: 150)
>>
>> Sorry, same error
>>
>> Just to be sure, I ran the following command to update my pfa tree:
>> svn up https://postfixadmin.svn.sourceforge.net/svnroot/postfixadmin/trunk postfixadmin and it
>> reported that my version is now 512 and that upgrade.php and delete.php were updated.
>
> Can you put  ?debug=1 on the end of the upgrade.php URL and repeat
> please. I only need to see the last query.
>
> Also, could you provide your MySQL my.cnf config file please?

OK, I reran upgrade.php against the new db. Below is what I got:

CREATE TABLE IF NOT EXISTS config ( `id` int(11) not null auto_increment primary key, `name` VARCHAR(20) /*!40100 CHARACTER SET latin1 */ NOT NULL DEFAULT '', `value` VARCHAR(20) /*!40100 CHARACTER SET latin1 */ NOT NULL DEFAULT '', UNIQUE name ( `name` ) ) ENGINE = MYISAM COMMENT = 'PostfixAdmin settings'

Updating database:

- old version: 317; target version: 511

updating to version 318 (MySQL)...

CREATE TABLE IF NOT EXISTS vacation_notification ( on_vacation varchar(255) NOT NULL, notified varchar(255) NOT NULL, notified_at timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY on_vacation (`on_vacation`, `notified`), CONSTRAINT `vacation_notification_pkey` FOREIGN KEY (`on_vacation`) REFERENCES vacation(`email`) ON DELETE CASCADE ) ENGINE=InnoDB TYPE=InnoDB COMMENT='Postfix Admin - Virtual Vacation Notifications'

DEBUG INFORMATION:
Invalid query: Can't create table './postfix/vacation_notification.frm' (errno: 150)

As requested, I put the my.cnf up at the same url as the other files were posted.

As I said in an earlier message I am a mysql novice. Is it possible this is a permissions problem?

When I created the new db I used the following commands:

(roadrunner pts6) # mysqladmin -p create postfix

(roadrunner pts5) # mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 183
Server version: 5.0.45-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> GRANT ALL PRIVILEGES ON postfix.* TO postfix@localhost IDENTIFIED BY 'MY_PASSWD';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

mysql> quit
Bye
(roadrunner pts5) #

Did I miss something?

Thanks for the help.

Regards,

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