/usr/share/mythtv/database/mc.sql: No such file [Solved]

[popatopalous]

Trying to set up MythTV using Sabayon wiki. When I get to:

Code: Select all
# /usr/bin/mysqladmin -u root -h localhost password *********** -p
Enter password:
# mysql -u root -p < /usr/share/mythtv/database/mc.sql
-su: /usr/share/mythtv/database/mc.sql: No such file or directory



Any idea why '/usr/share/mythtv/database/mc.sql' doesn't exist???

Code: Select all
# whereis /mythtv/database/mc.sql
mc: /usr/bin/mc /usr/lib/mc /usr/lib64/mc /usr/X11R6/bin/mc /usr/bin/X11/mc /usr/share/mc /usr/man/man1/mc.1.bz2 /usr/share/man/man1/mc.1.bz2



Any ideas??? I'm confused but still looking around...

[popatopalous]

Code: Select all

# mysql -u root -p < /usr/share/mc
Enter password:
mysql: Error reading file 'UNOPENED' (Errcode: 21)

[popatopalous]

Code: Select all

# emerge -av --nodeps mythtv
...
* MythTV requires Qt to be built with mysql and opengl use flags enabled.
 * Please re-emerge =x11-libs/qt-3*, after having the use flags set.


Maybe that's it...

[popatopalous]

Code: Select all

# echo "x11-libs/qt mysql opengl" >> /etc/portage/package.use
# emerge -pv =x11-libs/qt-3*

These are the packages that would be merged, in order:

Calculating dependencies... done!
[ebuild   R   ] x11-libs/qt-3.3.8-r4  USE="cups gif immqt-bc ipv6 opengl xinerama -debug -doc -examples (-firebird) -immqt -mysql -nas -nis -odbc -postgres -sqlite" 0 kB

Total: 1 package (1 reinstall), Size of downloads: 0 kB


That's what happened. It picked up USE=opengl but not USE=mysql. Why???

[popatopalous]

Code: Select all

nano /etc/portage/package.use
x11-libs/qt mysql opengl

As I preview this post I see that 'mysql' in 'CODE' is in orange and double underlined. What does that mean???

Code: Select all

# emerge -pv =x11-libs/qt-3*

These are the packages that would be merged, in order:

Calculating dependencies... done!
[ebuild   R   ] x11-libs/qt-3.3.8-r4  USE="cups gif immqt-bc ipv6 opengl  xinerama -debug -doc -examples (-firebird) -immqt  -mysql  -nas -nis -odbc -postgres -sqlite" 0 kB

Total: 1 package (1 reinstall), Size of downloads: 0 kB


Also

Code: Select all

nano /etc/make.conf
USE="mp3 divx4linux dvb dvd dvdread live mpeg jpeg truetype v4l v4l2 xv xvid \
multilib gnutls arts cups ppds foomatic-db alsa gimpprint freetype X gtk2 \
unicode moznocompose moznoirc moznomail kde qt samba xinerama xine theora \
kdeenablefinal wifi hal ieee1394 oggvorbis lm_sensors logitech-mouse \
zeroconf artswrappersuid jack nptl nptlonly rdesktop dvdr css gphoto2 openexr pcmcia \
speex jpeg2k povray scanner musicbrainz accessibility audiofile \
exif xscreensaver ffmpeg vcd sndfile musepack asterisk pam_chroot pam_timestamp \
pwdb gnokii pda sms bluetooth irda kig-scripting speedo browserplugin nsplugin ldap \
kerberos firefox dga aac dts xvmc dbus hal dvi on-the-fly-crypt dri xprint acpi \
symlink ada ruby perforce cjk fat hfs jfs ntfs xfs reiserfs \
joystick skins cdda real shout stream a52 wxwindows vlm lirc libcaca remote \
stats lcd unichrome 7zip commercial mozsvg canvas xml2 glut java gcj glitz \
svg avahi ogg vorbis aalib flac gdbm mikmod kdgraphics dlloader exscalibar ipod visualization \
cdr nntp cairo djvu pdf xml ladspa soundtouch \
bzip2 udev mad fuse rtsp tiff kdehiddenvisibility dvi usb kipi aiglx musicbrainz 3dfx pulseaudio \
x264 dv lame mp3rtp udev cdr dvi djvu libnotify bzip2 aalib startup-notification nsplugin jingle \
gsm dbox2 cddb -gnome -evo -eds -mono -beagle -esd opengl sdl png gif gtk qt3 qt4 qt3support
kickoff xcb tracker"


[popatopalous]

If I add 'mysql' to USE flags in '/etc/conf' I now get

Code: Select all

# emerge -pv =x11-libs/qt-3*

These are the packages that would be merged, in order:

Calculating dependencies... done!
[ebuild   R   ] x11-libs/qt-3.3.8-r4  USE="cups gif immqt-bc ipv6 mysql* opengl xinerama -debug -doc -examples (-firebird) -immqt -nas -nis -odbc -postgres -sqlite" 0 kB

Total: 1 package (1 reinstall), Size of downloads: 0 kB

Now 'mysql*' is there without the - and in light green instead of pink/red as other USE flags that are to be used. What does that mean??? I'm going to start over at the beginning. Have to if qt wasn't compiled with 'mysql' or 'mysql*' support.

[popatopalous]

Code: Select all

# emerge -av mythtv

These are the packages that would be merged, in order:

Calculating dependencies... done!
[ebuild  N    ] x11-drivers/xf86-video-via-0.2.2  USE="dri -debug" 389 kB
[ebuild  N    ] media-tv/mythtv-0.20.2_p15332  USE="alsa dbox2 dts dvb dvd ieee1394 jack joystick lcd lirc mmx opengl perl vorbis xvmc (-altivec) -autostart -backendonly -crciprec -debug -directv -freebox -frontendonly -hdhomerun -ivtv" VIDEO_CARDS="i810 via -nvidia" 0 kB
[ebuild  N    ] x11-themes/mythtv-themes-0.20.2_p14301  0 kB


[wolfden]

Sounds like you're in desperate need of understanding portage, try this:
http://gentoo-wiki.com/HOWTO_Use_Portag ... #USE_Flags

[popatopalous]

Sounds like you're in desperate need of understanding portage, try this:
http://gentoo-wiki.com/HOWTO_Use_Portag ... #USE_Flags

Thanks. Slowly but surely I'm learning.

* An asterisk following a USE flag indicates that its meaning/scope has been updated. Identical to green output.
green - The USE flag has changed since the last time the package was installed, as the asterisk after it indicates.

Thanks again.

[eduardhc]

Hi,
Check "/etc/portage/package.use" and make sure that there is ONLY one instance of x11-libs/qt.

IIRC there was more than one, differentiating between QT3 and QT4. You should maybe remove all and leave only one in form suggested before:

Code: Select all

x11-libs/qt mysql opengl


This way it should work.

Regards.