Xdmod SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: 'NOW()' for column `moddb`.`Users`.`password_last_updated` at row 1

[ssofya]

Hello,

I’m trying to configure xdmod 10 on CentOS 8 with PHP 7.2.24.
When I run xdmod-setup option 5 Create Admin User I’m getting this error:

SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘NOW()’ for column moddb.Users.password_last_updated at row 1

I tried manually adding Admin user to the database and it let me to add the user.
Also, I tried changing table format from timestamp to datetime and it didn’t help either.

I configured SimplePHPSaml but when It try to log in I get this error:
Access forbidden
You don’t have the needed privileges to access this application. Please contact the administrator if you find this to be incorrect.

I suspect it might be related.

Can you please advise?

[jeff.ohrstrom]

We’re not entirely sure. I did find this support portal but I’ll now use back channels to see if that’s the appropriate way to get help.

Solutions

[jpwhite4 (White, Joseph)]

Please can you ask this in the XDMoD help and we’ll try to get back to you quickly:
Support contact information is here: Open XDMoD - Support

[ssofya]

Thank you so much for your responses. I emailed to ccr-xdmod-help at buffalo.edu