Re: [opsview-users] Issue with my opsview

sampath Mon, 22 Feb 2010 08:23:59 -0800

Hello Duncan,

I tried to restore the old dump and it also failed.

So I will take up the second step

Kindly confirm if i am correct

sudo /etc.init.d/opsview stop
sudo /etc.init.d/opsview-web stop

mysql -unagios -p

ysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| opsview            |
| runtime            |
+--------------------+

drop database runtime;
create db_runtime db_install;

restart mysql

restart opsview
restart opsview-web

Please confirm & I am sorry for bothering you.

Thanks,

Sampath.

On 22 Feb 2010, at 15:21, sampath wrote:
Hello Duncan,

Thanks for your reply, Yes I followed your instruction and tried to repair the table under runtime
opsview_hostgroups   and when i check the status I get the following message
    
If standard MySQL repair commands cannot fix the tables I suggest you restore the database from your latest backup immediately before the corruption.

If this is not possible then you will need recreate the runtime database using 'db_runtime db_install' as nagios

In both cases you should stop opsview and opsview-web before working on the database.

  Duncs

--

Duncan Ferguson
Senior Developer

Opsera Limited | Unit 69 Suttons Business Park
Reading | Berkshire | RG6 1AZ | UK

Phone:   +44 (0) 845 057 7887
Mobile:   +44 (0) 7968 148 748
Skype:   duncan_j_ferguson     Email:   [email protected]
www.opsera.com

Opsera Limited is registered in the UK under Company Number 5396532. Our registered office is Gorse View, Horsell Rise, Woking, Surrey, GU21 4RB.

_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-users

Re: [opsview-users] Issue with my opsview

Reply via email to