Re: Mysql errors on upgrade to 9.14.509

odd, i didn't think that auto-creating the user was a feature in .14... and if 
it
is, why are the grants wrong?  can someone verify this?

Tom_Ed White (tomed@xxxxxxxxxxxxxx) wrote:
>
>You are quite right - I accidentally set "db_user" in header.inc.php to
>"phpgroupware" when I first installed the program. Somehow, all the tables got 
>set
>up under this new user during install, minus certain priviledges. Everything 
>was
>fine for several months until I tried to upgrade.
>
>But - I never "wanted" to set up a phpgroupware db user, and I don't know how 
>it
>happened. I believe that I may have accepted a default during setup, and I 
>didn't
>catch the difference. There may be a difference between the default on the 
>setup
>screen for db_user and the example db_user in the howto.
>
>Be that as it may, I manually ran the sql commands and am up and running 
>without
>restoring the database, and everything seems to be fine, thanks very much for 
>your
help.
>
>Regards,
>Tom Ed White
>
>Admin (chris@xxxxxxxxxxxxxxx) wrote:
>>
>>phpgw (the program, not the db user) also requires "grant all" on the 
>>database to do
>>almost anything anyway.  Obviously, if you're going to use a different 
>>username than
>>the howto's examples then you're going to have to replace the username 
>>anywhere the
>>howto mentions it.  In fact, you forgot a line in your quote "The command to 
>>create
>>a database called "phpgroupware" and user "phpgw" with password 
>>"my-db-passwd" is:".
>> This is not phpgroupware's fault, and I don't think it's even the HowTo 
>> creators
>>fault, it is your fault for wanting a different username than the example 
>>(which was
>>clearly presented as an example) and not making the needed changes to the 
>>example.
>>
>>As for fixing this, you'll probably need to restore a backup and start the 
>>upgrade
>>again.  If MySql had transactions this "broken upgrade" might have been 
>>preventable,
>>but it doesn't so all the presure is on the admin to make sure the 
>>prerequisites are
>>in place ahead of time.
>>
>>Tom Ed White (tomed@xxxxxxxxxxxxxx) wrote:
>>>
>>>I added priviledges "references" "index" and "alter" to user phpgroupware.
>>>Now I am able to manually alter the table from the first error message
>>>without problems.
>>>Should I take all the failed sql statements and run them manually, or
>>>rerun the update program again? If I need to rerun the php code that
>>>updates the tables, how do I do that? When I log in as setup admin, it
>>>does not give me the option of upgrading the tables.
>>>BTW, there is a "phpgw" user that has always had the necessary
>>>priviledges. Here's a snippet from the phpgroupware install howto, section
>>>2.3:
>>>
>>>$ mysqladmin -u root -p create phpgroupware (enter root's password when
>>>prompted)$ mysql -u root -p
>>>mysql> grant all on phpgroupware.* to phpgw@localhost identified by
>>>"my-db-passwd";mysql> exit;
>>>
>>>The phpgroupware user had all the same priviledges except for
>>>"references," "index," and "alter." The sequence of commands in the howto
>>>grants these priviledges to "phpgw," but not to "phpgroupware." The
>>>upgrade scripts need user "phpgroupware" to have these priviledges.
>>>Thanks,
>>>Tom Ed White
>>>
>>>
>>>> That looks like a mysql privilege problem
>>>> iirc you'll need to issue a mysql command
>>>> similar to GRANT ALL on yourdatabase TO yourdbuser with password
>>>> you might want to check the syntax its been a while since i used mysql
>>>>
>>>> Tom Ed White (tomed@xxxxxxxxxxxxxx) wrote:
>>>>>
>>>>>Running debian woody with mysql 3.23.49 and php4 4.1.2 and apache
>>>>>1.3.26
>>>>>
>>>>>Upgrading from 006 to 509, I get the following mysql errors after
>>>>>updating the header.inc.php file:
>>>>>Database error: Invalid SQL: ALTER TABLE phpgw_vfs ADD COLUMN content
>>>>>text MySQL Error: 1044 (Access denied for user:
>>>>>'phpgroupware@localhost' to database 'phpgroupware')Database error:
>>>>>Invalid SQL: ALTER TABLE lang RENAME phpgw_lang MySQL Error: 1044
>>>>>(Access denied for user: 'phpgroupware@localhost' to database
>>>>>'phpgroupware')Database error: Invalid SQL: ALTER TABLE languages
>>>>>RENAME
>>>> phpgw_languages
>>>>>MySQL Error: 1044 (Access denied for user: 'phpgroupware@localhost' to
>>>>>database 'phpgroupware')Database error: Invalid SQL: CREATE TABLE
>>>>>phpgw_async (id
>>>> varchar(255) NOT
>>>>>NULL, next int NOT NULL, times varchar(255) NOT NULL, method
>>>>>varchar(80) NOT NULL, data text NOT NULL, PRIMARY KEY(id))MySQL Error:
>>>>>1050 (Table
>>>> 'phpgw_async' already exists)
>>>>>Database error: Invalid SQL: ALTER TABLE phpgw_applications DROP COLUMN
>>>>>app_titleMySQL Error: 1044 (Access denied for user:
>>>>>'phpgroupware@localhost' to database 'phpgroupware')Database error:
>>>>>Invalid SQL: ALTER TABLE phpgw_preferences
>>>> RENAME
>>>>>old_preferencesMySQL Error: 1044 (Access denied for user:
>>>>>'phpgroupware@localhost' to database 'phpgroupware')Database error:
>>>>>Invalid SQL: CREATE TABLE phpgw_preferences (preference_owner int NOT
>>>>>NULL, preference_app varchar(25) NOT NULL, preference_value text NOT
>>>>>NULL, PRIMARY
>>>>>KEY(preference_owner,preference_app))MySQL Error: 1050 (Table
>>>>>'phpgw_preferences'
>>>> already exists)
>>>>>Database error: next_record called with no query pending.
>>>>>Database error: Invalid SQL: DROP TABLE old_preferences
>>>>>MySQL Error: 1051 (Unknown table 'old_preferences')
>>>>>Database error: Invalid SQL: ALTER TABLE phpgw_addressbook ADD COLUMN
>>>>>last_mod int NOT NULLMySQL Error: 1044 (Access denied for user:
>>>> 'phpgroupware@localhost' to
>>>>>database 'phpgroupware')Database error: Invalid SQL: ALTER TABLE
>>>>>phpgw_categories
>>>> ADD COLUMN
>>>>>last_mod int NOT NULLMySQL Error: 1044 (Access denied for user:
>>>> 'phpgroupware@localhost' to
>>>>>database 'phpgroupware')Database error: Invalid SQL: ALTER TABLE
>>>>>phpgw_vfs MODIFY
>>>> content text
>>>>>MySQL Error: 1044 (Access denied for user: 'phpgroupware@localhost' to
>>>>>database 'phpgroupware')Database error: Invalid SQL: ALTER TABLE
>>>>>phpgw_async ADD
>>>> COLUMN account_id
>>>>>int NOT NULL DEFAULT '0'MySQL Error: 1044 (Access denied for user:
>>>> 'phpgroupware@localhost' to
>>>>>database 'phpgroupware')Database error: Invalid SQL: ALTER TABLE
>>>>>phpgw_accounts ADD
>>>> COLUMN
>>>>>person_id intMySQL Error: 1044 (Access denied for user:
>>>>>'phpgroupware@localhost' to database 'phpgroupware')Database error:
>>>>>Invalid SQL: ALTER TABLE phpgw_contact ADD
>>>> COLUMN ab_id
>>>>>varchar(4)MySQL Error: 1044 (Access denied for user:
>>>>>'phpgroupware@localhost' to database 'phpgroupware')Database error:
>>>>>Invalid SQL: ALTER TABLE
>>>> phpgw_contact_person ADD COLUMN
>>>>>ab_id varchar(4)MySQL Error: 1044 (Access denied for user:
>>>>>'phpgroupware@localhost' to database 'phpgroupware')Database error:
>>>>>Invalid SQL: ALTER TABLE phpgw_contact_org
>>>> ADD COLUMN
>>>>>ab_id varchar(4)MySQL Error: 1044 (Access denied for user:
>>>>>'phpgroupware@localhost' to database 'phpgroupware')Database error:
>>>>>Invalid SQL: INSERT INTO phpgw_contact
>>>>>(owner,access,cat_id,contact_type_id,ab_id) VALUES
>>>>>(7,'private',null,1,1)MySQL
>>>> Error: 1054 (Unknown column 'ab_id' in 'field list')
>>>>>
>>>>>Session halted.
>>>>>
>>>>>I logged in to mysql as phpgroupware and tried some of the commands by
>>>>>hand, with the same errors resulting. Could I perhaps grant some
>>>>>priviledges to phpgroupware and try again? I have never done any manual
>>>>>setup/modifications to the phpgroupware tables, and have only used the
>>>>>install scripts.
>>>>>Logging in as setup admin, everything seems fine. I haven't tried
>>>>>upgrading applications yet. Logging in as a user, I get the following:
>>>>>Database error: Invalid SQL: UPDATE phpgw_async SET
>>>>>next=0,times='a:0:{}',method='none',data='a:3:',account_id=0
>>>>>WHERE id='##last-check-run##'MySQL Error: 1054 (Unknown column
>>>>>'account_id' in
>>>> 'field list')
>>>>>
>>>>>File: /var/www/phpgroupware/phpgwapi/inc/class.asyncservice.inc.php
>>>>>Line: 518
>>>>>
>>>>>Session halted.
>>>>>
>>>>>Thanks,
>>>>>Tom Ed White
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>_______________________________________________
>>>>>Phpgroupware-users mailing list
>>>>>Phpgroupware-users@xxxxxxx
>>>>>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>>>>>
>>>>>
>>>>
>>>> --
>>>> www.kbinx.com
>>>>
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Phpgroupware-users mailing list
>>>> Phpgroupware-users@xxxxxxx
>>>> http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>>>
>>>
>>>
>>>
>>>
>>>_______________________________________________
>>>Phpgroupware-users mailing list
>>>Phpgroupware-users@xxxxxxx
>>>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>>>
>>
>>
>>
>>_______________________________________________
>>Phpgroupware-users mailing list
>>Phpgroupware-users@xxxxxxx
>>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>>
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>Phpgroupware-users@xxxxxxx
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>