xoops forums

Mamba

Moderator
Posted on: 2018/11/12 2:21
Mamba
Mamba (Show more)
Moderator
Posts: 10818
Since: 2004/4/23
#1

Docker: XOOPS 2.5.10 on PHP 7.3 RC5 and MySQL 8.0.13

Resized Image


If you want to test the upcoming XOOPS version 2.5.10 on PHP 7.3 RC5 and MySQL 8.0.13 using Docker, the files are here:
https://github.com/geekwright/xoops_mysql8

Make sure you read the Readme.md file

Richard (aka Geekwright) is testing and is fixing potential issues. So far he has found only a few issues running under MySQL 8.0. The expanded reserved word list is one. There are also issues with using PHP with the new default authentication plugin in MySQL 8.0, caching_sha2_password.
Docker version above sets default-authentication-plugin=mysql_native_password.

The 'rank' column in users table is a reserve word, and needs to be `quoted`

Richard changed criteria class to use quotes on criteria column names to prevent reserved word issues.

I have installed the Docker version and it worked perfectly. I'll need to test some modules...

Background on problems.
---------------------------------
https://dev.mysql.com/doc/refman/8.0/en/keywords.html

https://mysqlserverteam.com/upgrading- ... on-plugin-considerations/
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs

alain01

Quite a regular
Posted on: 2/7 2:31
alain01
alain01 (Show more)
Quite a regular
Posts: 303
Since: 2003/6/20
#2

Re: Docker: XOOPS 2.5.10 on PHP 7.3 RC5 and MySQL 8.0.13

Hi Mamba,
i've just tested docker + https://github.com/geekwright/xoops_mysql8.

I'm new with docker, but all is ok,
ok runs, it's amazing...
Thanks for that (You and geekwright)

But i have one question :
My hoster is Ms W10,
i found the docker settings / advanced / disk image location

but how can i see and put some files like modules in it ?
ssh ?
docker commands ?

Alain01 from fr

Mamba

Moderator
Posted on: 2/7 2:51
Mamba
Mamba (Show more)
Moderator
Posts: 10818
Since: 2004/4/23
#3

Re: Docker: XOOPS 2.5.10 on PHP 7.3 RC5 and MySQL 8.0.13

Hi Alain,

welcome to the Docker world!

Here are few ways to copy files:

Linux: https://medium.freecodecamp.org/docker ... st-practices-9570c4592e9e

Windows: https://markheath.net/post/transfer-files-docker-windows-containers
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs

alain01

Quite a regular
Posted on: 2/7 11:58
alain01
alain01 (Show more)
Quite a regular
Posts: 303
Since: 2003/6/20
#4

Re: Docker: XOOPS 2.5.10 on PHP 7.3 RC5 and MySQL 8.0.13

humm...

Ok, my first contribution Docker/XOOPS
Just write here for memo,
please modify it if it's not correct.

show enabled containers :
>docker container ls (or >docker ps)

Enter in the container "xoopstest" (web server Apache ) in bash shell :
>docker run -it xoopstest bash
Then you could use linux command, like "ls", "pwd", "cd"...

Save modifications in the image :
root@xxxxxxx>[i]exit[/i]
>docker commit xxxxxxx xoopstest-update01

Next step :
Put files/directory in image (modules, theme, template)

alain01

Quite a regular
Posted on: 2/11 9:54
alain01
alain01 (Show more)
Quite a regular
Posts: 303
Since: 2003/6/20
#5

Re: Docker: XOOPS 2.5.10 on PHP 7.3 RC5 and MySQL 8.0.13

Here, a french tuto to use Docker with XOOPS :
http://www.frxoops.org/modules/news/article.php?storyid=1964

Mamba

Moderator
Posted on: 2/11 15:28
Mamba
Mamba (Show more)
Moderator
Posts: 10818
Since: 2004/4/23
#6

Re: Docker: XOOPS 2.5.10 on PHP 7.3 RC5 and MySQL 8.0.13

That's awesome!!!
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs