starred/koel-koel

Fork 0

mirror of https://github.com/koel/koel.git synced 2026-04-25 16:56:02 +03:00

[GH-ISSUE #581] Can't login 500 Internal Server Error at POST me #420

New issue

Closed

opened 2026-02-26 02:33:09 +03:00 by kerem · 4 comments

kerem commented

2026-02-26 02:33:09 +03:00

Owner

Originally created by @fanat98 on GitHub (Apr 24, 2017).
Original GitHub issue: https://github.com/koel/koel/issues/581

Hey, I just installed koel v3.6.2 on Ubuntu 16.04, use PHP 7.0 and Nginx
After enter my email and PW is keeping me on the login page
does do nothing.
Firebug Network: 500 Internal Server Error and tab HTML:

QueryException in Connection.php line 647: Database (/var/www/koel/config/../database/e2e.sqlite) does not exist. (SQL: select * from "users" where "email" = admin@admin.dev limit 1)

but i dont use sqlite, DB_CONNECTION=mysql

Can you please help? Thanks!

Originally created by @fanat98 on GitHub (Apr 24, 2017). Original GitHub issue: https://github.com/koel/koel/issues/581 Hey, I just installed koel v3.6.2 on Ubuntu 16.04, use PHP 7.0 and Nginx After enter my email and PW is keeping me on the login page does do nothing. Firebug Network: 500 Internal Server Error and tab HTML: ``` QueryException in Connection.php line 647: Database (/var/www/koel/config/../database/e2e.sqlite) does not exist. (SQL: select * from "users" where "email" = admin@admin.dev limit 1) ``` but i dont use sqlite, DB_CONNECTION=mysql Can you please help? Thanks!

kerem closed this issue

2026-02-26 02:33:09 +03:00

kerem commented

2026-02-26 02:33:09 +03:00

Author

Owner

@mtuchi commented on GitHub (May 2, 2017):

In my case i was missing the APP_KEY and the JWT_SECRET
if you used php artisan koel:init. Then these key are suppose to be generated for you
If not then make sure the following are correct,

1. Database connection name, which corresponds to the database driver.

# Possible values are: 
mysql (MySQL/MariaDB - default)
pgsql (PostgreSQL)
sqlsrv (Microsoft SQL Server)
In mycase i am using **mariadb** so
DB_CONNECTION=mysql
etc..

2. APP_KEY. use`php artisan key:generate`.

APP_KEY=(A random 32-char string will be generated here)

3. JWT_SECRET. use `php artisan koel:generate-jwt-secret`.

JWT_SECRET=( Another random 32-char string)

@mtuchi commented on GitHub (May 2, 2017): In my case i was missing the `APP_KEY` and the `JWT_SECRET` if you used `php artisan koel:init`. Then these key are suppose to be generated for you If not then make sure the following are correct, ### 1. Database connection name, which corresponds to the database driver. ``` # Possible values are: mysql (MySQL/MariaDB - default) pgsql (PostgreSQL) sqlsrv (Microsoft SQL Server) In mycase i am using **mariadb** so DB_CONNECTION=mysql etc.. ``` #### 2. APP_KEY. use`php artisan key:generate`. ``` APP_KEY=(A random 32-char string will be generated here) ``` #### 3. JWT_SECRET. use `php artisan koel:generate-jwt-secret`. ``` JWT_SECRET=( Another random 32-char string) ```

kerem commented

2026-02-26 02:33:09 +03:00

Author

Owner

@fanat98 commented on GitHub (May 2, 2017):

Hi @mtuchi Thank you for your answer.

DB connection is correct mysql
& 3) APP_KEY and JWT_SECRET are also correct.

I suspect that, something with nginx config is not correct, because when I start it with php artisan serve then works :(.

@fanat98 commented on GitHub (May 2, 2017): Hi @mtuchi Thank you for your answer. 1. DB connection is correct `mysql` 2. & 3) `APP_KEY` and `JWT_SECRET` are also correct. I suspect that, something with nginx config is not correct, because when I start it with `php artisan serve` then works :(.

kerem commented

2026-02-26 02:33:09 +03:00

Author

Owner

@nikohd12 commented on GitHub (May 4, 2017):

@fanat98

Try changing your settings in your .env, change it to mysql.

I also think there's some misconfiguration from your nginx config. Just use the one's provided in nginx.conf.example, if you're going to host it locally, change the 127.0.0.1:9000 to php-fpm.sock

@nikohd12 commented on GitHub (May 4, 2017): @fanat98 Try changing your settings in your .env, change it to mysql. I also think there's some misconfiguration from your nginx config. Just use the one's provided in nginx.conf.example, if you're going to host it locally, change the 127.0.0.1:9000 to php-fpm.sock

kerem commented

2026-02-26 02:33:09 +03:00

Author

Owner

@fanat98 commented on GitHub (May 4, 2017):

HI @nikojaro Thank you for answer.

I use already mysql.

I fixed it. The problem was the port, it was :8081, i changed it to :80 and now it is fine.

@fanat98 commented on GitHub (May 4, 2017): HI @nikojaro Thank you for answer. I use already mysql. I fixed it. The problem was the port, it was :8081, i changed it to :80 and now it is fine.

kerem referenced this issue

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

[PR #420] [MERGED] Clean UserTableSeeder #1245

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#420

No description provided.

Rows
Columns

[GH-ISSUE #581] Can't login 500 Internal Server Error at POST me #420

1. Database connection name, which corresponds to the database driver.

2. APP_KEY. usephp artisan key:generate.

3. JWT_SECRET. use php artisan koel:generate-jwt-secret.

2. APP_KEY. use`php artisan key:generate`.

3. JWT_SECRET. use `php artisan koel:generate-jwt-secret`.