Well, I think Cuddles is doing just fine here, but lets see it in a nutshell:

First list the scd's with:
ll /dev/scd[01]
Should look like:
root@fujibox:/dev# ll scd[01]
brw-rw-rw- 1 root cdrom 11, 0 Nov 14 2003 scd0
brw-rw-rw- 1 root cdrom 11, 1 Nov 14 2003 scd1

Remove the ones that aren't working:
rm /dev/scd0 /dev/scd1

Then create the missing devices:
mknod -m 666 /dev/scd0 b 11 0
mknod -m 666 /dev/scd1 b 11 1

Then remove the faulty symlinks:
rm /dev/cdrom /dev/cdrom1 /dev/dvd

Skip the sr? and do:
ln -s /dev/scd0 /dev/cdrom
ln -s /dev/scd1 /dev/cdrom1
ln -s /dev/scd1 /dev/dvd
Should look like:
root@fujibox:/dev# ll cdrom cdrom1 dvd
lrwxrwxrwx 1 root cdrom 9 Sep 5 14:18 cdrom -> /dev/scd0
lrwxrwxrwx 1 root cdrom 9 Apr 28 19:58 cdrom1 -> /dev/scd1
lrwxrwxrwx 1 root cdrom 9 Aug 10 13:53 dvd -> /dev/scd1

Recreate mountpoints just to be sure:
rmdir /cdrom /cdrom1 /dvd
mkdir /cdrom /cdrom1 /dvd

Change group to cdrom:
chgrp cdrom /dev/scd0 /dev/scd1 /dev/cdrom /dev/cdrom1 /dev/dvd /cdrom /cdrom1 /dvd

And use lines like these in fstab:
/dev/cdrom /cdrom iso9660 defaults,ro,users,noexec,noauto,uid=markus,gid=mar kus 0 0
/dev/cdrom1 /cdrom1 iso9660 defaults,ro,users,noexec,noauto,uid=markus,gid=mar kus 0 0
/dev/dvd /dvd iso9660 defaults,ro,users,noexec,noauto,uid=markus,gid=mar kus 0 0