ISPconfing 3 - stopped after server restart

Discussion in 'General' started by itstudio7777, Mar 23, 2022.

Page 2 of 3
  1. Jesse Norell

    Jesse Norell Well-Known Member Staff Member Howtoforge Staff

    ISPConfig doesn't "start" because it's not a service; your logs show that something is failing to login to mysql as 'ispconfig', which could be any number of services/scripts. You might test that both the 'ispconfig' and 'root' user can login to mysql (passwords are in /usr/local/ispconfig/server/{config.inc.php,mysql_clientdb.conf}). Does mysqld now stop/start with no errors?

    How recent is your last good backup?
     
    Jesse Norell, Mar 24, 2022
    #21
  2. itstudio7777

    itstudio7777 Member

    I don't have files config.inc.php and clientdb.conf in /usr/local/ispconfig/server/.

    mysqld don't start, I have this error :

    Code:
    -- The job identifier is 11233 and the job result is failed.
Mar 24 00:06:11 server1 rkhunter[31590]: Rootkit hunter check started (version 1.4.6)
Mar 24 00:06:13 server1 systemd[1]: mariadb.service: Service RestartSec=5s expired, scheduling restart.
Mar 24 00:06:13 server1 systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 73.
    I have 2 backups, already have used them but problems are the same.
     
    itstudio7777, Mar 24, 2022
    #22
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    Jesse meant the path /usr/local/ispconfig/server/lib/{config.inc.php,mysql_clientdb.conf}
     
    till, Mar 24, 2022
    #23
    Jesse Norell likes this.
  4. concept21

    concept21 Active Member

    If I were you, I would upgrade the VPS to one with more resource.
     
    concept21, Mar 24, 2022
    #24
  5. itstudio7777

    itstudio7777 Member

    Now It's working, but when I start MySQL (MariaDB) my server is overloading from MySQL (I don't have users online at moment of testing).

    I have 4 CPU Cores and 6 GB RAM but my VPS is overloading.
    What to do and how to tune MySQL to not overloading?
    What to upgrade RAM or CPU ?
     
    itstudio7777, Mar 24, 2022
    #25
  6. Jesse Norell

    Jesse Norell Well-Known Member Staff Member Howtoforge Staff

    6G is generally pretty usable, you probably just need to tune mysql, though you can always add more ram (check if you're using all ram and swapping or not). Take a look at https://github.com/major/MySQLTuner-perl
     
    Jesse Norell, Mar 24, 2022
    #26
  7. itstudio7777

    itstudio7777 Member

    Thank you !

    I have another one problem :
    I can't login to my ISPconfig admin - when I type user and password, page only refreshes but not loading the panel.

    I have problem also with website/wp-admin , it's not loading the wordpress admin zone.
    Where can be the problems?
     
    itstudio7777, Mar 24, 2022
    #27
  8. Jesse Norell

    Jesse Norell Well-Known Member Staff Member Howtoforge Staff

    Things that are common and potential/likely source of problems are the database, the filesystem, resource exhaustion (eg. memory, or maybe cpu), and maybe the web server or php daemon. Check system resource usage (especially ram and cpu), and check your log files to see what errors/warnings might be showing up.
     
    Jesse Norell, Mar 24, 2022
    #28
  9. itstudio7777

    itstudio7777 Member

    Usage is too high for cpu and for ram
    Code:
    10359 mysql     20   0 2744992 262616   6188 S 125.5   4.3   1:22.11 mysqld
    125.5 - too high , but I don't know how to use the tuner, which you send me to check.
     
    itstudio7777, Mar 24, 2022
    #29
  10. itstudio7777

    itstudio7777 Member

    update: I have stopped ALL websites from this server and the usage is again overloaded.

    What do you think about this: from phpmyadmin I will export all databases and will delete MySQL from the server, after that I will make new databases and will import ?

    Also, I can't login into ISPConfig - password and user are right but I it don't loading, only refresh the page
     
    itstudio7777, Mar 24, 2022
    #30
  11. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    Find out what's overloading it. I highly doubt it's the sites or the database.

    Also, exporting everything through phpMyAdmin and re-importing it is not a good idea - do you know what you're doing?
     
    Th0m, Mar 24, 2022
    #31
  12. itstudio7777

    itstudio7777 Member

    according the information from 'top' mysql is overloading the vps.
    According the log, vps is overkilling the process because of out of memory.

    I really don't know how to repair it, sorry for my stupid questions, I just want to have working server again
     
    itstudio7777, Mar 24, 2022
    #32
  13. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    How much memory does that host have?
    What show commands (paste in CODE tags):
    Code:
    free -h
uptime
df -hT
     
    Taleman, Mar 24, 2022
    #33
  14. till

    till Super Moderator Staff Member ISPConfig Developer

    That should be more than enough if the system is without load. Everything above 2GB RAM is generally fine for a lightly loaded system.
     
    till, Mar 24, 2022
    #34
  15. concept21

    concept21 Active Member

    It usually packs with examples in its distribution. Check for the examples.
     
    concept21, Mar 24, 2022
    #35
  16. itstudio7777

    itstudio7777 Member

    free -h : 5.86gb , used 5.46, free: 114mb
    Swap free is 1.1gb from 2.0gb

    Uptime: 1:17
    df -ht —t: no file system processed
     
    itstudio7777, Mar 24, 2022
    #36
  17. concept21

    concept21 Active Member

    Mine has 4GB with a very heavy php framework. Its Nginx sometimes is overloaded.

    So it depends on your particular usage.
     
    concept21, Mar 24, 2022
    #37
  18. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    You forgot the CODE tags.
    It is df -hT, not lower case t.
    That can not be the full output of uptime command.
    If you have out of memory errors, increase swap size. Find out which processes eat the memory.
     
    Taleman, Mar 24, 2022
    #38
  19. concept21

    concept21 Active Member

    1GB Swap disk is filled! RAM is not enough!
     
    concept21, Mar 24, 2022
    #39
  20. itstudio7777

    itstudio7777 Member

    I’m using it for some Wordpress websites with no heavy traffic.
    It was working perfect without overloading but 2 days ago it was overloaded and I just restarted it. After this restart I have problems
     
    itstudio7777, Mar 24, 2022
    #40
Page 2 of 3

Share This Page