Hi ! I'm having troubles trying to setup MythTV. I'm using a Hauppauge PVR350 with ivtv 0.4.2 drivers on kernel 2.6.15-r5 (on Pegasos PPC). My SQL server is installed and I've followed "MythTV Gentoo HOWTO" http://gentoo-wiki.com/HOWTO_Setup_MythTV. Note that I couldn't do the following commands (hope that's not the problem) : # eselect mysql list # eselect mysql set <number in list of mysql version you are using> # eselect mysql show eselect mysql list !!! Error: Can't load module mysql exiting. So I just did a : mysql -u root -p < /usr/share/mythtv/database/mc.sql and it seemed to work... Then I've launched mythtv-setup. When I configure my MM card I can see "MPEG2 PVR-250 / PVR-350", so I select it then "/dev/v4l/video0" and "tuner0" but when I validate, it seems that the settings are not saved. If I look at the shell I see many errors like this one : DB Error (Insert Keybinding): Query was: INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'qt', 'EDIT', 'Edit', 'E', 'pegasos' ); Driver error was [2/1146]: QMYSQL3: Unable to execute query Database error was: Table 'mythconverg.keybindings' doesn't exist So I guess that this table is missing, but why ? Note : I've looked at mysql script and it only creates the DB, not the tables... CREATE DATABASE mythconverg; GRANT ALL ON mythconverg.* TO mythtv@localhost IDENTIFIED BY "mythtv"; FLUSH PRIVILEGES; GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv@localhost IDENTIFIED BY "mythtv"; FLUSH PRIVILEGES; Is it created by mythtv-setup ? Regards.
(In reply to comment #0) > Note that I couldn't do the following commands (hope that's not the problem) : > # eselect mysql list > # eselect mysql set <number in list of mysql version you are using> > # eselect mysql show > eselect mysql list > !!! Error: Can't load module mysql We no longer ship slotted mysql in portage; the wiki page is outdated. Please note that Gentoo does not maintain the Gentoo Wiki, it's not official documentation.
(In reply to comment #1) > (In reply to comment #0) > > Note that I couldn't do the following commands (hope that's not the problem) : > > # eselect mysql list > > # eselect mysql set <number in list of mysql version you are using> > > # eselect mysql show > > eselect mysql list > > !!! Error: Can't load module mysql > > We no longer ship slotted mysql in portage; the wiki page is outdated. Please > note that Gentoo does not maintain the Gentoo Wiki, it's not official > documentation. > I've reinstalled MythTV from scratch and... I still have the same error :-(
You're doing something wrong with your mysql setup... you probably have multiple database directories... the QT libraries are linked to 1 and the command line utilties are linked to the other.. Unfortunately everytime I fix that Wiki page someone gets all moronic on it and breaks it. Get rid of everything mysql on your box... unmerge then hand delete the files and start all over. Best thing I can tell you.
(In reply to comment #3) > You're doing something wrong with your mysql setup... you probably have > multiple database directories... the QT libraries are linked to 1 and the > command line utilties are linked to the other.. > > Unfortunately everytime I fix that Wiki page someone gets all moronic on it and > breaks it. > > Get rid of everything mysql on your box... unmerge then hand delete the files > and start all over. Best thing I can tell you. > Hi ! I still have big problems with MySQL & MythTV. Now, it's even worse than before because I can't create the "mythconverg" DB anymore ! I did the following commands : rm -rf /var/lib/mysql emerge sync nano /etc/make.conf (added "mysql and alsa" flags...) emerge lame mysql qt emerge mythtv emerge --config mysql /etc/init.d/mysql start mysql -u root -p < /usr/share/mythtv/database/mc.sql Enter password: ERROR 1006 (HY000) at line 1: Can't create database 'mythconverg' (errno: 2) If I look at /var/lib/mysql/ dir there is no 'mythconverg' DB created. I really don't know what I'm doing wrong :-( Here is my current /etc/make.conf ================================= CFLAGS="-O3 -mtune=G4 -mabi=altivec -maltivec -fno-strict-aliasing -pipe" CHOST="powerpc-unknown-linux-gnu" CXXFLAGS="${CFLAGS}" USE="ppc alsa altivec arts bash-completion berkdb bitmap-fonts browserplugin bzip2 cdr cdparanoia crypt cups curl dri dts dv dvd dvdr dvdread dxr3 eds encode esd fame ffmpeg flac gdbm gif gnome graphviz gstreamer gtk guile howl ieee1394 imagemagick imlib2 ipv6 ivtv jack javascript jpeg2k kde lame lcms ldap lesstif libcaca libclamav live lzo mjpeg mng mozilla mysal mysql mythtv nas ncurses network nls nptl ogg opengl pam pda pcsc-lite perl png postgres python pvm qt quicktime readline samba sasl sdl smartcard snmp socks5 speex sqlite ssl tcpd tetex tiff truetype-fonts type1-fonts unicode usb v4l v4l2 vcd vorbis wifi X xanim Xaw3d xmms xine xmlxv xvid zeroconf zlib" FEATURES="buildpkg sandbox" ACCEPT_KEYWORDS="ppc" CONFIG_PROTECT_MASK="/etc/wget /etc/rc.d" LIRC_OPTS="--with-driver=hauppauge" KERNEL_ARCH="ppc"
