Mike Holloway wrote:
If you have phpMyAdmin installed, you can simply go to the webpage, go
into the mysql database, the db table, hit the Browser tab, and clone
the line for your particular asterisk db, changing the Host to %,
which will permit any host to connect to that database (assuming
proper user/password).
If you don't have phpMyAdmin installed, install it :P
Instead, from linux shell, you can follow the instructions on that URL
I sent, something like:
# mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
where *.* is the database name (or just leave *.* for all db's) and
root is the username that you will be connecting to mysql with. The
user must already exist in the 'user' table of the mysql database.
You can see what databases and users are already defined:
mysql> SELECT * from database;
mysql> SELECT * from user;
I used the wrong ip address in the GRANT statement, .....
However, I still have some troubles
dns*CLI> realtime load sippeers name 612
Column Name Column Value
-------------------- --------------------
id 65
name 612
accountcode 612
callerid "Ronald Video 612",<612>
canreinvite yes
context default
dtmfmode rfc2833
host dynamic
mailbox [EMAIL PROTECTED]
nat yes
pickupgroup 1
qualify 1000
secret deleted
type friend
username 612
disallow all
allow ulaw
allow alaw
allow speex
allow gsm
allow h263
allow h263p
regseconds 0
cancallforward yes
Jun 7 20:54:58 NOTICE[27657]: chan_sip.c:8098 handle_request:
Registration from '"Ronald Video (612)"<sip:[EMAIL PROTECTED]>' failed
for '192.168.250.108'
What do I still miss on my move?
BTW, I have a user, whos password I have typed in wrong. I have this
user in realtime, but now also in sip.conf.
show sip users list him twice with both passwords. How can I delete
the wrong one, that he can login?
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
