Re: [Postfixadmin-devel] upgrade problem

[Michiel v. B. <mi...@va...>]

Hi,

Do you have the InnoDB engine enabled in your my.cnf ?

On 04:10, Tue 13 Jan 09, me...@td... wrote:
> 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...
> 
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by:
> SourcForge Community
> SourceForge wants to tell your story.
> http://p.sf.net/sfu/sf-spreadtheword
> _______________________________________________
> Postfixadmin-devel mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel

-- 

Michiel van Baak
mi...@va...
http://michiel.vanbaak.eu
GnuPG key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x71C946BD

"Why is it drug addicts and computer aficionados are both called users?"