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-29, 06:27:02

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

Pages: [1] 2 3 ... 7
1
I clearly stated that MySQL is crashed because a malicious hacker attacked the vps. As the developer of KloxoMR, do you have any solution on fixing the problem?

2
Still not working. Any solution?

3
There is no problem with phpmyadmin. The problem is that in phpmyadmin, when I click on a database table, I get the following error message:

"1286 Unknown storage engine InnoDB".

You said to switch from innodb to myisam and when I did the problem still existed. There's a conflict with innodb and myisam. I asked you to switch back to innodb but you said the server already loaded myisam.

Please help me get the database tables working again.

4
yum list installed kloxomr*
Loaded plugins: fastestmirror, priorities, protectbase, replace
Loading mirror speeds from cached hostfile
 * base: mirror.rackspace.com
 * extras: mirror.rackspace.com
 * mratwork-epel: mirror.steadfast.net
 * mratwork-ius-stable: dl.iuscommunity.org
 * updates: centos.chi.host-engine.com
0 packages excluded due to repository protections
Installed Packages
kloxomr.noarch                                                 6.5.0.f-2014040701.mr                        @mratwork-release-neutral-noarch
kloxomr-addon-extjs.noarch                                     1.1-4.mr                                     @mratwork-release-neutral-noarch
kloxomr-addon-yui-dragdrop.noarch                              2.9.0-3.mr                                   @mratwork-release-neutral-noarch
kloxomr-editor-fckeditor.noarch                                2.6.8-8.mr                                   @mratwork-release-neutral-noarch
kloxomr-stats-awstats.noarch                                   7.1-4.mr                                     @mratwork-release-neutral-noarch
kloxomr-thirdparty-jcterm.noarch                               0.0.10-2.mr                                  @mratwork-release-neutral-noarch
kloxomr-thirdparty-phpmyadmin.noarch                           4.0.10-1.mr                                  @mratwork-release-neutral-noarch
kloxomr-thirdparty-sshterm-applet.noarch                       0.2.2-4.mr                                   @mratwork-release-neutral-noarch
kloxomr-webmail-afterlogic.noarch                              7.4.0.7-2.mr                                 @mratwork-release-neutral-noarch
kloxomr-webmail-rainloop.noarch                                1.6.9.164-1.mr                               @mratwork-release-neutral-noarch
kloxomr-webmail-roundcube.noarch                               1.0.3-1.mr                                   @mratwork-release-neutral-noarch
kloxomr-webmail-squirrelmail.noarch                            1.4.22-6.mr                                  @mratwork-release-neutral-noarch
kloxomr-webmail-telaen.noarch                                  1.3.2-2.mr                                   @mratwork-release-neutral-noarch

5
Yes, I did but in phpmyadmin the tables are still not working. Earlier I mentioned that in phpmyadmin, when I click on a database table, I get the following error message:

"1286 Unknown storage engine InnoDB".

6
Still not working.

service nginx restart
Stopping nginx:                                            [  OK  ]
Starting nginx:                                            [  OK  ]
[root@~]# service mysqld restart
Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                           [  OK  ]
[root@~]# mysql -u root -p
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 19
Server version: 5.5.40 Distributed by The IUS Community Project

Copyright (coffee) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show engines;
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                        | Transactions | XA   | Savepoints |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
| CSV                | YES     | CSV storage engine                                             | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
| MyISAM             | DEFAULT | MyISAM storage engine                                          | NO           | NO   | NO         |
| FEDERATED          | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |
| ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   | NO         |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO         |
| InnoDB             | NO      | Supports transactions, row-level locking, and foreign keys     | NULL         | NULL | NULL       |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
9 rows in set (0.00 sec)

7
No, still using 6.5 -- see sys info on 1st post. And I've been unable to update because of mysql crash.

8
sh /script/mysql-convert --engine=myisam
/script/mysql-convert: line 42: lxphp.exe: command not found

How do I switch back to innodb? myisam has lots of problems.

9
Ran the command but nothing happened. Should I restart the server? How do I switch back to innodb? What should I do to get mysql working and the sites live?

mysql> show engines;
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                        | Transactions | XA   | Savepoints |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
| CSV                | YES     | CSV storage engine                                             | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
| MyISAM             | DEFAULT | MyISAM storage engine                                          | NO           | NO   | NO         |
| FEDERATED          | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |
| ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   | NO         |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO         |
| InnoDB             | NO      | Supports transactions, row-level locking, and foreign keys     | NULL         | NULL | NULL       |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+

10
Log below. What is my next step? Restart server? And how do I switch back to innodb?

yum replace mysql --replace-with=mysql55
Loaded plugins: fastestmirror, priorities, protectbase, replace
Loading mirror speeds from cached hostfile
 * base: mirror.rackspace.com
 * extras: mirror.cs.uwp.edu
 * mratwork-epel: mirror.steadfast.net
 * mratwork-ius-stable: dl.iuscommunity.org
 * updates: centos.chi.host-engine.com
0 packages excluded due to repository protections
Replacing packages takes time, please be patient...

WARNING: Unable to resolve all providers: ['libmysqlclient.so.18(libmysqlclient_18)(64bit)', 'mysql-libs(x86-64)', 'mysql-client', 'mysql(x86-64)', 'libpinba_engine.so.0()(64bit)', 'mysql-server(x86-64)']

This may be normal depending on the package.  Continue? [y/N] y
Resolving Dependencies
--> Running transaction check
---> Package mysql.x86_64 0:5.5.34-1.el6 will be erased
---> Package mysql-libs.x86_64 0:5.5.34-1.el6 will be erased
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: php52s-5.2.17-11.mr.el6.x86_64
---> Package mysql-server.x86_64 0:5.5.34-1.el6 will be erased
---> Package mysql55.x86_64 0:5.5.40-1.ius.el6 will be installed
---> Package mysql55-libs.x86_64 0:5.5.40-1.ius.el6 will be installed
---> Package mysql55-server.x86_64 0:5.5.40-1.ius.el6 will be installed
--> Running transaction check
---> Package php52s.x86_64 0:5.2.17-11.mr.el6 will be erased
--> Finished Dependency Resolution
--> Running transaction check
---> Package php52s.x86_64 0:5.2.17-11.mr.el6 will be erased
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: php52s-5.2.17-11.mr.el6.x86_64
--> Running transaction check
---> Package php52s.x86_64 0:5.2.17-11.mr.el6 will be erased
--> Finished Dependency Resolution

Dependencies Resolved

============================================================================================================================================
 Package                       Arch                  Version                            Repository                                     Size
============================================================================================================================================
Installing:
 mysql55                       x86_64                5.5.40-1.ius.el6                   mratwork-ius-stable                           9.1 M
 mysql55-libs                  x86_64                5.5.40-1.ius.el6                   mratwork-ius-stable                           786 k
 mysql55-server                x86_64                5.5.40-1.ius.el6                   mratwork-ius-stable                           9.6 M
Removing:
 mysql                         x86_64                5.5.34-1.el6                       @mratwork-centalt                              29 M
 mysql-libs                    x86_64                5.5.34-1.el6                       @mratwork-centalt                             4.1 M
 mysql-server                  x86_64                5.5.34-1.el6                       @mratwork-centalt                              45 M
Removing for dependencies:
 php52s                        x86_64                5.2.17-11.mr.el6                   @mratwork-release-version-arch                 20 M

Transaction Summary
============================================================================================================================================
Install       3 Package(s)
Remove        4 Package(s)

Total size: 19 M
Total download size: 19 M
Is this ok [y/N]: y
Downloading Packages:
(1/2): mysql55-5.5.40-1.ius.el6.x86_64.rpm                                                                           | 9.1 MB     00:00     
(2/2): mysql55-server-5.5.40-1.ius.el6.x86_64.rpm                                                                    | 9.6 MB     00:00     
--------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                        10 MB/s |  19 MB     00:01     
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : mysql55-libs-5.5.40-1.ius.el6.x86_64                                                                                     1/7
warning: /etc/my.cnf created as /etc/my.cnf.rpmnew
  Installing : mysql55-5.5.40-1.ius.el6.x86_64                                                                                          2/7
  Installing : mysql55-server-5.5.40-1.ius.el6.x86_64                                                                                   3/7
  Erasing    : mysql-server-5.5.34-1.el6.x86_64                                                                                         4/7
  Erasing    : mysql-5.5.34-1.el6.x86_64                                                                                                5/7
  Erasing    : php52s-5.2.17-11.mr.el6.x86_64                                                                                           6/7
  Erasing    : mysql-libs-5.5.34-1.el6.x86_64                                                                                           7/7
  Verifying  : mysql55-server-5.5.40-1.ius.el6.x86_64                                                                                   1/7
  Verifying  : mysql55-5.5.40-1.ius.el6.x86_64                                                                                          2/7
  Verifying  : mysql55-libs-5.5.40-1.ius.el6.x86_64                                                                                     3/7
  Verifying  : php52s-5.2.17-11.mr.el6.x86_64                                                                                           4/7
  Verifying  : mysql-5.5.34-1.el6.x86_64                                                                                                5/7
  Verifying  : mysql-server-5.5.34-1.el6.x86_64                                                                                         6/7
  Verifying  : mysql-libs-5.5.34-1.el6.x86_64                                                                                           7/7

Removed:
  mysql.x86_64 0:5.5.34-1.el6               mysql-libs.x86_64 0:5.5.34-1.el6               mysql-server.x86_64 0:5.5.34-1.el6             

Dependency Removed:
  php52s.x86_64 0:5.2.17-11.mr.el6                                                                                                         

Installed:
  mysql55.x86_64 0:5.5.40-1.ius.el6         mysql55-libs.x86_64 0:5.5.40-1.ius.el6         mysql55-server.x86_64 0:5.5.40-1.ius.el6       

Complete!

11
yum list installed mysql*
Loaded plugins: fastestmirror, priorities, protectbase, replace
Loading mirror speeds from cached hostfile
 * base: mirror.rackspace.com
 * extras: ftpmirror.your.org
 * mratwork-epel: mirror.steadfast.net
 * mratwork-ius-stable: dl.iuscommunity.org
 * updates: mirror.fdcservers.net
0 packages excluded due to repository protections
Installed Packages
mysql.x86_64                                                   5.5.34-1.el6                                                @mratwork-centalt
mysql-libs.x86_64                                              5.5.34-1.el6                                                @mratwork-centalt
mysql-server.x86_64                                            5.5.34-1.el6                                                @mratwork-centalt
mysqlclient16.x86_64                                           5.1.61-4.ius.el6                                            @mratwork-ius

12
In phpmyadmin, when I click on a database table, I get the following error message:

"1286 Unknown storage engine InnoDB".

1. I changed the mysql engine from innodb to myisam by running the given code above but there's a conflict. I want to change it back to innodb -- what code do I run and which file needs changing?

2. I also tried upgrading to the latest version but I'm getting error.

this log is appearing when I try to upgrade mysql

Transaction Check Error:
  file /etc/my.cnf from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/lib64/mysql/libmysqlclient.so.18.0.0 from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/Index.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/armscii8.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/ascii.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/cp1250.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/cp1256.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/cp1257.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/cp850.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/cp852.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/cp866.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/dec8.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/geostd8.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/greek.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/hebrew.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/hp8.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/keybcs2.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/koi8r.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/koi8u.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/latin1.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/latin2.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/latin5.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/latin7.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/macce.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/macroman.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64
  file /usr/share/mysql/charsets/swe7.xml from install of mysql55-libs-5.5.40-1.ius.el6.x86_64 conflicts with file from package mysql-libs-5.5.34-1.el6.x86_64

Please help me fix these problems.
 

13
I was able to login to Kloxo-MR using the command above. However, I'm unable to restore from an admin {Backup Home} file I created in summer. I keep getting the message that all accounts (admin, reseller, website directories) and roundcube already exist. How do I help me restore this backup so my website can get back online? Since that bast*&^ crashed MySQL all data from PHPMyAdmin is returning innodb error.

14
I ran the command but I'm still unable to login to Kloxo admin.

15
sh /script/set-mysql-default
sh: /script/set-mysql-default: No such file or directory

The malicious hacker deleted some of the files.

Pages: [1] 2 3 ... 7

Top 4 Global Search Engines:    Google    Bing    Baidu    Yahoo

Page created in 0.033 seconds with 20 queries.

web stats analysis