Upgraded from 0.8.1 to 0.8.6.f. Poller seems to be working but I cannot see any graphs as I get ACCESS DENIED errors; perform any User Maintenance - cannot create or save a new user or see my account; etc. It seems (?) that mySql database did not upgrade.
All of my rrd files seem to be updating. I can log into cacti as myself and as the admin. All of my hosts are there but the graph trees are not.
Any ideas on how I can verify that the database actually updated?
Would it be a good thing to restore my old 0.8.1 db and try to upgrade?
Thanks.
Problems upgradeing from 0.8.1 to 0.8.6f
Moderators: Developers, Moderators
- TheWitness
- Developer
- Posts: 17007
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
I have sent an e-mail to our Auth expert for followup.
TheWitness
TheWitness
Last edited by TheWitness on Wed Jul 20, 2005 8:17 pm, edited 1 time in total.
True understanding begins only when we realize how little we truly understand...
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
- rony
- Developer/Forum Admin
- Posts: 6022
- Joined: Mon Nov 17, 2003 6:35 pm
- Location: Michigan, USA
- Contact:
Export? Do you mean expert?
Let's do 2 things, Please dump and email me you current problem database, so I can see what is causing the problem.
Second, attempt to upgrade again and let me know what happens.
Let's do 2 things, Please dump and email me you current problem database, so I can see what is causing the problem.
Second, attempt to upgrade again and let me know what happens.
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
- TheWitness
- Developer
- Posts: 17007
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
Sorry, got export on the brain
True understanding begins only when we realize how little we truly understand...
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
-
- Posts: 3
- Joined: Wed Jul 20, 2005 1:55 pm
I restored my old db and tried again with no success. Looking at a db dump, it does seem that it is not upgraded completely. I did try to recreate all the user* tables and was able to login; however, I then started to receive variable undefined errors. Kinda seems that the db didn't update correctly.
I will email you my db dump.
Thank you for your help,
Tom
I will email you my db dump.
Thank you for your help,
Tom
- rony
- Developer/Forum Admin
- Posts: 6022
- Joined: Mon Nov 17, 2003 6:35 pm
- Location: Michigan, USA
- Contact:
I got your dump, please send me a full dump, I will convert it for you.
Don't know what is happening and I would like to figure it out.
I was able to add and remove users after importing the partial dump you sent me. Are you using 0.8.6f, fully patched?
Don't know what is happening and I would like to figure it out.
I was able to add and remove users after importing the partial dump you sent me. Are you using 0.8.6f, fully patched?
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
-
- Posts: 3
- Joined: Wed Jul 20, 2005 1:55 pm
Yes...it works!
I did get the upgrade to work and stumbled on the solution by accident. I decided to create another 0.8.1 database to start collecting errors, screen shots and the like to answer your email. Ran the upgrade agains the new db and it worked!
I'm stumped.
This is what I did:
- Backup the 0.8.1 db.
- Create a new db with the name of 'test_cacti'
- Restore the 0.8.1 data to the 'test_cacti' db.
- Configure the new version of Cacti to use the 'test_cacti' db.
- Upgrade the "test_cacti" db to 0.8.6f
- Log in and start working. No errors at all.
- Patched up with the latest 11 patches
I'm not the MySQL admin; however, the userid is supposed to have full rights to the db. The only thing I can point my finger to is the old db.
Thank you for taking time to help resolve this problem.
I'm stumped.
This is what I did:
- Backup the 0.8.1 db.
- Create a new db with the name of 'test_cacti'
- Restore the 0.8.1 data to the 'test_cacti' db.
- Configure the new version of Cacti to use the 'test_cacti' db.
- Upgrade the "test_cacti" db to 0.8.6f
- Log in and start working. No errors at all.
- Patched up with the latest 11 patches
I'm not the MySQL admin; however, the userid is supposed to have full rights to the db. The only thing I can point my finger to is the old db.
Thank you for taking time to help resolve this problem.
Who is online
Users browsing this forum: No registered users and 1 guest