execute dataBaseSchema error about open-certification-trainer HOT 6 CLOSED

Hey @phuocle,

Thanks for giving it a try.
I'll have to improve on the install guide, sorry for that.

For importing the backup, you should use psql, which is bundled with PostgreSql server.
For me it was installed at C:\Program Files\PostgreSQL\10\bin. I added it to my windows path, so that it can be used without having to specify the full folder every time.

For importing the database schema:
psql -U postgres -h localhost -d postgres -f "C:\Open-Certification-Trainer\dataBaseSchema.sql"

Where -U is the user name of your root user (usually postgres), -h is the server (can be ommitted if localhost), -d is the database (postgres is the default database) and -f is the file location of your database schema.

I reinstalled the portal onto my laptop and updated the installation guide with steps that were previously missing. You should hopefully be able to get it running using the updated instructions.

Please give me a quick note, whether the installation succeeded like this.

Kind Regards,
Florian

from open-certification-trainer.

Thanks @DigitalFlow, it worked now.

One more question, when I run website, I sign up success, and then login. But I login with end user.

How I can login with admin user.

Thanks,
Phuoc

from open-certification-trainer.

Hi @phuocle,

awesome that it is working for you!

There is a default root user with user name root and password root.
You can login with it, then it would probably be a good idea to change his password.

Just give me a quick note, once you were able to login.

Kind Regards,
Florian

from open-certification-trainer.

Hi @DigitalFlow

Everything ok now.

Now i try learn howto publish to my sub-domain site. E.g: http://certification.mydomain.com

Question: Can I host it on IIS. I have a Win2012Server

from open-certification-trainer.

Hi @phuocle,

It should work using iisnode.

When using IIS, you should probably remove the PORT setting from .env.config, since IIS will set it itself.
Everything should be preparated for using it with IIS.
I didn't try it yet, so if you do please give me some feedback, if you got it working like that.

I'm using forever for publishing it constantly right now.
It's just a forever start dist/server.js after installing.

Kind Regards,
Florian

from open-certification-trainer.

Hey @phuocle,

Did you get it to work on IIS?
I'll close this task for now, please reopen or create another one if you need more information.

Kind Regards,
Florian

from open-certification-trainer.