[Serusers] Fwd: Questions re. MySQL

adding '--skip-column-names' to the mysql query solves this problem. sorry for unncessary question. still need help regarding other questions though..... :-( Frq ---------- Forwarded message ---------- From: frq ser <frq.ser(a)googlemail.com> Date: Fri, Apr 11, 2008 at 2:57 PM Subject: Fwd: Questions re. MySQL To: serusers(a)iptel.org I think I've found the answer to Q2 in my below email. For example, if wanted to retrieve the email address of user 1000, I'd use something like: exec_msg ('P=$(mysql -u root -D ser --password=mypassword -e "select email_address from subscriber where username=1000"') There is a problem though. If I type this on Linux shell: the output is: does anyone know how to get rid of the field name and just get the value. That is, instead of getting "email address 1000@localhost", how could I get just "1000@localhost" ? ---------- Forwarded message ---------- From: frq ser <frq.ser(a)googlemail.com> Date: Fri, Apr 11, 2008 at 1:41 PM Subject: Questions re. MySQL To: serusers(a)iptel.org Hi, Here's a set of basic questions for which I need your help. I want to play different announcements based on the caller's history. For simplicity, I want ann1_user1.wav to be played for the first call, and ann2_user1.wav for all subsequent calls from the 1st user. Similarly for 2nd user, the files would be ann*_user2.wav. 1) I want to have a basic record of the number of times a user has called the SER(ie, sent an INVITE). Which table and column in mySQL can I use for this purpose. Also, how can I write the integer using SER commands (ie something that I can put in ser.cfg file). There is an example ( http://www.iptel.org/write_custom_text_to_mysql_acc_table) which uses 'acc_db_request', but it can only write to sip_status column in acc table. How can I modify /write to to any general field in mysql? 2) Subsequently, how can I retreive this value from mysql through some command in ser.cfg file. I want to use this value in an 'if' statement and redirect the process flow accordingly. 3) I was thinking of rewriting the uri to make it 'ann1_user1@xxxxx' and sending the request to early_announce application so that the user hears different announcement based on username and their call history (ie whether this user has called before or not). However, I am not very clear about how to do this. Is there any simpler method to do this. The final aim of this whole exercise is to demonstrate call differentiation based on username and user history. So if someone has a better idea then please do share it. Thanks for the help and accept my apologies for squeezing so many questions into a single message. Regards, Frq