Replies: 5 comments 5 replies
-
|
Installing it manually outside portainer, everything works fine, APP_KEY is now presentm but the only thing i'm geeting is a server 500 address :( |
Beta Was this translation helpful? Give feedback.
-
|
What do the logs say? You can check them with |
Beta Was this translation helpful? Give feedback.
-
|
Starting Migration... Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: select table_name as at vendor/laravel/framework/src/Illuminate/Database/Connection.php:829 40 artisan:35 Creating caches... INFO Configuration cached successfully. INFO Blade templates cached successfully. [02-Feb-2025 20:52:42] NOTICE: fpm is running, pid 19 |
Beta Was this translation helpful? Give feedback.
-
|
The application seems to have no connection to the MySQL container. Unfortunately I have no experience with Portainer. Do you have other services running with a separate database container? Are there any config files for the Docker containers or how do you manage them? |
Beta Was this translation helpful? Give feedback.
-
|
You can also use a SQLite database in the application container, without the need for an additional container. |
Beta Was this translation helpful? Give feedback.
-
|
I have tried installing Servas with both databases, MySQL and and I keep
getting - 'Connection refused'.
My setup:
TrueNAS Scale ElectricEel-24.10.2
Dockge
Servas is perfect for me and I would hate to give up!
Log:
servas | Starting Migration...
servas |
servas | Illuminate\Database\QueryException
servas |
servas | SQLSTATE[HY000] [2002] Connection refused (Connection: mysql,
SQL: select table_name as `name`, (data_length + index_length) as `size`,
table_comment as `comment`, engine as `engine`, table_collation as
`collation` from information_schema.tables where table_schema = 'forge' and
table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name)
servas |
servas | at
vendor/laravel/framework/src/Illuminate/Database/Connection.php:829
servas | 825▕ $this->getName(), $query,
$this->prepareBindings($bindings), $e
servas | 826▕ );
servas | 827▕ }
servas | 828▕
servas | ➜ 829▕ throw new QueryException(
servas | 830▕ $this->getName(), $query,
$this->prepareBindings($bindings), $e
servas | 831▕ );
servas | 832▕ }
servas | 833▕ }
servas |
servas | +39 vendor frames
servas |
servas | 40 artisan:35
servas | Illuminate\Foundation\Console\Kernel::handle()
servas |
servas | Creating caches...
servas |
servas | INFO Configuration cached successfully.
servas |
servas |
servas | INFO Blade templates cached successfully.
servas |
servas | [05-Feb-2025 18:08:49] NOTICE: fpm is running, pid 19
servas | [05-Feb-2025 18:08:49] NOTICE: ready to handle connections
…On Wed, Feb 5, 2025 at 2:50 AM Henrik ***@***.***> wrote:
You can also use a SQLite database in the application container, without
the need for an additional container.
https://github.com/beromir/Servas/tree/main/docker/sqlite-example
—
Reply to this email directly, view it on GitHub
<#98 (reply in thread)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AARYC2S7KEPFW6NWSTRLVHL2OG7CTAVCNFSM6AAAAABRKXU366VHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTEMBWGQZTSMY>
.
You are receiving this because you commented.Message ID:
***@***.***>
--
Regards,
Neil
|
Beta Was this translation helpful? Give feedback.
-
|
Have you enabled SQLite in the .env file? |
Beta Was this translation helpful? Give feedback.
-
|
Hey.
These are the files with logs.
Hope you can see what I'm doing wrong!
Both of these files are in the same folder.
# docker-compose.yaml
services:
servas:
image: beromir/servas
container_name: servas
restart: unless-stopped
ports:
- "8080:80"
volumes:
- ./.env:/var/www/html/.env
- /mnt/tank0/docker/servas/data:/var/www/html/database/sqlite
# .env
APP_NAME=Servas
APP_ENV=production
APP_KEY=
APP_DEBUG=false
APP_URL=http://192.168.1.30:8080
SERVAS_ENABLE_REGISTRATION=true
# SQLite
DB_CONNECTION=sqlite
DB_DATABASE=/var/www/html/database/sqlite/servas.db
DB_FOREIGN_KEYS=true
# Log
Starting Migration...
INFO Preparing database.
Creating migration table ......................................... 11ms
DONE
INFO Loading stored database schemas.
database/schema/sqlite-schema.dump .............................. 178ms
DONE
INFO Running migrations.
2022_08_11_143315_add_two_factor_confirmed_column_to_users_table .. 6ms
DONE
2022_11_26_194415_remove_media_type_column_from_links_table ...... 56ms
DONE
2023_03_19_203332_add_expires_at_column_to_personal_access_tokens_table
5ms DONE
2023_04_30_173655_drop_later_table ................................ 5ms
DONE
2024_02_19_210136_increase_link_column_size ...................... 19ms
DONE
2024_03_02_180621_create_public_links_tables ..................... 21ms
DONE
2024_04_05_185606_add_query_options_columns_to_groups_table ...... 11ms
DONE
Creating caches...
INFO Configuration cached successfully.
INFO Blade templates cached successfully.
[07-Feb-2025 12:00:05] NOTICE: fpm is running, pid 20
[07-Feb-2025 12:00:05] NOTICE: ready to handle connections
127.0.0.1 - 07/Feb/2025:12:01:23 +0000 "GET /index.php" 500
127.0.0.1 - 07/Feb/2025:12:01:30 +0000 "GET /index.php" 500
127.0.0.1 - 07/Feb/2025:12:01:54 +0000 "GET /index.php" 500
127.0.0.1 - 07/Feb/2025:12:02:19 +0000 "GET /index.php" 500
…On Fri, Feb 7, 2025 at 4:14 AM Henrik ***@***.***> wrote:
Have you enabled SQLite in the .env file?
# SQLite
DB_CONNECTION=sqlite
DB_DATABASE=/var/www/html/database/sqlite/servas.db
DB_FOREIGN_KEYS=true
—
Reply to this email directly, view it on GitHub
<#98 (reply in thread)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AARYC2Q6QUNFGLWVVJRSIC32OR2PXAVCNFSM6AAAAABRKXU366VHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTEMBZGE3TQNI>
.
You are receiving this because you commented.Message ID:
***@***.***>
--
Regards,
Neil
|
Beta Was this translation helpful? Give feedback.
-
|
Hey, docker exec -it servas php artisan key:generate --force |
Beta Was this translation helpful? Give feedback.
-
|
The sqlite version is now working. Thank you.
I would really like to get the mariadb version working.
Here are my files with errors:
#docker-compose.yaml
services:
db:
image: mariadb:10.7.3
container_name: servas_db
restart: unless-stopped
command: mysqld --character-set-server=utf8mb4
--collation-server=utf8mb4_bin
environment:
- MARIADB_ROOT_PASSWORD=${DB_PASSWORD}
- MARIADB_USER=${DB_USERNAME}
- MARIADB_PASSWORD=${DB_PASSWORD}
- MARIADB_DATABASE=${DB_DATABASE}
volumes:
- /mnt/tank0/docker/servas/data:/var/lib/mysql
servas:
image: beromir/servas
container_name: servas
restart: unless-stopped
depends_on:
- db
ports:
- "8080:80"
volumes:
- ./.env:/var/www/html/.env
#.env
APP_NAME=Servas
APP_ENV=production
APP_KEY=
APP_DEBUG=false
APP_URL=http://192.168.1.30:8080
SERVAS_ENABLE_REGISTRATION=true
DB_CONNECTION=mysql
DB_HOST=db
DB_PORT=3306
DB_DATABASE=servas_db
DB_USERNAME=root
DB_PASSWORD=password12345678
#error
Starting Migration...
Illuminate\Database\QueryException
SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: select
table_name as `name`, (data_length + index_length) as `size`, table_comment
as `comment`, engine as `engine`, table_collation as `collation` from
information_schema.tables where table_schema = 'servas_db' and table_type
in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name)
at vendor/laravel/framework/src/Illuminate/Database/Connection.php:829
825▕ $this->getName(), $query,
$this->prepareBindings($bindings), $e
826▕ );
827▕ }
828▕
➜ 829▕ throw new QueryException(
830▕ $this->getName(), $query,
$this->prepareBindings($bindings), $e
831▕ );
832▕ }
833▕ }
+39 vendor frames
40 artisan:35
Illuminate\Foundation\Console\Kernel::handle()
Creating caches...
INFO Configuration cached successfully.
INFO Blade templates cached successfully.
[08-Feb-2025 14:26:12] NOTICE: fpm is running, pid 19
[08-Feb-2025 14:26:12] NOTICE: ready to handle connections
…On Fri, Feb 7, 2025 at 8:11 AM Henrik ***@***.***> wrote:
Hey,
this looks good, the database connection is now working and the migrations
are complete.
Now you have to generate an application key:
docker exec -it servas php artisan key:generate --force
—
Reply to this email directly, view it on GitHub
<#98 (reply in thread)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AARYC2QWKBHPGMV42JDTE7L2OSWGTAVCNFSM6AAAAABRKXU366VHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTEMBZGQYTQNI>
.
You are receiving this because you commented.Message ID:
***@***.***>
--
Regards,
Neil
|
Beta Was this translation helpful? Give feedback.
-
Is there a way to get an APP_KEY when i'm using portainer to handle all my stacks? In that case, the
docker exec -it servas php artisan key:generate --force
is giving a dumo saying no .env file with APP_KEY, what is true of course.
Any other way to create an APP_KEY and put it nto the yaml?
Beta Was this translation helpful? Give feedback.
All reactions