megamattc commented 1 year ago

Hello,

I am trying to install the webtool on an M1 Mac running Ventura 13.3.1, but encounter the following error when running docker-compose up:

fnbr-webserver-webtool361  | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.19.0.3. Set the 'ServerName' directive globally to suppress this message

I receive this error when I tried using similar nginx/unit images, including nginx/unit:1.27.0-python3.9, 1.28.0-python3.10, and 1.29.1-python3.11.

Are there any recommendations you have to solve this problem?

elymatos commented 1 year ago

Hello Matthew, It seems you are using a branch (3.6.1). Please try using the "main" branch. The message you relate is common - it indicates Apache is running inside container. You can run docker-compose like:

docker compose up -d

to run the container in background. Let me know if this works. Thanks, Ely

On Thu, 13 Apr 2023 at 18:09, Matthew Ong @.***> wrote:

Hello,

I am trying to install the webtool on an M1 Mac running Ventura 13.3.1, but encounter the following error when running docker-compose up:

fnbr-webserver-webtool361 | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.19.0.3. Set the 'ServerName' directive globally to suppress this message

I receive this error when I tried using similar nginx/unit images, including nginx/unit:1.27.0-python3.9, 1.28.0-python3.10, and 1.29.1-python3.11.

Are there any recommendations you have to solve this problem?

— Reply to this email directly, view it on GitHub https://github.com/FrameNetBrasil/webtool/issues/21, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABKLOBULEEQEXAPJOQNCIRDXBBTQBANCNFSM6AAAAAAW5TLKIU . You are receiving this because you are subscribed to this thread.Message ID: @.***>

megamattc commented 1 year ago

Hello Ely,

I think I followed your directions correctly. I think I did originally use the main branch, as I check on the label in the corner, and see I was always within the 'master' branch when cloning the repository.

In addition, when I ran the docker compose up -d command it said:

[+] Running 2/0
 ⠿ Container fnbr-gravis-webtool361     Running                                                                  0.0s
 ⠿ Container fnbr-webserver-webtool361  Running                                                                  0.0s

I'm not sure if that means the container was set up properly or not. At this point in the instructions, I'm not sure what to make of the line

⋅⋅* Restore/create the MySQL database from the dump located at webtool/apps/webtool/docs/database/webtool_dump.zip

since I do not find the file webtool_dump.zip in that directory (only two .mwb files). And when I try to run the program in the browser by clicking on the http://localhost:8001/ link, nothing loads. Where am I going wrong in all this?

elymatos commented 1 year ago

Hi Matthew, Actually I was in trouble with this repository: it seems it was mixing versions. Now I've made a fresh update to current version (3.6.1) and change the README instructions. The main change in this version was the fact we have removed the stuff related to MySQL database to simplify the installation process. Most of users already have some MySQL/MariaDb installation, so we are distributing just the database dump. I thank you very much by point the problems and I hope they are fixed now. I ask you to try to do a fresh installation following the README instructions. Let me know if you face issues again. Thanks, Ely

megamattc commented 1 year ago

Hello Ely,

I cloned the updated repository and followed the instructions to the best of my ability, but there were still problems. Specifically:

I installed MariaDb, however, when I tried to import the dump file into a new database and I checked the contents of that database, MariaDb said it was empty. If you wish to know the specific steps I followed (according to this site: https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-in-mysql-or-mariadb), I did:

MariaDB> CREATE DATABASE my_database;

(in directory with webtool_dump.sql) mysql -u root -p my_database < webtool_dump.sql

MariaDB> USE my_database;
MariaDB [my_database]> SHOW TABLES;
Empty set (0.005 sec)

I don't know if this is supposed to happen.

Furthermore, the locations of the conf.php files mentioned in readme.md as:

  webtool/core/conf/conf.php
  webtool/apps/webtool/conf/conf.php

do not appear to be correct. I can't tell from the context of the instruction

  'db' => [
    'webtool' => [
      ...
      'host' => '<db_host>',
      'dbname' => 'webtool_db',
      'user' => '<user name>',
      'password' => '<password>',
      ....

where this block of code should be inserted in any of the other conf.php files in the webtool directory.

That is as far as I got.

Matt

elymatos commented 1 year ago

Hi Matthew, Thanks for your feedback.

About the database: database schema is "webtool_db" and it is explicit in the dump. So, you must look for "webtool_db" in the MariaDb server. You have create "my_database" but the tables might be loaded at "webtool_db". (Although it is not stated explicitly at README, the server must allow "case-insensitive" access to the tables - please look at, for example - https://www.simplified.guide/mysql-mariadb/case-insensitive-table-linux)
About the conf files: you're right, they were missing. I pushed them now and you can edit the conf.php file "webtool/apps/webtool/conf/conf.php" - just change 'host', 'user' and 'password'. Thanks, Ely

megamattc commented 1 year ago

Hi Ely,

This time I got further. I was able to load the webtool_db.sql file into MariaDB. I saw a list of about 120 items when I used the command SHOW TABLES. If this counts as 'accessing the tables', it seems I was able to do this without modifying the my.cnf configuration file, to which I nevertheless added the line lower_case_table_names=1 at the bottom.

I edited conf.php so that host = localhost and user and password had my chosen values (I don't know if they need to be the same values as what I use to open up MariaDB from the command line, but they are different).

I was able to run docker-compose build this time.

But when I ran docker-compose up -d I got the following error:

[+] Running 1/2
 ⠿ Container fnbr-gravis-webtool361     Running                                                                  0.0s
 ⠧ Container fnbr-webserver-webtool361  Starting                                                                 0.8s
Error response from daemon: error while creating mount source path '/host_mnt/Users/matthewong/Documents/nlp_stuff/Metaphors/webtool/docker/config/php/php.ini': mkdir /host_mnt/Users/matthewong/Documents/nlp_stuff/Metaphors/webtool/docker/config/php/php.ini: no such file or directory

I don't know why it would say such a thing. The file php.ini does exist in the stated location. Do you have an idea about what is wrong here?

Matt

megamattc commented 1 year ago

Hello Ely,

I was wondering if you had had time to consider my last message?

Thank you

Matt

elymatos commented 1 year ago

Hi Matthew, Sorry by delay. Actually we are working on changes to the webtool database and preparing a fresh new version, so sometimes the time is short :-) About the database it seems to be corrected now (and yes, in the conf you need to set credentials for a user with permission to read/write in the tables). About the case for php.ini it is very strange - I tried to reproduce the problem here, but no success. As you said, the file already exists and it is just mapped to the container. I can't figure out why docker is trying to create something (the message is about "mkdir"). My first try would be to relax permissions in the folder just to test. And try to run the docker command with a elevated user. Let me know if it helps. Ely

FrameNetBrasil / webtool

Problem installing webtool #21

docker compose up -d