You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by GitBox <gi...@apache.org> on 2021/01/14 11:28:55 UTC
[GitHub] [incubator-dolphinscheduler] GloryJin opened a new issue #4458: [Bug][dolphinscheduler-dao] Follow the doc development env setup guide, Cannot log in after the system is started with admin account
GloryJin opened a new issue #4458:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4458
**Describe the bug**
User login failed
**To Reproduce**
I was build a development environment according to the "Development environment setup" section of Developer guide,
After completing all steps, i start the system . But the system reports an error that the user cannot log in。
**Expected behavior**
login success with default admin account.
**Screenshots**
login failed with default admin account.
**Which version of Dolphin Scheduler:**
-[1.3.4-release]
**Additional context**
I found the reason through the debugger, The code UpgradeDao.initSchema() like this：
```
case POSTGRESQL:
initSqlPath = "/sql/create/release-1.2.0_schema/postgresql/";
initSchema(initSqlPath);
break;
```
then the init sql script dolphinscheduler_ddl.sql like this:
define the t_ds_user table has not state field, but the entity User has this field as the picture shows.
so system throw an error like this when login:
```
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'state' in 'field list'
### The error may exist in file [C:\ericsson\githubpoj\incubator-dolphinscheduler\dolphinscheduler-dao\target\classes\org\apache\dolphinscheduler\dao\mapper\UserMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select id, user_name, user_password, user_type, email, phone, tenant_id, create_time, update_time, queue, state from t_ds_user where user_name=? and user_password = ?
### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'state' in 'field list'
; bad SQL grammar []
```
**Requirement or improvement**
- CreateDolphinScheduler Class And related init sql script should optimization. According to the different versions, call different sql script。
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] c-f-cooper commented on issue #4458: [Bug][dolphinscheduler-dao] Follow the doc development env setup guide, Cannot log in after the system is started with admin account
Posted by GitBox <gi...@apache.org>.
c-f-cooper commented on issue #4458:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4458#issuecomment-760587564
Hi，Glory,please check the pg table，the t_ds_version table has a record, the version is 1.3.1?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] GloryJin closed issue #4458: [Bug][dolphinscheduler-dao] Follow the doc development env setup guide, Cannot log in after the system is started with admin account
Posted by GitBox <gi...@apache.org>.
GloryJin closed issue #4458:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4458
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] GloryJin commented on issue #4458: [Bug][dolphinscheduler-dao] Follow the doc development env setup guide, Cannot log in after the system is started with admin account
Posted by GitBox <gi...@apache.org>.
GloryJin commented on issue #4458:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4458#issuecomment-760704582
Yeah, so code has no problem, just the guide doc has flaws . After all, according to the document operation, the system can not login in，cause trouble for novice.
there is only this step in the document like this.
Should add one step, run the main method of org.apache.dolphinscheduler.dao.upgrade.shell.UpgradeDolphinScheduler to automatically update the tables.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] GloryJin commented on issue #4458: [Bug][dolphinscheduler-dao] Follow the doc development env setup guide, Cannot log in after the system is started with admin account
Posted by GitBox <gi...@apache.org>.
GloryJin commented on issue #4458:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4458#issuecomment-760598590
no, the version is 1.3.4
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] felix-thinkingdata commented on issue #4458: [Bug][dolphinscheduler-dao] Follow the doc development env setup guide, Cannot log in after the system is started with admin account
Posted by GitBox <gi...@apache.org>.
felix-thinkingdata commented on issue #4458:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4458#issuecomment-760610656
ta-dolphin-scheduler/sql/upgrade/1.3.0_schema/mysql/dolphinscheduler_ddl.sql
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org