Koozali.org: home of the SME Server
Contribs.org Forums => General Discussion => Topic started by: rshiras on July 10, 2009, 04:19:37 PM
-
I have several domains, but I want to forward one of them to an exchange server. but first I want it to be processed through the usual clam-av and spamassassin. The closest place I can see to do this is through the Hostnames and addresses panel but I need step by step instructions.
-
rshiras
Please read the email FAQ, your question is answered there.
-
OK I see that now, but I just found out that my password no longer works to get in to phpMySQL.
I suppose I should start a new thread for that, but can you point me to a faq or other documentation that would help? Thanks
-
rshiras
Hey be proactive ! Read the same FAQ re mysql
-
Mary thanks for your help but that faq has no answers that help in this case. I have been working on this all day, very proactively. This problem is not your vanilla faq problem.
-
I see my previous posts did not make it for some reason, perhaps because my server was rebooting.
Here's what I have done:
I have reset the password for admin.
I can now log in from a shell as a user, but not as root (mysql command with no params).
I have reinstalled phpmyadmin.
I have made it public:
config set mysqld service access public status enabled TCPPort 3306
signal-event remoteaccess-update
signal-event reboot
I still cannot log in via the web interface using a username and password that works from the shell prompt.
-
rshiras
I was referring to restting the mysql password, which is in the FAQ and seemed to be your problem, which was poorly described.
It now seems you have also changed the system root password. I suggest making it the same as the admin pw and then reset the mysql pw as described in FAQ
-
#passwd admin
#passwd root
#cd /var/service/mysqld
#sv d .
#expand-template /root/.my.cnf
#expand-template /var/service/mysqld/set.password
#/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password
#sv u .
#mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Still can't log in from shell logged in as root, without a password parameter to the mysql command.
mysql --user='USER' --password='PASSWORD' works for users, but not for root.
I do have a user with super permissions. Do you recommend I delete the root user and add it according to the faq? I have tried following the faq instructions for Restoring accidently deleted MySQL root user as well, but no joy.
-
rshiras
If the instructions for resetting the mysql password do not seem to work, then I suggest you raise a bug at bugzilla. That may be the quickest way to resolving your problem.
ie a documentation bug