:) Thank you Guillaume. I think this will help me out. Have a good weekend! On Fri, 2017 Jul 07, 15:18:36 (+0000), Guillaume Lefranc wrote:
Hi Curtis,
yes MariaDB has the function to schedule events internally, check SHOW EVENTS, CREATE EVENT, etc.
Cheers, GL
Le ven. 7 juil. 2017 à 16:33, Curtis Brown <Curtis.Brown@colostate.edu> a écrit :
Hi Guillaume! Thank you for bringing some ideas to mind. When you said "set up an event which runs regularly", were you thinking of a cron job or some similar cron-like functionaility in MariaDB/MySQL, or something else? Can you elaborate?
On Fri, 2017 Jul 07, 10:22:28 (+0200), Guillaume Lefranc wrote:
Hi Curtis,
two different solutions come to mind.
You could wrap your user creation in a stored procedure that does all the heavy lifting: create the user and perform the additional functions
Or, you could set up an event which runs regularly, checks if new users have been added, and if that is the case runs aforementioned functions.
Hope that helps!
-GL
2017-07-07 0:41 GMT+02:00 Curtis Brown <Curtis.Brown@colostate.edu>:
I apologize in advance if this is the wrong venue; please point me in a more correct direction if that's the case.
I want to perform some extra database functions when a new user is
created
in our MariaDB installation. What I am learning though is that I can't CREATE TRIGGERs against system tables like the user table in the mysql database.
I am using MariaDB v10.1.24 in an Ubuntu 16.04.2 environment
Have others run across a similar situation? Are there techniques to work around this? One thought I had was to enable general query log and either monitor the file output or TRIGGER on the general_log table. Are there any better suggestions? Thanks in advance.
-- Curtis Brown, unix system administrator For general PC questions, Academic Computing and Networking Services call: 970-491-7276 <(970)%20491-7276> Colorado State University email: help@colostate.edu curtis.brown@colostate.edu http://lib.colostate.edu/helpdesk/
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Curtis Brown, unix system administrator For general PC questions, Academic Computing and Networking Services call: 970-491-7276 <(970)%20491-7276> Colorado State University email: help@colostate.edu curtis.brown@colostate.edu http://lib.colostate.edu/helpdesk/
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Curtis Brown, unix system administrator For general PC questions, Academic Computing and Networking Services call: 970-491-7276 Colorado State University email: help@colostate.edu curtis.brown@colostate.edu http://lib.colostate.edu/helpdesk/