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 - srisree

Pages: 1 [2]
16
MySQL / Re: error after mariadb upgrade
« on: September 03, 2020, 03:55:44 PM »
problem solved after upgrading mariadb from 10.2 to 10.4 by  following

https://www.mysterydata.com/update-upgrade-to-mariadb-10-4-on-vestacp-cwp-centos-7/


thanks mysterydata

17
MySQL / Re: error after mariadb upgrade
« on: August 31, 2020, 06:44:05 AM »
i am getting this message

[root@vps ~]# cd /var/lib/mysql/
[root@vps mysql]# mv ib_logfile0 ib_logfile0_OLD
mv: cannot stat ‘ib_logfile0’: No such file or directory
[root@vps mysql]# mv ib_logfile1 ib_logfile1_OLD
mv: cannot stat ‘ib_logfile1’: No such file or directory
[root@vps mysql]# systemctl restart mariadb

** (pkttyagent:9569): WARNING **: 11:47:46.380: Unable to register authentication agent: GDBus.Error:org.freedesktop.PolicyKit1.Error.Failed: Cannot determine user of subject
Error registering authentication agent: GDBus.Error:org.freedesktop.PolicyKit1.Error.Failed: Cannot determine user of subject (polkit-error-quark, 0)


18
Information / how to reinstall cwp pro?
« on: August 28, 2020, 03:33:03 PM »
how to reinstall cwp pro without loosing data

or

upgraded mariadb from 10.1 to 10.2.

websites working but in dashboard showing mysql failed


how to downgrade and reinstall mysql/mariadb without loosing data

regards

19
MySQL / error after mariadb upgrade
« on: August 25, 2020, 06:16:09 AM »
after successfull upgrade of mariadb 10.1 to 10.2

recived the following security updates


MariaDB-common.x86_64    10.2.33-1.el7.centos    mariadb    
MariaDB-devel.x86_64    10.2.33-1.el7.centos    mariadb    
MariaDB-shared.x86_64    10.2.33-1.el7.centos    mariadb


when i clicked update all

the above updates are updated .

but mysql database server stopped

when i click start its not started still showing failed


websites are not opening

when i click report issue

message displayed that     
Hi, I'm AI-Robot, I will try to recover your mariadb service.
Service Recovered! I have managed to recover your mariadb service !

Ohh I'm improving myself, soon I will be able to take a full control on all your server services.


now websites are working

but

showing in server services that mysql database server  FAILED


regards

logs

Aug 25 12:02:40 vps.familymeet.in mysqld[10073]: 2020-08-25 12:02:40 140626898647232 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/
Aug 25 12:02:40 vps.familymeet.in mysqld[10073]: 2020-08-25 12:02:40 140626898647232 [ERROR] InnoDB: Cannot open datafile './ibdata1'
Aug 25 12:02:40 vps.familymeet.in mysqld[10073]: 2020-08-25 12:02:40 140626898647232 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
Aug 25 12:02:40 vps.familymeet.in mysqld[10073]: 2020-08-25 12:02:40 140626898647232 [ERROR] InnoDB: Plugin initialization aborted with error Cannot open a file
Aug 25 12:02:40 vps.familymeet.in mysqld[10073]: 2020-08-25 12:02:40 140626898647232 [Note] InnoDB: Starting shutdown...
Aug 25 12:02:40 vps.familymeet.in mysqld[10073]: 2020-08-25 12:02:40 140626898647232 [ERROR] Plugin 'InnoDB' init function returned error.
Aug 25 12:02:40 vps.familymeet.in mysqld[10073]: 2020-08-25 12:02:40 140626898647232 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Aug 25 12:02:40 vps.familymeet.in mysqld[10073]: 2020-08-25 12:02:40 140626898647232 [ERROR] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
Aug 25 12:02:42 vps.familymeet.in kernel: Firewall: *TCP_IN Blocked* IN=eth0 OUT= MAC=f2:3c:92:b9:79:0a:1a:12:1c:98:45:62:08:00 SRC=193.27.228.172 DST=172.105.42.63 LEN=40 TOS=0x00 PREC=0x00 TTL=241 ID=28387 PROTO=TCP SPT=50601 DPT=12624 WINDOW=1024 RES=0x00 SYN URGP=0
Aug 25 12:03:02 vps.familymeet.in kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=f2:3c:92:b9:79:0a:1a:12:1c:98:45:62:08:00 SRC=80.82.77.212 DST=172.105.42.63 LEN=1500 TOS=0x00 PREC=0x00 TTL=240 ID=54321 PROTO=UDP SPT=51012 DPT=1701 LEN=1480
Aug 25 12:03:05 vps.familymeet.in kernel: Firewall: *TCP_IN Blocked* IN=eth0 OUT= MAC=f2:3c:92:b9:79:0a:1a:12:1c:98:45:62:08:00 SRC=195.54.167.93 DST=172.105.42.63 LEN=40 TOS=0x00 PREC=0x00 TTL=241 ID=6073 PROTO=TCP SPT=54729 DPT=50286 WINDOW=1024 RES=0x00 SYN URGP=0
Aug 25 12:03:11 vps.familymeet.in mysqld[10073]: 2020-08-25 12:03:11 140626898647232 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/var/lib/mysql/aria_log_control'
Aug 25 12:03:11 vps.familymeet.in mysqld[10073]: 2020-08-25 12:03:11 140626898647232 [ERROR] Plugin 'Aria' init function returned error.
Aug 25 12:03:11 vps.familymeet.in mysqld[10073]: 2020-08-25 12:03:11 140626898647232 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
Aug 25 12:03:11 vps.familymeet.in mysqld[10073]: 2020-08-25 12:03:11 140626898647232 [Note] Plugin 'FEEDBACK' is disabled.
Aug 25 12:03:11 vps.familymeet.in mysqld[10073]: 2020-08-25 12:03:11 140626898647232 [ERROR] Unknown/unsupported storage engine: InnoDB
Aug 25 12:03:11 vps.familymeet.in mysqld[10073]: 2020-08-25 12:03:11 140626898647232 [ERROR] Aborting
Aug 25 12:03:11 vps.familymeet.in systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Aug 25 12:03:11 vps.familymeet.in mysqld[10073]: Warning: Memory not freed: 520
Aug 25 12:03:11 vps.familymeet.in systemd[1]: Failed to start MariaDB 10.2.33 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Aug 25 12:03:11 vps.familymeet.in systemd[1]: Unit mariadb.service entered failed state.
Aug 25 12:03:11 vps.familymeet.in systemd[1]: mariadb.service failed.
Aug 25 12:03:17 vps.familymeet.in kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=f2:3c:92:b9:79:0a:1a:12:1c:98:45:62:08:00 SRC=89.248.168.17 DST=172.105.42.63 LEN=220 TOS=0x00 PREC=0x00 TTL=241 ID=54321 PROTO=UDP SPT=37998 DPT=123 LEN=200
Aug 25 12:03:20 vps.familymeet.in kernel: Firewall: *TCP_IN Blocked* IN=eth0 OUT= MAC=f2:3c:92:b9:79:0a:1a:12:1c:98:45:62:08:00 SRC=185.176.27.238 DST=172.105.42.63 LEN=40 TOS=0x00 PREC=0x00 TTL=246 ID=33910 PROTO=TCP SPT=40996 DPT=35456 WINDOW=1024 RES=0x00 SYN URGP=0


20
Information / about elasticsearch
« on: August 25, 2020, 04:30:24 AM »
i did not found any information in cwp forums about installing of elastic search

so i searched and found one article about how to install elasticsearch on centos7

https://computingforgeeks.com/how-to-install-elasticsearch-on-centos/


can i follow that article please guide me

or if any other best  tutorial please share link

21
MySQL / Re: error while upgrading mariadb
« on: August 24, 2020, 11:21:40 AM »
thank you

upgraded without error


22
MySQL / Re: error while upgrading mariadb
« on: August 24, 2020, 03:16:44 AM »
i tried to stop mariadb for upgrade

https://www.systemmen.com/web-server/vestacp/how-to-update-vestacp-to-mariadb-10-3-285.html

displayed  following error

[root@vps ~]# service mariadb stop
Redirecting to /bin/systemctl stop mariadb.service

** (pkttyagent:559): WARNING **: 03:12:38.769: Unable to register authentication agent: GDBus.Error:org.freedesktop.PolicyKit1.Error.Failed: Cannot determine user of subject
Error registering authentication agent: GDBus.Error:org.freedesktop.PolicyKit1.Error.Failed: Cannot determine user of subject (polkit-error-quark, 0)
[root@vps ~]# sudo yum update mysql-server

23
MySQL / Re: error while upgrading mariadb
« on: August 23, 2020, 04:28:31 PM »
hello can you guide me how to do that


i followed this url

https://www.mysterydata.com/upgrade-mariadb-5-5-to-mariadb-10-2-on-centos-7-vesta-cp/

unable to remove old version


thanks

24
MySQL / error while upgrading mariadb
« on: August 23, 2020, 07:21:13 AM »


upgraded mariadb with the following instructions which i found from this forum

https://www.mysterydata.com/upgrade-mariadb-5-5-to-mariadb-10-2-on-centos-7-vesta-cp/


and later i found update CWP i clicked update all

after download and update

CWP displayed following message and showing failed

please guide me what to do



Resolving Dependencies
--> Running transaction check
---> Package MariaDB-server.x86_64 0:10.1.46-1.el7.centos will be updated
---> Package MariaDB-server.x86_64 0:10.2.33-1.el7.centos will be an update
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package             Arch        Version                     Repository    Size
================================================================================
Updating:
 MariaDB-server      x86_64      10.2.33-1.el7.centos        mariadb       24 M

Transaction Summary
================================================================================
Upgrade  1 Package

Total size: 24 M
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction

******************************************************************
A MySQL or MariaDB server package (MariaDB-server-10.1.46-1.el7.centos.x86_64) is installed.

Upgrading directly from MySQL 10.1 to MariaDB 10.2 may not
be safe in all cases.  A manual dump and restore using mysqldump is
recommended.  It is important to review the MariaDB manual's Upgrading
section for version-specific incompatibilities.

A manual upgrade is required.

- Ensure that you have a complete, working backup of your data and my.cnf
  files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages.  Usually this command will
  list the packages you should remove:
  rpm -qa | grep -i '^mysql-'

  You may choose to use 'rpm --nodeps -ev ' to remove
  the package which contains the mysqlclient shared library.  The
  library will be reinstalled by the MariaDB-shared package.
- Install the new MariaDB packages supplied by MariaDB Foundation
- Ensure that the MariaDB server is started
- Run the 'mysql_upgrade' program

This is a brief description of the upgrade process.  Important details
can be found in the MariaDB manual, in the Upgrading section.
******************************************************************
error: %pre(MariaDB-server-10.2.33-1.el7.centos.x86_64) scriptlet failed, exit status 1
  Verifying  : MariaDB-server-10.2.33-1.el7.centos.x86_64                   1/2
  Verifying  : MariaDB-server-10.1.46-1.el7.centos.x86_64                   2/2

Failed:
  MariaDB-server.x86_64 0:10.1.46-1.el7.centos                                 
  MariaDB-server.x86_64 0:10.2.33-1.el7.centos                                 

Complete!



and in dashboard showing the following

Apache version: Apache/2.4.39
PHP version: 7.4.9
MySQL version: 10.2.33-MariaDB
FTP version: 1.0.47
SSH Port: 22
MySql Port: 3306
Web Servers: apache-only



from putty   mysql-v

its showing
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 32801
Server version: 10.1.46-MariaDB MariaDB Server

25
DNS / Re: need help
« on: May 29, 2020, 05:02:24 PM »
at the time of creating user account searchmatch.online i did not checked for ssl. later i updated ssl from webserver settings / ssl certificates for the domain and restarted web server.

after ssl page loading is very slow

and it nearly take 20 minutes to load CWP User Panel Link

i am using same domain for centos webpanel hostname and website is it problem?

any suggestions plz

regards


26
DNS / Re: need help
« on: May 29, 2020, 10:06:42 AM »
Thank you sandeep

Thanks for your help

It worked.

regards

27
DNS / need help
« on: May 29, 2020, 05:43:23 AM »
i have succesfully installed centOS webpanel with linode.

and updated to cwp pro without any trouble.

i have changed host name to server.searchmatch.online

the following waqs displayed

Your Hostname is: server.searchmatch.online and it resolves to IP: (ERROR: You don't have a valid hostname set!)
rDNS/PTR = FAILED, check with your hosting provider! FAILED


later

i have edited namesrvers

name server 1  - ns1.searchmatch.online - 172.105.57.65 ( ip4 address)
name server 2  - ns2.searchmatch.online - 172.105.57.65 ( ip4 address)

checked update dns zone file
checked restar DNS server

and saved.

and created user account with searchmatch.online

and it diplayed
user id
password
name servers as follows
ns1.searchmatch.online
ns2.searchmatch.online


next
my domain registered through hostinger.in

and i logged in to hostinger.in to update nameservers of searchmatch.online


and changed NS records to my domain.com as follows

ns1.searchmatch.online
ns2.searchmatch.online


but hostinger.in displayed a message that

error occured while updating name servers.{ ns1= name server ns1.searchmatch.online is not a valid nam server  ns2= name server ns2.searchmatch.online is not a valid name server}



what i am doing wrong please need help
regards


Pages: 1 [2]