My database machine is broken and I have to use another one.
I made somewhere mistake(s) and get now in the debug file:
[Feb 24 09:05:24] DEBUG[32664]: MySQL RealTime: Query: SELECT * FROM
sip_buddies WHERE name = '886'
[Feb 24 09:05:24] DEBUG[32664]: MySQL RealTime: Query Failed because:
Can't find file: './astconf/sip_buddies.frm' (errno: 13)
[Feb 24 09:05:25] DEBUG[32664]: MySQL RealTime: Retrieve SQL: SELECT *
FROM sip_buddies WHERE name = '494'
[Feb 24 09:05:25] DEBUG[32664]: MySQL RealTime: Everything is fine.
and in CLI:
[Feb 24 09:23:16] WARNING[32664]: res_config_mysql.c:135 realtime_mysql:
MySQL RealTime: Failed to query database. Check debug for more info.
[Feb 24 09:23:16] NOTICE[32664]: chan_sip.c:10935
handle_request_register: Registration from '"886"
<sip:[EMAIL PROTECTED]>' failed for '61.218.43.42' - Username/auth name
mismatch
I have added in the mysql user file (the line what I got from the old
database server with mysqldump):
INSERT INTO user VALUES
('192.168.250.20','xxxx','0aaabbbbccccf','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0);
192.168.250.20 is asterisk
192.168.250.33 is the old database server
192.168.250.254 is the new database server
I have restarted the database server
I have edited the files:
cdr_mysql.conf
[global]
;hostname=192.168.250.33
hostname=192.168.250.254
res_mysql.conf
[general]
;dbhost = 192.168.250.33
dbhost = 192.168.250.254
dbname = astconf
and restarted asterisk
What do I miss?
bye
Ronald Wiplinger
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
