Poli-0.11.0 jar file error

[roncking]

Jar file runs, but login doesn't work
Here's the config file on windows:

Config the absolute path to poli.db

For example, jdbc:sqlite:/home/poli/poli.db or jdbc:sqlite:c:/poli/poli.db

spring.datasource.url= jdbc:sqlite:c:/tmp/poli-0.11.0/db/poli.db

The maximum number of data source pool size

poli.datasource-maximum-pool-size=50

The maximum number of records returned in the JDBC result set. Default value is -1 which returns unlimited rows.

poli.maximum-query-records=-1

The display language.

poli.locale-language=en

Allow to run multiple SQL query statements in the query editor. If there are multiple SQL statements, only the

last one will return query results.

poli.allow-multiple-query-statements=false

PDF export server URL. Check export-server/poli-export-server.js for more details.

poli.export-server-url=http://127.0.0.1:6689/pdf

Here's the error from server.txt

Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT id, username, name, sys_role FROM p_user WHERE username=? AND password=?]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such table: p_user); nested exception is org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: p_user)] with root cause
org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: p_user)

[shzlw]

Hey, I just downloaded the release and tested it in windows environment. It worked fine for me.

May I know if you followed the installation guide and run the batch file to start the application?

[roncking]

I did use the start.bat file, and nothing happens when I try to login. I put in admin / adminadmin and pressed the login button, then nothing!

…

On Sun, Jan 19, 2020 at 10:34 PM Zhonglu ***@***.***> wrote: Hey, I just downloaded the release and tested it in windows environment. It worked fine for me. May I know if you followed the installation guide <https://shzlw.github.io/poli/#/installation> and run the batch file to start the application? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#62?email_source=notifications&email_token=AASYN45HRH3S6II2IM7Q5YTQ6USVJA5CNFSM4KI2KCL2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEJLJ62I#issuecomment-576102249>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AASYN43DPJUA3W4YI3MDLXDQ6USVJANCNFSM4KI2KCLQ> .

-- Fear is a reaction, courage a decision - Winston Churchill

[shzlw]

I tried it again and here are the steps:

1. I go to https://github.com/shzlw/poli/releases to download poli-0.11.0.zip
2. I unzip it under C:\temp so the directory is like C:\temp\poli-0.11.0...
3. I edit C:\temp\poli-0.11.0\config\poli.properties and it looks like this after:
   spring.datasource.url=jdbc:sqlite:c:/temp/poli-0.11.0/db/poli.db
4. I open a terminal and enter cd C:\temp\poli-0.11.0
5. I run start.bat
6. I go to http://localhost:6688/poli/login and login with admin/adminadmin.

Let me know which step is broken for you.

[roncking]

Step 6. No response when pressing the login button after using admin/adminadmin

…

On Mon, Jan 20, 2020 at 5:01 PM Zhonglu ***@***.***> wrote: I tried it again and here are the steps: 1. I go to https://github.com/shzlw/poli/releases to download poli-0.11.0.zip 2. I unzip it under C:\temp so the directory is like C:\temp\poli-0.11.0... 3. I edit C:\temp\poli-0.11.0\config\poli.properties and it looks like this after: spring.datasource.url=jdbc:sqlite:c:/temp/poli-0.11.0/db/poli.db 4. I open a terminal and enter cd C:\temp\poli-0.11.0 5. I run start.bat 6. I go to http://localhost:6688/poli/login and login with admin/adminadmin. Let me know which step is broken for you. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#62?email_source=notifications&email_token=AASYN44RT2WRBBLKZTW3AMLQ6YUOBA5CNFSM4KI2KCL2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEJOAC4Y#issuecomment-576455027>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AASYN44ERNJKOMTP5AXX2BLQ6YUOBANCNFSM4KI2KCLQ> .

-- Fear is a reaction, courage a decision - Winston Churchill

[shzlw]

Sorry, I cannot reproduce your issue and I suspect there might be something wrong with the poli.db file. The db file after being extracted is 76KB in my windows 10 environment. The DB schema can be found at https://github.com/shzlw/poli/blob/master/db/schema-sqlite.sql

Could you try download sqlite3 and check if your poli.db has all the tables?