Categories
Add a reply View Replies (43)

Resolved Errors installing RO Single Signon

  1. Anonymous User(Eddie Konczal)
  2. Pre-sale questions
  3. Thursday, 30 July 2020
  4.  Subscribe via email
When I attempt to install RO Single Sign On version 1.2.0, I get these errors:



Warning

JInstaller: :Install: Error SQL Invalid default value for '_expire'

Extension Install: SQL error processing query: DB function failed with error number 1067

Invalid default value for '_expire'

SQL =



CREATE TABLE IF NOT EXISTS `#__saml_LogoutStore`

(

    `_authSource`   varchar(191) NOT NULL,

    `_nameId`       varchar(40)  NOT NULL,

    `_sessionIndex` varchar(50)  NOT NULL,

    `_expire`       DATETIME    NOT NULL DEFAULT CURRENT_TIMESTAMP

        ON UPDATE CURRENT_TIMESTAMP,

    `_sessionId`    varchar(50)  NOT NULL,

    UNIQUE KEY `_authSource` (`_authSource`(191), `_nameId`, `_sessionIndex`),

    KEY `#__saml_LogoutStore_expire` (`_expire`),

    KEY `#__saml_LogoutStore_nameId` (`_authSource`(191), `_nameId`)

)

    ENGINE = InnoDB

    DEFAULT CHARSET = utf8;



Package Install: There was an error installing an extension: com_ro_sso_1.2.0.zip


Here is the system configuration:

PHP Built On Linux 4.12.14-197.45-default #1 SMP Thu Jun 4 11:06:04 UTC 2020 (2b6c749) x86_64
Database Type mysql
Database Version 5.5.39
Database Collation utf8_general_ci
Database Connection Collation utf8mb4_general_ci
PHP Version 7.2.5
Web Server Apache
WebServer to PHP Interface apache2handler
Joomla! Version Joomla! 3.10.0-alpha1 Alpha [ Amani ] 23-July-2020 21:10 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

Regards,
Eddie
0
Responses (43)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Eddie,

And in the back-end, the metadata URL is clearly incorrect:

https://webdev.sas.rutgers.edu/cms/sandbox39/https://webdev.sas.rutgers.edu/cms/sandbox39/www/module.php/saml/sp/metadata.php/test-idps
Not sure if my message got missed but here is what I said:
The incorrect URLs you see are just incorrect on display.
If you fix the URL manually so it reads 


https://webdev.sas.rutgers.edu/cms/sandbox39/www/module.php/saml/sp/metadata.php/test-idps
doesn't that work for you?

Can you even get the SimpleSAMLphp dashboard by going to https://webdev.sas.rutgers.edu/cms/sandbox39/www/ ?

Shibboleth Service - Unsupported Request
The application you have accessed is not registered for use with this service.
That sounds like an incomplete setup? As I said before, I never configured Shibboleth before, so I don't really know what to setup or change. Just going on the assumption the configuration is no different than SAML based, this is what the official docs say about it: https://simplesamlphp.org/docs/stable/simplesamlphp-sp
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. Pre-sale questions
  3. # 1
Edward Konczal
Edward Konczal
Accepted Answer Pending Moderation
Hello, Roland,



I didn’t miss that, but I thought if I made the other changes suggested in your last email, that the refreshed metadata URL would reflect that.



I don’t see a way in the back-end to manually change the URL that is appearing in the Identity Provider Profile. Can this be done in the back-end, or does a
file need to be manually edited? And if so, which one?



I cannot get the SimpleSAMLphp dashboard by going to
https://webdev.sas.rutgers.edu/cms/sandbox39/www/ - when I go to that URL, it redirects me to


the IDP at:



https://test-idps.rutgers.edu/idp/profile/SAML2/Redirect/SSO?SAMLRequest=rVLLbtswEPwVgXeJsoT4QdgG3BhFDaSNYbk95FLQ5ComIJEqdxmlf19azsM%2BJKeeCAx3Zmdnd46ybTqxCnS0O%2FgTACl5bhuLYvhYsOCtcBINCitbQEFKVKvvd6LIctF5R065hl1QPmdIRPBknGXJZr1gv4taqXJaH4obVY8nZQETmU%2FGANNJCVqBnM6gjHhdS5b8Ao%2BRuWBRKNIRA2wskrQUobzI03yWjsb70UzcTEVePLBkHacxVtLAOhJ1KDinCKZGd5j5QI9RMwMdeAR4HKc2DfCT24LvQBsPinhV3bNk9Wr81lkMLfgK%2FJNR8HN39y7dw0HDU4byWlu1yFFafXDP5Yz3fc9bp0MDWXfs%2BCkzjue3SKXCAX0zyZLtS8hfjNXGPn6e7%2BFchOLbfr9Nt%2FfVni3nJ2kx5OWX%2F8NqCyS1JHntdM4v%2B8zPd%2FUjOtyst64x6m%2Fy1flW0scDjLLRgBid1kOpCBY7UKY2oOMKmsb1tx4kwYKRD8D48tz0%2Bn6X%2FwA%3D&RelayState=https%3A%2F%2Fwebdev.sas.rutgers.edu%2Fcms%2Fsandbox39%2Fwww%2Fmodule.php%2Fcore%2Flogin%2Ftest-idps




but it then says,


Shibboleth Service - Unsupported Request
The application you have accessed is not registered for use with this service.




Is there a possibility of setting up a Zoom meeting in the near future so I can show you the back end and possibly resolve these problems we are having?



Thanks,

Eddie





From: RolandD Cyber Produksi <support@rolandd.com>


Sent: Wednesday, September 16, 2020 3:46 PM

To: Edward Konczal <konczal@sas.rutgers.edu>

Subject: [#63545]: Errors installing RO Single Signon (Reply)
  1. more than a month ago
  2. Pre-sale questions
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Eddie,

The URLs you see in the backend are basically just for display purposes, they are only there to help you build that URL. You should see the same URLs (or in your case, the correct URLs) in the SimpleSAMLphp dashboard, if you would be able to get that to show.

I cannot get the SimpleSAMLphp dashboard by going to
https://webdev.sas.rutgers.edu/cms/sandbox39/www/ - when I go to that URL, it redirects me to
That is really odd because the www link should display the SimpleSAMLphp application. If you look into the folder libraries/simplesamlphp/www there is an index.php that should be served by the webserver.

Is there a possibility of setting up a Zoom meeting in the near future so I can show you the back end and possibly resolve these problems we are having?
Unfortunately that is not possible, I am too busy for my own good and really have no spare time.

Perhaps the best next step is to just get SimpleSAMLphp dashboard to function. If that doesn't work, I am guessing there will be other problems as well. I would say to undo the htaccess change for now and see if you can get the dashboard to show on https://URL TO THE SITE/libraries/simplesamlphp/www
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. Pre-sale questions
  3. # 3
  • Page :
  • 1
  • 2
  • 3


There are no replies made for this post yet.
Be one of the first to reply to this post!
Edward Konczal
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below. Supports gif,jpg,png,jpeg,zip,rar,pdf,csv,txt,tsv,xml,docx,doc,xls,xlsx,ods,tgz
• Insert • Remove Upload Files (Maximum File Size: 4 MB)
Cite your Sources with a URL link to help readers verify facts or find more details.
Add Another Link
In this section you can provide your site details at here and it visible to the moderators only.