Sorry you are having trouble. I recently installed Mandriva Linux 2007 Free (official). I just put a CD in the drive, and a window popped up asking what to do with it. I selected the option to play it with kafeine since I do not have kscd installed here. I am listening to the music as I type this. When I put in a data CD, I get a similar dialog with appropriate options.
The line in my /etc/fstab for the CD being used is:
/dev/hdc /mnt/cdrom auto umask=0,users,iocharset=utf8,noauto,ro,exec 0 0