Page 1 of 2
MySQL is not working, MySQLi is working.
Posted: Mon Apr 13, 2015 2:02 pm
by Pilovali
Hello,
I have a problem with the MySQL server.
I want to install SMF (Forum software) and it is giving me this error:
Access denied for user 'pirus'@'localhost' (using password: NO)
pirus is the VestaCP username, not the database name.
I did some research and I found this interesting link:
http://stackoverflow.com/questions/7671 ... -with-that
It seems that it is using the unix username instead of the username I put in the config.
This problem is not happening with MySQLi, so things like the SMF beta and WordPress works just fine.
Could someone help me with this? I searched for DAYS!
I am using VestaCP 0.9.8.12 on Ubuntu 14.04 and I have PHP-APC and Google Pagespeed installed.
Re: MySQL is not working, MySQLi is working.
Posted: Mon Apr 13, 2015 2:47 pm
by skurudo
Wait, wait, wait... Do you create user - it's ok, do you create database / database user / password and then use for connect SMF forum and this don't work, correct? You copy all field right?
PHP have at least two connectors for database - mysql and mysqli (check in /etc/php5/conf.d) -
http://php.net/manual/en/mysqli.overview.php
Re: MySQL is not working, MySQLi is working.
Posted: Mon Apr 13, 2015 3:01 pm
by Pilovali
skurudo wrote:Wait, wait, wait... Do you create user - it's ok, do you create database / database user / password and then use for connect SMF forum and this don't work, correct? You copy all field right?
PHP have at least two connectors for database - mysql and mysqli (check in /etc/php5/conf.d) -
http://php.net/manual/en/mysqli.overview.php
I created the user and database on the VestaCP, it works if I want to install WordPress (uses MySQLi), but not SMF (uses MySQL).
This is the content of the conf.d:
*******@******:~# ls /etc/php5/apache2/conf.d/
05-opcache.ini 20-geoip.ini 20-mysql.ini 20-readline.ini
10-pdo.ini 20-intl.ini 20-mysqli.ini 20-sqlite3.ini
20-apcu.ini 20-json.ini 20-pdo_mysql.ini
20-curl.ini 20-mcrypt.ini 20-pdo_sqlite.ini
20-gd.ini 20-memcached.ini 20-pspell.ini
Re: MySQL is not working, MySQLi is working.
Posted: Mon Apr 13, 2015 4:09 pm
by skurudo
I made test SMF installation and don't see error. All work just fine and you have 20-mysql.ini connector. Mysql and Mysqli is overthinking. May be site error log can say us something?
Re: MySQL is not working, MySQLi is working.
Posted: Mon Apr 13, 2015 4:42 pm
by Pilovali
Error log of the website is emtpy, MySQL log shows nothing regarding to that.
Could it be because of something I installed? Like APC or Pagespeed? I didn't had this problem before.
Re: MySQL is not working, MySQLi is working.
Posted: Mon Apr 13, 2015 4:48 pm
by skurudo
Most likely Pagespeed (for apache2?), thy disable this module, restart apache2 and then try again.
Re: MySQL is not working, MySQLi is working.
Posted: Mon Apr 13, 2015 7:44 pm
by Pilovali
skurudo wrote:Most likely Pagespeed (for apache2?), thy disable this module, restart apache2 and then try again.
Nope, I disabled it and it didn't solved this issue.
Re: MySQL is not working, MySQLi is working.
Posted: Mon Apr 13, 2015 7:46 pm
by skurudo
May be you can some screenshot of installation process or url/database settings in PM?
Re: MySQL is not working, MySQLi is working.
Posted: Tue Apr 14, 2015 7:30 am
by Pilovali
skurudo wrote:May be you can some screenshot of installation process or url/database settings in PM?
I've send you a PM with credentials of the VestaCP user, perhaps you can take a look.
UPDATE:
I re-checked the MySQL logs and it's spamming this error:
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
I tried this:
https://serverfault.com/questions/47744 ... 1-error-11 but it keeps spamming.
Re: MySQL is not working, MySQLi is working.
Posted: Tue Apr 14, 2015 6:36 pm
by skurudo