NeonN
Neon•5mo ago•
5 replies
sacred-rose

Laravel Firebase Studio Neon connection error: `relation 'sessions' does not exist`

I'm using Firebase Studio laravel template and trying to connect to Neon. I added the Parameters Only connection snippet to my .env and the following to config/database.php:
'neondb' => [
            'driver' => 'pgsql',
            'url' => env('DB_URL'),
            'host' => env('PGHOST', '127.0.0.1'),
            'port' => env('DB_PORT', '5432'),
            'database' => env('PGDATABASE', 'neondb'),
            'username' => env('PGUSERNAME'),
            'password' => env('PGPASSWORD'),
            'charset' => env('DB_CHARSET', 'utf8'),
            'prefix' => '',
            'prefix_indexes' => true,
            'search_path' => 'public',
            'sslmode' => env('PGSSLMODE', 'require'),
        ],


I run it and got this error: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "sessions" does not exist LINE 1: select * from "sessions" where "id" = $1 limit 1 ^ (Connection: neondb, SQL: select * from "sessions" where "id" = rp69Vabcd1234tKkHyLgW2h7f5eVt1mZYhcTk limit 1)

I read Neon's documentation about it on here and here and found that I had to do some workarounds. But, I am a complete newbie in web development and databases. I think the answer is there but I don't understand it. What should I do? Thank you in advance.

Edit: Just now I tried php artisan migrate and in my neondb I can see there is now amigrations table, which means the connection was a success. But there's no users, job_batches, and other default tables from laravel. I also got this error: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block (Connection: neondb, SQL: alter table "users" add constraint "users_email_unique" unique ("email")).
Neon
Connection errors - Neon Docs
This topic describes how to resolve connection errors you may encounter when using Neon. The errors covered include The endpoint ID is not specified Password authentication failed for user Couldn't co...
Connection errors - Neon Docs
Neon
About Connection pooling - Neon Docs
Neon uses PgBouncer to support connection pooling, enabling up to 10,000 concurrent connections. PgBouncer is a lightweight connection pooler for Postgres. How to use connection pooling. To use connec...
About Connection pooling - Neon Docs
Was this page helpful?