mail server and mysql issue [solved]

morphal · Last edited by morphal on Wed Aug 03, 2005 7:34 pm; edited 2 times in total

I registered a domain name recently and I'm sort've using the brute-force method to make myself finally knuckle-down and become more geek.

I've followed the http://gentoo-wiki.com/HOWTO_Apache2_with_PHP_MySQL as well as the http://gentoo-wiki.com/HOWTO_Email_Virtual_Hosting_with_Courier_and_MySQL

I haven't had any problems that couldn't be figured out with enough backspacing. =/

However, I've got the daemons up and running alright but when I try to log in with Thunderbird, I get a "temporary problem" message with no other explanation. My logs show a FAILED LOGIN along with my username, IP and this:

Redeeman · l33t Joined: 25 Sep 2003 Posts: 958 Location: Portugal

well yes, you need to make it connect to localhost (you should also specify the socket)

morphal · Posted: Fri Jul 22, 2005 12:08 am Post subject:

Heh, awesome. How do I do that?

morphal · Posted: Sat Jul 23, 2005 1:42 am Post subject:

I know I can't demand help but I can at least try a little to make sure my problem is visible to those who can offer it. =)

/bump

morphal · Posted: Tue Jul 26, 2005 2:54 pm Post subject:

help?

kashani · Posted: Tue Jul 26, 2005 3:16 pm Post subject:

Since it's your authdaemon that's complaining in the logs I'd check your /etc/courier/authlib/authmysqlrc You'll like want to set your server to localhost here and maybe a few other variables if you've never touched this file.

morphal · Posted: Tue Jul 26, 2005 4:46 pm Post subject:

Alright, I edited that file to include the MYSql admin name and password in addition to pointing it at localhost instead of my domain. However, now, I can't seem to log in to phpmyadmin. I also get the same error message on the client side and my logs just show a failed login and

kashani · Posted: Tue Jul 26, 2005 5:58 pm Post subject:

IIRC phpmyadmin assumes you have a Mysql account named pma setup with the correct privileges. It'll use that to log into Mysql rather than any other accounts. I believe the ebuild mentions setting this up or the setup page of phpmyadmin. If you've created this account remember you'll need to run flush privileges or restart Mysql in order to activate the access.

kashani
_________________
Will personally fix your server in exchange for motorcycle related shop tools in good shape.

morphal · Posted: Tue Jul 26, 2005 6:23 pm Post subject:

During the past few days I've been logging into phpmyadmin with an admin name I had set up using the steps from the HowTo. I don't quite know how I screwed it up. I've restarted mysql though. The last post with the errors was after the restart had already been done.

I really should have done this on my test server first. I built one on purpose and I just haven't used it. I get over-eager ... but whatever, this is all a learning experience.

kashani · Posted: Tue Jul 26, 2005 7:00 pm Post subject:

It's possible you changed access on the account PHPMyadmin is using to control Mysql. I'd think that PMA needs an account with full access to Mysql rather than just yoru mail database. Can't say I can help much more since I never bothered to install it.

kashani
_________________
Will personally fix your server in exchange for motorcycle related shop tools in good shape.

morphal · Posted: Tue Jul 26, 2005 8:50 pm Post subject:

Alright, this php/mysql/mail stuff is just for my own education. I can nuke the whole install and start again. What's the best way to get rid of everything? Unmerging of course but what else should be done to make sure I don't end up with remnants from this screwed up instance interfering with the next one?

morphal · Posted: Fri Jul 29, 2005 5:17 am Post subject:

morphal · Posted: Wed Aug 03, 2005 6:56 pm Post subject:

help?

kashani · Posted: Wed Aug 03, 2005 7:32 pm Post subject:

rm the config files in /etc/ like /etc/postfix/, /etc/sasl2/, etc. Then check for stuff in /etc/conf.d/

kashani
_________________
Will personally fix your server in exchange for motorcycle related shop tools in good shape.

morphal · Posted: Wed Aug 03, 2005 7:34 pm Post subject:

Again, you are the awesome.

adaptr · Posted: Wed Aug 03, 2005 7:37 pm Post subject:

morphal · Posted: Wed Aug 03, 2005 8:06 pm Post subject:

Actually, that's good to know. I was pretty sure I had done things right but sometimes you just have to take the word of more experienced users. I understand the concept for this stuff but I'm just not familiar with all of the commands and how to properly use them. Learning all of that is exactly what this project is all about. All of this information is useful even if not immediately used.