grisswold
... our UPS only has a power life span of 30 minutes and it doesn't have the feature to automatically to shutdown computers... Those kind of UPS are too expensive for us...
I thought just about every basic UPS supported signalling between the UPS & the server via USB cable. You perhaps should be more selective of the UPS brand & model and choose one that does have signalling, without necessarily choosing an expensive one.
Ask in these Forums for which low end models work OK with sme servers & Nut. Also see the Nut compatibility list, linked from the Wiki Howto page.
I would encounter an error installing joomla using the contrib from the wiki... "could not connect to MySQL".. During this process "yum localinstall smesever-joomla-1.5.1-2.noarch.rpm" I was able to see the error "Access denied: could not connect to MySQL(password:NO)"... I believe the joomla was trying to create a db in the MySQL server. And the problem is... "MySQL wont restart my password"-which was my first problem-(I cnt login to MySQL just by typing mysql in the root console, I always have to login by "-u root -p password")....
Sounds like your issue is mysql root password related.
I thought you had fixed that issue by now.
I think you should stop trying to install Joomla and stop doing anything else to your sme server and fix up the mysql root password.
Stay on track until you resolve the root password issue, as it will only continue to cause problems with every other thing you do on the sme server.
Please go back to the thread on the root mysql password issue and continue the discussion there.
My guess is you have done the wrong procedures to fix it, and that's why it is not yet fixed.
Please post the exact commands you use, copy and paste using putty to make sure you transfer them to us exactly as you enter them. A simple spelling m,istak eor extra or missing space can make a lot o fdifference.
It should be a simple straightforward matter to reset the root mysql password.
I hesitate to say it as it should not be considered as the magic answer to all problems, but a reinstall may be your simplest and quickest way to resolve these problems, and without restoring any old data too.
Do an install from the latest sme7.3 CD to avoid earlier upgrade issues.
Just manually re-enter anything needed to ensure a clean stable system. Preferably do not go installing various apps or making custom changes etc, just get your basic sme server working correctly first ie one that does not have system errors.