Thread: [Postfixadmin-devel] upgrade problem
Brought to you by:
christian_boltz,
gingerdog
Menu
▾
▴
postfixadmin-devel
|
From: <me...@td...> - 2009-01-11 06:52:49
|
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?
regards,
--
Tom me...@td... Spamtrap address me...@td...
|
|
From: David G. <da...@co...> - 2009-01-11 08:07:14
|
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? thanks David. -- David Goodwin [ david at codepoets dot co dot uk ] [ http://www.codepoets.co.uk ] |
|
From: <me...@td...> - 2009-01-13 09:10:21
|
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... |
|
From: Michiel v. B. <mi...@va...> - 2009-01-13 10:07:20
|
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?" |
|
From: <me...@td...> - 2009-01-23 20:37:19
|
On Tue, 13 Jan 2009, Michiel van Baak wrote: > > Hi, > > Do you have the InnoDB engine enabled in your my.cnf ? No I do not. For the archives, GingerDog helped me out in irc and provided a fix that allowed the upgrade to complete. Regards, -- Tom me...@td... Spamtrap address me...@td... |
|
From: <me...@td...> - 2009-01-11 14:56:55
|
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... |
|
From: David G. <da...@co...> - 2009-01-11 15:28:13
|
> 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. Try : mysqldump -u whatever -ppassword postfix > whatever.sql gzip whatever.sql then attach whatever.sql.gz to me. Change 'postfix' to the name of your database. Note the above include all data, if you wish to exclude the data, use the --no-data option. Thanks David. -- David Goodwin [ david at codepoets dot co dot uk ] [ http://www.codepoets.co.uk ] |
|
From: David G. <da...@co...> - 2009-01-13 07:25:31
|
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? thanks David. -- David Goodwin [ david at codepoets dot co dot uk ] [ http://www.codepoets.co.uk ] |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X