Matthew Boehm wrote:
How do I do that inside of CLI?2. Run the query inside MySQL cli. How many rows where returned? If none, then its your fault it failed.
if you don't know what the MySQL CLI is then you need to stop using mysql.
Are you talking about "host *CLI>" or "host mysql>" ? At least I was looking for a way to get the data via *CLI!
I see that you are running phpmyadmin, did you run the query that debug
spits out? How many rows returned? Did you create the table using the schema
on the wiki? Do you have all the columns? Running newest versions of
everything?
mysql> select * from sip_buddies where name='621';
+----+------+-------------+----------+-----------+--------------+-------------+---------+-----------+----------+----------+------------+---------+---------------+---------------+----------+----------+-----------+-----------+-----+--------+------+------+-------------+------+---------+-------------+------------+----------------+-----------+--------+----------+-----------+----------+-------------+------------+--------+----------------+
| id | name | accountcode | amaflags | callgroup | callerid | canreinvite | context | defaultip | dtmfmode | fromuser | fromdomain | host | incominglimit | outgoinglimit | insecure | language | mailbox | md5secret | nat | permit | deny | mask | pickupgroup | port | qualify | restrictcid | rtptimeout | rtpholdtimeout | secret | type | username | allow | disallow | musiconhold | regseconds | ipaddr | cancallforward |
+----+------+-------------+----------+-----------+--------------+-------------+---------+-----------+----------+----------+------------+---------+---------------+---------------+----------+----------+-----------+-----------+-----+--------+------+------+-------------+------+---------+-------------+------------+----------------+-----------+--------+----------+-----------+----------+-------------+------------+--------+----------------+
| 1 | 621 | NULL | NULL | NULL | "Demo" <621> | yes | inhouse | NULL | rfc2833 | NULL | NULL | dynamic | NULL | NULL | NULL | NULL | [EMAIL PROTECTED] | NULL | 1 | NULL | NULL | NULL | 1 | | 999 | NULL | NULL | NULL | Password | friend | 621 | ulaw;alaw | all | NULL | 0 | | yes |
+----+------+-------------+----------+-----------+--------------+-------------+---------+-----------+----------+----------+------------+---------+---------------+---------------+----------+----------+-----------+-----------+-----+--------+------+------+-------------+------+---------+-------------+------------+----------------+-----------+--------+----------+-----------+----------+-------------+------------+--------+----------------+
1 row in set (0.00 sec)
I believe I use the newest version, since I installed it from the wiki just three days ago! (copy and past)
I have only one record in the database (phone 621)
bye
Ronald
_______________________________________________ Asterisk-Users mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
