ASTupdate crashes inserting agi params into live_channels

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

ASTupdate crashes inserting agi params into live_channels

Postby Acidshock » Tue Jul 17, 2018 1:20 pm

Got a weird problem. ASTupdate keeps crashing when its trying to insert data from a TTS agi that I have modified to use the google Wavenet library. I am at a complete loss of words on how its interpreting the data as extension/channel data and is getting referenced. Can someone give me some clues as to maybe work around this problem?

I call the AGI via a custom dial plan in the call menu.

exten => B,1,Playback(DynIVRIntroGCDHello)
exten => B,2,agi(googlecloudtts.agi,"Hello "~~${first_name}~~". We see that you are calling about order "~~${custom_order}~~". on ."~~${custom_date}~~". at ."~~${custom_time}~~"...",en)
exten => B,3,Playback(DynIVRIntroGCDPart2)
exten => B,4,Playback(DynIVRIntroGCDPart3)
exten => B,5,WaitExten(5)



DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '219878'~~". on ."~~04/25/2018~~". at ."~~12:00 PM~~"..."','"~~'219878'~~". on ."~~04/25/2018~~". at ."~~12:00 PM~~".' at line 1 at /usr/share/astguiclient/AST_update.pl line 991.
Couldn't execute query: |INSERT INTO live_channels (channel,server_ip,extension,channel_data) values('SIP/flr-00000251','192.168.0.33','"~~'219878'~~". on ."~~04/25/2018~~". at ."~~12:00 PM~~"..."','"~~'219878'~~". on ."~~04/25/2018~~". at ."~~12:00 PM~~"...",en')|
Last edited by Acidshock on Tue Jul 17, 2018 1:37 pm, edited 2 times in total.
VERSION: 2.14-698a | BUILD: 190207-2301 | Asterisk:13.24.1-vici | Vicibox 8.1.2
Acidshock
 
Posts: 428
Joined: Wed Mar 03, 2010 3:19 pm

Re: ASTupdate crashes inserting agi params into live_channel

Postby mflorell » Tue Jul 17, 2018 1:34 pm

What is the admin.php version and build on that system?
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: ASTupdate crashes inserting agi params into live_channel

Postby Acidshock » Tue Jul 17, 2018 1:34 pm

VERSION: 2.14-645a
BUILD: 171214-2045
VERSION: 2.14-698a | BUILD: 190207-2301 | Asterisk:13.24.1-vici | Vicibox 8.1.2
Acidshock
 
Posts: 428
Joined: Wed Mar 03, 2010 3:19 pm

Re: ASTupdate crashes inserting agi params into live_channel

Postby Acidshock » Tue Jul 17, 2018 4:29 pm

Got a work around that seems to be working. I offloaded the text into its own AGI and then passed variables over using --- as a separator similar to other AGIs that VICIDIAL uses. Really wanted to keep it so that I could supply the text in the dial plan but special characters seem to be an issue and I dont know how to sanitize so that its not breaking if the ASTupdate script picks it up. I guess it could be used as a method for SQL injection too.
VERSION: 2.14-698a | BUILD: 190207-2301 | Asterisk:13.24.1-vici | Vicibox 8.1.2
Acidshock
 
Posts: 428
Joined: Wed Mar 03, 2010 3:19 pm


Return to Support

Who is online

Users browsing this forum: No registered users and 66 guests