1 Topic by 2009tester (edited by 2009tester 2012-06-21 11:58:23)

  • 2009tester
  • Member
  • Offline
  • Registered: 2012-06-21
  • Posts: 15

Topic: Server Starts but iredmail stopped function

Debian squeeze
Iredmail 0.8 with mysql

iredmail was working OK for some time.
After some host maintenace, started having  "internal server error"
when opening httpS://sever/iredadmin/  httpS://sever/mail

Server itself starts, but mysqld unable to start
Apache works ok
=== error log==
[ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
[ERROR] Do you already have another mysqld server running on port: 3306 ?
[ERROR] Aborting

mysqld: 120620 23:10:08  InnoDB: Starting shutdown...
mysqld: 120620 23:10:14  InnoDB: Shutdown completed; log sequence number 0 17348037
mysqld: 120620 23:10:14 [Note] /usr/sbin/mysqld: Shutdown complete
======end

I tried to start on another port :     mysqld -P 3305
it again says
======
[Note] Plugin 'FEDERATED' is disabled.
InnoDB: Initializing buffer pool, size = 8.0M
InnoDB: Completed initialization of buffer pool
InnoDB: Started; log sequence number 0 17348037
[ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
[ERROR] Do you already have another mysqld server running on port: 3305 ?
[ERROR] Aborting

InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 0 17348037
[Note] mysqld: Shutdown complete
=================end

my.cnf says
bind-address = 127.0.0.1
there is no port open at 3306

I noticed that
https://iredmail.googlecode.com/hg/iRed … les/my.cnf
says bind-address not used.

Any suggestions for the cause of this mysqld error?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,790

Re: Server Starts but iredmail stopped function

- Did you check whether there's mysql running with below command?

# netstat -ntlp

- It says "[ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address", does it work if you comment out "bind-address" line in my.cnf?

- Could you please show us the whole my.cnf?

3 Reply by 2009tester

  • 2009tester
  • Member
  • Offline
  • Registered: 2012-06-21
  • Posts: 15

Re: Server Starts but iredmail stopped function

i did check open ports and services. mysql service and ports were closed.
even i could not start service on another port.

SOLVED
my host provider found out that  /etc/network/interfaces file
had this entry on top:
pre-up iptables-restore < /etc/iptables.up.rules
This command was preventing the set up for  interfaces.

It caused to malfunction mysql sevice on bind-address 127.0.0.1 after reboot
and since mysql stopped whole mail service stopped.
But the Apache was running.

I dont know how the command "pre-up iptables-restore < /etc/iptables.up.rules"
entered in the file interfaces.
actually there is nothing wrong with that command. Iptables Rules in the specified file are all correct.

1) is this "pre-up" command inserted by iredmail?
2) where can I get initial iptables for iredmail+mysql?

Thanking you.