Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - molmi

Pages: [1]
1
CentOS 6 Problems / Can't connect with root in SSH
« on: July 10, 2021, 12:39:10 AM »
Hi
Since yesterday i cannot SSH connect with root ( 20s timed out), even if i change my IP adresse. regular ftp works well for accounts not the root.
and when When i try to connect to cwp panel to disable the firewall i have this error: No Loader is installed, please try to run this command or contact support: sh /scripts/update_ioncube restart.
So i have no control at all on my server at this moment, and thats very sad.
Any help to disable that shitty firewall in my situation ? my server provider can offer a netboot acces to my server with another linux distro.
Thanks for help

2
MySQL / MySql auto shutdown at night
« on: August 03, 2016, 10:31:05 AM »
Hello,

Until Sunday last everything works very well. In the 1st of August a big backup eat all my root's partition space what stops mysql from working. I deleted that backup and restart mysql, then everything works fine again.

BUT..
when i woke up the next day, i find that all websites have an mysql connexion error, i connected to do CWP admin to see what happen, than i had this message on the index :

Quote
mysqld (pid 16175) is running...

Trying to start mysql server, please reload browser!

Could not connect: No such file or directory

I reload the page, and the CWP works fine (and all other website by the way), just by refreshing the CWP index it seems that there is no Mysql error anymore.
I open the log file to see what happen and i noticed that in 4H00 am, the mysql was shutted down and it start again on the exact time when i reloead my CWP index page.

I ignored this probleme hopping that will not happen again, but the day after the same thing happen, mysql shutting down at late night, and when connecting to CWP everything works fine after realoding this page, the only difference was the time when Mysql was Shutdown, it was 03h11AM and not 04H00AM (so i don't think it's a cron).

I added today this line to the crontab file as a mini solution : checking mysql service every 15min, and start it if it's down, and i hope it will fix temporary this problem, until i find the real cause and solve it.
Code: [Select]
*/15 * * * * /sbin/service mysqld status || service mysqld start
The server is a good machine, an 8 core xeon with 32gb of ram, and there is only 3 websites in. The estimated traffic for the 3 website is 20k/25k visitor per day, and we use cache. i don't think at all that the server is over 20% charge all the day.

this is the log file, i hope someone can help me, because the server is a production one:

Code: [Select]
2016-08-02 20:30:01 4361 [Warning] IP address '123.249.45.132' could not be resolved: Name or service not known
2016-08-03 00:13:21 4361 [Warning] IP address '210.212.98.235' could not be resolved: Name or service not known
2016-08-03 00:17:13 4361 [Warning] IP address '114.112.1.117' could not be resolved: Name or service not known
2016-08-03 03:11:01 4361 [Note] /usr/sbin/mysqld: Normal shutdown

2016-08-03 03:11:01 4361 [Note] Giving 1 client threads a chance to die gracefully
2016-08-03 03:11:01 4361 [Note] Event Scheduler: Purging the queue. 0 events
2016-08-03 03:11:01 4361 [Note] Shutting down slave threads
160803 03:11:02 mysqld_safe A mysqld process already exists
2016-08-03 03:11:03 4361 [Note] Forcefully disconnecting 0 remaining clients
2016-08-03 03:11:03 4361 [Note] Binlog end
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'partition'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'ARCHIVE'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_METRICS'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_CMP'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'INNODB_TRX'
2016-08-03 03:11:03 4361 [Note] Shutting down plugin 'InnoDB'
2016-08-03 03:11:03 4361 [Note] InnoDB: FTS optimize thread exiting.
2016-08-03 03:11:03 4361 [Note] InnoDB: Starting shutdown...
2016-08-03 03:11:04 4361 [Note] InnoDB: Shutdown completed; log sequence number 919189441
2016-08-03 03:11:04 4361 [Note] Shutting down plugin 'BLACKHOLE'
2016-08-03 03:11:04 4361 [Note] Shutting down plugin 'CSV'
2016-08-03 03:11:04 4361 [Note] Shutting down plugin 'MyISAM'
2016-08-03 03:11:04 4361 [Note] Shutting down plugin 'MEMORY'
2016-08-03 03:11:04 4361 [Note] Shutting down plugin 'MRG_MYISAM'
2016-08-03 03:11:04 4361 [Note] Shutting down plugin 'sha256_password'
2016-08-03 03:11:04 4361 [Note] Shutting down plugin 'mysql_old_password'
2016-08-03 03:11:04 4361 [Note] Shutting down plugin 'mysql_native_password'
2016-08-03 03:11:04 4361 [Note] Shutting down plugin 'binlog'
2016-08-03 03:11:04 4361 [Note] /usr/sbin/mysqld: Shutdown complete

160803 03:11:05 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

Pages: [1]