How to change Page Refresh Interval for All Users

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Moderators, Developers

Post Reply
Author
Message
cacti_is_awesome
Posts: 12
Joined: Thu Apr 30, 2009 11:38 am
Location: San Diego

How to change Page Refresh Interval for All Users

#1 Post by cacti_is_awesome » Fri Feb 05, 2010 5:35 pm

Hi,

I've created network weathermap for my network. Now I want to change default "Page Refresh" interval from 300 seconds to 200 seconds for all the users.

I can certainly change it for few users, but there are more than 100 users here.

See attached for more information.

Is there a way to do it for all users either by editing a file or by updating a table in cactidb?

Thanks,
Ray

Attachments
graph_Settings.JPG
graph_Settings.JPG (103.92 KiB) Viewed 2197 times

User avatar
Linegod
Developer
Posts: 1630
Joined: Thu Feb 20, 2003 10:16 am
Location: Canada
Contact:

#2 Post by Linegod » Fri Feb 05, 2010 7:28 pm

Code: Select all

update settings_graphs set value=200 where `name`='page_refresh';
--
Live fast, die young
You're sucking up my bandwidth.

J.P. Pasnak,CD
CCNA, LPIC-1
http://www.warpedsystems.sk.ca

cacti_is_awesome
Posts: 12
Joined: Thu Apr 30, 2009 11:38 am
Location: San Diego

#3 Post by cacti_is_awesome » Mon Feb 08, 2010 2:26 pm

Linegod wrote:

Code: Select all

update settings_graphs set value=200 where `name`='page_refresh';
Thanks for the SQL query. It updated only 20 rows, against 375 users I have.

Any idea why few users show up when you query "settings_graphs" table using below query?

select user_id from settings_graphs where name='page_refresh';
+---------+
| user_id |
+---------+
| 1 |
| 18 |
| 33 |
| 48 |
| 50 |
| 51 |
| 52 |
| 54 |
| 82 |
| 88 |
| 92 |
| 164 |
| 225 |
| 227 |
| 247 |
| 262 |
| 272 |
| 324 |
| 333 |
| 335 |
+---------+
20 rows in set (0.01 sec)
Attachments
sql_output.JPG
sql_output.JPG (31.67 KiB) Viewed 2152 times

User avatar
Linegod
Developer
Posts: 1630
Joined: Thu Feb 20, 2003 10:16 am
Location: Canada
Contact:

#4 Post by Linegod » Mon Feb 08, 2010 2:50 pm

Their settings have not been adjusted, so they will use the site default.
--
Live fast, die young
You're sucking up my bandwidth.

J.P. Pasnak,CD
CCNA, LPIC-1
http://www.warpedsystems.sk.ca

User avatar
Linegod
Developer
Posts: 1630
Joined: Thu Feb 20, 2003 10:16 am
Location: Canada
Contact:

#5 Post by Linegod » Mon Feb 08, 2010 2:51 pm

Just to be clear, not 'default', but whatever is set on the global Settings.
--
Live fast, die young
You're sucking up my bandwidth.

J.P. Pasnak,CD
CCNA, LPIC-1
http://www.warpedsystems.sk.ca

Post Reply