I have successfully enabled my asterisk server to save voicemessages in wav format to an external MySQL database. And also, for easier voicemail access, I have created a custom PHP Webpage where my employees can access that page and play all the voicemessages in the database. From what I can see so far, That default MySQL Database lacks Time and Date Column.
My question is, Is it possible to create a custom MySQL column (In my case “Date and Time”) where each time a new voicemessage that is inserted by Asterisk into that Database it also inserts the time and date the voicemessage was created?
Hi @sedwards, Thanks for your reply.
The origtime column contains what I think is somewhat random numbers only like 1626026380,1625638036, etc. It doesn’t have the slightest hint of a time and date. Also, I tried adding a custom column in voicemessages table like datetime default value NOW() but that doesn’t work. The weird thing is when I play the VMs via an extension it plays the time and date it was created so I assume that asterisk stores it somewhere