[Asterisk-Users] Realtime does not work yet, ...

[Ronald Wiplinger]

Matthew Boehm wrote:

>>>2. Run the query inside MySQL cli. How many rows where returned? If
>>>none, then its your fault it failed.
>>>
>>>
>>>      
>>>
>>How do I do that inside of CLI?
>>    
>>
>
>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     | 
621 at other | 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