Obsolete Releases > SME 8.x Contribs

Problem with AFFA after upgrade prodbox to SME 8.0

<< < (3/3)

idp_qbn:
Only the sort who hang around bars ....
Back next week (I hope)

idp_qbn:
Back now from FNQ (where it is warm......)
I have done some tests, as suggested
Thanks Mary, Stefano and Nicola for your help so far - I think I will need even more before this is resolved.

result of mysql -BNre "show databases
   information_schema
   horde
   mysql
   sme7admin
   test

result of mysqlcheck -c -A
horde.horde_alarms                                 OK
horde.horde_cache                                  OK
horde.horde_datatree                               OK
horde.horde_datatree_attributes                    OK
horde.horde_datatree_seq                           OK
horde.horde_groups                                 OK
horde.horde_groups_members                         OK
horde.horde_histories                              OK
horde.horde_histories_seq                          OK
horde.horde_locks                                  OK
horde.horde_perms                                  OK
horde.horde_prefs                                  OK
horde.horde_sessionhandler                         OK
horde.horde_signups                                OK
horde.horde_syncml_anchors                         OK
horde.horde_syncml_map                             OK
horde.horde_tokens                                 OK
horde.horde_users                                  OK
horde.horde_vfs                                    OK
horde.imp_sentmail                                 OK
horde.ingo_forwards                                OK
horde.ingo_lists                                   OK
horde.ingo_rules                                   OK
horde.ingo_shares                                  OK
horde.ingo_shares_groups                           OK
horde.ingo_shares_users                            OK
horde.ingo_spam                                    OK
horde.ingo_vacations                               OK
horde.kronolith_events                             OK
horde.kronolith_shares                             OK
horde.kronolith_shares_groups                      OK
horde.kronolith_shares_users                       OK
horde.kronolith_storage                            OK
horde.turba_objects                                OK
horde.turba_shares                                 OK
horde.turba_shares_groups                          OK
horde.turba_shares_users                           OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.func                                         OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.proc                                         OK
mysql.procs_priv
Error    : Can't find file: 'procs_priv' (errno: 2)
error    : Corrupt
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
sme7admin.afp                                      OK
sme7admin.dhcpd                                    OK
sme7admin.ftp                                      OK
sme7admin.pppoe                                    OK
sme7admin.samba                                    OK
sme7admin.ssh                                      OK
sme7admin.vpn                                      OK

(Sorry to post such a lot)
This confirms that procs_priv is missing or corrupt.

Questions:
1 - can i use the example procs_priv Nicola (nicolatiana) shows and copy the file from another mysql database?
2)- if I can, how do I do it and where do I copy it to and what changes may have to be made?
3)- if NOT,  how do I create/recreate a table?

You can see I am trying to avoid having to drive the 300 km to where the server is located.....
Tonight I will install  phpmyadmin contrib (which requires a reboot, I believe) and in the meantime start reading as much as I can take in about mysql and phpmyadmin.

Cheers
Ian

idp_qbn:
Just an update - I "solved" the problem by installing phpmyadmin, looking at the databases listed, them going to a databse called "mysql" which did not seem to be in use. It had a table (procs_priv) that was corrupt so could not been used anyway.
I manually backked up all the user data and Ibays to a WinXP box(shudder)

I then used phpmyadmin to remove the table procs_priv. Just for good measure, and it was after 1.oo am by this stage, I rebooted both the production server and the AFFA server.

At the next scheduled AFFA run, all worked perfectly and over the next day a complete backup was done automatically.....AFFAmagically? :-)

The production system continues to run, users report no problems and the limited testing of the backup I have tried seems to indicate everything is working OK.
When I am next down there (Canberra) I will try doing a full restore just to make sure.

Just goes to show
a) how good SME is
b) how good the advice in forums and bugzilla is
c) how much sleep one can lose trying to support something over a distance of 300km
d) how such a little thing (a corrupt mysql table) can cause such big problems.
e) how much close attention one should use when doing an upgrade - don't overlook/ignore/miss  warning messages!

Once again, thanks to all who responded.
Cheerio
Ian

nicolatiana:
Maybe You should better try to recreate the removed table; I see that in my server(s) too this table is empty but . . . . Some help from a Mysql expert should be necessary.
Looking at an existing db You may look at the table structure and then recreate it.
 
Just for debug purpose: what did you do before upgrading the system (e.g. did You remove some Contrib). The upgrade went appearently smooth ?
 
Bye
 
Nicola
 
 

idp_qbn:
I had an old contrib that put an "rsync" option into Server Manager list. I had not used it for some time  - since moving from 6.5 to 7.x. I think it may have been a precurser to DAR. I removed that. I think that was the only thing I changed.

I did not notice anything going wrong with the update during the process itself.  Everything seemed to be functioning after the upgrade. It was only when I looked at the affa backups (or lack of them) that I realised something had stopped.

The site had changed ISPs, new IP address for remote loging etc, so it was a while beofre I could connect again (300 km apart - PuTTy and SCP are my friends!)

Cheers
Ian

Navigation

[0] Message Index

[*] Previous page