Docker error on grant tables

[caihexin]

[root@ravada dockerfy]# docker-compose up -d Creating network "ravada_network" with the default driver Creating ravada-mysql ... done Creating ravada-front ... done Creating ravada-back ... done

[root@ravada dockerfy]# docker exec -it ravada-back bash root@200b567a5909:/ravada# PERL5LIB=./lib ./script/rvd_back --add-user admin Permission clone_all doesn't exist at table grant_types $VAR1 = { 'expose_ports' => 22, 'rename_all' => 15, 'shutdown_clone' => 9, 'create_machine' => 5, 'rename_clones' => 16, 'reboot_clones' => 20, 'change_settings_all' => 11, 'start_many' => 21, 'change_settings_clones' => 7, 'create_base' => 6, 'reboot' => 18, 'hibernate_clone_all' => 13, 'clone' => 1, 'reboot_all' => 19, 'remove_clone_all' => 12, 'remove' => 3, 'hibernate_clone' => 10, 'change_settings' => 2, 'rename' => 14, 'start_limit' => 23, 'screenshot' => 4, 'shutdown' => 17, 'remove_clone' => 8 };

[caihexin]

[root@ravada dockerfy]# docker version Client: Docker Engine - Community Version: 20.10.5 API version: 1.41 Go version: go1.13.15 Git commit: 55c4c88 Built: Tue Mar 2 20:17:04 2021 OS/Arch: linux/amd64 Context: default Experimental: true

Server: Docker Engine - Community Engine: Version: 20.10.5 API version: 1.41 (minimum version 1.12) Go version: go1.13.15 Git commit: 363e9a8 Built: Tue Mar 2 20:15:27 2021 OS/Arch: linux/amd64 Experimental: false containerd: Version: 1.4.3 GitCommit: 269548fa27e0089a8b8278fc4fc781d7f65a939b runc: Version: 1.0.0-rc92 GitCommit: ff819c7e9184c13b7c2607fe6c30ae19403a7aff docker-init: Version: 0.19.0 GitCommit: de40ad0

[frankiejol]

Hi @caihexin , can you check at the beginning of lib/Ravada.pm what version is there ? There should be a line like: our $VERSION = '0.11.4';

[caihexin]

lib/Ravada.pm our $VERSION = '1.0.0';

use docker images

ravada/back latest 97037d4a2509 3 months ago 464MB

[frankiejol]

Ok, My guess is the doc is from when the docker was in development, now we must work in the stable branch.

I can't tell for sure right now, but can you please try this. First go to the ravada/dockerfy directory

cd ravada/dockerfy

Then we swith to the stable branch and we try it from there:

git checkout master
docker-compose pull
docker-compose up -d

And then follow the procedure in https://ravada.readthedocs.io/en/latest/docs/INSTALLfromDockers.html#ravada-web-user

Hope this helps. In that case we will check the documentation and then also fix the development branch.

[fv3rdugo]

[root@ravada dockerfy]# docker-compose up -d Creating network "ravada_network" with the default driver Creating ravada-mysql ... done Creating ravada-front ... done Creating ravada-back ... done

[root@ravada dockerfy]# docker exec -it ravada-back bash root@200b567a5909:/ravada# PERL5LIB=./lib ./script/rvd_back --add-user admin Permission clone_all doesn't exist at table grant_types $VAR1 = { 'expose_ports' => 22, 'rename_all' => 15, 'shutdown_clone' => 9, 'create_machine' => 5, 'rename_clones' => 16, 'reboot_clones' => 20, 'change_settings_all' => 11, 'start_many' => 21, 'change_settings_clones' => 7, 'create_base' => 6, 'reboot' => 18, 'hibernate_clone_all' => 13, 'clone' => 1, 'reboot_all' => 19, 'remove_clone_all' => 12, 'remove' => 3, 'hibernate_clone' => 10, 'change_settings' => 2, 'rename' => 14, 'start_limit' => 23, 'screenshot' => 4, 'shutdown' => 17, 'remove_clone' => 8 };

I have the same problem. I run docker-compose from develop branch and clean docker environment. I delete all persistent data, database, etc.

[fv3rdugo]

Another question, from master branch not work. I think that is not up to date from develop branch. A cherry pick from https://github.com/UPC/ravada/pull/1471 may be fixed. I copy the output result:

✔ ~/src/ravada/dockerfy [master|…1⚑ 6] 17:46 $ docker exec -it ravada-back bash root@0e1b4ea28633:/ravada# PERL5LIB=./lib ./script/rvd_back --add-user admin Cannot determine local time zone Compilation failed in require at lib/Ravada/Auth/SQL.pm line 16. BEGIN failed--compilation aborted at lib/Ravada/Auth/SQL.pm line 16. Compilation failed in require at lib/Ravada/Auth.pm line 8. BEGIN failed--compilation aborted at lib/Ravada/Auth.pm line 8. Compilation failed in require at lib/Ravada.pm line 25. BEGIN failed--compilation aborted at lib/Ravada.pm line 25. Compilation failed in require at ./script/rvd_back line 14. BEGIN failed--compilation aborted at ./script/rvd_back line 14.

[fv3rdugo]

I apply cherry-pick in master branch locally. Now, dockers start but the error is the same that when I tried from develop branch. I copy the output result:

✘-127 ~/src/ravada/dockerfy [master|…1⚑ 6] 18:04 $ git cherry-pick 003bf0f92258815bf6033f59f981e8c2b37f00fa [master 153f4570] fix(dockers): read env file Author: fv3rdugo [email protected] Date: Fri Jan 15 23:01:20 2021 +0100 1 file changed, 2 insertions(+) ✔ ~/src/ravada/dockerfy [master ↑·1|…1⚑ 6] 18:04 $ docker-compose up -d ravada-mysql is up-to-date Recreating ravada-front ... done Recreating ravada-back ... done ✔ ~/src/ravada/dockerfy [master ↑·1|⚑ 6] 18:05 $ docker exec -it ravada-back bash root@94d97b228293:/ravada# PERL5LIB=./lib ./script/rvd_back --add-user admin Permission clone_all doesn't exist at table grant_types $VAR1 = { 'start_many' => 21, 'clone' => 1, 'create_machine' => 5, 'change_settings_clones' => 7, 'expose_ports' => 22, 'remove_clone_all' => 12, 'create_base' => 6, 'remove_clone' => 8, 'rename' => 14, 'start_limit' => 23, 'reboot' => 18, 'screenshot' => 4, 'hibernate_clone_all' => 13, 'change_settings_all' => 11, 'reboot_clones' => 20, 'shutdown_clone' => 9, 'change_settings' => 2, 'rename_clones' => 16, 'hibernate_clone' => 10, 'shutdown' => 17, 'rename_all' => 15, 'reboot_all' => 19, 'remove' => 3 }; root@94d97b228293:/ravada#

[fv3rdugo]

Missing this tables to create:

• clone_all
• grant
• grant_types
• remove_all
• shutdown_all

[caihexin]

test many version, error same

[frankiejol]

I have been able to reproduce the problem. I will try to debug why SQL information for table grant_types doesn't get inserted as it is done in the development and packaged release

[fv3rdugo]

NNN