Can the system command be used to retrieve a variable from a mysql database using the mysql command line client?? or would it be simpler to write some sort of AGI type application?? -- ______________________________________________ http://www.linuxmail.org/ Now with e-mail forwarding for only US$5.95/yr Powered by Outblaze
On Mon, 2003-07-07 at 12:43, WipeOut . wrote:> Can the system command be used to retrieve a variable from a mysql database using the mysql command line client?? > or would it be simpler to write some sort of AGI type application??-= Info about application 'System' =- [Synopsis]: Execute a system command [Description]: System(command): Executes a command by using system(). Returns -1 on failure to execute the specified command. If the command itself executes but is in error, and if there exists a priority n + 101, where 'n' is the priority of the current instance, then the channel will be setup to continue at that priority level. Otherwise, System returns 0.>From this it looks like there is no direct route to a asterisk variable.Your only option would be a numeric return and then coding for each n+101 priority. Better and easier to go AGI or postgres. -- Steven Critchfield <critch@basesys.com>
The system at the moment can run some program/script but there is no way to retrieve the results. Although you could have tried with ${ENV(VARIABLE)} Martin On Mon, 7 Jul 2003, WipeOut . wrote:> Can the system command be used to retrieve a variable from a mysql database using the mysql command line client?? > or would it be simpler to write some sort of AGI type application?? > -- > ______________________________________________ > http://www.linuxmail.org/ > Now with e-mail forwarding for only US$5.95/yr > > Powered by Outblaze > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users >
It could be possible, but it might be simpler to try AGI and Asterisk-PERL. It works great! -wade> -----Original Message----- > From: asterisk-users-admin@lists.digium.com [mailto:asterisk-users- > admin@lists.digium.com] On Behalf Of WipeOut . > Sent: Monday, July 07, 2003 1:44 PM > To: asterisk-users@lists.digium.com > Subject: [Asterisk-Users] System command.. > > Can the system command be used to retrieve a variable from a mysql > database using the mysql command line client?? > or would it be simpler to write some sort of AGI type application?? > -- > ______________________________________________ > http://www.linuxmail.org/ > Now with e-mail forwarding for only US$5.95/yr > > Powered by Outblaze > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users