[Solved] VestaCP + Percona

[.MP.]

hi,

i've following the offical guide to install Percona after fresh install VestaCP (CentOS 6.7 x64).
but after that i have problems.

# /etc/my.cnf doesn't exist, but /etc/my.cnf.rpmsave exist
if i rename it, Percona won't start.

# i can't access phpMyAdmin, 403 Forbidden.

anyone can help me?
thanks.

[skurudo]

If by default my.cnf is not created. You have to create it yourself.

Code: Select all

# rpm -qa | grep Percona-Server

Code: Select all

cat /etc/*release*

Code: Select all

find / | grep cnf

Some output like this:

/usr/share/mysql/my-huge.cnf
/usr/share/mysql/my-medium.cnf
/usr/share/mysql/my-large.cnf
/usr/share/mysql/my-innodb-heavy-4G.cnf
/usr/share/mysql/my-small.cnf
/usr/share/doc/Percona-Server-server-51-5.1.51/my-huge.cnf
/usr/share/doc/Percona-Server-server-51-5.1.51/my-medium.cnf
/usr/share/doc/Percona-Server-server-51-5.1.51/my-large.cnf
/usr/share/doc/Percona-Server-server-51-5.1.51/my-innodb-heavy-4G.cnf
/usr/share/doc/Percona-Server-server-51-5.1.51/my-small.cnf

And you can copy and rename percona conf file (try medium for start)

[.MP.]

i only have this :

/usr/local/vesta/install/rhel/5/mariadb/my-large.cnf
/usr/local/vesta/install/rhel/5/mariadb/my-medium.cnf
/usr/local/vesta/install/rhel/5/mariadb/my-small.cnf
/usr/local/vesta/install/rhel/5/mysqld/my-large.cnf
/usr/local/vesta/install/rhel/5/mysqld/my-medium.cnf
/usr/local/vesta/install/rhel/5/mysqld/my-small.cnf
/usr/local/vesta/install/rhel/6/mariadb/my-large.cnf
/usr/local/vesta/install/rhel/6/mariadb/my-medium.cnf
/usr/local/vesta/install/rhel/6/mariadb/my-small.cnf
/usr/local/vesta/install/rhel/6/mysqld/my-large.cnf
/usr/local/vesta/install/rhel/6/mysqld/my-medium.cnf
/usr/local/vesta/install/rhel/6/mysqld/my-small.cnf
/usr/local/vesta/install/rhel/7/mariadb/my-large.cnf
/usr/local/vesta/install/rhel/7/mariadb/my-medium.cnf
/usr/local/vesta/install/rhel/7/mariadb/my-small.cnf
/usr/local/vesta/install/rhel/7/mysqld/my-large.cnf
/usr/local/vesta/install/rhel/7/mysqld/my-medium.cnf
/usr/local/vesta/install/rhel/7/mysqld/my-small.cnf
/usr/share/php/phpseclib/openssl.cnf
/usr/share/doc/Percona-Server-server-56-5.6.27/my-default.cnf
/usr/share/percona-server/my-default.cnf
/var/lib/mysql/auto.cnf

mysqld and mariadb only, dont have percona.
which one should i use?

[skurudo]

i only have this :
mysqld and mariadb only, dont have percona.
which one should i use?

One of those:

/usr/share/doc/Percona-Server-server-56-5.6.27/my-default.cnf
/usr/share/percona-server/my-default.cnf

I think - second - copy and rename.

[.MP.]

done this is my.cnf content :

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0

skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 240K

#innodb_use_native_aio = 0
innodb_file_per_table

max_connections=50
max_user_connections=25
wait_timeout=10
interactive_timeout=50
long_query_time=5

#slow_query_log=1
#slow_query_log_file=/var/log/mysql-slow-queries.log

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

but phpmyadmin still error, i can't access it..
404 error..
where i can configured it?

[.MP.]

After check httpd config for phpMyAdmin :

/etc/httpd/conf.d/phpMyAdmin.conf

the folder /usr/share/phpMyAdmin not exist.
it because i forget install phpMyAdmin after change MySQL to Percona.

yum install php-mysqlnd phpmyadmin --enablerepo=remi
cp /etc/httpd/conf.d/phpMyAdmin.conf.rpmsave /etc/httpd/conf.d/phpMyAdmin.conf
service httpd restart

now its work perfectly after i install it.
thanks.

[SOLVED]

[skurudo]

the folder /usr/share/phpMyAdmin not exist.
it because i forget install phpMyAdmin after change MySQL to Percona.
[SOLVED]

Nice! Good solution ;-)