Page 1 of 1

backend troubles

Posted: Tue Feb 24, 2009 9:46 am
by seth_keith
I am trying to setup a new 0.21.0-64 installation. It starts booting OK, then gets to the backend communications and dies with:

"cannot connect to the MythTV master backend database"

Here is minimyth.log:

Use of uninitialized value in numeric ne (!=) at /etc/rc.d/init/security.pm line 33.
Use of uninitialized value in numeric ne (!=) at /etc/rc.d/init/security.pm line 33.
DBI connect('database=mythconverg;host=192.168.1.1','mythtv',...) failed: Access denied for user 'mythtv'@'%' to database 'mythconverg' at /usr/lib/perl5/site_perl/5.10.0/MiniMyth.pm line 560
Exiting eval via last at /etc/rc.d/rc.pl line 84.
Use of uninitialized value $_ in pattern match (m//) at ./rc.pl line 176.
Use of uninitialized value $_ in pattern match (m//) at ./rc.pl line 194.
Use of uninitialized value $_ in pattern match (m//) at ./rc.pl line 212.
root@myth1:/var/log #



I cannot figure out what is wrong. I did have some trouble setting up the mythtv user. I had to change the the password file like so:



#mythtv:x:100:101:mythtvbackend User:/var/lib/mythtv:/sbin/nologin
mythtv:x:100:101:mythtvbackend User:/var/lib/mythtv:/bin/bash


could this be related?

here are the variables from the client:
MM_ACPI_EVENT_BUTTON_POWER='off'
MM_ACPI_VIDEO_FLAGS='0'
MM_AUDIO_CARD_NUMBER='0'
MM_AUDIO_DEVICE_NUMBER='0'
MM_AUDIO_TYPE='analog'
MM_BACKEND_DEBUG_LEVEL='none'
MM_BACKEND_ENABLED='no'
MM_BACKEND_TUNER_FIRMWARE_FILE_LIST=''
MM_CODECS_URL='confrw:codecs.32.sfs'
MM_CONF_VERSION='40'
MM_CPU_FAMILY='6'
MM_CPU_FETCH_MICROCODE_DAT='no'
MM_CPU_FREQUENCY_GOVERNOR='performance'
MM_CPU_MODEL='9'
MM_CPU_VENDOR='CentaurHauls'
MM_CRON_FETCH_CRONTAB='no'
MM_DEBUG='no'
MM_DHCP_DOMAIN_NAME=''
MM_DHCP_DOMAIN_NAME_SERVERS=''
MM_DHCP_HOST_NAME='myth1'
MM_DHCP_LOG_SERVERS=''
MM_DHCP_NTP_SERVERS='time-a.nist.gov'
MM_DHCP_TCODE=''
MM_EXTERNAL_POWER_OFF=''
MM_EXTERNAL_POWER_ON=''
MM_EXTERNAL_VOLUME_DOWN=''
MM_EXTERNAL_VOLUME_ENABLED='no'
MM_EXTERNAL_VOLUME_MUTE=''
MM_EXTERNAL_VOLUME_UP=''
MM_EXTRAS_URL='confro:extras.sfs'
MM_FLASH_URL=''
MM_FONT_FILE_TTF_ADD=''
MM_FONT_FILE_TTF_DELETE=''
MM_GAME_BIOS_ROOT='/mnt/game/bios'
MM_GAME_GAME_ROOT='/mnt/game/game'
MM_GAME_SAVE_ENABLED='no'
MM_GAME_SAVE_LIST='.fceultra:.jzintv:.mednafen:.stella:.mame:.vba:.zsnes:VisualBoyAdvance.cfg'
MM_HARDWARE_KERNEL_MODULES='via'
MM_INIT_TYPE='perl'
MM_KERNEL_IMAGE='minimyth-0.21.0-64/kernel'
MM_LCDPROC_DEVICE=''
MM_LCDPROC_DRIVER=''
MM_LCDPROC_FETCH_LCDD_CONF='no'
MM_LCDPROC_KERNEL_MODULE=''
MM_LCDPROC_KERNEL_MODULE_OPTIONS=''
MM_LIRC_AUTO_ENABLED='yes'
MM_LIRC_DEVICE=''
MM_LIRC_DEVICE_BLACKLIST=''
MM_LIRC_DEVICE_LIST=''
MM_LIRC_DRIVER=''
MM_LIRC_FETCH_LIRCD_CONF='no'
MM_LIRC_FETCH_LIRCRC='no'
MM_LIRC_IREXEC_ENABLED='auto'
MM_LIRC_KERNEL_MODULE=''
MM_LIRC_KERNEL_MODULE_OPTIONS=''
MM_LIRC_SLEEP_ENABLED='yes'
MM_LIRC_WAKEUP_ENABLED='yes'
MM_MASTER_DBNAME='mythconverg'
MM_MASTER_DBPASSWORD='mythtv'
MM_MASTER_DBUSERNAME='mythtv'
MM_MASTER_SERVER='192.168.1.1'
MM_MASTER_WOLSQLCOMMAND='wakelan -b @MM_MASTER_WOL_BROADCAST@ -m @MM_MASTER_WOL_MAC@'
MM_MASTER_WOLSQLCONNECTRETRY='20'
MM_MASTER_WOLSQLRECONNECTWAITTIME='15'
MM_MASTER_WOL_ADDITIONAL_DELAY='0'
MM_MASTER_WOL_ENABLED='no'
MM_MASTER_WOL_MAC='00:00:00:00:00:00'
MM_MEDIA_DVD_RIP_MOUNTPOINT='/mnt/dvd'
MM_MEDIA_DVD_RIP_URL=''
MM_MEDIA_GALLERY_MOUNTPOINT='/mnt/gallery'
MM_MEDIA_GALLERY_URL=''
MM_MEDIA_GAME_MOUNTPOINT='/mnt/game'
MM_MEDIA_GAME_URL=''
MM_MEDIA_GENERIC_LIST=''
MM_MEDIA_MUSIC_MOUNTPOINT='/mnt/music'
MM_MEDIA_MUSIC_URL=''
MM_MEDIA_TV_MOUNTPOINT='/mnt/tv'
MM_MEDIA_TV_URL=''
MM_MEDIA_VIDEO_MOUNTPOINT='/mnt/video'
MM_MEDIA_VIDEO_URL=''
MM_MINIMYTH_BOOT_URL='tftp://192.168.1.1/minimyth/'
MM_MINIMYTH_FETCH_MINIMYTH_PM='no'
MM_MINIMYTH_UPDATE_URL='http://minimyth.org/download/stable/latest/'
MM_NETWORK_INTERFACE='eth0'
MM_PLUGIN_BROWSER_ENABLED='yes'
MM_PLUGIN_DVD_ENABLED='no'
MM_PLUGIN_GALLERY_ENABLED='yes'
MM_PLUGIN_GAME_ENABLED='yes'
MM_PLUGIN_INFORMATION_CENTER_ENABLED='yes'
MM_PLUGIN_MUSIC_ENABLED='yes'
MM_PLUGIN_NEWS_ENABLED='yes'
MM_PLUGIN_OPTICAL_DISK_ENABLED='yes'
MM_PLUGIN_PHONE_ENABLED='yes'
MM_PLUGIN_STREAM_ENABLED='yes'
MM_PLUGIN_VIDEO_ENABLED='yes'
MM_PLUGIN_WEATHER_ENABLED='yes'
MM_PLUGIN_ZONEMINDER_ENABLED='yes'
MM_ROOTFS_IMAGE=''
MM_ROOTFS_TYPE='nfs'
MM_SECURITY_ENABLED='no'
MM_SECURITY_FETCH_CA_BUNDLE_CRT='no'
MM_SECURITY_FETCH_CREDENTIALS_CIFS='no'
MM_SECURITY_USER_MINIMYTH_GID='1000'
MM_SECURITY_USER_MINIMYTH_UID='1000'
MM_SSH_SERVER_ENABLED='no'
MM_TFTP_BOOT_URL='tftp://192.168.1.1/minimyth/'
MM_TFTP_SERVER='192.168.1.1'
MM_THEMECACHE_URL='confrw:themecache.sfs'
MM_THEMEOSD_NAME='Titivillus-OSD'
MM_THEMEOSD_URL='confro:themes/Titivillus-OSD.sfs'
MM_THEME_FILE_MENU_ADD=''
MM_THEME_NAME='G.A.N.T'
MM_THEME_URL='confro:themes/G.A.N.T.sfs'
MM_VERSION='0.21.0-64'
MM_VERSION_MINIMYTH='64'
MM_VERSION_MYTH='0.21.0'
MM_VERSION_MYTH_BINARY='0.21.20080304-1'
MM_VERSION_MYTH_BINARY_EXTRA='1'
MM_VERSION_MYTH_BINARY_MAJOR='0'
MM_VERSION_MYTH_BINARY_MINOR='21'
MM_VERSION_MYTH_BINARY_TEENY='20080304'
MM_VIDEO_ASPECT_RATIO='4:3'
MM_VIDEO_DECODER='auto'
MM_VIDEO_DEINTERLACER='none'
MM_VIDEO_FONT_SCALE='100'
MM_VIDEO_PLAYBACK_PROFILE='MiniMyth'
MM_VIDEO_RESIZE_ENABLED=''
MM_WIIMOTE_ADDRESS_0=''
MM_WIIMOTE_ADDRESS_1=''
MM_WIIMOTE_ADDRESS_2=''
MM_WIIMOTE_ADDRESS_3=''
MM_X_DISPLAYSIZE='160x120'
MM_X_DRIVER='openchrome'
MM_X_ENABLED='yes'
MM_X_FETCH_XINITRC='no'
MM_X_FETCH_XMODMAPRC='no'
MM_X_FETCH_XORG_CONF='no'
MM_X_HACK_HIDE_BLUE_LINE_ENABLED='no'
MM_X_MODE='720x480Noscale'
MM_X_MODELINE=''
MM_X_MODELINE_0=''
MM_X_MODELINE_1=''
MM_X_MODELINE_2=''
MM_X_MODE_0=''
MM_X_MODE_1=''
MM_X_MODE_2=''
MM_X_MYTH_PROGRAM='mythfrontend'
MM_X_OUTPUT_DVI='none'
MM_X_OUTPUT_TV='auto'
MM_X_OUTPUT_VGA='none'
MM_X_REFRESH='VertRefresh 58-62'
MM_X_RESOLUTION=''
MM_X_RESTART_ON_SLEEP_ENABLED='no'
MM_X_SCREENSAVER='none'
MM_X_SCREENSAVER_HACK='blank'
MM_X_SCREENSAVER_TIMEOUT='2'
MM_X_SYNC='HorizSync 10.0-70.0'
MM_X_TV_OUTPUT='Composite'
MM_X_TV_OVERSCAN='0.0'
MM_X_TV_TYPE='NTSC'
MM_X_VIRTUAL='720x480'
MM_X_VNC_ENABLED='yes'
MM_X_WM_ENABLED='yes'


Please help...
[/b]

Posted: Tue Feb 24, 2009 3:26 pm
by Pablo
Did you set the permissions on your backend's mysql mythconverg database to allow access from machines other than localhost? If not, then you will not be able to connect. The instructions are here.