search

developeregrem / fewohbee-dockerized

Dockerization of the hotel management software
https://www.fewohbee.de
MIT License
4 stars 1 forks source link

Can't get access application after install with docker #3

Open dnyamy opened 2 years ago

dnyamy commented 2 years ago

Hello, Thanks a lot for this initiative !

I am having trouble installing the dockerized application. The containers are launched well 

CONTAINER ID   IMAGE                                         COMMAND                  CREATED          STATUS          PORTS                                                                            NAMES
a6a919f415c0   developeregrem/fewohbee-acme:latest           "crond -f"               13 minutes ago   Up 12 minutes                                                                                    fewohbee-acme-1
af1952916393   mariadb:10.9                                  "docker-entrypoint.s…"   13 minutes ago   Up 13 minutes   3306/tcp                                                                         fewohbee-db-1
1cf571cb5286   developeregrem/fewohbee-phpfpm:latest         "/entrypoint.sh php-…"   13 minutes ago   Up 13 minutes   9000/tcp                                                                         fewohbee-php-1
77c6f7e89019   nginx:mainline-alpine                         "/docker-entrypoint.…"   13 minutes ago   Up 12 minutes   0.0.0.0:8484->80/tcp, :::8484->80/tcp, 0.0.0.0:4444->443/tcp, :::4444->443/tcp   fewohbee-web-1
a563ff4f7aae   redis:alpine                                  "docker-entrypoint.s…"   13 minutes ago   Up 12 minutes   6379/tcp                                                                         fewohbee-redis-1

As can be seen, I have edited the docker-compose file to map the container's 80 and 443 ports respoctively to ports 8484 and 4444 of the docker host. I have an apache server which receive the requests and forward to the container.

The logs of the web container shows the queries are being rejected with a 301 response code

sudo docker logs -f fewohbee-web-1
172.23.0.1 - - [02/Nov/2022:10:22:58 +0000] "GET / HTTP/1.1" 301 162 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36"

Last thing, since the certificates are handled by the docker host, I have manually edited the .env file to disable the certificate handling 

LETSENCRYPT=false
SELF_SIGNED=false

Don't know what to chek again. Please any direction ?

Looking forward to try the tool.

Dn

developeregrem commented 2 years ago

Hi @dnyamy thanks for you interest in the application :) By default, the setup redirects all traffic from http to https. That is the 301 code. If your SSL/TLS termination is done by your own reverse proxy you need to disable this redirect. First make sure that fewohbee can be handled using http:

cp conf/nginx/site-enabled-https/01_fewohbee.snippet conf/nginx/site-enabled-http

Second disable the redirect in the file conf/nginx/site.conf on line 18 (add comment character)

#    return         301 https://$server_name$request_uri;

And restart the web container

docker-compose restart web

Afterwards you should be able to see something ;)

Alex

dnyamy commented 2 years ago

Great ! It is better now I can see the login page But, please, can't find the temp credentials for first login Dn

developeregrem commented 2 years ago

Good to hear! For the login data please take a look here https://github.com/developeregrem/fewohbee/issues/61#issuecomment-1259776186

dnyamy commented 2 years ago

In deed, there is a problem with database setup Some errors I can see

Creating db backup user ...
ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2)
In ExceptionConverter.php line 101:

  An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused  

In Exception.php line 28:

  SQLSTATE[HY000] [2002] Connection refused  

In Driver.php line 28:

  SQLSTATE[HY000] [2002] Connection refused
developeregrem commented 2 years ago

I see ... Can you give me some more information about your environment? Which operating system and what version are you using. Can you provide me the full output of docker-compose logs php and docker-compose logs db please?

dnyamy commented 2 years ago

System info Linux 5.4.0-124-generic x86_64 GNU/Linux

PHP logs

fewohbee-php-1  | HEAD is now at 535b1fd Merge pull request #60 from developeregrem/3.3.0-dev
fewohbee-php-1  | Installing dependencies from lock file
fewohbee-php-1  | Verifying lock file contents can be installed on current platform.
fewohbee-php-1  | Nothing to install, update or remove
fewohbee-php-1  | Generating optimized autoload files
fewohbee-php-1  | Class App\Entity\SpecialDays located in ./src/Entity/SpecialDay.php does not comply with psr-4 autoloading standard. Skipping.
fewohbee-php-1  | 78 packages you are using are looking for funding.
fewohbee-php-1  | Use the `composer fund` command to find out more!
fewohbee-php-1  | 
fewohbee-php-1  | Run composer recipes at any time to see the status of your Symfony recipes.
fewohbee-php-1  | 
fewohbee-php-1  | Executing script cache:clear [OK]
fewohbee-php-1  | 
fewohbee-php-1  | Executing script assets:install public [OK]
fewohbee-php-1  | {"message":"Notified event \"console.command\" to listener \"Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure\".","context":{"event":"console.command","listener":"Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"},"level":100,"level_name":"DEBUG","channel":"event","datetime":"2022-11-03T10:44:15.748586+01:00","extra":{}}
fewohbee-php-1  | {"message":"Notified event \"console.command\" to listener \"Symfony\\Bridge\\Monolog\\Handler\\ConsoleHandler::onCommand\".","context":{"event":"console.command","listener":"Symfony\\Bridge\\Monolog\\Handler\\ConsoleHandler::onCommand"},"level":100,"level_name":"DEBUG","channel":"event","datetime":"2022-11-03T10:44:15.748615+01:00","extra":{}}
fewohbee-php-1  | {"message":"Connecting with parameters array{\"driver\":\"pdo_mysql\",\"charset\":\"utf8mb4\",\"url\":\"<redacted>\",\"host\":\"db\",\"port\":3306,\"user\":\"fewohbee\",\"password\":\"<redacted>\",\"driverOptions\":[],\"serverVersion\":\"mariadb-10.8.3\",\"defaultTableOptions\":{\"charset\":\"utf8mb4\",\"collate\":\"utf8mb4_unicode_ci\"},\"dbname\":\"fewohbee\"}","context":{"params":{"driver":"pdo_mysql","charset":"utf8mb4","url":"<redacted>","host":"db","port":3306,"user":"fewohbee","password":"<redacted>","driverOptions":[],"serverVersion":"mariadb-10.8.3","defaultTableOptions":{"charset":"utf8mb4","collate":"utf8mb4_unicode_ci"},"dbname":"fewohbee"}},"level":200,"level_name":"INFO","channel":"doctrine","datetime":"2022-11-03T10:44:15.832508+01:00","extra":{}}
fewohbee-php-1  | {"message":"Error thrown while running command \"--no-interaction 'doctrine:migration:migrate'\". Message: \"An exception 
occurred in the driver: SQLSTATE[HY000] [2002] Connection refused\"","context":{"exception":{"class":"Doctrine\\DBAL\\Exception\\ConnectionException","message":"An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused","code":2002,"file":"/var/www/html/fewohbee/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:101","previous":{"class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","message":"SQLSTATE[HY000] [2002] Connection refused","code":2002,"file":"/var/www/html/fewohbee/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28","previous":{"class":"PDOException","message":"SQLSTATE[HY000] [2002] Connection refused","code":2002,"file":"/var/www/html/fewohbee/vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php:28"}}},"command":"--no-interaction 'doctrine:migration:migrate'","message":"An exception 
occurred in the driver: SQLSTATE[HY000] [2002] Connection refused"},"level":500,"level_name":"CRITICAL","channel":"console","datetime":"2022-11-03T10:44:15.836954+01:00","extra":{}}
fewohbee-php-1  | 10:44:15 CRITICAL  [console] Error thrown while running command "--no-interaction 'doctrine:migration:migrate'". Message: 
"An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused" ["exception" => Doctrine\DBAL\Exception\ConnectionException { …},"command" => "--no-interaction 'doctrine:migration:migrate'","message" => "An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused"]
fewohbee-php-1  | {"message":"Notified event \"console.error\" to listener \"Symfony\\Bundle\\FrameworkBundle\\EventListener\\SuggestMissingPackageSubscriber::onConsoleError\".","context":{"event":"console.error","listener":"Symfony\\Bundle\\FrameworkBundle\\EventListener\\SuggestMissingPackageSubscriber::onConsoleError"},"level":100,"level_name":"DEBUG","channel":"event","datetime":"2022-11-03T10:44:15.869588+01:00","extra":{}}
fewohbee-php-1  | {"message":"Notified event \"console.error\" to listener \"Symfony\\Component\\Console\\EventListener\\ErrorListener::onConsoleError\".","context":{"event":"console.error","listener":"Symfony\\Component\\Console\\EventListener\\ErrorListener::onConsoleError"},"level":100,"level_name":"DEBUG","channel":"event","datetime":"2022-11-03T10:44:15.869669+01:00","extra":{}}
fewohbee-php-1  | {"message":"Command \"--no-interaction 'doctrine:migration:migrate'\" exited with code \"2002\"","context":{"command":"--no-interaction 'doctrine:migration:migrate'","code":2002},"level":100,"level_name":"DEBUG","channel":"console","datetime":"2022-11-03T10:44:15.870109+01:00","extra":{}}
fewohbee-php-1  | {"message":"Notified event \"console.terminate\" to listener \"Symfony\\Component\\Console\\EventListener\\ErrorListener::onConsoleTerminate\".","context":{"event":"console.terminate","listener":"Symfony\\Component\\Console\\EventListener\\ErrorListener::onConsoleTerminate"},"level":100,"level_name":"DEBUG","channel":"event","datetime":"2022-11-03T10:44:15.870197+01:00","extra":{}}
fewohbee-php-1  | {"message":"Notified event \"console.terminate\" to listener \"Symfony\\Bridge\\Monolog\\Handler\\ConsoleHandler::onTerminate\".","context":{"event":"console.terminate","listener":"Symfony\\Bridge\\Monolog\\Handler\\ConsoleHandler::onTerminate"},"level":100,"level_name":"DEBUG","channel":"event","datetime":"2022-11-03T10:44:15.870342+01:00","extra":{}}
fewohbee-php-1  | 
fewohbee-php-1  | In ExceptionConverter.php line 101:
fewohbee-php-1  | 
fewohbee-php-1  |   An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refu
fewohbee-php-1  |   sed
fewohbee-php-1  | 
fewohbee-php-1  | 
fewohbee-php-1  | In Exception.php line 28:
fewohbee-php-1  | 
fewohbee-php-1  |   SQLSTATE[HY000] [2002] Connection refused
fewohbee-php-1  | 
fewohbee-php-1  | 
fewohbee-php-1  | In Driver.php line 28:
fewohbee-php-1  | 
fewohbee-php-1  |   SQLSTATE[HY000] [2002] Connection refused
fewohbee-php-1  | 
fewohbee-php-1  | 
fewohbee-php-1  | doctrine:migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--allow-no-migration] [--all-or-nothing 
[ALL-OR-NOTHING]] [--configuration CONFIGURATION] [--em EM] [--conn CONN] [--] [<version>]
fewohbee-php-1  | 
fewohbee-php-1  | 
fewohbee-php-1  |  // Clearing cache pool: doctrine.result_cache_pool
fewohbee-php-1  | 
fewohbee-php-1  |  // Clearing cache pool: doctrine.system_cache_pool
fewohbee-php-1  | 
fewohbee-php-1  |  [OK] Cache was successfully cleared.
fewohbee-php-1  | 
fewohbee-php-1  | [03-Nov-2022 10:44:16] NOTICE: fpm is running, pid 1
fewohbee-php-1  | [03-Nov-2022 10:44:16] NOTICE: ready to handle connections

DB logs

fewohbee-db-1  | 2022-11-03 09:44:04+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.9.3+maria~ubu2204 started.
fewohbee-db-1  | 2022-11-03 09:44:05+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
fewohbee-db-1  | 2022-11-03 09:44:05+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.9.3+maria~ubu2204 started.        
fewohbee-db-1  | 2022-11-03 09:44:05+00:00 [Note] [Entrypoint]: Initializing database files
fewohbee-db-1  | 2022-11-03  9:44:06 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOMEM: try larger memory locked limit, ulimit 
-l, or https://mariadb.com/kb/en/systemd/#configuring-limitmemlock under systemd (262144 bytes required)
fewohbee-db-1  | 2022-11-03  9:44:06 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
fewohbee-db-1  | 
fewohbee-db-1  | 
fewohbee-db-1  | PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
fewohbee-db-1  | To do so, start the server, then issue the following command:
fewohbee-db-1  | 
fewohbee-db-1  | '/usr/bin/mysql_secure_installation'
fewohbee-db-1  | 
fewohbee-db-1  | which will also give you the option of removing the test
fewohbee-db-1  | databases and anonymous user created by default.  This is
fewohbee-db-1  | strongly recommended for production servers.
fewohbee-db-1  | 
fewohbee-db-1  | See the MariaDB Knowledgebase at https://mariadb.com/kb
fewohbee-db-1  | 
fewohbee-db-1  | Please report any problems at https://mariadb.org/jira
fewohbee-db-1  | 
fewohbee-db-1  | The latest information about MariaDB is available at https://mariadb.org/.
fewohbee-db-1  | 
fewohbee-db-1  | Consider joining MariaDB's strong and vibrant community:
fewohbee-db-1  | https://mariadb.org/get-involved/
fewohbee-db-1  | 
fewohbee-db-1  | 2022-11-03 09:44:26+00:00 [Note] [Entrypoint]: Database files initialized
fewohbee-db-1  | 2022-11-03 09:44:26+00:00 [Note] [Entrypoint]: Starting temporary server
fewohbee-db-1  | 2022-11-03 09:44:26+00:00 [Note] [Entrypoint]: Waiting for server startup
fewohbee-db-1  | 2022-11-03  9:44:26 0 [Note] mariadbd (server 10.9.3-MariaDB-1:10.9.3+maria~ubu2204) starting as process 102 ...
fewohbee-db-1  | 2022-11-03  9:44:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
fewohbee-db-1  | 2022-11-03  9:44:26 0 [Note] InnoDB: Number of transaction pools: 1
fewohbee-db-1  | 2022-11-03  9:44:26 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
fewohbee-db-1  | 2022-11-03  9:44:26 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
fewohbee-db-1  | 2022-11-03  9:44:26 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOMEM: try larger memory locked limit, ulimit 
-l, or https://mariadb.com/kb/en/systemd/#configuring-limitmemlock under systemd (262144 bytes required)
fewohbee-db-1  | 2022-11-03  9:44:26 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
fewohbee-db-1  | 2022-11-03  9:44:26 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
fewohbee-db-1  | 2022-11-03  9:44:26 0 [Note] InnoDB: Completed initialization of buffer pool
fewohbee-db-1  | 2022-11-03  9:44:26 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
fewohbee-db-1  | 2022-11-03  9:44:26 0 [Note] InnoDB: 128 rollback segments are active.
fewohbee-db-1  | 2022-11-03  9:44:26 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
fewohbee-db-1  | 2022-11-03  9:44:26 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
fewohbee-db-1  | 2022-11-03  9:44:26 0 [Note] InnoDB: log sequence number 46488; transaction id 14
fewohbee-db-1  | 2022-11-03  9:44:26 0 [Note] Plugin 'FEEDBACK' is disabled.
fewohbee-db-1  | 2022-11-03  9:44:26 0 [Warning] 'user' entry 'root@4983e84f8467' ignored in --skip-name-resolve mode.
fewohbee-db-1  | 2022-11-03  9:44:26 0 [Warning] 'proxies_priv' entry '@% root@4983e84f8467' ignored in --skip-name-resolve mode.
fewohbee-db-1  | 2022-11-03  9:44:26 0 [Note] mariadbd: ready for connections.
fewohbee-db-1  | Version: '10.9.3-MariaDB-1:10.9.3+maria~ubu2204'  socket: '/run/mysqld/mysqld.sock'  port: 0  mariadb.org binary distribution
fewohbee-db-1  | 2022-11-03 09:44:27+00:00 [Note] [Entrypoint]: Temporary server started.
fewohbee-db-1  | 2022-11-03 09:44:30+00:00 [Note] [Entrypoint]: Creating database fewohbee
fewohbee-db-1  | 2022-11-03 09:44:30+00:00 [Note] [Entrypoint]: Creating user fewohbee
fewohbee-db-1  | 2022-11-03 09:44:30+00:00 [Note] [Entrypoint]: Giving user fewohbee access to schema fewohbee
fewohbee-db-1  | 2022-11-03 09:44:30+00:00 [Note] [Entrypoint]: Securing system users (equivalent to running mysql_secure_installation)     
fewohbee-db-1  | 
fewohbee-db-1  | 2022-11-03 09:44:30+00:00 [Note] [Entrypoint]: Stopping temporary server
fewohbee-db-1  | 2022-11-03  9:44:30 0 [Note] mariadbd (initiated by: unknown): Normal shutdown
fewohbee-db-1  | 2022-11-03  9:44:30 0 [Note] InnoDB: FTS optimize thread exiting.
fewohbee-db-1  | 2022-11-03  9:44:30 0 [Note] InnoDB: Starting shutdown...
fewohbee-db-1  | 2022-11-03  9:44:30 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
fewohbee-db-1  | 2022-11-03  9:44:30 0 [Note] InnoDB: Buffer pool(s) dump completed at 221103  9:44:30
fewohbee-db-1  | 2022-11-03  9:44:30 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
fewohbee-db-1  | 2022-11-03  9:44:30 0 [Note] InnoDB: Shutdown completed; log sequence number 46488; transaction id 15
fewohbee-db-1  | 2022-11-03  9:44:30 0 [Note] mariadbd: Shutdown complete
fewohbee-db-1  | 
fewohbee-db-1  | 2022-11-03 09:44:30+00:00 [Note] [Entrypoint]: Temporary server stopped
fewohbee-db-1  | 
fewohbee-db-1  | 2022-11-03 09:44:30+00:00 [Note] [Entrypoint]: MariaDB init process done. Ready for start up.
fewohbee-db-1  | 
fewohbee-db-1  | 2022-11-03  9:44:30 0 [Note] mariadbd (server 10.9.3-MariaDB-1:10.9.3+maria~ubu2204) starting as process 1 ...
fewohbee-db-1  | 2022-11-03  9:44:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
fewohbee-db-1  | 2022-11-03  9:44:30 0 [Note] InnoDB: Number of transaction pools: 1
fewohbee-db-1  | 2022-11-03  9:44:30 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
fewohbee-db-1  | 2022-11-03  9:44:30 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
fewohbee-db-1  | 2022-11-03  9:44:30 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOMEM: try larger memory locked limit, ulimit 
-l, or https://mariadb.com/kb/en/systemd/#configuring-limitmemlock under systemd (262144 bytes required)
fewohbee-db-1  | 2022-11-03  9:44:30 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
fewohbee-db-1  | 2022-11-03  9:44:30 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
fewohbee-db-1  | 2022-11-03  9:44:30 0 [Note] InnoDB: Completed initialization of buffer pool
fewohbee-db-1  | 2022-11-03  9:44:32 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
fewohbee-db-1  | 2022-11-03  9:44:32 0 [Note] InnoDB: 128 rollback segments are active.
fewohbee-db-1  | 2022-11-03  9:44:32 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
fewohbee-db-1  | 2022-11-03  9:44:32 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
fewohbee-db-1  | 2022-11-03  9:44:32 0 [Note] InnoDB: log sequence number 46488; transaction id 14
fewohbee-db-1  | 2022-11-03  9:44:32 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
fewohbee-db-1  | 2022-11-03  9:44:32 0 [Note] Plugin 'FEEDBACK' is disabled.
fewohbee-db-1  | 2022-11-03  9:44:32 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
fewohbee-db-1  | 2022-11-03  9:44:32 0 [Note] Server socket created on IP: '0.0.0.0'.
fewohbee-db-1  | 2022-11-03  9:44:32 0 [Note] Server socket created on IP: '::'.
fewohbee-db-1  | 2022-11-03  9:44:32 0 [Note] InnoDB: Buffer pool(s) load completed at 221103  9:44:32
fewohbee-db-1  | 2022-11-03  9:44:32 0 [Note] mariadbd: ready for connections.
fewohbee-db-1  | Version: '10.9.3-MariaDB-1:10.9.3+maria~ubu2204'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
developeregrem commented 2 years ago

Hi, currently I'm not able to reproduce the issue. I've tested different setups :( Are you using debian/ubuntu or something else? Please try to reset everthing again and also delete the fewohbee folder inside /opt/data The only thing I can see based on the logs is that the db server might be up an running too late and the connection is required earlier. So what you can also try to do is add another short delay here: https://github.com/developeregrem/fewohbee-dockerized/blob/53eec58bdde5d9be3d58516e4975d202b0132696/install.sh#L194

sleep 5
dnyamy commented 2 years ago

Hello, Yes I am using Ubuntu 20.04

I did as you said

No error appear. But still I can't see the temp password

$docker-compose logs php
fewohbee-php-1  | HEAD is now at 535b1fd Merge pull request #60 from developeregrem/3.3.0-dev
fewohbee-php-1  | Installing dependencies from lock file
fewohbee-php-1  | Verifying lock file contents can be installed on current platform.
fewohbee-php-1  | Nothing to install, update or remove
fewohbee-php-1  | Generating optimized autoload files
fewohbee-php-1  | Class App\Entity\SpecialDays located in ./src/Entity/SpecialDay.php does not comply with psr-4 autoloading standard. Skipping.
fewohbee-php-1  | 78 packages you are using are looking for funding.
fewohbee-php-1  | Use the `composer fund` command to find out more!
fewohbee-php-1  | 
fewohbee-php-1  | Run composer recipes at any time to see the status of your Symfony recipes.
fewohbee-php-1  | 
fewohbee-php-1  | Executing script cache:clear [OK]
fewohbee-php-1  | Executing script assets:install public [OK]
fewohbee-php-1  | 
fewohbee-php-1  | [notice] Migrating up to DoctrineMigrations\Version20220820130837
fewohbee-php-1  | [warning] Migration DoctrineMigrations\Version20190906160425 was executed but did not result in any SQL statements.   
fewohbee-php-1  | [warning] Migration DoctrineMigrations\Version20190915110513 was executed but did not result in any SQL statements.   
fewohbee-php-1  | [notice] finished in 32850.4ms, used 10M memory, 14 migrations executed, 101 sql queries
fewohbee-php-1  | 
fewohbee-php-1  | 
fewohbee-php-1  |  // Clearing cache pool: doctrine.result_cache_pool
fewohbee-php-1  | 
fewohbee-php-1  |  // Clearing cache pool: doctrine.system_cache_pool
fewohbee-php-1  | 
fewohbee-php-1  |  [OK] Cache was successfully cleared.
fewohbee-php-1  | 
fewohbee-php-1  | [07-Nov-2022 11:04:53] NOTICE: fpm is running, pid 1
fewohbee-php-1  | [07-Nov-2022 11:04:53] NOTICE: ready to handle connections
fewohbee-php-1  | 172.26.0.4 -  07/Nov/2022:11:05:33 +0100 "GET /index.php" 302
fewohbee-php-1  | 172.26.0.4 -  07/Nov/2022:11:05:35 +0100 "GET /index.php" 200
fewohbee-php-1  | 172.26.0.4 -  07/Nov/2022:11:06:31 +0100 "GET /index.php" 200
docker-compose logs db 
fewohbee-db-1  | 2022-11-07 10:04:04+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.9.3+maria~ubu2204 started.
fewohbee-db-1  | 2022-11-07 10:04:05+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
fewohbee-db-1  | 2022-11-07 10:04:05+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.9.3+maria~ubu2204 started.    
fewohbee-db-1  | 2022-11-07 10:04:07+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
fewohbee-db-1  | 2022-11-07 10:04:07 0 [Note] mariadbd (server 10.9.3-MariaDB-1:10.9.3+maria~ubu2204) starting as process 1 ...
fewohbee-db-1  | 2022-11-07 10:04:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
fewohbee-db-1  | 2022-11-07 10:04:07 0 [Note] InnoDB: Number of transaction pools: 1
fewohbee-db-1  | 2022-11-07 10:04:07 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
fewohbee-db-1  | 2022-11-07 10:04:07 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
fewohbee-db-1  | 2022-11-07 10:04:07 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOMEM: try larger memory locked limit, ulimit -l, or https://mariadb.com/kb/en/systemd/#configuring-limitmemlock under systemd (262144 bytes required)
fewohbee-db-1  | 2022-11-07 10:04:07 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
fewohbee-db-1  | 2022-11-07 10:04:07 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
fewohbee-db-1  | 2022-11-07 10:04:07 0 [Note] InnoDB: Completed initialization of buffer pool
fewohbee-db-1  | 2022-11-07 10:04:07 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
fewohbee-db-1  | 2022-11-07 10:04:07 0 [Note] InnoDB: 128 rollback segments are active.
fewohbee-db-1  | 2022-11-07 10:04:07 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
fewohbee-db-1  | 2022-11-07 10:04:07 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
fewohbee-db-1  | 2022-11-07 10:04:07 0 [Note] InnoDB: log sequence number 46488; transaction id 14
fewohbee-db-1  | 2022-11-07 10:04:07 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
fewohbee-db-1  | 2022-11-07 10:04:07 0 [Note] Plugin 'FEEDBACK' is disabled.
fewohbee-db-1  | 2022-11-07 10:04:07 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
fewohbee-db-1  | 2022-11-07 10:04:07 0 [Note] InnoDB: Buffer pool(s) load completed at 221107 10:04:07
fewohbee-db-1  | 2022-11-07 10:04:07 0 [Note] Server socket created on IP: '0.0.0.0'.
fewohbee-db-1  | 2022-11-07 10:04:07 0 [Note] Server socket created on IP: '::'.
fewohbee-db-1  | 2022-11-07 10:04:07 0 [Note] mariadbd: ready for connections.
fewohbee-db-1  | Version: '10.9.3-MariaDB-1:10.9.3+maria~ubu2204'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution

Thanks

developeregrem commented 2 years ago

Did you run ./install.sh after reset or just docker-compose up -d? You should be asked to define your own credentials ... But you can perform this action manually too:

docker-compose exec --user www-data php /bin/sh -c "php fewohbee/bin/console app:first-run"

and afterwards

docker-compose exec --user www-data php /bin/sh -c "php fewohbee/bin/console doctrine:fixtures:load --append"
dnyamy commented 2 years ago

Hello, I have tried many times The error message does give a bit more details But still, no password I have even tried to define manually with your command Getting the same error


fewohbee-php-1  | In ExceptionConverter.php line 101:
fewohbee-php-1  |
fewohbee-php-1  |   An exception occurred in the driver: SQLSTATE[HY000] [1045] Access denied f
fewohbee-php-1  |   or user 'fewohbee'@'192.168.48.4' (using password: YES)
fewohbee-php-1  |
fewohbee-php-1  |
fewohbee-php-1  | In Exception.php line 28:
fewohbee-php-1  |
fewohbee-php-1  |   SQLSTATE[HY000] [1045] Access denied for user 'fewohbee'@'192.168.48.4' (us
fewohbee-php-1  |   ing password: YES)
fewohbee-php-1  |
fewohbee-php-1  |
fewohbee-php-1  | In Driver.php line 28:
fewohbee-php-1  |
fewohbee-php-1  |   SQLSTATE[HY000] [1045] Access denied for user 'fewohbee'@'192.168.48.4' (us
fewohbee-php-1  |   ing password: YES)
developeregrem commented 2 years ago

This is very strange :( The only thing I would do is to do a complete reset of the installation again (and keep your sleepin the install.sh file)

cd /opt/fewohbee-dockerized
./cleanup.sh
rm .env
rm -r ../data/fewohbee
./install.sh

After install you should also check whether you can login to the db manually

docker-compose exec db /bin/bash
mysql -p$MYSQL_PASSWORD -u$MYSQL_USER $MYSQL_DATABASE
show tables;

If the login is working than the user should work as expected (2x Strg+D at the end to exit the db and the container)

dnyamy commented 2 years ago

Another new error, After cleanup, rm .env ...

In ExceptionConverter.php line 49:

  An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fewohbee.reservation_origins' doesn't exist

In Exception.php line 28:

  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fewohbee.reservation_origins' doesn't exist

In Statement.php line 134:

  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fewohbee.reservation_origins' doesn't exist
developeregrem commented 1 year ago

Hi, sorry for the late response. I'm not able to reproduce the issue either when using ubutnu. Maybe you can try the version without docker/docker-compose. See LAMP-Stack:-Apache,-MySQL,-PHP-(Ubuntu-22)

dnyamy commented 1 year ago

Thanks for this reply,

I have tried and am experiencing issues also with that method. https://github.com/developeregrem/fewohbee/issues/75

I looks forward to trying the application.

dnyamy commented 1 year ago

Hello, I try to switch back to dockerized version I have started all over

docker-compose exec db /bin/bash
mysql -p$MYSQL_PASSWORD -u$MYSQL_USER $MYSQL_DATABASE

I am able to login to db manually now But DB is empty. 

MariaDB [fewohbee]> show tables;
Empty set (0.001 sec)

MariaDB [fewohbee]>

Is that normal ? I guess that is why the user cannot be created 

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fewohbee.users' doesn't exist
developeregrem commented 1 year ago

Something in your setup/installation seems to be broken :( But I have no idea what went wrong. The database must be filled if no errors occurred during setup process. I guess you will find some messages in docker-compose logs php? I can provide you a demo access to a running version of fewohbee if you want to play a bit with the application. Please email me to info @ fewohbee.de if you are interested and I provide you credentials.