ispCP - Board - Support
Change ip don't working - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: Change ip don't working (/thread-11153.html)



Change ip don't working - sfera - 07-09-2010 11:52 PM

Hi i try change the ip using the how to in debian 5 but i have a error
Code:
ServerWeb:/var/www/virtual# /etc/init.d/ispcp_daemon stop
Stopping ispCP GUI-Backend communication Daemon: ispcp_daemon.
ServerWeb:/var/www/virtual# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 66
Server version: 5.0.51a-24+lenny4 (Debian)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> USE ispcp;
Database changed
mysql> UPDATE server_ips SET ip_number = "87.98.230.131" WHERE ip_id = 1;
Query OK, 0 rows affected (0.05 sec)
Rows matched: 1  Changed: 0  Warnings: 0

mysql> UPDATE `domain` SET `domain_status` = 'change' WHERE `domain_status` = 'ok';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> UPDATE `subdomain` SET `subdomain_status` = 'change' WHERE `subdomain_status` = 'ok';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> UPDATE `domain_aliasses` SET `alias_status` = 'change' WHERE `alias_status` = 'ok';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> UPDATE mail_users SET status="toadd" where status="ok";
ERROR 1017 (HY000): Can't find file: './ispcp/mail_users.frm' (errno: 13)
mysql> quit
Bye
ServerWeb:/var/www/virtual# /var/www/ispcp/engine/ispcp-rqst-mngr
DEBUG: push_el() sub_name: mngr_start_up(), msg: Starting...
DEBUG: push_el() sub_name: lock_system(), msg: Starting...
DEBUG: push_el() sub_name: lock_system(), msg: Ending...
DEBUG: push_el() sub_name: get_conf(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Ending...
DEBUG: push_el() sub_name: setup_main_vars(), msg: Starting...
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Starting...
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Ending...
DEBUG: push_el() sub_name: setup_main_vars(), msg: Ending...
DEBUG: push_el() sub_name: get_conf(), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: mngr_start_up(), msg: Ending...
DEBUG: push_el() sub_name: mngr_engine(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: ERROR: Incorrect SQL Query -> Can't find file: './ispcp/mail_users.frm' (errno: 13)
Can't use string ("") as an ARRAY ref while "strict refs" in use at /var/www/ispcp/engine/ispcp-rqst-mngr line 183.

Any idea?

ÇThx in advanced.


RE: Change ip don't working - BeNe - 07-11-2010 06:39 PM

Quote:Can't find file: './ispcp/mail_users.frm'
Seems to me that you DB is corrupt.
Please check the health with the MySQL DB tools and try it again after that.

Greez BeNe