starred/koel-koel

Fork 0

mirror of https://github.com/koel/koel.git synced 2026-04-26 09:15:59 +03:00

[GH-ISSUE #1801] [Bug]: Fresh install fail (Pre-compiled) #997

New issue

Closed

opened 2026-02-26 02:34:53 +03:00 by kerem · 4 comments

kerem commented

2026-02-26 02:34:53 +03:00

Owner

Originally created by @kazukyakayashi on GitHub (Jul 22, 2024).
Original GitHub issue: https://github.com/koel/koel/issues/1801

Originally assigned to: @phanan on GitHub.

Read the Troubleshooting guide.

I have read and followed the Troubleshooting guide

Reproduction steps

I wanted to install Koel* on my personal server at home (currently with OVH) but it doesn't work.

This is a new installation to see if it works properly on my server (and not the migration of my instance to OVH).

create my DB and DB user
download and unzip Koel archive
use php artisan koel:init --no-assets
I put the information for the db connection
... fail

Expected behavior

Success

Actual behavior

php artisan koel:init --no-assets
************************************
*     KOEL INSTALLATION WIZARD     *
************************************

As a reminder, you can always install/upgrade manually following the guide at https://docs.koel.dev

  Clearing caches ........................................................................................................................ 15ms DONE
  .env file exists -- skipping ................................................................................................................ DONE
  Retrieving app key ...................................................................................................................... 0ms DONE
  Using app key: base64:F02Npehcj.. ........................................................................................................... DONE
  Migrating database ..................................................................................................................... 16ms FAIL

   ERROR  Oops! Koel installation or upgrade didn't finish successfully.  

   ERROR  Please check the error log at storage/logs/laravel.log and try again.  

   ERROR  For further troubleshooting, visit https://docs.koel.dev/troubleshooting.  

   ERROR  😥 Sorry for this. You deserve better.

Logs

logs : https://paste.hostux.net/?3090a465ce726779#2na6oE3hj7SubwvA69fvibi1vR99nEYRE76XGNMTaUGc

Koel version

7.0.8

How did you install Koel?

Pre-compiled tar/zip archive

Additional information

Server OS: Debian bullseye
PHP version: 8.2
Database: Postresql
Node version: -
Additional context:

Originally created by @kazukyakayashi on GitHub (Jul 22, 2024). Original GitHub issue: https://github.com/koel/koel/issues/1801 Originally assigned to: @phanan on GitHub. ### Read the Troubleshooting guide. - [X] I have read and followed the Troubleshooting guide ### Reproduction steps I wanted to install Koel* on my personal server at home (currently with OVH) but it doesn't work. * This is a new installation to see if it works properly on my server (and not the migration of my instance to OVH). 1. create my DB and DB user 2. download and unzip Koel archive 3. use `php artisan koel:init --no-assets` 4. I put the information for the db connection 5. ... fail ### Expected behavior Success ### Actual behavior ``` php artisan koel:init --no-assets ************************************ * KOEL INSTALLATION WIZARD * ************************************ As a reminder, you can always install/upgrade manually following the guide at https://docs.koel.dev Clearing caches ........................................................................................................................ 15ms DONE .env file exists -- skipping ................................................................................................................ DONE Retrieving app key ...................................................................................................................... 0ms DONE Using app key: base64:F02Npehcj.. ........................................................................................................... DONE Migrating database ..................................................................................................................... 16ms FAIL ERROR Oops! Koel installation or upgrade didn't finish successfully. ERROR Please check the error log at storage/logs/laravel.log and try again. ERROR For further troubleshooting, visit https://docs.koel.dev/troubleshooting. ERROR 😥 Sorry for this. You deserve better. ``` ### Logs logs : https://paste.hostux.net/?3090a465ce726779#2na6oE3hj7SubwvA69fvibi1vR99nEYRE76XGNMTaUGc ### Koel version 7.0.8 ### How did you install Koel? Pre-compiled tar/zip archive ### Additional information - **Server OS**: Debian bullseye - **PHP version**: 8.2 - **Database**: Postresql - **Node version**: - - **Additional context**:

kerem closed this issue

2026-02-26 02:34:53 +03:00

kerem commented

2026-02-26 02:34:53 +03:00

Author

Owner

@phanan commented on GitHub (Jul 22, 2024):

The error is right there in the log: Your PostgreSQL user doesn't have enough privileges.

[2024-07-22 16:22:25] production.ERROR: PDOException: SQLSTATE[42501]: Insufficient privilege: 7 ERROR: permission denied for schema public at character 14 in /var/www/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:587

@phanan commented on GitHub (Jul 22, 2024): The error is right there in the log: Your PostgreSQL user doesn't have enough privileges. > [2024-07-22 16:22:25] production.ERROR: PDOException: SQLSTATE[42501]: Insufficient privilege: 7 ERROR: permission denied for schema public at character 14 in /var/www/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:587

kerem commented

2026-02-26 02:34:53 +03:00

Author

Owner

@kazukyakayashi commented on GitHub (Jul 22, 2024):

My user has full privileges

GRANT ALL PRIVILEGES ON DATABASE my_db TO my_user;

I even tried what not to do.

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO myuser;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO myuser;
GRANT ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA public TO myuser;

Without success

@kazukyakayashi commented on GitHub (Jul 22, 2024): My user has full privileges ``` GRANT ALL PRIVILEGES ON DATABASE my_db TO my_user; ``` I even tried what not to do. ``` GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO myuser; GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO myuser; GRANT ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA public TO myuser; ``` Without success

kerem commented

2026-02-26 02:34:53 +03:00

Author

Owner

@phanan commented on GitHub (Jul 22, 2024):

I can't debug that for you, but the log says it's a database permission error. 100% this is not a Koel issue. Try this StackOverflow question and answer: https://stackoverflow.com/questions/75352342/permission-denied-for-schema-public-at-character-x.

@phanan commented on GitHub (Jul 22, 2024): I can't debug that for you, but the log says it's a database permission error. 100% this is not a Koel issue. Try this StackOverflow question and answer: https://stackoverflow.com/questions/75352342/permission-denied-for-schema-public-at-character-x.

kerem commented

2026-02-26 02:34:53 +03:00

Author

Owner

@kazukyakayashi commented on GitHub (Jul 22, 2024):

I absolutely don't understand why it doesn't work ..., I did exactly the same thing as I did when I installed Koel on my OVH server.

Je vois pas ce qui ne va pas :

   Name    |  Owner   | Encoding | Collate |  Ctype  | ICU Locale | Locale Provider |   Access privileges   
-----------+----------+----------+---------+---------+------------+-----------------+-----------------------
 koel      | freebox  | UTF8     | C.UTF-8 | C.UTF-8 |            | libc            | =Tc/freebox          +
           |          |          |         |         |            |                 | freebox=CTc/freebox

Nothing seems to be working ...
Thanks for the link but unfortunately I've already done that.
I'll look into it but...

@kazukyakayashi commented on GitHub (Jul 22, 2024): I absolutely don't understand why it doesn't work ..., I did exactly the same thing as I did when I installed Koel on my OVH server. Je vois pas ce qui ne va pas : ``` Name | Owner | Encoding | Collate | Ctype | ICU Locale | Locale Provider | Access privileges -----------+----------+----------+---------+---------+------------+-----------------+----------------------- koel | freebox | UTF8 | C.UTF-8 | C.UTF-8 | | libc | =Tc/freebox + | | | | | | | freebox=CTc/freebox ``` Nothing seems to be working ... Thanks for the link but unfortunately I've already done that. I'll look into it but...

kerem referenced this issue

2026-02-26 03:31:17 +03:00

[PR #996] [CLOSED] Bump facebook/webdriver from 1.6.0 to 1.7.1 #1507

kerem referenced this issue

2026-02-26 03:31:17 +03:00

[PR #997] [MERGED] Apply fixes from StyleCI #1508

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

starred/koel-koel#997

No description provided.

Rows
Columns