how do i connect sql database ? about generator-jhipster-nodejs HOT 12 CLOSED

Hi @ameinabdi,
there is the orm.config.ts where is stored db information. For dev it will be always sqlite created on app startup.

from generator-jhipster-nodejs.

thanks @amanganiello90
i have added my info about database in that file but i still it doesn't work so did you test sql before now ?

from generator-jhipster-nodejs.

What db have you choosen in the related question?

from generator-jhipster-nodejs.

mysql

from generator-jhipster-nodejs.

What command are you using to startup application? Write in order the commands.

from generator-jhipster-nodejs.

jhipster --blueprint nodejs

from generator-jhipster-nodejs.

That command is for generation.. I said about startup.. however for mysql prod db, the connection created is:

ormconfig = {
        name: 'default',
        type: 'mysql',
       url: 'mysql://localhost:27017/<your-app-name>,
        synchronize: true,
        logging: false,
        entities: [__dirname + '/domain/*.entity{.ts,.js}'],
    };

Change url with your mysql instance.

from generator-jhipster-nodejs.

i run this command inside the server folder
npm start

from generator-jhipster-nodejs.

i run this command inside the server folder
npm start

Ok, so you are using sqlite dev db, not mysql.. paste in your server/src/orm.config.ts the orm.config.ts content

from generator-jhipster-nodejs.

but i don't need to use sqlite. i need to use mysql database

from generator-jhipster-nodejs.

Then, replace in the if of Prod section the mysql source configuration and run:

set NODE_ENV=prod&&npm start

Please attention that in your db instance must be created the 3 user management tables, otherwise the initial db seed insert fails.

To disable it comment this line

from generator-jhipster-nodejs.

okey thanks a lot mr @amanganiello90

from generator-jhipster-nodejs.