Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 7th January 2008, 10:32
juanfra77 juanfra77 is offline
Junior Member
 
Join Date: Jan 2008
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Fedora 8 - Mysql and Postfix problems when installing ISPConfig-2.2.18

I found some problems when I was following your instructions to install ISPConfig on a brand new Linux Server. I am using Fedora 8. Is it possible that you read below and help me out? Your instructions were clear and useful at every step. I am now two steps from the end and then I can start installing ISPConfig. I am affraid I have to get this two things fixed before I proceed with the installation.

Thanks very much.

juanfra77@tiscali.it

------------------------------------------------

enabling root password for MySql

[root@linuxserver sbin]# mysqladmin -u juanfra77 password changeme
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'juanfra77'@'localhost' (using password: NO)'


[root@linuxserver sbin]# mysqladmin -h server1.example.com -u root password changeme
mysqladmin: connect to server at 'server1.example.com' failed
error: 'Unknown MySQL server host 'server1.example.com' (1)'
Check that mysqld is running on server1.example.com and that the port is 3306.
You can check this by doing 'telnet server1.example.com 3306'

-------------------------------------------------


Enabling Post Fix


postconf -e 'smtpd_sasl_local_domain ='
postconf -e 'smtpd_sasl_auth_enable = yes'
postconf -e 'smtpd_sasl_security_options = noanonymous'
postconf -e 'broken_sasl_auth_clients = yes'
postconf -e 'smtpd_recipient_restrictions = permit_sasl_authenticated,permit_mynetworks,reject _unauth_destination'
postconf -e 'inet_interfaces = all'
postconf -e 'mynetworks = 127.0.0.0/8'





I get errors saying postconf is not found. I run it from sbin

[root@linuxserver sbin]# ./postconf -e 'smtpd_sasl_auth_enable = yes'
bash: ./postconf: No such file or directory


The same problem here, postconf is not recognize command.

Next we configure Postfix for TLS:

postconf -e 'smtpd_tls_auth_only = no'
postconf -e 'smtp_use_tls = yes'
postconf -e 'smtpd_use_tls = yes'
postconf -e 'smtp_tls_note_starttls_offer = yes'
postconf -e 'smtpd_tls_key_file = /etc/postfix/ssl/smtpd.key'
postconf -e 'smtpd_tls_cert_file = /etc/postfix/ssl/smtpd.crt'
postconf -e 'smtpd_tls_CAfile = /etc/postfix/ssl/cacert.pem'
postconf -e 'smtpd_tls_loglevel = 1'
postconf -e 'smtpd_tls_received_header = yes'
postconf -e 'smtpd_tls_session_cache_timeout = 3600s'
postconf -e 'tls_random_source = dev:/dev/urandom'
postconf -e 'smtpd_sasl_authenticated_header = yes'

--------------------------------------------------
Reply With Quote
Sponsored Links
  #2  
Old 8th January 2008, 17:40
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Quote:
Originally Posted by juanfra77
I found some problems when I was following your instructions to install ISPConfig on a brand new Linux Server. I am using Fedora 8. Is it possible that you read below and help me out? Your instructions were clear and useful at every step. I am now two steps from the end and then I can start installing ISPConfig. I am affraid I have to get this two things fixed before I proceed with the installation.

Thanks very much.

juanfra77@tiscali.it

------------------------------------------------

enabling root password for MySql

[root@linuxserver sbin]# mysqladmin -u juanfra77 password changeme
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'juanfra77'@'localhost' (using password: NO)'


[root@linuxserver sbin]# mysqladmin -h server1.example.com -u root password changeme
mysqladmin: connect to server at 'server1.example.com' failed
error: 'Unknown MySQL server host 'server1.example.com' (1)'
Check that mysqld is running on server1.example.com and that the port is 3306.
You can check this by doing 'telnet server1.example.com 3306'

-------------------------------------------------
What's the output of
Code:
netstat -tap
?


Quote:
Originally Posted by juanfra77
I get errors saying postconf is not found. I run it from sbin

[root@linuxserver sbin]# ./postconf -e 'smtpd_sasl_auth_enable = yes'
bash: ./postconf: No such file or directory
Sounds like a path problem. Please make sure that you log in directly as root; logging in as another user and then doing a su to root might be the problem.
__________________
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
  #3  
Old 10th January 2008, 20:02
juanfra77 juanfra77 is offline
Junior Member
 
Join Date: Jan 2008
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default There are some points still not working, for the rest it works fine. Thanks.

Hi falko, thanks very much for your quick response. I had a few issues I am starting to wonder if it is just me who is having these problems or other people too.

A) I am still having trouble enabling my password root password for mysql. Following your instructions, I used:

mysqladmin -u root password changeme (this command worked out great)
mysqladmin -h server1.example.com -u root password (did not work)

This was the outcome.

[root@fedora-8-server named]# mysqladmin -h fedora-8-server -u root password changeme
mysqladmin: connect to server at 'fedora-8-server' failed
error: 'Access denied for user 'root'@'fedora-8-server' (using password: NO)'

As you see, the problem persists. I logged in as root directly. If the access is denied to root, who can do it then? This is a bit weird, because mysql is running.


You also asked me to try netstat tap, and here is the outcome.

[root@fedora-8-server named]# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 *:mysql *:* LISTEN 2828/mysqld
tcp 0 0 *:50636 *:* LISTEN 1611/rpc.statd
tcp 0 0 *:sunrpc *:* LISTEN 1592/rpcbind
tcp 0 0 localhost.localdomai:domain *:* LISTEN 2515/named
tcp 0 0 localhost.localdomain:ipp *:* LISTEN 1942/cupsd
tcp 0 0 localhost.localdomain:rndc *:* LISTEN 2515/named
tcp 0 0 localhost.localdomain:smtp *:* LISTEN 1817/sendmail: acce
tcp 0 0 localhost6.localdoma:domain *:* LISTEN 2515/named
tcp 0 0 *:ssh *:* LISTEN 1794/sshd
tcp 0 0 localhost6.localdomain:rndc *:* LISTEN 2515/named
tcp 0 0 fedora-8-server:ssh ::ffff:193.221.137.1:talnet ESTABLISHED 2413/0


B) You had a great idea to introduce the set of postconf commands. I logged in as root from the first time, and it worked great. Maybe the article should also indicate, as other people may find themselves with the same problem.


C) Once you finish installing PostFix, they ask you try the below command to test that SMTP-AUTH and TLS. I didnt error messages during its configuration, only when I try if it works, the session times out.

[root@fedora-8-server sbin]# telnet localhost 25
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
220 Fedora-8-server ESMTP Postfix
421 4.4.2 Fedora-8-server Error: timeout exceeded
Connection closed by foreign host.

As you can imagine, the command ehlo localhost doesnt work either.


For the rest, I managed to install ICP successfully and it works fine. Thanks very much for your indications.
Reply With Quote
  #4  
Old 11th January 2008, 13:43
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
 
Default

Quote:
Originally Posted by juanfra77
mysqladmin -h server1.example.com -u root password (did not work)

This was the outcome.

[root@fedora-8-server named]# mysqladmin -h fedora-8-server -u root password changeme
mysqladmin: connect to server at 'fedora-8-server' failed
error: 'Access denied for user 'root'@'fedora-8-server' (using password: NO)'

As you see, the problem persists. I logged in as root directly. If the access is denied to root, who can do it then? This is a bit weird, because mysql is running.
This means you have the wrong hostname in the mysql.user table. You can fix it as shown in chapter 8 on http://www.howtoforge.com/perfect_se...pensuse10.3_p4 , starting with
Quote:
As you've seen in the netstat output, MySQL is not only listening on localhost,

Quote:
Originally Posted by juanfra77
C) Once you finish installing PostFix, they ask you try the below command to test that SMTP-AUTH and TLS. I didnt error messages during its configuration, only when I try if it works, the session times out.

[root@fedora-8-server sbin]# telnet localhost 25
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
220 Fedora-8-server ESMTP Postfix
This is where you must enter
Code:
ehlo localhost
If you don't do this and wait too long, you get the timeout:

Quote:
Originally Posted by juanfra77
421 4.4.2 Fedora-8-server Error: timeout exceeded
Connection closed by foreign host.
__________________
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
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
postfix problems with smtp linkdeb Server Operation 13 15th March 2014 17:58
POP3 problems, Virtual Users And Domains With Postfix, Courier And MySQL (Fedora 8) garbagedigger HOWTO-Related Questions 1 10th December 2007 02:51
postfix mysql on fedora core5 igongora Installation/Configuration 7 17th April 2007 04:40
ISPCONFIG and Virtual Users And Domains With Postfix, Courier And MySQL QuikSoft Installation/Configuration 5 6th December 2006 18:01
Centos 4.4 32bit Hangs, High Server load 3cwired_com Server Operation 11 16th November 2006 15:47


All times are GMT +2. The time now is 07:32.


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