Cannot add iscsi user

Description

All details are described here:

https://www.truenas.com/community/threads/bug-truenas-12-0-u1-1-adding-authorized-access-iscsi-user-fails.90397/#post-625806

When adding a user, a error message is triggered.

Problem/Justification

None

Impact

None

SmartDraw Connector

Katalon Manual Tests (BETA)

Activity

Show:

Bug Clerk January 28, 2021 at 12:17 PM

Bug Clerk January 27, 2021 at 7:06 PM

Christoph Lampl January 23, 2021 at 10:31 AM

Attachment attached

Bonnie Follweiler January 21, 2021 at 5:51 PM

Thank you for the report .  Can you please provide a debug by navigating to System -> Advanced, click save debug, and upload the attachment to the Attachment:Private are in this ticket?

Bonnie Follweiler January 21, 2021 at 5:49 PM

From the Forum post:

Version: TrueNAS-12.0-U1.1

I filled the fields:

  • Group ID

  • User

  • Secret

  • Secret (Confirm)

I left these fields blank:

  • Peer User

  • Peer Secret

  • Peer Secret (Confirm)

This is the error message which appears when trying to add a user at
Sharing -> Block Shares (iSCSI) -> Authorized Access

Code:
Error: Traceback (most recent call last): File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1247, in execute_context self.dialect.do_execute( File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 590, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: NOT NULL constraint failed: services_iscsitargetauthcredential.iscsi_target_auth_peersecret The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 137, in call_method result = await self.middleware._call(message['method'], serviceobj, methodobj, params, app=self, File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 1195, in _call return await methodobj(*prepared_call.args) File "/usr/local/lib/python3.8/site-packages/middlewared/service.py", line 455, in create rv = await self.middleware._call( File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 1195, in _call return await methodobj(*prepared_call.args) File "/usr/local/lib/python3.8/site-packages/middlewared/schema.py", line 973, in nf return await f(*args, **kwargs) File "/usr/local/lib/python3.8/site-packages/middlewared/plugins/iscsi.py", line 333, in do_create data['id'] = await self.middleware.call( File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 1238, in call return await self._call( File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 1195, in _call return await methodobj(*prepared_call.args) File "/usr/local/lib/python3.8/site-packages/middlewared/schema.py", line 973, in nf return await f(*args, *kwargs) File "/usr/local/lib/python3.8/site-packages/middlewared/plugins/datastore/write.py", line 31, in insert await self.middleware.call('datastore.execute_write', table.insert().values(*insert)) File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 1238, in call return await self._call( File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 1195, in _call return await methodobj(*prepared_call.args) File "/usr/local/lib/python3.8/site-packages/middlewared/plugins/datastore/connection.py", line 65, in execute_write return await self.middleware.run_in_executor(self.thread_pool, self._execute_write, sql, binds) File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 1110, in run_in_executor return await loop.run_in_executor(pool, functools.partial(method, *args, **kwargs)) File "/usr/local/lib/python3.8/concurrent/futures/thread.py", line 57, in run result = self.fn(*self.args, **self.kwargs) File "/usr/local/lib/python3.8/site-packages/middlewared/plugins/datastore/connection.py", line 68, in _execute_write result = self.connection.execute(sql, binds) File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 976, in execute return self._execute_text(object, multiparams, params) File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1145, in execute_text ret = self._execute_context( File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1287, in _execute_context self._handle_dbapi_exception( File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1481, in _handle_dbapi_exception util.raise( File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 178, in raise_ raise exception File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1247, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 590, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: services_iscsitargetauthcredential.iscsi_target_auth_peersecret [SQL: INSERT INTO services_iscsitargetauthcredential (iscsi_target_auth_tag, iscsi_target_auth_user, iscsi_target_auth_secret, iscsi_target_auth_peeruser) VALUES (?, ?, ?, ?)] [parameters: (1, 'gffdgdfgdfgdf', '/+gorWWdsWMLIz7Vx9JTLuzxIDI9So2JwqhUzlFwm3Hk1sYrQ+tv2g==', '')] (Background on this error at: http://sqlalche.me/e/gkpj)

Complete

Details

Assignee

Reporter

Labels

Impact

High

Components

Affects versions

Priority

More fields

Katalon Platform

Created January 18, 2021 at 9:32 PM
Updated July 1, 2022 at 5:14 PM
Resolved January 29, 2021 at 8:46 PM