Re: [Phpgroupware-users] Mysql errors on upgrade to 9.14.509

[Tom_Ed White]

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 (address@hidden) 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 (address@hidden) 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 address@hidden 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 (address@hidden) 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:
>>>>'address@hidden' to database 'phpgroupware')Database error:
>>>>Invalid SQL: ALTER TABLE lang RENAME phpgw_lang MySQL Error: 1044
>>>>(Access denied for user: 'address@hidden' to database
>>>>'phpgroupware')Database error: Invalid SQL: ALTER TABLE languages
>>>>RENAME
>>> phpgw_languages
>>>>MySQL Error: 1044 (Access denied for user: 'address@hidden' 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:
>>>>'address@hidden' to database 'phpgroupware')Database error:
>>>>Invalid SQL: ALTER TABLE phpgw_preferences
>>> RENAME
>>>>old_preferencesMySQL Error: 1044 (Access denied for user:
>>>>'address@hidden' 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:
>>> 'address@hidden' to
>>>>database 'phpgroupware')Database error: Invalid SQL: ALTER TABLE
>>>>phpgw_categories
>>> ADD COLUMN
>>>>last_mod int NOT NULLMySQL Error: 1044 (Access denied for user:
>>> 'address@hidden' to
>>>>database 'phpgroupware')Database error: Invalid SQL: ALTER TABLE
>>>>phpgw_vfs MODIFY
>>> content text
>>>>MySQL Error: 1044 (Access denied for user: 'address@hidden' 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:
>>> 'address@hidden' to
>>>>database 'phpgroupware')Database error: Invalid SQL: ALTER TABLE
>>>>phpgw_accounts ADD
>>> COLUMN
>>>>person_id intMySQL Error: 1044 (Access denied for user:
>>>>'address@hidden' to database 'phpgroupware')Database error:
>>>>Invalid SQL: ALTER TABLE phpgw_contact ADD
>>> COLUMN ab_id
>>>>varchar(4)MySQL Error: 1044 (Access denied for user:
>>>>'address@hidden' 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:
>>>>'address@hidden' 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:
>>>>'address@hidden' 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
>>>>address@hidden
>>>>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>>>>
>>>>
>>>
>>> --
>>> www.kbinx.com
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> Phpgroupware-users mailing list
>>> address@hidden
>>> http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>>
>>
>>
>>
>>
>>_______________________________________________
>>Phpgroupware-users mailing list
>>address@hidden
>>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>>
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>