[Asterisk-Users] mysql problems

[Ronald Wiplinger]

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:886 at vpbx.elmit.com>' 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