Posts by theprincy
-
-
When from reseller account try to edit domain out this error
Display MoreCode- An error has been encountered
- An exception with the following message has been thrown in file /var/www/imscp/gui/library/shared-functions.php (Line: 2320):
- SQLSTATE[42S22]: Column not found: 1054 Unknown column 't2.subdomain_status' in 'field list'
- Query was:
- SELECT t1.domain_status, COUNT(t2.subdomain_status) + COUNT(t3.alias_status) + COUNT(t4.subdomain_alias_status) AS statusNotOk FROM domain AS t1 INNER JOIN admin AS t2 ON(admin_id = domain_admin_id) LEFT JOIN subdomain AS t3 ON (t1.domain_id = t3.domain_id AND t3.subdomain_status NOT RLIKE ?) LEFT JOIN domain_aliasses AS t4 ON (t1.domain_id = t4.domain_id AND t4.alias_status NOT RLIKE ?) LEFT JOIN subdomain_alias AS t5 ON (t5.alias_id = t4.alias_id AND t5.subdomain_alias_status NOT RLIKE ?) WHERE t1.domain_id = ? AND t2.created_by = ?
how to solve?
Information :
version I-Mscp 1.1.5
debian 7.0 -
You have very much Problems with your Server its not normal... Better to make a fresh installation or maybe a reconfiguration or update do actual version.
And also you offer Webservice....
problems derived from the server in a company that I have acquired, I will not say the other problems that I found in the management of domains,the other servers do not have all these problems, if not every time the spam ...
-
when add domain or modify the properties of a domain services i-MSCP not restart, I noticed that in mysql that is not recognized ip assigned, it returns the value as NUL, I report image error of the panel.
This error does not allow me to do any updates now (since even the current time) because the domains remain blocked until it would modify the mysql.
OS: debian
I-MSCP : 1.1.0 -
I have a server with characteristics that do not use, I can give without any problems to the project. IS 4EX or 6EX ... is a hetzner farm
-
I have a domain with external mail management that focuses on google, managing DNS for MX records is handled on the server, when you send out emails to some addresses you get this type of error.
Technical details of permanent failure:
Google tried to deliver your message, but it was rejected by the server for the recipient domain xxxxx.xxx by mail.xxxxxxx.xxx. [xxx.xxx.xxxx.xxx].
The error that the other server returned was:
550 209.85.217.175 is not allowed to send mail from xxxxxx.xxxx
Code- spf:xxx.xxx Find Problems spf Type Domain Name TTL Record Prefix Value PrefixDesc Description+ a Pass Match if IP has a DNS 'A' record in given domain + mx Pass Match if IP is one of the MX hosts for given domain name + ptr Pass Match if IP has a DNS 'PTR' record within given domain + include _spf.google.com Pass The specified domain is searched for an 'allow'. ~ all SoftFail Always matches. It goes at the end of your record.
or
- all Fail Always matches. It goes at the end of your record.Code- Your MX records that were reported by your nameservers are:10 aspmx3.googlemail.com 74.125.25.26 (no glue) 5 aspmx.l.google.com 74.125.136.26 (no glue) 10 alt1.aspmx.l.google.com 173.194.69.27 (no glue) 10 alt2.aspmx.l.google.com 74.125.25.26 (no glue) 10 aspmx2.googlemail.com 173.194.71.26 (no glue) [These are all the MX records that I found. If there are some non common MX records at your nameservers you should see them below. ]
CodeI not think it is a server configuration issue because as I said quietly send emails to other addresses, What can it be?
-
[FATAL ERROR]
main::setupIsImscpDb: SQL query failed: Error while executing query: Can't read
dir of '.' (errno: 13)[ERROR]
iMSCP::Debug::END: Exit code: 30
I may have figured out from where comes the problem, on another server, I did a test script to copy the file to a specific mysql database (var / lib / mysql / dbname / *) and left every 10 minutes, I made the case to time and moved up from there are all wrong, but I do not understand why going to change the folder chown mysql for now I stopped the script.error is a problem whit a chown folder changes from mysql mysql to polw polw , and yet in the script I set the permissions that are maintained , mistery
-
are same passwords, control differences.
-
I have not changed anything, I'm just doing rsync folder
/var/www/virtual
/var/mail/
while I still have to make a script for cloning the db to avoid problems , I still have synchronize db between the two serversLinux Distro Debian PHP Version5.4.4-14 i-MSCP Version1.1.0
the steps I did were on new server 2
1) install imscp
2) copy database
3) copy file /var/www/ , /etc/imspc , /etc/apache2 , /etc/postfix, /etc/bind/
4) run perl /var/www/imscp/engine/setup/imscp-setup --reconfigure ipsand on server 1 gave that error ...
-
the panel and the sites get this error? how to solve?
Unable to establish the connection to the database. SQL returned: SQLSTATE[HY000] [1049] Unknown database 'imscp'
but
Display MoreCode- /var/lib/mysql# ls -asl imscp
- totale 500
- 4 drwx------ 2 mysql mysql 4096 feb 23 19:49 .
- 4 drwx------ 80 polw polw 4096 feb 22 22:39 ..
- 20 -rw-rw---- 1 mysql mysql 17814 feb 23 19:49 admin.frm
- 12 -rw-rw---- 1 mysql mysql 8702 feb 23 19:49 autoreplies_log.frm
- 12 -rw-rw---- 1 mysql mysql 8592 feb 23 19:49 config.frm
- 12 -rw-rw---- 1 mysql mysql 8774 feb 23 19:49 custom_menus.frm
- 4 -rw-rw---- 1 mysql mysql 61 set 18 15:48 db.opt
- 16 -rw-rw---- 1 mysql mysql 13036 feb 23 19:49 domain_aliasses.frm
- 12 -rw-rw---- 1 mysql mysql 8959 feb 23 19:49 domain_dns.frm
- 12 -rw-rw---- 1 mysql mysql 10514 feb 23 19:49 domain.frm
- 12 -rw-rw---- 1 mysql mysql 8824 feb 23 19:49 domain_traffic.frm
- 12 -rw-rw---- 1 mysql mysql 8696 feb 23 19:49 email_tpls.frm
- 12 -rw-rw---- 1 mysql mysql 8758 feb 23 19:49 error_pages.frm
- 12 -rw-rw---- 1 mysql mysql 8634 feb 23 19:49 ftp_group.frm
- 16 -rw-rw---- 1 mysql mysql 12896 feb 23 19:49 ftp_users.frm
- 12 -rw-rw---- 1 mysql mysql 8740 feb 23 19:49 hosting_plans.frm
- 16 -rw-rw---- 1 mysql mysql 12904 feb 23 19:49 htaccess.frm
- 12 -rw-rw---- 1 mysql mysql 8694 feb 23 19:49 htaccess_groups.frm
- 12 -rw-rw---- 1 mysql mysql 8688 feb 23 19:49 htaccess_users.frm
- 12 -rw-rw---- 1 mysql mysql 8626 feb 23 19:49 httpd_vlogger.frm
- 12 -rw-rw---- 1 mysql mysql 8646 feb 23 19:49 log.frm
- 12 -rw-rw---- 1 mysql mysql 8780 feb 23 19:49 login.frm
- 12 -rw-rw---- 1 mysql mysql 9032 feb 23 19:49 mail_users.frm
- 12 -rw-rw---- 1 mysql mysql 8864 feb 23 19:49 opendkim.frm
- 12 -rw-rw---- 1 mysql mysql 9068 feb 23 19:49 php_ini.frm
- 12 -rw-rw---- 1 mysql mysql 8894 feb 23 19:49 plugin.frm
- 12 -rw-rw---- 1 mysql mysql 9048 feb 23 19:49 quotalimits.frm
- 12 -rw-rw---- 1 mysql mysql 8925 feb 23 19:49 quotatallies.frm
- 12 -rw-rw---- 1 mysql mysql 10561 feb 23 19:49 reseller_props.frm
- 12 -rw-rw---- 1 mysql mysql 8678 feb 23 19:49 server_ips.frm
- 12 -rw-rw---- 1 mysql mysql 8976 feb 23 19:49 server_traffic.frm
- 12 -rw-rw---- 1 mysql mysql 8646 feb 23 19:49 sql_database.frm
- 12 -rw-rw---- 1 mysql mysql 8682 feb 23 19:49 sql_user.frm
- 12 -rw-rw---- 1 mysql mysql 8809 feb 23 19:49 ssl_certs.frm
- 12 -rw-rw---- 1 mysql mysql 8894 feb 23 19:49 subdomain_alias.frm
- 12 -rw-rw---- 1 mysql mysql 8836 feb 23 19:49 subdomain.frm
- 12 -rw-rw---- 1 mysql mysql 8988 feb 23 19:49 tickets.frm
- 12 -rw-rw---- 1 mysql mysql 8770 feb 23 19:49 user_gui_props.frm
- 12 -rw-rw---- 1 mysql mysql 9080 feb 23 19:49 web_software_depot.frm
- 12 -rw-rw---- 1 mysql mysql 9454 feb 23 19:49 web_software.frm
- 12 -rw-rw---- 1 mysql mysql 9542 feb 23 19:49 web_software_inst.frm
- 12 -rw-rw---- 1 mysql mysql 8692 feb 23 19:49 web_software_options.frm
why to me??????
