Custom database is active and accepting connections but I cannot start the project
I am using "wasp start" and "wasp db migrate-dev" since it is a new fresh database. How to get it started as there is no documentation regarding this
5 Replies
Hi @Omen. I'm kapa.ai, your friendly support bot. I will try to answer your question by searching through the knowledge base. :wave:
----------------------
Based on the information provided in the knowledge sources, it seems you're encountering an issue with connecting to your custom database. Let's go through the steps to resolve this:
1. First, make sure your custom database is indeed running and accessible.
2. You need to set the
DATABASE_URL environment variable to connect Wasp to your custom database. The easiest way to do this is by adding it to the .env.server file in the root directory of your Wasp project. If this file doesn't exist, create it.
As mentioned in the Databases documentation:
3. In the .env.server file, add your database connection string:
4. Once you've set the DATABASE_URL, try running wasp db migrate-dev again. This command should create the necessary tables in your database.
5. If wasp db migrate-dev is successful, you should then be able to run wasp start to start your project.
If you're still encountering issues after following these steps, it might be helpful to check the specific error messages you're receiving. The knowledge sources don't provide information on all possible error scenarios, so more details about the exact error you're seeing could be helpful in troubleshooting further.
Remember, if you're switching from SQLite (the default) to PostgreSQL, you might need to follow additional steps. There's a mention of a guide for migrating from SQLite to PostgreSQL in the Databases documentation, but the specific guide isn't provided in the knowledge sources.
----------------------
Note: you can ask me a follow up question by @ mentioning me again :speech_balloon:
----------------------
Sorry @Omen, I seem to be having a bit of trouble. Don't worry though, I've pinged my support and they will try to fix me up! :technologist:
Perhaps try again in 15mins?❌ --- [Error] Can not connect to database: ---------------------------------------
The database needs to be running in order to execute this command. You can easily start a managed dev database with
wasp start db
The database is indeed working and live but wasp project does not run
@kapa.aiLet me check the knowledge base for you again. One moment! :books:
Sorry @Omen, I seem to be having a bit of trouble. Don't worry though, I've pinged my support and they will try to fix me up! :technologist:
Perhaps try again in 15mins?
Is your database local/remote? Are you able to connect to the same URL from other tools, e.g. terminal, db admin GUI?
Hey @Omen, @genyus is spot on with what I would ask 🙂