Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #11  
Old 14th December 2006, 20:31
stickyplaster stickyplaster is offline
Junior Member
 
Join Date: Dec 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko
What's the output of
Code:
/etc/init.d/mysql restart
,

Stopping MySQL database server: mysqld
Starting MySQL database server: mysqld
Checking for corrupt, not cleanly closed and upgrade needing tables.

Code:
ps aux|grep -i mysql
root 17829 0.0 0.1 1744 384 ? S 19:14 0:00 /usr/sbin/courierlogger -pid=/var/run/courier/authdaemon/pid -start /usr/lib/courier/authlib/authdaemond.mysql
root 17831 0.0 0.2 2416 640 ? S 19:14 0:00 /usr/lib/courier/authlib/authdaemond.mysql
root 17833 0.0 0.1 2416 312 ? S 19:14 0:00 /usr/lib/courier/authlib/authdaemond.mysql
root 17834 0.0 0.1 2416 312 ? S 19:14 0:00 /usr/lib/courier/authlib/authdaemond.mysql
root 17835 0.0 0.1 2416 340 ? S 19:14 0:00 /usr/lib/courier/authlib/authdaemond.mysql
root 17836 0.0 0.1 2416 312 ? S 19:14 0:00 /usr/lib/courier/authlib/authdaemond.mysql
root 17837 0.0 0.2 2452 740 ? S 19:14 0:00 /usr/lib/courier/authlib/authdaemond.mysql
root 19708 0.0 0.4 2384 1100 pts/28 S 19:20 0:00 /bin/sh /usr/bin/mysqld_safe
mysql 19747 0.0 6.2 126240 16380 pts/28 S 19:20 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
root 19748 0.0 0.1 1568 504 pts/28 S 19:20 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld


and
Code:
netstat -tap
?
mysql seems to be showing now:

Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 :imaps *:* LISTEN -
tcp 0 0 op3s *:* LISTEN -
tcp 0 0 :mysql *:* LISTEN -
tcp 0 0 op3 *:* LISTEN -
tcp 0 0 :imap2 *:* LISTEN -
tcp 0 0 :www *:* LISTEN -
tcp 0 0 :10002 *:* LISTEN -
tcp 0 0 :ssh *:* LISTEN -
tcp 0 0 :smtp *:* LISTEN -
tcp 0 0 :https *:* LISTEN -
tcp 0 52 ssh ESTABLISHED-
tcp 38 0 :CLOSE_WAIT -

but still no joy.

regards
Reply With Quote
Sponsored Links
  #12  
Old 14th December 2006, 21:38
stickyplaster stickyplaster is offline
Junior Member
 
Join Date: Dec 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am seeing mysql on localhost now:

tcp 0 0 :mysql localhost:37249 TIME_WAIT -
tcp 0 0 :mysql localhost:37250 TIME_WAIT -
tcp 0 0 localhost:37249 mysql TIME_WAIT -

still no luck though ho hum
Reply With Quote
  #13  
Old 15th December 2006, 13:07
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,743 Times in 2,577 Posts
Default

Do you use 127.0.0.1 in your configuration files (as recommended by the tutorial) or localhost?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #14  
Old 15th December 2006, 13:34
stickyplaster stickyplaster is offline
Junior Member
 
Join Date: Dec 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko
Do you use 127.0.0.1 in your configuration files (as recommended by the tutorial) or localhost?
Hi
As far as I am aware I have used 127.0.0.1 throughout
Reply With Quote
  #15  
Old 15th December 2006, 15:34
Tortanick Tortanick is offline
Member
 
Join Date: Mar 2006
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Its a long shot but I had an authentication problem that was caused by putting squigles in my MySQL password. (not root the one SASL uses). Try only useing numbers and letters in you're password.
Reply With Quote
  #16  
Old 15th December 2006, 17:07
stickyplaster stickyplaster is offline
Junior Member
 
Join Date: Dec 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by Tortanick
Its a long shot but I had an authentication problem that was caused by putting squigles in my MySQL password. (not root the one SASL uses). Try only useing numbers and letters in you're password.
Hi
Unfortunately my password is only letters and numbers. I am going to have to rethink this one I feel.

regards
Reply With Quote
  #17  
Old 16th December 2006, 11:58
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,743 Times in 2,577 Posts
Default

I think you should compare all your configuration files again with those of the tutorial. Also take care about their format (tabs, spaces, ...). Courier is very finicky about this.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #18  
Old 16th December 2006, 14:09
stickyplaster stickyplaster is offline
Junior Member
 
Join Date: Dec 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Quote:
Originally Posted by falko
I think you should compare all your configuration files again with those of the tutorial. Also take care about their format (tabs, spaces, ...). Courier is very finicky about this.
I have done both many times, believe me.

Perhaps I'm just going to have to accept that I can't get it to work.

Thanks for all your help.

regards
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Virtual Users And Domains With Postfix, Courier And MySQL wmrwl HOWTO-Related Questions 73 6th October 2006 23:06
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs k1piee HOWTO-Related Questions 14 1st October 2006 13:46
Autoreply problem using Virtual Users And Domains With Postfix, Courier And MySQL triak HOWTO-Related Questions 1 19th May 2006 15:25
Problem with Virtual Users And Domains With Postfix, Courier And MySQL Howto fenix Server Operation 4 11th March 2006 02:53
Another Problem: Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP bluegrass Installation/Configuration 24 8th March 2006 01:41


All times are GMT +2. The time now is 20:41.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.