[JIRA] (JJDBC-5) Unable to install JDBC Plugin in idp4.1.0 or 4.2.1

[Vivien Wu (Jira)]

Vivien Wu ( https://shibboleth.atlassian.net/secure/ViewProfile.jspa?accountId=5f0e4b291a26ad001434d48d ) *commented* on JJDBC-5 ( https://shibboleth.atlassian.net/browse/JJDBC-5?atlOrigin=eyJpIjoiZDY0ZGQwMTIwYmQ0NGIwNDk0NjEwOGMxZTZmMDYzYzEiLCJwIjoiaiJ9 )

Re: Unable to install JDBC Plugin in idp4.1.0 or 4.2.1 ( https://shibboleth.atlassian.net/browse/JJDBC-5?atlOrigin=eyJpIjoiZDY0ZGQwMTIwYmQ0NGIwNDk0NjEwOGMxZTZmMDYzYzEiLCJwIjoiaiJ9 )

MySQL [shibidp_dev]> show create table StorageRecords;
| StorageRecords | CREATE TABLE StorageRecords (
context varchar(255) NOT NULL,
id varchar(255) NOT NULL,
expires bigint(20) DEFAULT NULL,
value longtext NOT NULL,
version bigint(20) NOT NULL,
created timestamp NULL DEFAULT CURRENT_TIMESTAMP,
updated timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (context,id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

Compared with yours, somehow, there are two extra timestamp related columns..

MySQL [shibidp_dev]> INSERT INTO StorageRecords (context,id,expires,value,version) VALUES ("net.shibboleth.plugin.storage.jdbc.impl.test", 
   -> "net.shibboleth.plugin.storage.jdbc.impl.test", 100,
   -> "net.shibboleth.plugin.storage.jdbc.impl.test", 1)
   -> ;
Query OK, 1 row affected (0.026 sec)

If I insert the record with named column.. then it seems to work.
Those two timestamp columns were added (automatically) after sql migration.. as it seems.

( https://shibboleth.atlassian.net/browse/JJDBC-5#add-comment?atlOrigin=eyJpIjoiZDY0ZGQwMTIwYmQ0NGIwNDk0NjEwOGMxZTZmMDYzYzEiLCJwIjoiaiJ9 ) Add Comment ( https://shibboleth.atlassian.net/browse/JJDBC-5#add-comment?atlOrigin=eyJpIjoiZDY0ZGQwMTIwYmQ0NGIwNDk0NjEwOGMxZTZmMDYzYzEiLCJwIjoiaiJ9 )

Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8 ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100201- sha1:00501c8 )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/commits/attachments/20220624/b28d4206/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-comment-icon-d041ef19-f720-4f1a-83bf-944219ae6b88
Type: image/png
Size: 1084 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220624/b28d4206/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-avatar-3aa78df2-0294-4d66-8578-af748735236e
Type: image/png
Size: 425 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220624/b28d4206/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-footer-desktop-logo-58546f23-b026-4458-ae32-0f20fbf6f25f
Type: image/png
Size: 10805 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220624/b28d4206/attachment-0005.png>