Try opening the file "/etc/fstab" in an editor (gedit is fine) and see if there is an entry for /dev/cdrom. In Suse 8.0 it is mounted as /media/cdrom or /media/dvd. If the line is corrupted or missing try inserting something like this:
/dev/cdrom /media/cdrom auto ro,noauto,user,exec 0 0
You will have to be root to make any changes and make sure you save the file.
At the command line you could try:
"mount /media/cdrom " or "mount /media/dvd".