Atomicorp

premierhosting wrote:Following this thread intently. Tried setting up cacti and failed so far

setting up cacti is easy its getting it to monitor the stuff you want thats not so easy. If you want a quick and dirty way to get cacti working and play with it? check this out. http://cactiez.cactiusers.org/

I tried getting qmail, spam assassin, and plesk in general working with Cacti as I have a very large cacti install monitoring the server and many other devices already. I had no luck finding a template and am not versed enough to create my own templates or graph templates. I had alway hoped that som...

So has anyone upgraded from Plesk 9.5.3 to 10.0.1 while using ASL? anything catastrophic happen? everything go smoothly? Is it worth the risk yet?

sweet! ya it was running 5.0.9 before I upgraded to 5.1.5 so it was compatible with 5 but probably just not 5.1... I have already notified the customer but they will probably just say "switch me back to the other one then lol" at least the server is back up and functional!! Thank you for a...

When I disable that customers website and no one tries to access it there is no problem. As soon as I activate that customers site and try to browse to it the website never loads and mysql spikes and does not come down until I disable the site and restart mysql. Weird thing is... before the upgrade ...

197% cpu, that's not good! First, see what mysql processes are running: mysql -uadmin -p`cat /etc/psa/.psa.shadow` SHOW PROCESSLIST; Restart: /etc/init.d/mysqld restart and monitor mysql to see if it's a particular query causing the problem. By default mysql 5.0 reserves 150 process (up from 100), ...

try to setup new DB , and new user through plesk...should be good to go at this point... It worked!! but check this out... for some reason now my mysql process is spiking the CPU. One of my customers webpages wont load but the rest will (happened after I did what I did earlier today) PID USER PR NI...

OK, that means (Plesk) admin user has all the necessary privileges to be able to create databases/uses in MySQL. Now you need to flush the privileges to be sure - via SSH: 1. Enter: mysql -uadmin -p`cat /etc/psa/.psa.shadow` - at prompt: mysql > 2. Enter: FLUSH PRIVILEGES; See if any rows are affec...

Ya I tried running some of these commands and just keep getting syntax errors... I tried reading up on the link you included as well and to be honest its over my head I don't quite understand it. OK, just to be certain the commands are being run correctly first: 1. SSH to your box and get root priv...

..... plesk admin should be as user... here is a referrence page for setting users: http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html run this command to optimize databases, and it will only work if plesk admin is the user...which is what you want...if it doesn't run, then you have to ...

Mysql is running, the databases that were installed and the users that were there prior to the upgrade are functioning fine... I have a lot of database driven websites that all work fine still... the problem is just that plesk is not communicating with the database server and I cannot add new datab...

Is it safe to say that I should consider rolling back? the bad thing is... I upgraded all of the databases... so I don't know if I even can at this point.

[root@psa ~]# rpm -qa | grep -i psa psa-fcgi-2.4.0-2 psa-proftpd-1.3.3-2.el5.art psa-pylibplesk-9.5.2-cos5.build95100504.10 psa-qmail-1.03-cos5.build95100504.10 psa-ftputil-2.1.1-0.98221 psa-libpam-plesk-9.5.2-cos5.build95100504.10 psa-api-rpc-9.5.2-cos5.build95100504.10 psa-passwd-3.1.2-cos5.build9...

I can say that what originally happened was a yum upgrade that had tons of packages... I didn't see mysql in there until it was all said and done. At that point I performed the rest of the steps listed in here including the step 4 of upgrading the database. it ran through and I did the repair lines ...

As far as I know it is setup however plesk installs it. All of my applications that use databases are setup to point to localhost so I would assume thats how it is. As far as following the instructions I followed them off of a post here and yea they were pretty detailed. Everything appeared to be ok...