Sun Microsystems, Inc.  Oracle System Handbook - ISO 7.0 May 2018 Internal/Partner Edition
   Home | Current Systems | Former STK Products | EOL Systems | Components | General Info | Search | Feedback

Asset ID: 1-72-2313990.1
Update Date:2017-10-09
Keywords:
Solution Type  Problem Resolution Sure

Solution  2313990.1 :   PMAC Guest Upgrade Failed From Release 6.0 to 6.4 with ERROR 1292 (22007) at line 866: Incorrect datetime value: '0000-00-00 00:00:00' for column 'last_password_change' at row 1  

Related Items 
    

  • Oracle Communications Diameter Signaling Router (DSR)
    •  
Related Categories 
    

  • PLA-Support>Sun Systems>CommsGBU>Global Signaling Solutions>SN-SND: Tekelec DSR
    •  






In this Document


Symptoms


Changes


Cause


Solution



Created from <SR 3-15740211571>


Applies to:  

Oracle Communications Diameter Signaling Router (DSR) - Version DSR 7.0 to DSR 8.1.0 [Release DSR 7.0 to DSR 8.0]
Information in this document applies to any platform.



Symptoms


PMAC Guest upgrade Failed from Release 6.0 to Release 6.4


DSR Release Upgrade R7.3  to R8.1.1

Error in upgrade logs /var/TKLC/log/upgrade/upgrade.log:


1505349456::ERROR 1292 (22007) at line 866: Incorrect datetime value: '0000-00-00 00:00:00' for column 'last_password_change' at row 1


Changes


 


Cause


The issue is caused by "pmacadmin" user. The "last_password_change" field shows invalid timestamp value "0000-00-00 00:00:00" as reported in Upgrade Failure log.


from command /usr/bin/sudo /usr/bin/mysql -psmp-$((6**8)) SmacGUI -e "select * from user"
********** (not pasting all fields) 
| username | passwd | groupname | comment | consecutive_failed_login_attempts | last_password_change
| pmacadmin | $6$rounds=5000$Mpw.XL65xegFvgEu$D60RySKkIj0Rw./UN3ZKJMCCaXTtQtPqjygHMRQlhBwfyL79Ih0joGX | admin | PM&C GUI Superuser | 5 | 0000-00-00 00:00:00 |
| pmacop | $6$rounds=5000$bXrjm96/HaWy0kOf$A8hAkjgUlORb0mIe4ozML6xjVyUa3ikDV9fWDIwzsVE1rgKbrQj2NNKx0 | ops | PM&C GUI Operators | 0 | 2012-12-06 19:00:00 |

***********




Solution


Please, contact Oracle TAC for verification and commands in order to correct the datetime issue for a user.


Following logs are required to provide:


    

  1. Upgrade logs: (/var/TKLC/log/upgrade/upgrade.log)
    2. 

  2. savelogs_smac: (sudo /usr/TKLC/smac/bin/savelogs_smac)
    3. 

  3. sudo mysql -psmp-$((6**8)) SmacGUI -e 'select * from user''
    4. 

  4. savelogs_plat: ( sudo /usr/TKLC/plat/sbin/savelogs_plat --workdir=/var/TKLC/db/filemgmt
    5. 





For TAC: IF the logs indicate the same failure and same user as in "cause" following commands need to be run to fix it




/usr/bin/sudo /usr/bin/mysql -psmp-$((6**8)) SmacGUI -e "UPDATE user SET last_password_change=NOW() WHERE username='pmacadmin'"


/usr/bin/sudo /usr/bin/mysql -psmp-$((6**8)) SmacGUI -e "UPDATE user SET last_login=NOW() WHERE username='pmacop'"


/usr/bin/sudo /usr/bin/mysql -psmp-$((6**8)) SmacGUI -e "UPDATE user SET last_password_change=NOW() WHERE username='c0shasy'"
/usr/bin/sudo /usr/bin/mysql -psmp-$((6**8)) SmacGUI -e "UPDATE user SET last_login=NOW() WHERE username='c0shasy'"


/usr/bin/sudo /usr/bin/mysql -psmp-$((6**8)) SmacGUI -e "UPDATE user SET last_password_change=NOW() WHERE username='c0tsafr'"
/usr/bin/sudo /usr/bin/mysql -psmp-$((6**8)) SmacGUI -e "UPDATE user SET last_login=NOW() WHERE username='c0tsafr'"




After making the changes, need to verify that no users in user table have an entry in any field with "0000-00-00 00:00:00" in it.


Enter the following command to verify this:


/usr/bin/sudo /usr/bin/mysql -psmp-$((6**8)) SmacGUI -e "select * from user"


Check each user defined in this table. Make sure there are no 0 strings for a timestamp.




 



Attachments

This solution has no attachment


















       

Copyright © 2018 Oracle, Inc.  All rights reserved.

 Feedback