Clean installation od 1.2.11 - Can't create database

LordRuthwen · Feb 2nd 2016

Distro - Debian 8 x86_64
IMSPCP: 1.2.11
Mode: php5-fpm

After clean installation i can't create database from panel.

Code

An exception has been thrown in file
/var/www/imscp/gui/library/Functions/Shared.php at line 2753:
=================================================================
SQLSTATE[HY000]: General error: 1006 Can't create database'biblioteka' (errno: 13)
Query was:
CREATE DATABASE IF NOT EXISTS `testdb`
=================================================================
Debug backtrace:
---------------
File: /var/www/imscp/gui/public/client/sql_database_add.php at line153
Function: execute_query()File: /var/www/imscp/gui/public/client/sql_database_add.php at line208
Function: client_addSqlDb()
Additional information:
----------------------
Http User Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36(KHTML, like Gecko) Chrome/48.0.2564.97 Safari/537.36
Request Uri: /client/sql_database_add.php
Http Referer: [url='https://admin.b1.gcth.pl/client/sql_database_add.php']https://admin.mydomain/client/sql_database_add.php[/url]
Remote Addr: IP
Server Addr: IP

Display More

Debug log of imspcp does not contain any information about error, mysql log too.

I can create users, domains, ftp and mail accounts, problem is only with database.

**Nuxwin** · Feb 2nd 2016

@LordRuthwen

Any plugin in use?

Something is really weird in the mail you received...

First we have:

Code

SQLSTATE[HY000]: General error: 1006 Can't create database'biblioteka' (errno: 13)

and then after, we have

Code

CREATE DATABASE IF NOT EXISTS `testdb`

So please, what the name of the database you tried to create exactly?

**Nuxwin** · Feb 2nd 2016

@LordRuthwen

I cannot reproduce the problem anyway with my branch. I would be curious to see the content of your /var/www/imscp/gui/public/client/sql_database_add.php script.

**theemstra** · Feb 2nd 2016

Can't reproduce on 1.2.9, no changes have been made in this part of i-MSCP since 1.2.9 until 1.2.11.

Database is creatable and removable

**Nuxwin** · Feb 2nd 2016

@LordRuthwen

You should check that your /var/lib/mysql directory and its content has correct permissions (e.g mysql as owner and group).

For instance:

Code

root@xenial:~# ls -la /var/lib/mysql
total 176176
drwx------ 11 mysql mysql 4096 févr. 2 12:32 .
drwxr-xr-x 48 root root 4096 janv. 29 17:59 ..
-rw-rw---- 1 mysql mysql 56 janv. 24 22:22 auto.cnf
drwx------ 2 mysql mysql 4096 févr. 2 12:32 biblioteka
drwx------ 2 mysql mysql 4096 janv. 26 21:10 db03pg
-rw-r--r-- 1 root root 0 janv. 25 08:46 debian-5.0.flag
-rw-rw---- 1 mysql mysql 79691776 févr. 2 12:32 ibdata1
-rw-rw---- 1 mysql mysql 50331648 févr. 2 12:32 ib_logfile0
-rw-rw---- 1 mysql mysql 50331648 janv. 24 22:22 ib_logfile1
drwx------ 2 mysql mysql 4096 févr. 2 12:27 imscp
drwx------ 2 mysql mysql 4096 janv. 24 22:26 imscp_pma
drwx------ 2 mysql mysql 4096 janv. 24 22:26 imscp_rainloop
drwx------ 2 mysql mysql 4096 janv. 24 22:26 imscp_roundcube
drwx------ 2 mysql root 4096 janv. 24 22:22 mysql
drwx------ 2 mysql mysql 4096 janv. 24 22:22 performance_schema
drwx------ 2 mysql mysql 4096 févr. 2 12:32 testdb

Display More

LordRuthwen · Feb 2nd 2016

And that solved problem, I have database on different location.
Before:

Code

drwx------ 2 mysql root 4096 sty 8 09:50 mysql-rw------- 1 root root 6 sty 8 09:50 mysql_upgrade_info

Now:

Code

drwx------ 2 mysql mysql 4096 sty 8 09:50 mysql
-rw------- 1 mysql mysql 6 sty 8 09:50 mysql_upgrade_info

And work.

**theemstra** · Feb 2nd 2016

@LordRuthwen
Any clue why this happened? Did you put a backup back in place or sth?

LordRuthwen · Feb 2nd 2016

I think, I forgot change owner to directory with databases (it was created manualy by root).

**Nuxwin** · Feb 2nd 2016

@LordRuthwen

We are maybe to curious but why you move all your data to other locations?

Share

Daily visitors