Issue with php artisan migrate --seed on Ubuntu 24.04

[JET-9]

Hello dbarzin,

I am following your documentation to set up the project. Everything went well until I ran the command php artisan migrate --seed. However, I encountered the following error:

Steps I have taken to troubleshoot:
I have correctly configured the database credentials in the .env file.
The password is correct since I can manually connect to MySQL using mysql -u mercator_user -p.
I checked that the user mercator_user has the necessary privileges by running SHOW GRANTS FOR 'mercator_user'@'localhost';.
I also tried reinstalling using sudo, but the issue persists.

Do you have any idea what might be causing this issue?

Thank you in advance for your help.

Best regards,

[dbarzin]

Try php artisan db to check if Laravel can connect to the DB.

[dbarzin]

You should not seed the database when migrating it. The command to only migrate the DB is php artisan migrate

[JET-9]

I tried running the commands php artisan db and php artisan migrate, but I still get the same error—Laravel is unable to connect to the database.

However, when I try to connect manually using:

mysql -h 127.0.0.1 -u mercator_user -p
mysql -h localhost -u mercator_user -p
it works perfectly fine.

So far, I've double-checked the credentials in the .env file, verified that the user has the correct privileges, and cleared the Laravel config cache, but the issue persists.

[dbarzin]

Check the following steps:

Verify .env settings
Ensure your .env contains:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1  # Try replacing localhost with 127.0.0.1
DB_PORT=3306
DB_DATABASE=your_db_name
DB_USERNAME=mercator_user
DB_PASSWORD="your_password"

If the password has special characters, enclose it in quotes.

Clear config cache

php artisan config:clear
php artisan cache:clear

Check MySQL connection via Laravel

php artisan tinker
DB::connection()->getPdo();

Check MySQL user host

SELECT host FROM mysql.user WHERE user = 'mercator_user';

Ensure it includes '127.0.0.1' or '%'.

Let me know if the issue persists.

[JET-9]

Thanks again for your help! I managed to fix the database connection issue by adding quotes around the password in the .env file due to special characters, like you said.

However, now I'm facing another issue. When I try to access the web interface at http://IP:8000/login, the page keeps loading indefinitely, as shown in the attached screenshot. The network tab shows that the necessary CSS and images are loading, but the interface itself does not display anything.

[dbarzin]

Is there and error in the logs : /var/www/mercator/storage/logs/laravel.log ?

[JET-9]

I tried checking the logs in storage/logs/laravel.log, but the file does not exist. I also navigated to the storage/ directory, and it seems that the logs/ folder is missing.

[dbarzin]

It might be a write access issue. Try :

sudo chmod -R 0777 /var/www/mecrator/storage

[JET-9]

I found the issue—it was caused by my VPN connection. It works locally using curl. Thank you for your help and quick response!