Mysql and Ispconfig 3 bakend can't login and connect

Okay,I will share my steps later.

 

here is my solution:
first edit /etc/postfix/main.cf
and comment these two line

Code:

# content_filter = amavis:[127.0.0.1]:10024 
# receive_override_options = no_address_mappings

then flow these steps:
/etc/init.d/postfix restart
update-rc.d -f clamav-daemon remove
update-rc.d -f clamav-freshclam remove
update-rc.d -f spamassassin remove
update-rc.d -f amavis remove

when finish this steps,restart apache2 and mysql

 

But yesterday,i got Mysql error on my website,when i restart mysql,i got follow error message:

Code:

root@server:~# ERROR 1016 (HY000) at line 1: Can't open file: './dbispconfig/dns                                   _rr.frm' (errno: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/dn                                   s_slave.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/dn                                   s_soa.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/dn                                   s_template.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/do                                   main.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/fi                                   rewall.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/ft                                   p_user.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/he                                   lp_faq.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/he                                   lp_faq_sections.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/ip                                   tables.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/ma                                   il_access.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/ma                                   il_backup.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/ma                                   il_content_filter.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/ma                                   il_domain.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/ma                                   il_forwarding.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/ma                                   il_get.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/ma                                   il_mailinglist.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/ma                                   il_relay_recipient.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/ma                                   il_traffic.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/ma                                   il_transport.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/ma                                   il_user.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/ma                                   il_user_filter.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/mo                                   nitor_data.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/op                                   envz_ip.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/op                                   envz_ostemplate.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/op                                   envz_template.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/op                                   envz_traffic.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/op                                   envz_vm.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/re                                   mote_session.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/re                                   mote_user.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/se                                   rver.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/se                                   rver_ip.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/se                                   rver_php.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/sh                                   ell_user.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/so                                   ftware_package.MYD' (Errcode: 24 - Too many open files)

 

Code:

ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/so                                   ftware_repo.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/so                                   ftware_update.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/so                                   ftware_update_inst.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/sp                                   amfilter_policy.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/sp                                   amfilter_users.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/sp                                   amfilter_wblist.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/su                                   pport_message.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/sy                                   s_config.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/sy                                   s_cron.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/sy                                   s_datalog.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/sy                                   s_dbsync.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/sy                                   s_filesync.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/sy                                   s_group.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/sy                                   s_ini.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/sy                                   s_log.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/sy                                   s_remoteaction.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/sy                                   s_session.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/sy                                   s_theme.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/we                                   b_backup.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/we                                   b_database.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/we                                   b_database_user.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/we                                   b_domain.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/we                                   b_folder.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/we                                   b_folder_user.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/we                                   b_traffic.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './dbispconfig/we                                   bdav_user.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './mysql/columns_                                   priv.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './mysql/db.MYD'                                    (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './mysql/event.MY                                   D' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './mysql/func.MYD                                   ' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './mysql/help_cat                                   egory.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './mysql/help_key                                   word.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './mysql/help_rel                                   ation.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './mysql/help_top                                   ic.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './mysql/ndb_binl                                   og_index.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './mysql/plugin.M                                   YD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './mysql/procs_pr                                   iv.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './mysql/proxies_                                   priv.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './mysql/servers.                                   MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './mysql/tables_p                                   riv.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './mysql/time_zon                                   e.MYD' (Errcode: 24 - Too many open files)
ERROR 23 (HY000) at line 1: Out of resources when opening file './mysql/time_zon                                   e_leap_second.MYD' (Errcode: 24 - Too many open files)
ERROR 1016 (HY000) at line 1: Can't open file: './mysql/time_zone_name.frm' (err                                   no: 24 - Too many open files)
ERROR 1016 (HY000) at line 1: Can't open file: './mysql/time_zone_transition.frm                                   ' (errno: 24 - Too many open files)
ERROR 1016 (HY000) at line 1: Can't open file: './mysql/time_zone_transition_typ                                   e.frm' (errno: 24 - Too many open files)
ERROR 1016 (HY000) at line 1: Can't open file: './mysql/user.frm' (errno: 24 - T                                   oo many open files)

But b4 i edit the limits.conf and add follow lines:
soft nproc 65535
hard nproc 65535
soft nofile 65535
hard nofile 65535
it's looks like not work,any idea?

 

see posts #7 and #13