tag:blogger.com,1999:blog-7884492825228653821.post4351282089327513517..comments2024-03-08T15:14:19.603+05:30Comments on CrazyTechThoughts: Call an external program from MySQL triggerSarbajit Chatterjeehttp://www.blogger.com/profile/07178321902250011434noreply@blogger.comBlogger66125tag:blogger.com,1999:blog-7884492825228653821.post-61617647256038146692022-04-29T17:36:56.389+05:302022-04-29T17:36:56.389+05:30can you explain me how to do that using windows, i...can you explain me how to do that using windows, instead of linux?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-86321990954195270672021-11-09T10:32:04.117+05:302021-11-09T10:32:04.117+05:30Taking a drug test can be a scary thought, even if...Taking a drug test can be a scary thought, even if you don’t do drugs. Numerous pieces of advice on the web may cater to audiences with varying needs. But they might create confusion, too. The whole thing can be a messy quagmire of myths, quick fixes, and even worse, some very bad advice.So, what do you do when a drug test is around the corner? If you often consume substances that could get you into trouble on a drug test but want to get clean for your job interview, you may want to find proper guidance.Detoxification is one of the primary methods to prepare your body for a hassle-free drug test. But first, you must understand how most drug tests work in order to successfully detoxify your body and prepare it in the best way possible.Note: This article isn’t meant for cocaine or heroin addicts trying to pass a drug test. In this article, we specifically talk about weed-lovers – occasional or habitual – and how they can beat the test without raising any alarm.#2. Most labs accept urine samples between 90 and 100 degrees Fahrenheit. Finally, the deposit must have the specific gravity of real piss. It can’t have any unusual sediments at the bottom or separate when left to sit.When employing the use of synthetic urine to pass a drug test, you sneak your pee into the facility undetected. Then, once you’re in the bathroom, simply pour your prepared sample of fake piss into the container instead of urinating into it. As long as you don’t experience any leaks or spills, it can truly be that straightforward.Unow22https://www.blogger.com/profile/07800738312523344518noreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-30493344608789438932019-05-08T18:58:16.015+05:302019-05-08T18:58:16.015+05:30instead of installing libmysqlclient15-dev change ...instead of installing libmysqlclient15-dev change your makefile and add those two flags to the gcc command -DMYSQL_DYNAMIC_PLUGIN -fPICAmen AYADIhttps://www.blogger.com/profile/02574215632287331777noreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-53759335193083524092017-05-27T18:12:26.402+05:302017-05-27T18:12:26.402+05:30I want to execute an sh scrpipt but nothing is hap...I want to execute an sh scrpipt but nothing is happening when I execute the following code:<br /><br />DELIMITER @@<br /><br />CREATE TRIGGER autohome1 <br />AFTER INSERT ON prueba<br />FOR EACH ROW <br />BEGIN<br /> DECLARE cmd VARCHAR(255);<br /> DECLARE result int(10);<br /> SET cmd=CONCAT('sh /home/pi/Desktop/Py_Script_Auto_Home/autohome.sh');<br /> SET result = sys_exec(cmd);<br />END;<br />@@<br />DELIMITER ;<br /><br />I just want to execute the script, and I dont mind about returning values or whatever, should I still be using the sys_exec funcition??.<br /><br />Thanks beforehand.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-35274550809212814892017-05-26T22:10:43.734+05:302017-05-26T22:10:43.734+05:30This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/15041412186483253653noreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-27875122422807985702017-05-02T07:52:36.025+05:302017-05-02T07:52:36.025+05:30Hello,
I am not able to install apt-get install li...Hello,<br />I am not able to install apt-get install libmysqlclient15-dev<br />but i am able to install apt-get install libmysqlclient-dev<br />after that given shell script is not running please help me.<br />but i am able to install apt-get install libmysqlclient-dev<br />after that given shell script is not running please help me.<br />i have ubuntu 64 system <br />but when i going to install apt-get install libmysqlclient15-dev then its show me unable to locate package.Anonymoushttps://www.blogger.com/profile/00046080373103957939noreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-91928686756543327232017-05-02T07:49:21.695+05:302017-05-02T07:49:21.695+05:30This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/00046080373103957939noreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-45418998388766376732017-04-10T16:31:04.932+05:302017-04-10T16:31:04.932+05:30sudo ln -s /etc/apparmor.d/usr.sbin.mysqld /etc/ap...sudo ln -s /etc/apparmor.d/usr.sbin.mysqld /etc/apparmor.d/disable/<br /><br />sudo apparmor_parser -R /etc/apparmor.d/usr.sbin.mysqld<br /><br />you need to execute above commands in linux prompt after you install the lib_mysqludf_sys library successfullyAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-74991855100274796612017-03-30T12:40:34.052+05:302017-03-30T12:40:34.052+05:30Which MySQL version supports as it is working on 5...Which MySQL version supports as it is working on 5.0 but not in above 5.0..please suggest if it is true?<br />As somebody ask here also http://answerguru.net/798/how-to-execute-call-an-external-program-from-mysql-trigger?show=1396#c1396<br /><br />but no one answered, please helpSunny Khetarpalhttps://www.blogger.com/profile/03055123965649400798noreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-56482836111381722922017-03-30T12:37:09.981+05:302017-03-30T12:37:09.981+05:30This comment has been removed by the author.Sunny Khetarpalhttps://www.blogger.com/profile/03055123965649400798noreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-64274516827639445922017-03-07T00:32:26.736+05:302017-03-07T00:32:26.736+05:30Hello, how can i execute a java file?Hello, how can i execute a java file?JPMhttps://www.blogger.com/profile/09225746403608960731noreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-74059889320088004642016-11-01T22:56:54.389+05:302016-11-01T22:56:54.389+05:30Is there a way that i can publish the changes to t...Is there a way that i can publish the changes to the external python application?? ( changes > ./python.py )Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-83816252584244254982016-09-29T09:43:11.848+05:302016-09-29T09:43:11.848+05:30It's the same thing as linux. First find where...It's the same thing as linux. First find where your php is. Shortly in command you should do "php your_php_file.php"Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-32635534758004096742016-06-30T12:02:19.575+05:302016-06-30T12:02:19.575+05:30is 'testesito' a shell script?
in that ca...is 'testesito' a shell script? <br />in that case please run 'bash /home/sgroup/viticontrol/testesito' as the command.<br />Please do let me know if it worksRIQhttps://www.blogger.com/profile/06017812105636057829noreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-31672317808040191482016-05-20T01:21:19.265+05:302016-05-20T01:21:19.265+05:30Suggesting an edit to the blog motto: "I hope...Suggesting an edit to the blog motto: "I hope some of them are _just_ crazy enough for you to try out."<br />(cf. http://tvtropes.org/pmwiki/pmwiki.php/Main/CrazyEnoughToWork )Anonymoushttps://www.blogger.com/profile/00348123273121068694noreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-37325173471025730172016-02-22T16:27:42.842+05:302016-02-22T16:27:42.842+05:30Hi,
I want to execute triger when data insert in ...Hi,<br /><br />I want to execute triger when data insert in table. I have run your triger code but I am getting sys_exe dose not exist. if any other way to execute this command please let me know.<br /><br />Thank youSOULShttps://www.blogger.com/profile/08231757762542005717noreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-30505108084002696962015-12-10T12:10:52.159+05:302015-12-10T12:10:52.159+05:30Hello ,there,
I am new to the UDF thing please he...Hello ,there,<br /><br />I am new to the UDF thing please help me to install with it MYSQL and how to call the UDF function in TriggerAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-47693383297545174652015-12-01T19:39:42.827+05:302015-12-01T19:39:42.827+05:30I have the same problem on centos 7.
When i run co...I have the same problem on centos 7.<br />When i run command select sys_exec('/usr/bin/php /tmp/test.php');<br />get the error: Could not open input file: /tmp/test.php<br />file test.php has owner mysql MariaDB and permission set to 777<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-73798551770922705412015-07-04T16:56:56.202+05:302015-07-04T16:56:56.202+05:30We've been trying to use sys_exec without succ...We've been trying to use sys_exec without success. <br /><br />We installed lib_mysqludf_sys successfully. But when we define a trigger in a mysql database (using phpmyadmin in a linux environment, it does not trigger as desired the execution of a given function (testesito) located on a specific directory. We have tried several syntaxes:<br /><br />BEGIN<br /> DECLARE cmd CHAR(255);<br /> DECLARE resultado int(10);<br /> SET cmd='/home/sgroup/viticontrol/testesito';<br /> SET resultado = sys_exec(cmd);<br />END<br /><br />we also tried other commands:<br /><br /> SET cmd=CONCAT('cd /home/sgroup/viticontrol/testesito');<br /> SET cmd=CONCAT('cd /home/sgroup/viticontrol/', './testesito');<br /><br />None give an error. the shall trigger occurs when the table is updated. But when we change the value of a given line of the table, the trigger does not execute as desired the executable. <br /><br />Any hint?Lucio Studerhttps://www.blogger.com/profile/06810656294061427676noreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-12786748360945326752015-06-06T01:48:02.900+05:302015-06-06T01:48:02.900+05:30I dont know if anybody still got the "ERROR: ...I dont know if anybody still got the "ERROR: You need libmysqlclient development software installed" but I found a working solution :<br /><br />yum install mysql-devel -yDevrim Baharhttps://www.blogger.com/profile/00851966033258814700noreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-13098320733324833262015-04-30T12:26:10.969+05:302015-04-30T12:26:10.969+05:30how can i set execute permission for mysql user fo...how can i set execute permission for mysql user for executing command/program..<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-86394971852774809312015-04-30T12:12:16.394+05:302015-04-30T12:12:16.394+05:30tried using mkdir/tmp/test_dir..its not creating a...tried using mkdir/tmp/test_dir..its not creating any folder..how to solve this plz let me knowAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-80162428458098718852015-04-30T12:08:00.486+05:302015-04-30T12:08:00.486+05:30i am not able to call external program from trigge...i am not able to call external program from trigger using sys_exec()Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-56585582667552843462015-02-05T01:16:53.291+05:302015-02-05T01:16:53.291+05:30Good Article!.
I am looking to do the same in Win...Good Article!.<br /><br />I am looking to do the same in Windows system running mysql (xampp) The library is for linux. Any help ?<br /><br />Thanks in advance.<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7884492825228653821.post-68009005563992500602015-01-14T22:34:03.383+05:302015-01-14T22:34:03.383+05:30Hello, very usefull article.
Can I with mysql tri...Hello, very usefull article.<br /><br />Can I with mysql trigger, call a method in a jar that is already running? Here is what i want to do. I have a web site in PHP and when a user logs in succesfully, I want a mysql trigger invoke a java method from a class that is already running and wait to be awaked.<br /><br />Thanks in advanceAnonymoushttps://www.blogger.com/profile/04977596200099800407noreply@blogger.com