Postfix Admin and error 105

| No TrackBacks

Spent some time struggling to upgrade my old Postfix Admin install from 2.1.0 to 2.2.1.1, kept running up against the following error:


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

Seems like others have had this, but I didn't find a solution posted. Some time Googling and investigating MySQL docs finally had me stumbling across the answer. The MySQL user 'postfixadmin' wasn't originally granted sufficient privileges to the database, and a prior ALTER step hadn't executed, and more importantly, hadn't been flagged as an error. Granting this user the ability to Alter, Create, Drop, and all other structure related commands then running the setup.php again resolved the issue.

Hope this helps someone out there.

No TrackBacks

TrackBack URL: http://www.wrightthisway.com/cgi-bin/mt/mt-tb.cgi/564

November 2010

Sun Mon Tue Wed Thu Fri Sat
  1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30        

About this Entry

This page contains a single entry by Jim published on February 7, 2009 7:59 PM.

Using an iPhone without service was the previous entry in this blog.

More updates break Postfix is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.

Powered by Movable Type 5.031