asterisk users - Feb 2006 - mysql problems

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@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

On Fri, 2006-02-24 at 09:44 +0800, Ronald Wiplinger
wrote:
> 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)
first of, errno 13 is 'permission denied', so I guess your mysql
database is running as a user who hasn't got permissions to the file.
--- which makes it a question for the mysql mailing list.
Anyways, on linux, you can use "ps axu" to find out as what user mysql
runs as. Then change permissions/ownership on the files to match.

Conrad