upgraded 6.2 and mysql lost all privileges
Hi there, I just upgraded to 6.2 and now I do not see my mysql privileges. is there an easy way to get them back in place. I thought they would magically appear in the /var/db/mysql directory and stuff. Is there an easy way to recover these accounts or do I need to readd them manually?? Cheers, Noah ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: upgraded 6.2 and mysql lost all privileges
Noah schrieb: Hi there, I just upgraded to 6.2 and now I do not see my mysql privileges. is there an easy way to get them back in place. I thought they would magically appear in the /var/db/mysql directory and stuff. Is there an easy way to recover these accounts or do I need to readd them manually?? What privileges do you mean? Privileges for accessing the database or /var/db/mysql? What do you expect? What happens? More input (and output) please. Björn ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: upgraded 6.2 and mysql lost all privileges
the user accounts are gone. where does that information reside? I dont know how else to say or ask that question. Cheers, Noah Björn König wrote: Noah schrieb: Hi there, I just upgraded to 6.2 and now I do not see my mysql privileges. is there an easy way to get them back in place. I thought they would magically appear in the /var/db/mysql directory and stuff. Is there an easy way to recover these accounts or do I need to readd them manually?? What privileges do you mean? Privileges for accessing the database or /var/db/mysql? What do you expect? What happens? More input (and output) please. Björn ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: upgraded 6.2 and mysql lost all privileges
user accounts are held in /etc/passwd the default UIDs created by ports are listed in /usr/ports/UIDs including mysql mysql:*:88:88:MySQL Daemon:/var/db/mysql:/sbin/nologin you can either re-add it using pw or just paste the line in using vipw Vince Noah wrote: the user accounts are gone. where does that information reside? I dont know how else to say or ask that question. Cheers, Noah Björn König wrote: Noah schrieb: Hi there, I just upgraded to 6.2 and now I do not see my mysql privileges. is there an easy way to get them back in place. I thought they would magically appear in the /var/db/mysql directory and stuff. Is there an easy way to recover these accounts or do I need to readd them manually?? What privileges do you mean? Privileges for accessing the database or /var/db/mysql? What do you expect? What happens? More input (and output) please. Björn ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: upgraded 6.2 and mysql lost all privileges
thanks Vince, yeah - I have about 15 other user accounts specific to my mysql installation that were not in the /etc/passwd file. where were those stored? Cheers, Noah Vince Hoffman wrote: user accounts are held in /etc/passwd the default UIDs created by ports are listed in /usr/ports/UIDs including mysql mysql:*:88:88:MySQL Daemon:/var/db/mysql:/sbin/nologin you can either re-add it using pw or just paste the line in using vipw Vince Noah wrote: the user accounts are gone. where does that information reside? I dont know how else to say or ask that question. Cheers, Noah Björn König wrote: Noah schrieb: Hi there, I just upgraded to 6.2 and now I do not see my mysql privileges. is there an easy way to get them back in place. I thought they would magically appear in the /var/db/mysql directory and stuff. Is there an easy way to recover these accounts or do I need to readd them manually?? What privileges do you mean? Privileges for accessing the database or /var/db/mysql? What do you expect? What happens? More input (and output) please. Björn ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: upgraded 6.2 and mysql lost all privileges
In the last episode (Mar 06), Noah said: yeah - I have about 15 other user accounts specific to my mysql installation that were not in the /etc/passwd file. where were those stored? If you're just talking about mysql users, those are in /var/db/mysql/mysql/user.* . An OS upgrade shouldn't have touched them at all. Unless you reformatted /var or something :) -- Dan Nelson [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: upgraded 6.2 and mysql lost all privileges
binary install. okay I backed up teh dir let me look for them now cheers, Noah Dan Nelson wrote: In the last episode (Mar 06), Noah said: yeah - I have about 15 other user accounts specific to my mysql installation that were not in the /etc/passwd file. where were those stored? If you're just talking about mysql users, those are in /var/db/mysql/mysql/user.* . An OS upgrade shouldn't have touched them at all. Unless you reformatted /var or something :) ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: upgraded 6.2 and mysql lost all privileges
Dan, okay you got me on the right track. I can see mysql files in that directory. but mysql is not aware of the users in the user files is there something that I need to tell to mysql to use those files to reincorporate the mysql related users? # ls -l /var/db/mysql/mysql total 648 -rw-rw 1 mysql mysql 0 Mar 6 06:49 columns_priv.MYD -rw-rw 1 mysql mysql1024 Mar 6 06:49 columns_priv.MYI -rw-rw 1 mysql mysql8820 Mar 6 06:49 columns_priv.frm -rw-rw 1 mysql mysql 876 Mar 6 06:49 db.MYD -rw-rw 1 mysql mysql4096 Mar 6 06:49 db.MYI -rw-rw 1 mysql mysql9494 Mar 6 06:49 db.frm -rw-rw 1 mysql mysql 0 Mar 6 06:49 func.MYD -rw-rw 1 mysql mysql1024 Mar 6 06:49 func.MYI -rw-rw 1 mysql mysql8665 Mar 6 06:49 func.frm -rw-rw 1 mysql mysql 20916 Mar 6 06:49 help_category.MYD -rw-rw 1 mysql mysql3072 Mar 6 06:49 help_category.MYI -rw-rw 1 mysql mysql8700 Mar 6 06:49 help_category.frm -rw-rw 1 mysql mysql 75254 Mar 6 06:49 help_keyword.MYD -rw-rw 1 mysql mysql 15360 Mar 6 06:49 help_keyword.MYI -rw-rw 1 mysql mysql8612 Mar 6 06:49 help_keyword.frm -rw-rw 1 mysql mysql6624 Mar 6 06:49 help_relation.MYD -rw-rw 1 mysql mysql 13312 Mar 6 06:49 help_relation.MYI -rw-rw 1 mysql mysql8630 Mar 6 06:49 help_relation.frm -rw-rw 1 mysql mysql 269424 Mar 6 06:49 help_topic.MYD -rw-rw 1 mysql mysql 17408 Mar 6 06:49 help_topic.MYI -rw-rw 1 mysql mysql8770 Mar 6 06:49 help_topic.frm -rw-rw 1 mysql mysql 0 Mar 6 06:49 host.MYD -rw-rw 1 mysql mysql1024 Mar 6 06:49 host.MYI -rw-rw 1 mysql mysql9416 Mar 6 06:49 host.frm -rw-rw 1 mysql mysql 0 Mar 6 06:49 proc.MYD -rw-rw 1 mysql mysql1024 Mar 6 06:49 proc.MYI -rw-rw 1 mysql mysql9691 Mar 6 06:49 proc.frm -rw-rw 1 mysql mysql 0 Mar 6 06:49 procs_priv.MYD -rw-rw 1 mysql mysql1024 Mar 6 06:49 procs_priv.MYI -rw-rw 1 mysql mysql8875 Mar 6 06:49 procs_priv.frm -rw-rw 1 mysql mysql 0 Mar 6 06:49 tables_priv.MYD -rw-rw 1 mysql mysql1024 Mar 6 06:49 tables_priv.MYI -rw-rw 1 mysql mysql8947 Mar 6 06:49 tables_priv.frm -rw-rw 1 mysql mysql 0 Mar 6 06:49 time_zone.MYD -rw-rw 1 mysql mysql1024 Mar 6 06:49 time_zone.MYI -rw-rw 1 mysql mysql8636 Mar 6 06:49 time_zone.frm -rw-rw 1 mysql mysql 0 Mar 6 06:49 time_zone_leap_second.MYD -rw-rw 1 mysql mysql1024 Mar 6 06:49 time_zone_leap_second.MYI -rw-rw 1 mysql mysql8624 Mar 6 06:49 time_zone_leap_second.frm -rw-rw 1 mysql mysql 0 Mar 6 06:49 time_zone_name.MYD -rw-rw 1 mysql mysql1024 Mar 6 06:49 time_zone_name.MYI -rw-rw 1 mysql mysql8606 Mar 6 06:49 time_zone_name.frm -rw-rw 1 mysql mysql 0 Mar 6 06:49 time_zone_transition.MYD -rw-rw 1 mysql mysql1024 Mar 6 06:49 time_zone_transition.MYI -rw-rw 1 mysql mysql8686 Mar 6 06:49 time_zone_transition.frm -rw-rw 1 mysql mysql 0 Mar 6 06:49 time_zone_transition_type.MYD -rw-rw 1 mysql mysql1024 Mar 6 06:49 time_zone_transition_type.MYI -rw-rw 1 mysql mysql8748 Mar 6 06:49 time_zone_transition_type.frm -rw-rw 1 mysql mysql 208 Mar 6 06:49 user.MYD -rw-rw 1 mysql mysql2048 Mar 6 06:49 user.MYI -rw-rw 1 mysql mysql 10330 Mar 6 06:49 user.frm Dan Nelson wrote: In the last episode (Mar 06), Noah said: yeah - I have about 15 other user accounts specific to my mysql installation that were not in the /etc/passwd file. where were those stored? If you're just talking about mysql users, those are in /var/db/mysql/mysql/user.* . An OS upgrade shouldn't have touched them at all. Unless you reformatted /var or something :) ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: upgraded 6.2 and mysql lost all privileges
In the last episode (Mar 06), Noah said: yeah - I have about 15 other user accounts specific to my mysql installation that were not in the /etc/passwd file. where were those stored? If you're just talking about mysql users, those are in /var/db/mysql/mysql/user.* . An OS upgrade shouldn't have touched them at all. Unless you reformatted /var or something :) It may be possible that mergemaster was used incorrectly. If so, there should be a copy of the updated /etc/master.passwd file in: # /var/tmp/temproot/etc You can compare that against the new file in /etc. If they are the same, mergemaster hosed the original. I don't know if mergemaster makes a backup of the original, but it may be easier to pull master.passwd from a backup (you did backup /etc right?) and try re-merging if there were any differences. Then again, I may be totally wrong with this assessment. Steve ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: upgraded 6.2 and mysql lost all privileges
I dont think that is the issue. the problem is with the mysql virtual users they do not appear in the /etc/passwd or /etc/master.passwd files. so that is the wrong direction. cheers, Noah Steve Bertrand wrote: In the last episode (Mar 06), Noah said: yeah - I have about 15 other user accounts specific to my mysql installation that were not in the /etc/passwd file. where were those stored? If you're just talking about mysql users, those are in /var/db/mysql/mysql/user.* . An OS upgrade shouldn't have touched them at all. Unless you reformatted /var or something :) It may be possible that mergemaster was used incorrectly. If so, there should be a copy of the updated /etc/master.passwd file in: # /var/tmp/temproot/etc You can compare that against the new file in /etc. If they are the same, mergemaster hosed the original. I don't know if mergemaster makes a backup of the original, but it may be easier to pull master.passwd from a backup (you did backup /etc right?) and try re-merging if there were any differences. Then again, I may be totally wrong with this assessment. Steve ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: upgraded 6.2 and mysql lost all privileges
In the last episode (Mar 06), Noah said: okay you got me on the right track. I can see mysql files in that directory. but mysql is not aware of the users in the user files is there something that I need to tell to mysql to use those files to reincorporate the mysql related users? # ls -l /var/db/mysql/mysql total 648 -rw-rw 1 mysql mysql 208 Mar 6 06:49 user.MYD -rw-rw 1 mysql mysql2048 Mar 6 06:49 user.MYI -rw-rw 1 mysql mysql 10330 Mar 6 06:49 user.frm If you can log into mysql, does select * from user print anything? A 208-byte MYD file is only large enough for about four user records. If you had 15 in there before, they're gone. You'll probably want to restore your entire /var/db/mysql/mysql/ directory from a backup, then run mysql_fix_privilege_tables to bring the tables up to whatever version of mysql you're now running. -- Dan Nelson [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
