search

shzlw / poli

An easy-to-use BI server built for SQL lovers. Power data analysis in SQL and gain faster business insights.
https://shzlw.github.io/poli
MIT License
1.97k stars 331 forks source link

Poli-0.11.0 jar file error #62

Closed roncking closed 4 years ago

roncking commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

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 notifications@github.com 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 https://github.com/shzlw/poli/issues/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 commented 4 years ago

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 commented 4 years ago

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

On Mon, Jan 20, 2020 at 5:01 PM Zhonglu notifications@github.com 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 https://github.com/shzlw/poli/issues/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 commented 4 years ago

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?