Search the Community
Showing results for tags 'single sign-on'.
-
I'm attempting to utilise single sign on in WHMCS, but get a PDO error "Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'user_id' cannot be null' in /whmcs/vendor/illuminate/database/Connection.php:444". I have the correct request parameters as described here: http://docs.whmcs.com/API:CreateOAuthCredential. The params I'm using are: username:xxxxxxxx password:xxxxxxxxx action:CreateOAuthCredential grantType:single_sign_on scope:clientarea:sso clientarea:profile description:Test SSO serviceId:<USER ID HERE> responsetype:json I put some logging in Connection.php and it appears WHMCS is attempting to insert into `tbloauthserver_clients`, but there is no user_id. How do I pass user_id as a parameter? What am I doing wrong?
-
- oauth
- single sign on
-
(and 2 more)
Tagged with:
-
The client area product details page changes when single sign-on is enabled, and it looks like this: http://docs.whmcs.com/CPanel_Single_Sign-On#Customising_Single_Sign-On_Shortcuts Rather than doing all the customizing work, I'd prefer to keep using the old look and forget about the integration. Is there an option for this, besides hacking the code for clientareaproductdetails.tpl?
- 2 replies
-
- client area
- product details
-
(and 1 more)
Tagged with:
-
For the last three days I have spent hours exchanging messages with the helpful and really nice people from the Support team regarding some strange issues that we affecting my WHMCS installation. The symptoms were: At the "OpenID Connect" page I was getting an error for not existing SSL certificate. Which was bizarre since I have a wildcard SSL installed and it is verifying perfectly. Clicking any of the "Billings & Support" Cpanel section links, was redirecting OK at first but then throwing an expired token error like this: {"error":"expired_token","error_description":"The access token provided has expired"} Finally we realised that the solutions to these problems were the following: A GeolocationIP hook (called geolocation_hook.php) was causing the missing SSL error on OpenID Connect page. Removing this hook, fixed the issue. The Billings & Support issue was caused due to a difference between PHP and mySQL server time. As soon as the two timezones were identical, problem was solved. Let's hope that this might help someone who happens to have the same issues. How possible is that? Thanks to the WHMCS support team for their help, patience and efforts.
