icclab / cyclops-dashboard

Angularjs UI for Cyclops framework
Apache License 2.0
10 stars 10 forks source link

sqlite database connection #5

Closed 0xffea closed 6 years ago

0xffea commented 8 years ago

I get the following error for a sqlite database. Notice "/usr/share/tomcat/".

 Error while trying to create the tables in the database: path to '"/tmp/dashboard.db"': '/usr/share/tomcat/"' does not exist

Looks to me like openConnection() in src/main/java/ch/icclab/cyclops/dashboard/database/DatabaseHelper.java fails. Someone has an suggestion what is wrong here?

######################## PROVIDE CREDENTIALS ####################
# Your GateKeeper auth server credentials
GK_ADMIN=admin
GK_PASSWORD=admin

# This admin account will be created during installation automatically (has to be different from Gatekeeper)
DASHBOARD_ADMIN=dashboardadmin
DASHBOARD_PASSWORD=admin

# Provide paths for accessing SQLite database and saving PDFs
DASHBOARD_DB_PATH="/tmp/dashboard.db"
BILLING_PDF_PATH=/root/cyclops/build/bills
[ DEBUG ] 2016-07-29 16:14:20 (applicationFactory.AbstractApplicationFactory:39) - Attempting to get the Environment from the Configuration file.
[ DEBUG ] 2016-07-29 16:14:20 (applicationFactory.AbstractApplicationFactory:42) - Attempting to create the application Class
[ TRACE ] 2016-07-29 16:14:20 (application.AbstractApplication:72) - Attempting to Create the database.
[ TRACE ] 2016-07-29 16:14:20 (database.DatabaseHelper:93) - Creating Database Tables if doesn't exists
[ DEBUG ] 2016-07-29 16:14:20 (database.DatabaseHelper:81) - XXX "/tmp/dashboard.db"
[ DEBUG ] 2016-07-29 16:14:20 (database.DatabaseHelper:108) - XXX SQL exception
[ ERROR ] 2016-07-29 16:14:20 (database.DatabaseHelper:109) - Error while trying to create the tables in the database: path to '"/tmp/dashboard.db"': '/usr/share/tomcat/"' does not exist
[ ERROR ] 2016-07-29 16:14:20 (application.AbstractApplication:76) - Error while creating the Database: path to '"/tmp/dashboard.db"': '/usr/share/tomcat/"' does not exist
[ ERROR ] 2016-07-29 16:14:20 (errorreporting.ErrorReporter:50) - Failed to open connection for error reporting: somehost
[ DEBUG ] 2016-07-29 16:14:20 (application.AbstractApplication:60) - Attempting to create the default admin account.
[ DEBUG ] 2016-07-29 16:14:20 (registration.Registration:118) - Attempting to create the Default Admin Account.
[ DEBUG ] 2016-07-29 16:14:20 (registration.Registration:148) - Attempting to create the initial Dashboard Admin Account in Gatekeeper.
[ DEBUG ] 2016-07-29 16:14:20 (registration.Registration:159) - Attempting to get the token to create the account into Gatekeeper.
[ DEBUG ] 2016-07-29 16:14:20 (registration.Registration:162) - Username: admin Password: admin
[ TRACE ] 2016-07-29 16:14:20 (gatekeeper.GatekeeperTokenGenerator:47) - Attempting go get the userId from the database.
[ DEBUG ] 2016-07-29 16:14:20 (gatekeeper.GatekeeperTokenGenerator:50) - Asking for a token to authenticating the query
[ DEBUG ] 2016-07-29 16:14:20 (gatekeeper.GatekeeperTokenGenerator:54) - Attempting to get the token from the Gatekeeper.
[ DEBUG ] 2016-07-29 16:14:20 (gatekeeper.GatekeeperTokenGenerator:65) - Gatekeeper Token URL: http://localhost:8000/token/
[ ERROR ] 2016-07-29 16:14:20 (gatekeeper.GatekeeperTokenGenerator:68) - Error while getting the token from the Gatekeeper: Communication Error
[ ERROR ] 2016-07-29 16:14:20 (errorreporting.ErrorReporter:50) - Failed to open connection for error reporting: somehost
[ ERROR ] 2016-07-29 16:14:20 (registration.Registration:141) - Error while registering a new User: Internal Server Error
[ ERROR ] 2016-07-29 16:14:20 (errorreporting.ErrorReporter:50) - Failed to open connection for error reporting: somehost
[ ERROR ] 2016-07-29 16:14:20 (application.AbstractApplication:66) - Couldn't create the default admin account.
[ DEBUG ] 2016-07-29 16:14:20 (application.AbstractApplication:48) - Attempting to create the common routes.
[ DEBUG ] 2016-07-29 16:14:20 (application.AbstractApplication:54) - Attempting to create the specific routes
[ TRACE ] 2016-07-29 16:14:20 (login.Login:48) - Attempting to login
[ TRACE ] 2016-07-29 16:14:20 (login.Login:76) - Checking if the user exists.
[ TRACE ] 2016-07-29 16:14:20 (database.DatabaseHelper:473) - Attempting to Check if a user exists in the database.
[ DEBUG ] 2016-07-29 16:14:20 (database.DatabaseHelper:81) - XXX "/tmp/dashboard.db"
[ ERROR ] 2016-07-29 16:14:20 (database.DatabaseHelper:488) - Error while checking Users in the database: path to '"/tmp/dashboard.db"': '/usr/share/tomcat/"' does not exist
[ ERROR ] 2016-07-29 16:14:20 (login.Login:55) - Error while Loging in: path to '"/tmp/dashboard.db"': '/usr/share/tomcat/"' does not exist
[ ERROR ] 2016-07-29 16:14:20 (errorreporting.ErrorReporter:50) - Failed to open connection for error reporting: somehost
ManuPerezBelmonte commented 8 years ago

Dear David,

The error seems to come from the lack of the /usr/share/tomcat/ folder, It may be that this folder is simply not existing or that your tomcat installation is somewhere else. You should check whether you don't have access to this folder or it just doesn't exists.

I would also like to clarify that the Dashboard is currently supporting just the old code releases and not Cyclops 2.0. The support to the Dashboard is being implemented at the moment and will be published in following months.

If anyway you are trying to deploy the 1.0 architecture and have some more trouble, don't hesitate on asking.

Manu, Cyclops team.

2016-07-29 16:32 GMT+02:00 David Höppner notifications@github.com:

I get the following error for a sqlite database. Notice "/usr/share/tomcat/".

Error while trying to create the tables in the database: path to '"/tmp/dashboard.db"': '/usr/share/tomcat/"' does not exist

Looks to me like openConnection() in src/main/java/ch/icclab/cyclops/dashboard/database/DatabaseHelper.java fails. Someone has an suggestion what is wrong here?

######################## PROVIDE CREDENTIALS ####################

Your GateKeeper auth server credentials

GK_ADMIN=admin GK_PASSWORD=admin

This admin account will be created during installation automatically (has to be different from Gatekeeper)

DASHBOARD_ADMIN=dashboardadmin DASHBOARD_PASSWORD=admin

Provide paths for accessing SQLite database and saving PDFs

DASHBOARD_DB_PATH="/tmp/dashboard.db" BILLING_PDF_PATH=/root/cyclops/build/bills

[ DEBUG ] 2016-07-29 16:14:20 (applicationFactory.AbstractApplicationFactory:39) - Attempting to get the Environment from the Configuration file. [ DEBUG ] 2016-07-29 16:14:20 (applicationFactory.AbstractApplicationFactory:42) - Attempting to create the application Class [ TRACE ] 2016-07-29 16:14:20 (application.AbstractApplication:72) - Attempting to Create the database. [ TRACE ] 2016-07-29 16:14:20 (database.DatabaseHelper:93) - Creating Database Tables if doesn't exists [ DEBUG ] 2016-07-29 16:14:20 (database.DatabaseHelper:81) - XXX "/tmp/dashboard.db" [ DEBUG ] 2016-07-29 16:14:20 (database.DatabaseHelper:108) - XXX SQL exception [ ERROR ] 2016-07-29 16:14:20 (database.DatabaseHelper:109) - Error while trying to create the tables in the database: path to '"/tmp/dashboard.db"': '/usr/share/tomcat/"' does not exist [ ERROR ] 2016-07-29 16:14:20 (application.AbstractApplication:76) - Error while creating the Database: path to '"/tmp/dashboard.db"': '/usr/share/tomcat/"' does not exist [ ERROR ] 2016-07-29 16:14:20 (errorreporting.ErrorReporter:50) - Failed to open connection for error reporting: somehost [ DEBUG ] 2016-07-29 16:14:20 (application.AbstractApplication:60) - Attempting to create the default admin account. [ DEBUG ] 2016-07-29 16:14:20 (registration.Registration:118) - Attempting to create the Default Admin Account. [ DEBUG ] 2016-07-29 16:14:20 (registration.Registration:148) - Attempting to create the initial Dashboard Admin Account in Gatekeeper. [ DEBUG ] 2016-07-29 16:14:20 (registration.Registration:159) - Attempting to get the token to create the account into Gatekeeper. [ DEBUG ] 2016-07-29 16:14:20 (registration.Registration:162) - Username: admin Password: admin [ TRACE ] 2016-07-29 16:14:20 (gatekeeper.GatekeeperTokenGenerator:47) - Attempting go get the userId from the database. [ DEBUG ] 2016-07-29 16:14:20 (gatekeeper.GatekeeperTokenGenerator:50) - Asking for a token to authenticating the query [ DEBUG ] 2016-07-29 16:14:20 (gatekeeper.GatekeeperTokenGenerator:54) - Attempting to get the token from the Gatekeeper. [ DEBUG ] 2016-07-29 16:14:20 (gatekeeper.GatekeeperTokenGenerator:65) - Gatekeeper Token URL: http://localhost:8000/token/ [ ERROR ] 2016-07-29 16:14:20 (gatekeeper.GatekeeperTokenGenerator:68) - Error while getting the token from the Gatekeeper: Communication Error [ ERROR ] 2016-07-29 16:14:20 (errorreporting.ErrorReporter:50) - Failed to open connection for error reporting: somehost [ ERROR ] 2016-07-29 16:14:20 (registration.Registration:141) - Error while registering a new User: Internal Server Error [ ERROR ] 2016-07-29 16:14:20 (errorreporting.ErrorReporter:50) - Failed to open connection for error reporting: somehost [ ERROR ] 2016-07-29 16:14:20 (application.AbstractApplication:66) - Couldn't create the default admin account. [ DEBUG ] 2016-07-29 16:14:20 (application.AbstractApplication:48) - Attempting to create the common routes. [ DEBUG ] 2016-07-29 16:14:20 (application.AbstractApplication:54) - Attempting to create the specific routes [ TRACE ] 2016-07-29 16:14:20 (login.Login:48) - Attempting to login [ TRACE ] 2016-07-29 16:14:20 (login.Login:76) - Checking if the user exists. [ TRACE ] 2016-07-29 16:14:20 (database.DatabaseHelper:473) - Attempting to Check if a user exists in the database. [ DEBUG ] 2016-07-29 16:14:20 (database.DatabaseHelper:81) - XXX "/tmp/dashboard.db" [ ERROR ] 2016-07-29 16:14:20 (database.DatabaseHelper:488) - Error while checking Users in the database: path to '"/tmp/dashboard.db"': '/usr/share/tomcat/"' does not exist [ ERROR ] 2016-07-29 16:14:20 (login.Login:55) - Error while Loging in: path to '"/tmp/dashboard.db"': '/usr/share/tomcat/"' does not exist [ ERROR ] 2016-07-29 16:14:20 (errorreporting.ErrorReporter:50) - Failed to open connection for error reporting: somehost

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/icclab/cyclops-dashboard/issues/5, or mute the thread https://github.com/notifications/unsubscribe-auth/ALCiWQX0PNvIiJAbccfMWVn2htCSJNWiks5qag8SgaJpZM4JYP2a .