Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Bug: During upgrade misp to 2.5 get maria db error (Invalid datetime format) #10054

Open
1 task done
RR19MR opened this issue Nov 20, 2024 · 3 comments
Open
1 task done

Bug: During upgrade misp to 2.5 get maria db error (Invalid datetime format) #10054

RR19MR opened this issue Nov 20, 2024 · 3 comments
Labels
needs triage This issue has been automatically labelled and needs further triage

Comments

@RR19MR
Copy link

RR19MR commented Nov 20, 2024

Actual behavior

After upgrading from Ubuntu 20.04 to 22.04 and MISP from 2.4.198 to 2.5.2 and php from 7.4 to 8.1, get error related maria db ( invalid datetime format). After upgrade server version was: 10.6.18-MariaDB-0ubuntu0.22.04.1 Ubuntu 22.04

Database update from 10.6.18 to 11.4.4-MariaDB did not resolve the issue.

Logs below.

Expected behavior

Steps to reproduce

Version

2.4.198

Operating System

Ubuntu

Operating System version

20.04

PHP version

7.4.33

Browser

No response

Browser version

No response

Relevant log output

2024-11-20 09:38:53 Error: [PDOException] SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '1732095533' for column `misp`.`logs`.`created` at row 1
Request URL: /users/login
Stack Trace:
#0 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Datasource/DboSource.php(502): PDOStatement->execute()
#1 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Datasource/DboSource.php(468): DboSource->_execute()
#2 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Datasource/DboSource.php(1132): DboSource->execute()
#3 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Model.php(1942): DboSource->create()
#4 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Model.php(1760): Model->_doSave()
#5 /var/www/MISP/app/Model/Log.php(277): Model->save()
#6 /var/www/MISP/app/Model/User.php(1340): Log->createLogEntry()
#7 /var/www/MISP/app/Plugin/ShibbAuth/Controller/Component/Auth/ApacheShibbAuthenticate.php(137): User->extralog()
#8 /var/www/MISP/app/Lib/cakephp/lib/Cake/Controller/Component/AuthComponent.php(698): ApacheShibbAuthenticate->getUser()
#9 /var/www/MISP/app/Lib/cakephp/lib/Cake/Controller/Component/AuthComponent.php(305): AuthComponent->_getUser()
#10 /var/www/MISP/app/Controller/AppController.php(1317): AuthComponent->startup()
#11 /var/www/MISP/app/Controller/AppController.php(270): AppController->_loadAuthenticationPlugins()
#12 /var/www/MISP/app/Controller/UsersController.php(29): AppController->beforeFilter()
#13 /var/www/MISP/app/Lib/Tools/BetterCakeEventManager.php(23): UsersController->beforeFilter()
#14 /var/www/MISP/app/Lib/cakephp/lib/Cake/Controller/Controller.php(682): BetterCakeEventManager->dispatch()
#15 /var/www/MISP/app/Lib/cakephp/lib/Cake/Routing/Dispatcher.php(189): Controller->startupProcess()
#16 /var/www/MISP/app/Lib/cakephp/lib/Cake/Routing/Dispatcher.php(167): Dispatcher->_invoke()
#17 /var/www/MISP/app/webroot/index.php(107): Dispatcher->dispatch()
#18 {main}

Extra attachments

No response

Code of Conduct

  • I agree to follow this project's Code of Conduct
@RR19MR RR19MR added the needs triage This issue has been automatically labelled and needs further triage label Nov 20, 2024
@iglocska
Copy link
Member

How did you run the update, you were on 22.04 and it should only work on 24.04?... Or did you do it manually?

@RR19MR
Copy link
Author

RR19MR commented Nov 20, 2024

How did you run the update, you were on 22.04 and it should only work on 24.04?... Or did you do it manually?
first upgrade ubuntu to 22.04, later upgrade MISP to 2.5.2 by git comands

@iglocska
Copy link
Member

There's an upgrade process to be followed, just switching to the 2.5 branch will definitely not work.

https://github.com/MISP/MISP/blob/2.5/INSTALL/UPGRADE.ubuntu2404.sh

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
needs triage This issue has been automatically labelled and needs further triage
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@iglocska @RR19MR