Topic: How to enable mysql scl version on ibay

[beast]

Hi

Have installed https://wiki.contribs.org/PHP_Software_Collections and it works fine.

Now I need to update mysql on a specific ibay. For some reason I am unable to find this information?
E.g. how to install a higher version to only a specific ibay like with PHP

Is this because it is system wide or?

Like to have a overview before I install it like this: https://wiki.contribs.org/MySQL57

If I get this information I will update the wiki after the installation as others may also have the same problem.

/Benny

[janet]

beast

Please learn to read & review the list of Contribs, link is at top of Forums.
You would have easily found what you are after by looking under M for Mysql
eg
https://wiki.contribs.org/MySQL55
&
https://wiki.contribs.org/MySQL57

[beast]

beast

Please learn to read & review the list of Contribs, link is at top of Forums.
You would have easily found what you are after by looking under M for Mysql
eg
https://wiki.contribs.org/MySQL55
&
https://wiki.contribs.org/MySQL57

I know those links and the information I am asking for is not there!

I do not think you get my question: Is the mysql upgrade active pr ibay and how to control it?

[Stefano]

Beast, your question has a simple answer: MySQL (both the standard one and the scl one) doesn't know anything about ibays
It's up to you to configure the apps to use the right DB engine

[janet]

Beast

MySQL (both the standard one and the scl one) doesn't know anything about ibays
It's up to you to configure the apps to use the right DB engine

...and instructions related to that are linked to on line 2 of the articles referred to earlier
ie
https://wiki.contribs.org/MySQL

[beast]

Beast, your question has a simple answer: MySQL (both the standard one and the scl one) doesn't know anything about ibays
It's up to you to configure the apps to use the right DB engine

OK so they live side by side on a system wide basis. But how do I select how to use the correct one?

It may be a simple question for others but I like to update the WIKI as I think that information is needed.

If I install phpmyadmin - how do I select the 'correct' database? Normal situation is just to specify 'localhost' but this will properly just select the OS standard one.

If I install for instance https://piwik.org/ that need a higher version how do I make it use the correct database.

It is not clear to me from the links that have been provided and I like to update the text in the Wiki.

/Benny

 

[mmccarn]

You specify which version of sql to use by specifying the connection details of the application.

To administer the scl version of mysql from the command line, add a specific connection option on the command line:

Code: [Select]

mysql --socket=/var/lib/mysql/mysql55.sock

or, if you configured your scl sql to use TCP on port 3307:

Code: [Select]

mysql --protocol=TCP --port=3307

For your ibay, you'd have to find out how to configure the application to use the alternate/secondary database connection.  I'm using mysql 5.5 from the software collections for my local install of "etherpad-lite"; I had to modify the etherpad-lite 'settings.json' to use the mysql55 socket:

Code: [Select]

...
   "dbSettings" : {
                    "user"    : "etherpad",
                    "port"    : "/var/lib/mysql/mysql55.sock",
                    "host"    : "localhost",
...

phpmyadmin is "just" another application -- to connect it to your SCL sql, you'd have to set the database connection correctly.

[Jean-Philippe Pialasse]

Indeed they are all system wide available. You can even have some application using more than one of the mysql services.

Php application aware of sockect are few, most of them will try to connect to a port, you have to find a way to define the one you want to use for your particular app. Some let you put it in a variable, some will just need you to add it after the hostname or ip (localhost:3306), some will just assume 3306 and just ignore anything else.


As a resumé mostly the answer to your question is :
- localhost:3306 or localhost to use the original mysql version
-localhost:3307 to use the mysql55 version
- localhost:3309 to use the mysql57 version


Where is the hell the 3308? I kept it for mysql56 in case i take time to adapt it.

Also: smeserver-mysql57 is an adaptation of smeserver-mysql55, it is still alpha as i did not have the time to fully test, should be fine, but would be happy to ear from you if you manage to test it before me .

Lastly: i think this piece of information and the one provided by mmccarn should be added to the wiki, as this could be a frequent question, what to do to use the one installation i want

[frifri]

For Wordpress :

MySQL Sockets or Pipes - If your host uses Unix sockets or pipes, adjust the DB_HOST value in the wp-config.php file accordingly.

Code: [Select]

define( 'DB_HOST', '127.0.0.1:/var/run/mysqld/mysqld.sock' );
// or define( 'DB_HOST', 'localhost:/var/run/mysqld/mysqld.sock' );
// or define( 'DB_HOST', 'example.tld:/var/run/mysqld/mysqld.sock' );

Replace /var/run/mysqld/mysqld.sock with the socket or pipe information provided by your host.

I defined the host as : localhost:/var/lib/mysql/mysql55.sock

F.

[beast]

Great - I will update Wiki based on these comments.

It also seam to work with:  localhost;unix_socket=/var/lib/mysql/mysql55.sock

based on my testing!

[beast]

Have made some quick changes to https://wiki.contribs.org/MySQL55 that reflect this thread

[beast]

But I think the complete section on SCL could need an update as it looks a bit random what pages have been created and the relation between them - that will have to wait