Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Unable to generate an api-token on rundeck 1.5 #327

Closed
connaryscott opened this issue Mar 18, 2013 · 1 comment
Closed

Unable to generate an api-token on rundeck 1.5 #327

connaryscott opened this issue Mar 18, 2013 · 1 comment
Assignees
@gschueler
Labels
bug
Milestone
1.5.1

Comments

@connaryscott
Copy link

Using rpm version 1.5-1.6GA:

[root@centgoldrk1v cscott2]# rpm -q rundeck
rundeck-1.5-1.6.GA.noarch

on centos 6.3 x86_64

[root@centgoldrk1v rundeck]# cat /etc/redhat-release 
CentOS release 6.3 (Final)
[root@centgoldrk1v rundeck]# uname -p
x86_64

when trying to generate a new token UI shows:

Error: [object Object]

Log suggests an H2 sql error:

org.h2.jdbc.JdbcSQLException: Value too long for column AUTH_ROLES VARCHAR(255)

log tail here:

[root@centgoldrk1v rundeck]# cd /var/log/rundeck/
[root@centgoldrk1v rundeck]# tail -100 service.log 
2013-03-15 15:23:48.607:/rundeck:INFO:  Initializing Spring FrameworkServlet 'grails'
2013-03-15 15:23:48.625::INFO:  Started [email protected]:4440
2013-03-15 15:24:00.196::INFO:  Login attempts: 1, Hits: 0, Ratio: 0%.
2013-03-15 15:24:00.205::INFO:  Attempting authentication: CN=Chuck Scott,OU=Mismo,OU=Corp,OU=WSGC Users,DC=wsgc,DC=com
WARN  FrameworkService: rdeck.base is: /etc/rundeck
2013-03-15 15:24:01.408:/rundeck:INFO:  Initializing Spring FrameworkServlet 'gsp'
2013-03-15 15:24:01.408:/rundeck:INFO:  GSP servlet initialized
2013-03-18 14:24:24.670::INFO:  Login attempts: 2, Hits: 0, Ratio: 0%.
2013-03-18 14:24:24.674::INFO:  Cache Eviction for cscott2.
2013-03-18 14:24:24.679::INFO:  Attempting authentication: CN=Chuck Scott,OU=Mismo,OU=Corp,OU=WSGC Users,DC=wsgc,DC=com
ERROR JDBCExceptionReporter: Value too long for column AUTH_ROLES VARCHAR(255) NOT NULL: 'GS-Members-MISMO-CORP,GS-EComm-WebAdmins,GS-WebSiteAccess-MIS-CORP,Web Admins-eCommerce,$MISMO,GS-PrivNAS-AK-CORP,GS-Everyone-M... (303); SQL statement:
insert into auth_token (id, version, auth_roles, token, user_id) values (null, ?, ?, ?, ?) [90005-112]
ERROR GrailsExceptionResolver: Exception occurred when processing request: [POST] /rundeck/user/generateApiToken.json
Stacktrace follows:
org.h2.jdbc.JdbcSQLException: Value too long for column AUTH_ROLES VARCHAR(255) NOT NULL: 'GS-Members-MISMO-CORP,GS-EComm-WebAdmins,GS-WebSiteAccess-MIS-CORP,Web Admins-eCommerce,$MISMO,GS-PrivNAS-AK-CORP,GS-Everyone-M... (303); SQL statement:
insert into auth_token (id, version, auth_roles, token, user_id) values (null, ?, ?, ?, ?) [90005-112]
        at org.h2.message.Message.getSQLException(Message.java:107)
        at org.h2.message.Message.getSQLException(Message.java:118)
        at org.h2.table.Column.validateConvertUpdateSequence(Column.java:301)
        at org.h2.table.Table.validateConvertUpdateSequence(Table.java:582)
        at org.h2.command.dml.Insert.update(Insert.java:97)
        at org.h2.command.CommandContainer.update(CommandContainer.java:71)
        at org.h2.command.Command.executeUpdate(Command.java:207)
        at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:139)
        at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:128)
        at rundeck.controllers.UserController$_closure16.doCall(UserController.groovy:190)
        at rundeck.controllers.UserController$_closure16.doCall(UserController.groovy)
ERROR JDBCExceptionReporter: Value too long for column AUTH_ROLES VARCHAR(255) NOT NULL: 'GS-Members-MISMO-CORP,GS-EComm-WebAdmins,GS-WebSiteAccess-MIS-CORP,Web Admins-eCommerce,$MISMO,GS-PrivNAS-AK-CORP,GS-Everyone-M... (303); SQL statement:
insert into auth_token (id, version, auth_roles, token, user_id) values (null, ?, ?, ?, ?) [90005-112]
ERROR GrailsExceptionResolver: Exception occurred when processing request: [POST] /rundeck/user/generateApiToken.json
Stacktrace follows:
org.h2.jdbc.JdbcSQLException: Value too long for column AUTH_ROLES VARCHAR(255) NOT NULL: 'GS-Members-MISMO-CORP,GS-EComm-WebAdmins,GS-WebSiteAccess-MIS-CORP,Web Admins-eCommerce,$MISMO,GS-PrivNAS-AK-CORP,GS-Everyone-M... (303); SQL statement:
insert into auth_token (id, version, auth_roles, token, user_id) values (null, ?, ?, ?, ?) [90005-112]
        at org.h2.message.Message.getSQLException(Message.java:107)
        at org.h2.message.Message.getSQLException(Message.java:118)
        at org.h2.table.Column.validateConvertUpdateSequence(Column.java:301)
        at org.h2.table.Table.validateConvertUpdateSequence(Table.java:582)
        at org.h2.command.dml.Insert.update(Insert.java:97)
        at org.h2.command.CommandContainer.update(CommandContainer.java:71)
        at org.h2.command.Command.executeUpdate(Command.java:207)
        at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:139)
        at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:128)
        at rundeck.controllers.UserController$_closure16.doCall(UserController.groovy:190)
        at rundeck.controllers.UserController$_closure16.doCall(UserController.groovy)
ERROR JDBCExceptionReporter: Value too long for column AUTH_ROLES VARCHAR(255) NOT NULL: 'GS-Members-MISMO-CORP,GS-EComm-WebAdmins,GS-WebSiteAccess-MIS-CORP,Web Admins-eCommerce,$MISMO,GS-PrivNAS-AK-CORP,GS-Everyone-M... (303); SQL statement:
insert into auth_token (id, version, auth_roles, token, user_id) values (null, ?, ?, ?, ?) [90005-112]
ERROR GrailsExceptionResolver: Exception occurred when processing request: [POST] /rundeck/user/generateApiToken.json
Stacktrace follows:
org.h2.jdbc.JdbcSQLException: Value too long for column AUTH_ROLES VARCHAR(255) NOT NULL: 'GS-Members-MISMO-CORP,GS-EComm-WebAdmins,GS-WebSiteAccess-MIS-CORP,Web Admins-eCommerce,$MISMO,GS-PrivNAS-AK-CORP,GS-Everyone-M... (303); SQL statement:
insert into auth_token (id, version, auth_roles, token, user_id) values (null, ?, ?, ?, ?) [90005-112]
        at org.h2.message.Message.getSQLException(Message.java:107)
        at org.h2.message.Message.getSQLException(Message.java:118)
        at org.h2.table.Column.validateConvertUpdateSequence(Column.java:301)
        at org.h2.table.Table.validateConvertUpdateSequence(Table.java:582)
        at org.h2.command.dml.Insert.update(Insert.java:97)
        at org.h2.command.CommandContainer.update(CommandContainer.java:71)
        at org.h2.command.Command.executeUpdate(Command.java:207)
        at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:139)
        at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:128)
        at rundeck.controllers.UserController$_closure16.doCall(UserController.groovy:190)
        at rundeck.controllers.UserController$_closure16.doCall(UserController.groovy)
ERROR JDBCExceptionReporter: Value too long for column AUTH_ROLES VARCHAR(255) NOT NULL: 'GS-Members-MISMO-CORP,GS-EComm-WebAdmins,GS-WebSiteAccess-MIS-CORP,Web Admins-eCommerce,$MISMO,GS-PrivNAS-AK-CORP,GS-Everyone-M... (303); SQL statement:
insert into auth_token (id, version, auth_roles, token, user_id) values (null, ?, ?, ?, ?) [90005-112]
ERROR GrailsExceptionResolver: Exception occurred when processing request: [POST] /rundeck/user/generateApiToken.json
Stacktrace follows:
org.h2.jdbc.JdbcSQLException: Value too long for column AUTH_ROLES VARCHAR(255) NOT NULL: 'GS-Members-MISMO-CORP,GS-EComm-WebAdmins,GS-WebSiteAccess-MIS-CORP,Web Admins-eCommerce,$MISMO,GS-PrivNAS-AK-CORP,GS-Everyone-M... (303); SQL statement:
insert into auth_token (id, version, auth_roles, token, user_id) values (null, ?, ?, ?, ?) [90005-112]
        at org.h2.message.Message.getSQLException(Message.java:107)
        at org.h2.message.Message.getSQLException(Message.java:118)
        at org.h2.table.Column.validateConvertUpdateSequence(Column.java:301)
        at org.h2.table.Table.validateConvertUpdateSequence(Table.java:582)
        at org.h2.command.dml.Insert.update(Insert.java:97)
        at org.h2.command.CommandContainer.update(CommandContainer.java:71)
        at org.h2.command.Command.executeUpdate(Command.java:207)
        at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:139)
        at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:128)
        at rundeck.controllers.UserController$_closure16.doCall(UserController.groovy:190)
        at rundeck.controllers.UserController$_closure16.doCall(UserController.groovy)
2013-03-18 15:58:50.822::INFO:  Login attempts: 3, Hits: 0, Ratio: 0%.
2013-03-18 15:58:50.832::INFO:  Attempting authentication: CN=Jigar Patel,OU=Mismo,OU=Corp,OU=WSGC Users,DC=wsgc,DC=com
2013-03-18 15:59:37.530::INFO:  Login attempts: 4, Hits: 0, Ratio: 0%.
2013-03-18 15:59:37.530::INFO:  Cache Eviction for cscott2.
2013-03-18 15:59:37.546::INFO:  Attempting authentication: CN=Chuck Scott,OU=Mismo,OU=Corp,OU=WSGC Users,DC=wsgc,DC=com
ERROR JDBCExceptionReporter: Value too long for column AUTH_ROLES VARCHAR(255) NOT NULL: '$MISMO,GS-EComm-WebAdmins,GS-APMPRDLDAP,All North Point - Associates,GS-Everyone-MISMO-CORP,Web Admins-eCommerce,GS-PrivNAS-AK-... (303); SQL statement:
insert into auth_token (id, version, auth_roles, token, user_id) values (null, ?, ?, ?, ?) [90005-112]
ERROR GrailsExceptionResolver: Exception occurred when processing request: [POST] /rundeck/user/generateApiToken.json
Stacktrace follows:
org.h2.jdbc.JdbcSQLException: Value too long for column AUTH_ROLES VARCHAR(255) NOT NULL: '$MISMO,GS-EComm-WebAdmins,GS-APMPRDLDAP,All North Point - Associates,GS-Everyone-MISMO-CORP,Web Admins-eCommerce,GS-PrivNAS-AK-... (303); SQL statement:
insert into auth_token (id, version, auth_roles, token, user_id) values (null, ?, ?, ?, ?) [90005-112]
        at org.h2.message.Message.getSQLException(Message.java:107)
        at org.h2.message.Message.getSQLException(Message.java:118)
        at org.h2.table.Column.validateConvertUpdateSequence(Column.java:301)
        at org.h2.table.Table.validateConvertUpdateSequence(Table.java:582)
        at org.h2.command.dml.Insert.update(Insert.java:97)
        at org.h2.command.CommandContainer.update(CommandContainer.java:71)
        at org.h2.command.Command.executeUpdate(Command.java:207)
        at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:139)
        at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:128)
        at rundeck.controllers.UserController$_closure16.doCall(UserController.groovy:190)
        at rundeck.controllers.UserController$_closure16.doCall(UserController.groovy)
@connaryscott
Copy link
Author

Additional note,

we are using Active Directory and role authorization and seems that it may be related.

@gschueler gschueler mentioned this issue Apr 22, 2013
Closed
@ghost ghost assigned gschueler Apr 22, 2013
gschueler added a commit to gschueler/rundeck that referenced this issue Apr 24, 2013
@gschueler
Fix too-long value for api token roles rundeck#327
29d8c9f 
don't store unused auth roles in token
change auth roles to text column for future use
@snyk-bot snyk-bot mentioned this issue May 8, 2020
Closed
@carlosrfranco carlosrfranco mentioned this issue May 13, 2022
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@gschueler gschueler

Labels
bug
Projects
None yet
Milestone
1.5.1
Development

No branches or pull requests
2 participants
@gschueler @connaryscott