I am trying to set up slimserver on amd64. I had several problems: - could not start without dev-perl/DBD-mysql-3.0007, although ebuild depends on 3.0002 only - once /etc/init.d/slimserver starts, it falls down automatically. My /var/log/slimserver: ------------------- InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 061222 23:28:28 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 061222 23:28:29 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 061222 23:28:29 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 061222 23:28:31 InnoDB: Started; log sequence number 0 0 061222 23:28:31 [Warning] Can't open and lock time zone table: Table 'mysql.time _zone_leap_second' doesn't exist trying to live without them 061222 23:28:31 [Note] /opt/slimserver/Bin/mysqld: ready for connections. Version: '5.0.26' socket: '/var/cache/slimserver/slimserver-mysql.sock' port: 9092 Gentoo Linux mysql-5.0.26-r1 061222 23:28:32 [Note] /opt/slimserver/Bin/mysqld: Normal shutdown 061222 23:28:34 InnoDB: Starting shutdown... 061222 23:28:36 InnoDB: Shutdown completed; log sequence number 0 43655 061222 23:28:36 [Note] /opt/slimserver/Bin/mysqld: Shutdown complete 061222 23:28:37 InnoDB: Started; log sequence number 0 43655 061222 23:28:37 [Note] /opt/slimserver/Bin/mysqld: ready for connections. Version: '5.0.26' socket: '/var/cache/slimserver/slimserver-mysql.sock' port: 9092 Gentoo Linux mysql-5.0.26-r1 061222 23:28:39 InnoDB: Error: table `slimserver/years` already exists in InnoD B internal InnoDB: data dictionary. Have you deleted the .frm file InnoDB: and not used DROP TABLE? Have you used DROP DATABASE InnoDB: for InnoDB tables in MySQL version <= 3.23.43? InnoDB: See the Restrictions section of the InnoDB manual. InnoDB: You can drop the orphaned table inside InnoDB by InnoDB: creating an InnoDB table with the same name in another InnoDB: database and copying the .frm file to the current database. InnoDB: Then MySQL thinks the table exists, and DROP TABLE will InnoDB: succeed. InnoDB: You can look for further help from InnoDB: http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html Database error: Can't create table './slimserver/years.frm' (errno: 121) at /opt /slimserver/CPAN/DBIx/Migration.pm line 115. 061222 23:37:19 [Note] /opt/slimserver/Bin/mysqld: Normal shutdown 061222 23:37:19 InnoDB: Starting shutdown... 061222 23:37:21 InnoDB: Shutdown completed; log sequence number 0 147016 061222 23:37:21 [Note] /opt/slimserver/Bin/mysqld: Shutdown complete --------------- Note if I start /opt/slimserver/slimserver.pl as a user, it does ok.
Hi Sebastien, I'll update the dependencies to use DBD-mysql-3.0007. Re the database problem, it looks like the slimserver database was only partially created the first time and this confused slimserver when it started the second time. Please try deleting everything in /var/cache/slimserver and trying again. Cheers, Tom
Hi Tom, Thanks for the answer. I actually removed everything in /var/*/slimserver, even the user/group, and re-emerged slimserver. It gave me the same problem. I used to have a slimserver 6.1.1 with the ebuilds in bug #73832. But I can't find any left over files from the old slimserver that I have not removed. It seems a cache problem, may be in the /etc/slimserver.prefs. Sebastien
Hmmm, in that case I'm very confused. Is there anything non-standard about your MySQL setup? Please post the output of emerge --info. Thanks, Tom
I have dev-db/mysql-5.0.26-r1 installed with virtual/mysql-5.0. Could this mysql confuse the one embedded in slimserver? emerge --info gives me: Gentoo Base System version 1.12.6 Portage 2.1.1-r2 (default-linux/amd64/2006.1/desktop, gcc-4.1.1, glibc-2.4-r4, 2.6.17-gentoo-r8 x86_64) ================================================================= System uname: 2.6.17-gentoo-r8 x86_64 AMD Athlon(tm) 64 Processor 3500+ Last Sync: Tue, 26 Dec 2006 10:50:01 +0000 ccache version 2.3 [enabled] app-admin/eselect-compiler: [Not Present] dev-java/java-config: 1.3.7, 2.0.30 dev-lang/python: 2.4.3-r4 dev-python/pycrypto: 2.0.1-r5 dev-util/ccache: 2.3 dev-util/confcache: [Not Present] sys-apps/sandbox: 1.2.17 sys-devel/autoconf: 2.13, 2.60 sys-devel/automake: 1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2 sys-devel/binutils: 2.16.1-r3 sys-devel/gcc-config: 1.3.14 sys-devel/libtool: 1.5.22 virtual/os-headers: 2.6.11-r2 ACCEPT_KEYWORDS="amd64" AUTOCLEAN="yes" CBUILD="x86_64-pc-linux-gnu" CFLAGS="-O2 -pipe -march=athlon64" CHOST="x86_64-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config" CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/gconf /etc/java-config/vms/ /etc/revdep-rebuild /etc/splash /etc/terminfo /etc/texmf/web2c" CXXFLAGS="-O2 -pipe -march=athlon64" DISTDIR="/usr/portage/distfiles" FEATURES="autoaddcvs autoconfig ccache distlocks metadata-transfer sandbox sfperms strict" GENTOO_MIRRORS="ftp://mirrors1.netvisao.pt/gentoo" LANG="en_GB.UTF-8" LC_ALL="en_GB.UTF-8" LINGUAS="en pt fr" MAKEOPTS="-j2" PKGDIR="/usr/portage/packages" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude='/distfiles' --exclude='/local' --exclude='/packages'" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/home/seb/gentoo/misc /usr/portage/local/layman/sunrise /usr/portage/local/layman/science" SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage" USE="amd64 X a52 aac acpi alsa alsa_cards_ali5451 alsa_cards_als4000 alsa_cards_atiixp alsa_cards_atiixp-modem alsa_cards_bt87x alsa_cards_ca0106 alsa_cards_cmipci alsa_cards_emu10k1x alsa_cards_ens1370 alsa_cards_ens1371 alsa_cards_es1938 alsa_cards_es1968 alsa_cards_fm801 alsa_cards_hda-intel alsa_cards_intel8x0 alsa_cards_intel8x0m alsa_cards_maestro3 alsa_cards_trident alsa_cards_usb-audio alsa_cards_via82xx alsa_cards_via82xx-modem alsa_cards_ymfpci alsa_pcm_plugins_adpcm alsa_pcm_plugins_alaw alsa_pcm_plugins_asym alsa_pcm_plugins_copy alsa_pcm_plugins_dmix alsa_pcm_plugins_dshare alsa_pcm_plugins_dsnoop alsa_pcm_plugins_empty alsa_pcm_plugins_extplug alsa_pcm_plugins_file alsa_pcm_plugins_hooks alsa_pcm_plugins_iec958 alsa_pcm_plugins_ioplug alsa_pcm_plugins_ladspa alsa_pcm_plugins_lfloat alsa_pcm_plugins_linear alsa_pcm_plugins_meter alsa_pcm_plugins_mulaw alsa_pcm_plugins_multi alsa_pcm_plugins_null alsa_pcm_plugins_plug alsa_pcm_plugins_rate alsa_pcm_plugins_route alsa_pcm_plugins_share alsa_pcm_plugins_shm alsa_pcm_plugins_softvol asf audacious audiofile bash-completion berkdb bitmap-fonts blas bzip2 cairo cdparanoia cdr cli cracklib crypt css cups dbus dga directfb divx4linux dlloader dmi doc dri dts dv dvd dvdr dvdread elibc_glibc emacs emboss encode exif exscalibar fam fbcon fbdev ffmpeg fftw firefox flac foomaticdb fortran gcj geoip gif glitz gnutls gphoto2 gpm gs gsl gstreamer gtk2 hal iconv icq ieee1394 imagemagick input_devices_keyboard input_devices_mouse isdnlog jabber java javascript jbig jpeg kde kdeenablefinal kernel_linux lapack libg++ linguas_en linguas_fr linguas_pt lirc lirc_devices_serial lm_sensors lzo mad matroska mikmod mjpeg mng mp3 mp4 mpeg msn musepack musicbrainz ncurses nls nptl nptlonly nsplugin nvidia objc offensive ogg oggvorbis opengl pam pcre pdf perl png ppds pppd python qt3 qt4 quicktime readline reflection rt2500pci scanner sdl sensord session shorten sndfile sox speex spell spl ssl subversion svg symlink tcltk tcpd tetex theora threads tiff truetype truetype-fonts type1-fonts udev unicode usb userland_GNU v4l v4l2 vcd video_cards_fbdev video_cards_nv video_cards_nvidia video_cards_vesa vorbis wifi wind32codecs wma wmf wxwindows x264 xanim xcomposite xine xml xorg xpm xv xvid xvmc yahoo zlib zvbi" Unset: CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LDFLAGS, PORTAGE_RSYNC_EXTRA_OPTS
Sebastien, I'm sorry, I don't know what's going wrong on your system. Can you post your problem on http://forums.slimdevices.com/ and/or experiment with slimserver's debug switches. Let me know what you find out... Cheers, Tom
Still waiting for more information from bug reporter.
Hi Tom, Well I did submit my problem to the forums back then, with no answers: http://forums.slimdevices.com/showthread.php?t=31046 There must be something wrong on my system, but I just can't find out what. I played with debug switches, removed all /var/*/slimserver*, emerged again, still nothing. Note the debug error has been shorter with slimserver-6.5.1, I now just get: Database error: Can't create table './slimserver/years.frm' (errno: 121) at /opt/slimserver/CPAN/DBIx/Migration.pm line 115. As I said before, as a user /opt/slimserver/slimsever.pl still starts OK though. I will open another thread on the slimserver forums, meanwhile if you have any clue, they are more than welcome! Thanks, Sébastien
