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

Discussions Regarding Software

Moderator: Moderators

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

Postby popatopalous » Fri Jan 11, 2008 2:10

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...
Last edited by popatopalous on Sat Jan 12, 2008 23:50, edited 3 times in total.
Thanks,
popatopalous
Sabayon 3.5 AMD64 : AMD64 X2 4800+ : 4x1GB DDR2 800 : GeForce 6150 256MB : ASUS M2NPV-VM : HD-2x320GB
popatopalous
Simple Hen
 
Posts: 47
Joined: Sun Nov 04, 2007 23:48

Re: /usr/share/mythtv/database/mc.sql: No such file or directory

Postby popatopalous » Fri Jan 11, 2008 2:45

Code: Select all
# mysql -u root -p < /usr/share/mc
Enter password:
mysql: Error reading file 'UNOPENED' (Errcode: 21)
Thanks,
popatopalous
Sabayon 3.5 AMD64 : AMD64 X2 4800+ : 4x1GB DDR2 800 : GeForce 6150 256MB : ASUS M2NPV-VM : HD-2x320GB
popatopalous
Simple Hen
 
Posts: 47
Joined: Sun Nov 04, 2007 23:48

Re: /usr/share/mythtv/database/mc.sql: No such file or directory

Postby popatopalous » Fri Jan 11, 2008 2:48

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...
Thanks,
popatopalous
Sabayon 3.5 AMD64 : AMD64 X2 4800+ : 4x1GB DDR2 800 : GeForce 6150 256MB : ASUS M2NPV-VM : HD-2x320GB
popatopalous
Simple Hen
 
Posts: 47
Joined: Sun Nov 04, 2007 23:48

Re: /usr/share/mythtv/database/mc.sql: No such file or directory

Postby popatopalous » Fri Jan 11, 2008 2:51

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??? :?: :?: :?:
Thanks,
popatopalous
Sabayon 3.5 AMD64 : AMD64 X2 4800+ : 4x1GB DDR2 800 : GeForce 6150 256MB : ASUS M2NPV-VM : HD-2x320GB
popatopalous
Simple Hen
 
Posts: 47
Joined: Sun Nov 04, 2007 23:48

Re: /usr/share/mythtv/database/mc.sql: No such file or directory

Postby popatopalous » Fri Jan 11, 2008 3:06

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??? :shock:

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"


:shock:
Last edited by popatopalous on Fri Jan 11, 2008 3:18, edited 1 time in total.
Thanks,
popatopalous
Sabayon 3.5 AMD64 : AMD64 X2 4800+ : 4x1GB DDR2 800 : GeForce 6150 256MB : ASUS M2NPV-VM : HD-2x320GB
popatopalous
Simple Hen
 
Posts: 47
Joined: Sun Nov 04, 2007 23:48

Re: /usr/share/mythtv/database/mc.sql: No such file or directory

Postby popatopalous » Fri Jan 11, 2008 3:16

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.
Thanks,
popatopalous
Sabayon 3.5 AMD64 : AMD64 X2 4800+ : 4x1GB DDR2 800 : GeForce 6150 256MB : ASUS M2NPV-VM : HD-2x320GB
popatopalous
Simple Hen
 
Posts: 47
Joined: Sun Nov 04, 2007 23:48

Re: /usr/share/mythtv/database/mc.sql: No such file or directory

Postby popatopalous » Fri Jan 11, 2008 3:28

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
Thanks,
popatopalous
Sabayon 3.5 AMD64 : AMD64 X2 4800+ : 4x1GB DDR2 800 : GeForce 6150 256MB : ASUS M2NPV-VM : HD-2x320GB
popatopalous
Simple Hen
 
Posts: 47
Joined: Sun Nov 04, 2007 23:48

Re: /usr/share/mythtv/database/mc.sql: No such file or directory

Postby wolfden » Fri Jan 11, 2008 4:16

Sounds like you're in desperate need of understanding portage, try this:
http://gentoo-wiki.com/HOWTO_Use_Portag ... #USE_Flags
wolfden
Sharecropper
 
Posts: 9050
Joined: Sat Jan 14, 2006 0:55
Location: Midwest USA

Re: /usr/share/mythtv/database/mc.sql: No such file or directory

Postby popatopalous » Fri Jan 11, 2008 4:40

wolfden wrote: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.
Thanks,
popatopalous
Sabayon 3.5 AMD64 : AMD64 X2 4800+ : 4x1GB DDR2 800 : GeForce 6150 256MB : ASUS M2NPV-VM : HD-2x320GB
popatopalous
Simple Hen
 
Posts: 47
Joined: Sun Nov 04, 2007 23:48

Re: /usr/share/mythtv/database/mc.sql: No such file or directory

Postby eduardhc » Fri Jan 11, 2008 13:07

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.
"Life is an eternal compilation"
(anonymous Gentoo user)
eduardhc
Technological Hen
 
Posts: 372
Joined: Tue Sep 19, 2006 16:31
Location: Barcelona (Cat)

Next

Return to Software in General

Who is online

Users browsing this forum: No registered users and 3 guests

cron