how make different MySQL settings for customers? (strict mode)

[PietroV.]

Hi!

We are running Plesk 12.0.18 with MySQL (Server Version: 5.5.33-MariaDB - openSUSE package) on OpenSuSE 13.1

MySQL is running in strict mode and its fine for the most of our customers. But some are trying to run Contenido, thats a CMS, which could work with this mode and we have to disable mysql strict mode.

So my question is:
Is it possible to disable mysql strict mode just for choosen customers?


Thanks!


Best regards
Pietro

Btw: Before I post here, I checked all documentary which is available on odin.com.

 

[UFHH01]

No, you can only have one strict-mode-setting in a MySQL - instance. But you could install a second MySQL - server, which you can use to run with the desired setting on another port.

 

[PietroV.]

Hi!

Thanks for your reply. I have something already feared, but did not want to admit.
So, I have to install a new MySQL Server (instance), just for those customers.

Thanks for help. If someone have another idea, please feel free to tell us!

best regards

 

[UFHH01]

Actually, it IS possible... as I just found out... you could tell the MySQL - Server over the database - connector, to choose another SQL mode while connecting:

$this->query("SET sql_mode = ''");​

This additional setting could be set in: "conlib/db_mysql.inc" , after the connect ( function connect($Database = "", $Host = "", $User = "", $Password = "") { ), in your Contenido installation.

 

[PietroV.]

Ok, I'll try that out. I will give you some Feedback here.

 

[PietroV.]

Hi!
Also, it didn't work.
I read, that is possible to make own my.cnf files for users, but how?

If I get it right, there is now own user for a plesk user, right?

https://mariadb.com/kb/en/mariadb/documentation/getting-started/configuring-mariadb-with-mycnf/

Any idea?