:) 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 <[email protected]> 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 <[email protected]>: > > > > > > > > > > > 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: > > [email protected] > > > > [email protected] > > http://lib.colostate.edu/helpdesk/ > > > > > > > > _______________________________________________ > > > > Mailing list: https://launchpad.net/~maria-discuss > > > > Post to : [email protected] > > > > 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: [email protected] > > [email protected] http://lib.colostate.edu/helpdesk/ > > > > _______________________________________________ > > Mailing list: https://launchpad.net/~maria-discuss > > Post to : [email protected] > > 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: [email protected] [email protected] http://lib.colostate.edu/helpdesk/ _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
