clopez2007
Intenta esto
PAra que te funcione necesitas homologar tu relación de trunks. en mi caso lo tengo asi: Nombre-Apellido
O podría ser, Nombre-Departamento
#!/bin/sh
OLDIFS=IFS
MYSQL_USER="read"
MYSQL_PASSWORD="Tu1297dnAPAss"
MYSQL_HOST="180.201.76.12"
sql_database="asterisk"
#sql_args="-h $sql_host -u $slq_usuario -p$sql_password -D $sql_database -s -e"
SQL="SET CHARACTER SET utf8; SELECT extension FROM users"
SQL2="SET CHARACTER SET utf8; SELECT name FROM users"
IFS="echo -e "\t\n\r\f"
"
declare -a IPS
results=(echo "$SQL" | mysql -u $MYSQL_USER --password=$MYSQL_PASSWORD -D $sql_database -h $MYSQL_HOST --skip-column-names
)
results2=(echo "$SQL2" | mysql -u $MYSQL_USER --password=$MYSQL_PASSWORD -D $sql_database -h $MYSQL_HOST --skip-column-names -s
)
#results=($(mysql $sql_args "SELECT extension from users;"))
#results2=($(mysql $sql_args "SELECT name from users;"))
cnt=${#results[@]}
echo "conteo de consults" $cnt
rm /tftpboot/phonebook.xml
touch /tftpboot/phonebook.xml
echo "<?xml version='1.0' encoding='UTF-8'?>" >> /tftpboot/phonebook.xml
echo "<AddressBook>" >> /tftpboot/phonebook.xml
for (( i=0 ;i<$cnt;i++ ))
do
echo "Record No." $i ":" ${results[$i]};
echo "Record No." $i ":" ${results2[$i]};
lastna=$(echo ${results2[$i]}| cut -d'-' -f 2)
firta=$(echo ${results2[$i]}| cut -d'-' -f 1)
echo "<Contact>" >> /tftpboot/phonebook.xml
echo "<LastName>$lastna</LastName>" >> /tftpboot/phonebook.xml
echo "<FirstName>$firta</FirstName>" >> /tftpboot/phonebook.xml
echo "<Phone>" >> /tftpboot/phonebook.xml
echo "<phonenumber>${results[$i]}</phonenumber>" >> /tftpboot/phonebook.xml
echo "<accountindex>1</accountindex>" >> /tftpboot/phonebook.xml
echo "<downloaded>0</downloaded>" >> /tftpboot/phonebook.xml
echo "</Phone>" >> /tftpboot/phonebook.xml
echo "</Contact>" >> /tftpboot/phonebook.xml
done
echo "</AddressBook>" >> /tftpboot/phonebook.xml
Mete tu script en un cron, y todo funcionara! =D