Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2024-03-28, 10:57:34

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.


Messages - dfreddie

Pages: [1] 2 3 ... 7
1
Kloxo-MR Technical Helps / Letsencrypt error
« on: 2019-11-15, 14:24:32 »
For some users and some domains I can add Letsencrypt SSL.
But for many cases I get:
Fatal error: Call to a member function isOn() on null in /usr/local/lxlabs/kloxo/httpdocs/lib/domain/domainlib.php on line 1367

2
I've added but is the same. Mysql starts delayed and that for (I think) web server have to be restart for avoiding error 500.


3
cat /etc/my.cnf.d/server.cnf
#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#

# this is read by the standalone daemon and embedded servers
[server]

# this is only for the mysqld standalone daemon
[mysqld]
performance-schema=on
default-storage-engine=myisam
skip-innodb
#OpenVZ AIO bug fix
innodb-use-native-aio=0

# this is only for embedded server
[embedded]

# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]

# This group is only read by MariaDB-10.0 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.0]

4
Try reboot and then check with 'pgrep' a couple of times.
It starts delayed!
But my webpages shows Error 500 - Internal Server Error!

5
Look like mysql running in your vps from 'pgrep' and 'ps aux' information.
Yes becouse I've started it with "sh /script/restart-mysql" command after server booted.

With fresh restart:
pgrep mysql -a - no output
ps aux|grep -i mysql|grep -v grep - no output

6
pgrep mysql -a
4301 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/xxx.pid
4380 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/xxx.err --pid-file=/var/lib/mysql/xxx.pid


ps aux|grep -i mysql|grep -v grep
root      4301  0.0  0.0  11816  1604 pts/0    S    19:02   0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/xxx.pid
mysql     4380  0.3  1.5 1288988 188228 pts/0  Sl   19:02   0:18 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/xxx.err --pid-file=/var/lib/mysql/xxx.pid

7
 chkconfig --list|grep -i mysql|grep -v grep

Note: This output shows SysV services only and does not include native
      systemd services. SysV configuration data might be overridden by native
      systemd configuration.

      If you want to list systemd services use 'systemctl list-unit-files'.
      To see services enabled on particular target use
      'systemctl list-dependencies [target]'.

mysql             0:off   1:off   2:on   3:on   4:on   5:on   6:off

systemctl list-unit-files|grep mysql
shows no output

8
... but after restart ... I have again to restart manually mysql with: sh /script/restart-mysql
  :( :( :-[

9
Did you tried 'sh /script/reset-mysql-root-password YOURNEWPASSWORD'?
After that seems everything is ok!  ;D
Thanks a lot!!

10
Nothing wrong with restart process. MariaDB also restart mysqld_safe together with their main service.

Nope, it's all wrong! MariaDB is not started at boot as I showed! Moreover can't login in mysql as root: Access denied for user 'root'@'localhost' using password="yes"!

11
At new, reboot server:
systemctl status mysql -l
mysql.service - LSB: start and stop MariaDB
   Loaded: loaded (/etc/rc.d/init.d/mysql; bad; vendor preset: disabled)
   Active: inactive (dead)
     Docs: man:systemd-sysv-generator(8)

After:
sh /script/restart-mysql
I have:
*** Process for MYSQL/MARIADB service ***
Starting MariaDB.190904 13:46:30 mysqld_safe Logging to '/var/lib/mysql/xxx.err'.
190904 13:46:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
                                                           [  OK  ]
  - Process: restart
Shutting down MariaDB                                      [  OK  ]
Starting MariaDB.190904 13:46:32 mysqld_safe Logging to '/var/lib/mysql/xxx.err'.
190904 13:46:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
 
                                                         [  OK  ]
then I have to restart web and php:
sh /script/fixphp; sh /script/restart-web -y

I have:
systemctl status mysql -l
mysql.service - LSB: start and stop MariaDB
   Loaded: loaded (/etc/rc.d/init.d/mysql; bad; vendor preset: disabled)
   Active: active (exited) since Wed 2019-09-04 12:39:14 EEST; 41min ago
     Docs: man:systemd-sysv-generator(8)
  Process: 12256 ExecStart=/etc/rc.d/init.d/mysql start (code=exited, status=0/SUCCESS)
systemd[1]: Starting LSB: start and stop MariaDB...
mysql[12256]: Starting MariaDB[  OK  ]
systemd[1]: Started LSB: start and stop MariaDB.
mysql[12256]: 190904 12:39:14 mysqld_safe Logging to '/var/lib/mysql/xxx.err
mysql[12256]: 190904 12:39:14 mysqld_safe A mysqld process already exists

12
It seems that after make some space on disk now is starting ...

After restart ... same error!! Something is wrong! Mariadb not starting at boot.
I have to manually start it with "sh /script/restart-mysql".

13
Same situation here...
Any progress on it??
Thx!!

14
Still error at
http://cp.domain.com/tht
"The following function is needed for TheHostingTool to run properly:MySQL"

15
Right now is not even starting with "/usr/sbin/pure-uploadscript -B -r /etc/pure-ftpd/pure-ftpd.conf" trick!!! >:( >:(

Pages: [1] 2 3 ... 7

Top 10 Social Networking:    Facebook    Twitter    LinkedIn    Pinterest    Google Plus    Tumblr    Instagram    VK    Flickr    Vine
Click Here

Page created in 0.048 seconds with 20 queries.

web stats analysis