Page 1 of 4 123 ... LastLast
Results 1 to 10 of 31

Thread: MythTV could not connect to database

  1. #1
    Join Date
    Jun 2007
    Location
    Southampton, England
    Beans
    45

    MythTV could not connect to database

    Hi all

    Since an upgrade to 0.26 ive been having problems with mythtv starting.
    Im always presented with the screen "please enter which country your in..." then onto database configuration 1/2 with the message "mythtv could not connect to database" check settings etc
    Sometimes the backend has started despite this message but other times it doesnt. I use mythwelcome.
    There is nothing in the logs frontenf, backend or mysql logs that i can find to indicate a problem. Does anyone have any suggestions?

    TIA
    Last edited by Crowie; October 18th, 2012 at 12:57 PM.

  2. #2
    Join Date
    Jun 2007
    Location
    Southampton, England
    Beans
    45

    Re: MythTV could not connect to database

    Ok ive just started myth from cold boot. Both mythbacken and mythwelcome are running as per top output. However im still presented with the screen asking me to select the country in which i reside and then to check database settings.
    Here is the output of some logs in case ive missed something, nothing is written to /var/log/mysql/error.log when starting myth:

    Code:
    121005 14:48:25 [Note] Event Scheduler: Purging the queue. 0 events
    121005 14:48:25  InnoDB: Starting shutdown...
    121005 14:48:27  InnoDB: Shutdown completed; log sequence number 0 30384708
    121005 14:48:27 [Note] /usr/sbin/mysqld: Shutdown complete
    
    121005 14:48:27 [Note] Plugin 'FEDERATED' is disabled.
    121005 14:48:27  InnoDB: Initializing buffer pool, size = 8.0M
    121005 14:48:27  InnoDB: Completed initialization of buffer pool
    121005 14:48:28  InnoDB: Started; log sequence number 0 30384708
    121005 14:48:28 [Note] Event Scheduler: Loaded 0 events
    121005 14:48:28 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.1.63-0ubuntu0.11.10.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
    121005 14:50:49 [Note] /usr/sbin/mysqld: Normal shutdown
    
    121005 14:50:49 [Note] Event Scheduler: Purging the queue. 0 events
    121005 14:50:51  InnoDB: Starting shutdown...
    121005 14:50:53  InnoDB: Shutdown completed; log sequence number 0 30384744
    121005 14:50:53 [Note] /usr/sbin/mysqld: Shutdown complete
    Code:
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: C thread_unknown mythcommandlineparser.cpp:2545 (ConfigureLogging) mythwelcome version: fixes/0.26 [v0.26.0-16-gbff8eb1] www.mythtv.org
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: C thread_unknown mythcommandlineparser.cpp:2547 (ConfigureLogging) Qt version: compile: 4.8.1, runtime: 4.8.1
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: N thread_unknown mythcommandlineparser.cpp:2549 (ConfigureLogging) Enabled verbose msgs:  general
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: N thread_unknown logging.cpp:837 (logStart) Setting Log Level to LOG_INFO
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I Logger logging.cpp:306 (run) Added logging to the console
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Interrupt handler
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Terminated handler
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Segmentation fault handler
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Aborted handler
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Bus error handler
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Floating point exception handler
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Illegal instruction handler
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Real-time signal 0 handler
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: N thread_unknown mythdirs.cpp:55 (InitializeMythDirs) Using runtime prefix = /usr
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: N thread_unknown mythdirs.cpp:68 (InitializeMythDirs) Using configuration directory = /home/shabba/.mythtv
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I CoreContext mythcorecontext.cpp:231 (Init) Assumed character encoding: en_GB.UTF-8
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: N CoreContext mythcontext.cpp:493 (LoadDatabaseSettings) Empty LocalHostName.
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I CoreContext mythcontext.cpp:501 (LoadDatabaseSettings) Using localhost value of shabba
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I CoreContext mythcontext.cpp:682 (TestDBconnection) Testing network connectivity to '192.168.1.66'
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I SystemManager system-unix.cpp:263 (run) Starting process manager
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I SystemIOHandlerR system-unix.cpp:90 (run) Starting IO manager (read)
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I SystemIOHandlerW system-unix.cpp:90 (run) Starting IO manager (write)
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I SystemSignalManager system-unix.cpp:490 (run) Starting process signal handler
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: N CoreContext DisplayRes.cpp:64 (Initialize) Desktop video mode: 1280x720 60.000 Hz
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I Logger logging.cpp:487 (launchLogServer) Starting mythlogserver
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I CoreContext lirc.cpp:308 (Init) LIRC: Successfully initialized '/dev/lircd' using '/home/shabba/.mythtv/lircrc' config
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: E CoreContext jsmenu.cpp:91 (Init) JoystickMenuThread: Joystick disabled - Failed to read /home/shabba/.mythtv/joystickmenurc
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: E CoreContext cecadapter.cpp:128 (Open) CECAdapter: Failed to load libcec.
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I CoreContext mythudplistener.cpp:32 (Enable) UDPListener: Enabling
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I CoreContext serverpool.cpp:482 (bind) Binding to UDP 127.0.0.1:0
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I CoreContext serverpool.cpp:482 (bind) Binding to UDP [::1]:0
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I CoreContext serverpool.cpp:482 (bind) Binding to UDP [fe80::224:8cff:fe7e:e0a2%eth1]:0
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I CoreContext mythmainwindow.cpp:954 (Init) Using Frameless Window
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I CoreContext mythmainwindow.cpp:967 (Init) Using Full Screen Window
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I CoreContext mythmainwindow.cpp:1058 (Init) Using the Qt painter
    Oct 19 12:00:17 shabba mythlogserver: mythwelcome[1937]: I Logger logging.cpp:447 (initialTimeout) Added logging to mythlogserver at TCP:35327
    Oct 19 12:00:22 shabba mythlogserver: mythwelcome[1937]: I Logger logging.cpp:487 (launchLogServer) Starting mythlogserver
    Nothing in the mythfrontend logs

    in the backend logs

    Code:
    Oct 19 00:10:17 shabba mythlogserver: mythbackend[2472]: I ProcessRequest mainserver.cpp:1397 (HandleAnnounce) adding: shabba as a client (events: 1)
    Passed time: 1350614640
    Running /usr/bin/setwakeup.sh to set the wakeup time to 1350614640
    Passed time: 1350614640
    Running /usr/bin/setwakeup.sh to set the wakeup time to 1350614640
    rtc_time        : 23:10:37
    rtc_date        : 2012-10-18
    alrm_time       : 02:44:00
    alrm_date       : 2012-10-19
    alarm_IRQ       : yes
    alrm_pending    : no
    update IRQ enabled      : no
    periodic IRQ enabled    : no
    periodic IRQ frequency  : 1024
    max user IRQ frequency  : 64
    24hr            : yes
    periodic_IRQ    : no
    update_IRQ      : no
    HPET_emulated   : yes
    BCD             : yes
    DST_enable      : no
    periodic_freq   : 1024
    batt_status     : okay
    rtc_time        : 23:10:37
    rtc_date        : 2012-10-18
    alrm_time       : 02:44:00
    alrm_date       : 2012-10-19
    alarm_IRQ       : yes
    alrm_pending    : no
    update IRQ enabled      : no
    periodic IRQ enabled    : no
    periodic IRQ frequency  : 1024
    max user IRQ frequency  : 64
    24hr            : yes
    periodic_IRQ    : no
    update_IRQ      : no
    HPET_emulated   : yes
    BCD             : yes
    DST_enable      : no
    periodic_freq   : 1024
    batt_status     : okay
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: C thread_unknown mythcommandlineparser.cpp:2545 (ConfigureLogging) mythbackend version: fixes/0.26 [
    v0.26.0-16-gbff8eb1] www.mythtv.org
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: C thread_unknown mythcommandlineparser.cpp:2547 (ConfigureLogging) Qt version: compile: 4.8.1, runti
    me: 4.8.1
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: N thread_unknown mythcommandlineparser.cpp:2549 (ConfigureLogging) Enabled verbose msgs:  general
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: N thread_unknown logging.cpp:837 (logStart) Setting Log Level to LOG_INFO
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: I Logger logging.cpp:306 (run) Added logging to the console
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Interrupt handler
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Terminated handler
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Segmentation fault handler
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Aborted handler
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Bus error handler
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Floating point exception handler
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Illegal instruction handler
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Real-time signal 0 handler
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: N thread_unknown mythdirs.cpp:55 (InitializeMythDirs) Using runtime prefix = /usr
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: N thread_unknown mythdirs.cpp:68 (InitializeMythDirs) Using configuration directory = /home/mythtv/.
    mythtv
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: I CoreContext mythcorecontext.cpp:231 (Init) Assumed character encoding: en_GB.UTF-8
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: N CoreContext mythcontext.cpp:493 (LoadDatabaseSettings) Empty LocalHostName.
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: I CoreContext mythcontext.cpp:501 (LoadDatabaseSettings) Using localhost value of shabba
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: I Logger logging.cpp:487 (launchLogServer) Starting mythlogserver
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: I SystemManager system-unix.cpp:263 (run) Starting process manager
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: I SystemSignalManager system-unix.cpp:490 (run) Starting process signal handler
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: I SystemIOHandlerR system-unix.cpp:90 (run) Starting IO manager (read)
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: I SystemIOHandlerW system-unix.cpp:90 (run) Starting IO manager (write)
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: N CoreContext mythcorecontext.cpp:1283 (InitLocale) Setting QT default locale to en_GB
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: I CoreContext mythcorecontext.cpp:1316 (SaveLocaleDefaults) Current locale en_GB
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: N CoreContext mythlocale.cpp:121 (LoadDefaultsFromXML) Reading locale defaults from /usr/share/mytht
    v//locales/en_gb.xml
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: I CoreContext schemawizard.cpp:118 (Compare) Current MythTV Schema Version (DBSchemaVer): 1307
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: I CoreContext mythtranslation.cpp:65 (load) Loading en_gb translation for module mythfrontend
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: N CoreContext main_helpers.cpp:575 (run_backend) MythBackend: Starting up as the master server.
    Oct 19 12:00:21 shabba mythlogserver: mythbackend[2553]: I Logger logging.cpp:447 (initialTimeout) Added logging to mythlogserver at TCP:35327
    Oct 19 12:00:22 shabba mythlogserver: mythbackend[2553]: I CoreContext programinfo.cpp:2062 (CheckProgramIDAuthorities) Found 10 distinct programid authoriti
    es
    Oct 19 12:00:22 shabba mythlogserver: mythbackend[2553]: I Scheduler mythdbcon.cpp:436 (getStaticCon) New static DB connectionSchedCon
    Oct 19 12:00:22 shabba mythlogserver: mythbackend[2553]: I CoreContext serverpool.cpp:395 (listen) Listening on TCP 127.0.0.1:6544
    Oct 19 12:00:22 shabba mythlogserver: mythbackend[2553]: I CoreContext serverpool.cpp:395 (listen) Listening on TCP 192.168.1.66:6544
    Oct 19 12:00:22 shabba mythlogserver: mythbackend[2553]: I CoreContext serverpool.cpp:395 (listen) Listening on TCP [::1]:6544
    Oct 19 12:00:22 shabba mythlogserver: mythbackend[2553]: I CoreContext serverpool.cpp:395 (listen) Listening on TCP [fe80::224:8cff:fe7e:e0a2%eth1]:6544
    Oct 19 12:00:23 shabba mythlogserver: mythbackend[2553]: I CoreContext main_helpers.cpp:645 (run_backend) Main::Registering HttpStatus Extension
    Oct 19 12:00:23 shabba mythlogserver: mythbackend[2553]: I CoreContext serverpool.cpp:395 (listen) Listening on TCP 127.0.0.1:6543
    Oct 19 12:00:23 shabba mythlogserver: mythbackend[2553]: I CoreContext serverpool.cpp:395 (listen) Listening on TCP 192.168.1.66:6543
    Oct 19 12:00:23 shabba mythlogserver: mythbackend[2553]: I CoreContext serverpool.cpp:395 (listen) Listening on TCP [::1]:6543
    Oct 19 12:00:23 shabba mythlogserver: mythbackend[2553]: I CoreContext serverpool.cpp:395 (listen) Listening on TCP [fe80::224:8cff:fe7e:e0a2%eth1]:6543
    Oct 19 12:00:23 shabba mythlogserver: mythbackend[2553]: N CoreContext autoexpire.cpp:264 (CalcParams) AutoExpire: CalcParams(): Max required Free Space: 10.
    0 GB w/freq: 15 min
    Oct 19 12:00:24 shabba mythlogserver: mythbackend[2553]: I CoreContext bonjourregister.cpp:100 (BonjourCallback) Bonjour: Service registration complete: name
     'Mythbackend on shabba' type '_mythbackend-master._tcp.' domain: 'local.'
    Oct 19 12:00:25 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2126 (HandleReschedule) Reschedule requested for MATCH 0 0 0 - SchedulerIn
    it
    Oct 19 12:00:30 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2239 (HandleReschedule) Scheduled 129 items in 4.4 = 3.78 match + 0.39 che
    ck + 0.21 place
    Oct 19 12:00:30 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2297 (HandleRunSchedulerStartup) Scheduler: AUTO-Startup assumed
    Oct 19 12:00:30 shabba mythlogserver: mythbackend[2553]: I TVRecEvent tv_rec.cpp:1043 (HandleStateChange) TVRec(13): Changing from None to RecordingOnly
    Oct 19 12:00:30 shabba mythlogserver: mythbackend[2553]: I TVRecEvent tv_rec.cpp:3562 (TuningCheckForHWChange) TVRec(13): HW Tuner: 13->13
    Oct 19 12:00:30 shabba mythlogserver: mythbackend[2553]: N Scheduler autoexpire.cpp:264 (CalcParams) AutoExpire: CalcParams(): Max required Free Space: 12.0
    GB w/freq: 14 min
    Oct 19 12:00:30 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2646 (HandleRecordingStatusChange) Tuning recording: "Come Dine with Me":
    channel 1004 on cardid 13, sourceid 1
    Oct 19 12:00:30 shabba mythlogserver: mythbackend[2553]: I TVRecEvent tv_rec.cpp:1557 (HandlePendingRecordings) TVRec(14): ASK_RECORDING 14 0 0 0
    Oct 19 12:00:31 shabba mythlogserver: mythbackend[2553]: I CoreContext scheduler.cpp:655 (UpdateRecStatus) Updating status for "Come Dine with Me" on cardid
    13 (Tuning => Recording)
    Oct 19 12:00:31 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2126 (HandleReschedule) Reschedule requested for PLACE PrepareToRecord
    Oct 19 12:00:32 shabba mythlogserver: mythbackend[2553]: I TVRecEvent tv_rec.cpp:4056 (TuningNewRecorder) TVRec(13): rec->GetPathname(): '/var/lib/mythtv/rec
    ordings/1004_20121019110000.mpg'
    Oct 19 12:00:32 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2239 (HandleReschedule) Scheduled 128 items in 1.5 = 0.00 match + 0.00 che
    ck + 1.46 place
    Oct 19 12:00:33 shabba mythlogserver: mythbackend[2553]: I HouseKeeping housekeeper.cpp:221 (RunHouseKeeping) Running housekeeping thread
    Oct 19 12:00:36 shabba mythlogserver: mythbackend[2553]: I HouseKeeping housekeeper.cpp:814 (UpdateRecordedArtwork) Performing Artwork Refresh: /usr/bin/myth
    metadatalookup --refresh-all-artwork  --verbose general --loglevel info --syslog local7
    Oct 19 12:00:37 shabba mythlogserver: mythbackend[2553]: I ProcessRequest mainserver.cpp:1395 (HandleAnnounce) MainServer::ANN Playback
    Oct 19 12:00:37 shabba mythlogserver: mythbackend[2553]: I ProcessRequest mainserver.cpp:1397 (HandleAnnounce) adding: shabba as a client (events: 0)
    Oct 19 12:00:37 shabba mythlogserver: mythbackend[2553]: I ProcessRequest mainserver.cpp:1395 (HandleAnnounce) MainServer::ANN Monitor
    Oct 19 12:00:37 shabba mythlogserver: mythbackend[2553]: I ProcessRequest mainserver.cpp:1397 (HandleAnnounce) adding: shabba as a client (events: 1)
    Oct 19 12:01:43 shabba mythlogserver: mythbackend[2553]: N Expire autoexpire.cpp:264 (CalcParams) AutoExpire: CalcParams(): Max required Free Space: 12.0 GB
    w/freq: 14 min
    Oct 19 12:01:43 shabba mythlogserver: mythbackend[2553]: N Expire autoexpire.cpp:641 (SendDeleteMessages) Expiring 30 MB for 1022 at 2010-11-15T13:48:18Z =>
    "Moira C Bags Pick of the Day"
    Oct 19 12:01:43 shabba mythlogserver: mythbackend[2553]: E CoreContext programinfo.cpp:2284 (GetPlaybackURL) ProgramInfo(1022_20101115134818.mpg): GetPlaybac
    kURL: '1022_20101115134818.mpg' should be local, but it can not be found.
    Oct 19 12:01:43 shabba mythlogserver: mythbackend[2553]: E CoreContext mainserver.cpp:2622 (DoHandleDeleteRecording) ERROR when trying to delete file: GetPla
    ybackURL/UNABLE/TO/FIND/LOCAL/FILE/ON/shabba/1022_20101115134818.mpg. File doesn't exist.  Database metadata will not be removed.
    Oct 19 12:02:08 shabba mythlogserver: mythbackend[2553]: I HouseKeeping housekeeper.cpp:821 (UpdateRecordedArtwork) Artwork Refresh Complete
    Oct 19 12:06:19 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2126 (HandleReschedule) Reschedule requested for MATCH 0 0 0 - EITScanner
    Oct 19 12:06:23 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2239 (HandleReschedule) Scheduled 139 items in 4.2 = 3.50 match + 0.44 che
    ck + 0.22 place
    Oct 19 12:07:14 shabba mythlogserver: mythbackend[2553]: I HouseKeeping housekeeper.cpp:221 (RunHouseKeeping) Running housekeeping thread
    Oct 19 12:09:08 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2126 (HandleReschedule) Reschedule requested for MATCH 0 0 0 - EITScanner
    Oct 19 12:09:13 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2239 (HandleReschedule) Scheduled 139 items in 4.2 = 3.52 match + 0.44 che
    ck + 0.23 place
    Oct 19 12:11:55 shabba mythlogserver: mythbackend[2553]: W TFWWrite ThreadedFileWriter.cpp:500 (DiskLoop) TFW(/var/lib/mythtv/recordings/1004_20121019110000.
    mpg:77): write(57528) cnt 112 total 6501980 -- took a long time, 12367 ms
    Oct 19 12:12:03 shabba mythlogserver: mythbackend[2553]: W TFWWrite ThreadedFileWriter.cpp:500 (DiskLoop) TFW(/var/lib/mythtv/recordings/1004_20121019110000.
    mpg:77): write(57716) cnt 116 total 6756908 -- took a long time, 6183 ms
    Oct 19 12:12:20 shabba mythlogserver: mythbackend[2553]: I HouseKeeping housekeeper.cpp:221 (RunHouseKeeping) Running housekeeping thread
    Oct 19 12:15:43 shabba mythlogserver: mythbackend[2553]: N Expire autoexpire.cpp:264 (CalcParams) AutoExpire: CalcParams(): Max required Free Space: 12.0 GB
    w/freq: 14 min
    Oct 19 12:16:15 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2126 (HandleReschedule) Reschedule requested for MATCH 0 0 0 - EITScanner
    Oct 19 12:16:20 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2239 (HandleReschedule) Scheduled 140 items in 4.2 = 3.54 match + 0.45 che
    ck + 0.24 place
    Oct 19 12:17:27 shabba mythlogserver: mythbackend[2553]: I HouseKeeping housekeeper.cpp:221 (RunHouseKeeping) Running housekeeping thread
    Oct 19 12:19:30 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2126 (HandleReschedule) Reschedule requested for MATCH 0 0 0 - EITScanner
    Oct 19 12:19:34 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2239 (HandleReschedule) Scheduled 141 items in 4.2 = 3.54 match + 0.45 che
    ck + 0.24 place
    Oct 19 12:22:32 shabba mythlogserver: mythbackend[2553]: I HouseKeeping housekeeper.cpp:221 (RunHouseKeeping) Running housekeeping thread
    Oct 19 12:22:55 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2126 (HandleReschedule) Reschedule requested for MATCH 0 0 0 - EITScanner
    Oct 19 12:22:59 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2239 (HandleReschedule) Scheduled 141 items in 4.3 = 3.57 match + 0.45 che
    ck + 0.23 place
    Oct 19 12:25:37 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2126 (HandleReschedule) Reschedule requested for MATCH 0 0 0 - EITScanner
    Oct 19 12:25:41 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2239 (HandleReschedule) Scheduled 141 items in 4.2 = 3.50 match + 0.44 che
    ck + 0.23 place
    Oct 19 12:27:36 shabba mythlogserver: mythbackend[2553]: I HouseKeeping housekeeper.cpp:221 (RunHouseKeeping) Running housekeeping thread
    Oct 19 12:29:43 shabba mythlogserver: mythbackend[2553]: N Expire autoexpire.cpp:264 (CalcParams) AutoExpire: CalcParams(): Max required Free Space: 12.0 GB
    w/freq: 14 min
    Oct 19 12:32:01 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2126 (HandleReschedule) Reschedule requested for MATCH 0 0 0 - EITScanner
    Oct 19 12:32:05 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2239 (HandleReschedule) Scheduled 141 items in 4.3 = 3.66 match + 0.44 che
    ck + 0.23 place
    Oct 19 12:32:30 shabba mythlogserver: mythbackend[2553]: I TVRecEvent tv_rec.cpp:1557 (HandlePendingRecordings) TVRec(13): ASK_RECORDING 13 28 0 0
    Oct 19 12:32:31 shabba mythlogserver: mythbackend[2553]: I TVRecEvent tv_rec.cpp:1557 (HandlePendingRecordings) TVRec(14): ASK_RECORDING 14 28 0 0
    Oct 19 12:32:40 shabba mythlogserver: mythbackend[2553]: I HouseKeeping housekeeper.cpp:221 (RunHouseKeeping) Running housekeeping thread
    Oct 19 12:33:00 shabba mythlogserver: mythbackend[2553]: I TVRecEvent tv_rec.cpp:1043 (HandleStateChange) TVRec(14): Changing from None to RecordingOnly
    Oct 19 12:33:00 shabba mythlogserver: mythbackend[2553]: I TVRecEvent tv_rec.cpp:3562 (TuningCheckForHWChange) TVRec(14): HW Tuner: 14->14
    Oct 19 12:33:00 shabba mythlogserver: mythbackend[2553]: N Scheduler autoexpire.cpp:264 (CalcParams) AutoExpire: CalcParams(): Max required Free Space: 12.0
    GB w/freq: 7 min
    Oct 19 12:33:00 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2646 (HandleRecordingStatusChange) Tuning recording: "Come Dine with Me":
    channel 1004 on cardid 14, sourceid 1
    Oct 19 12:33:02 shabba mythlogserver: mythbackend[2553]: I CoreContext scheduler.cpp:655 (UpdateRecStatus) Updating status for "Come Dine with Me" on cardid
    14 (Tuning => Recording)
    Oct 19 12:33:02 shabba mythlogserver: mythbackend[2553]: I TVRecEvent tv_rec.cpp:4056 (TuningNewRecorder) TVRec(14): rec->GetPathname(): '/var/lib/mythtv/rec
    ordings/1004_20121019113300.mpg'
    Oct 19 12:34:50 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2126 (HandleReschedule) Reschedule requested for MATCH 0 0 0 - EITScanner
    Oct 19 12:34:55 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2239 (HandleReschedule) Scheduled 141 items in 4.3 = 3.67 match + 0.45 che
    ck + 0.23 place
    Oct 19 12:37:28 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2126 (HandleReschedule) Reschedule requested for MATCH 0 0 0 - EITScanner
    Oct 19 12:37:32 shabba mythlogserver: mythbackend[2553]: I Scheduler scheduler.cpp:2239 (HandleReschedule) Scheduled 141 items in 4.4 = 3.73 match + 0.45 che
    ck + 0.23 place
    Oct 19 12:37:44 shabba mythlogserver: mythbackend[2553]: I HouseKeeping housekeeper.cpp:221 (RunHouseKeeping) Running housekeeping thread
    Oct 19 12:38:33 shabba mythlogserver: mythbackend[2553]: I Metadata_5350 jobqueue.cpp:2156 (DoMetadataLookupThread) JobQueue: Metadata Lookup Starting for "C
    --More--
    Does anyone have any ideas

    TIA

  3. #3
    Join Date
    Nov 2006
    Location
    Oregon
    Beans
    4,285
    Distro
    Ubuntu Development Release

    Re: MythTV could not connect to database

    What IP address are you setting in the frontend for your backend? Is the MythTV service enabled in the mythbuntu-control-centre.
    *Don't PM me directly for support, open a new thread
    *Looking for a MythTV quick start guide?

  4. #4
    Join Date
    Jun 2007
    Location
    Southampton, England
    Beans
    45

    Re: MythTV could not connect to database

    Hi
    In the frontend, the hostname is 192.168.1.66 the frontend is on the same machine but I also use another frontend.

    It appears to be enabled in the mythbuntu control centre as in primary backend and desktop frontend are enable. Its also set to Automatically start MythTV Frontend.

    Thanks for your help

  5. #5
    Join Date
    Nov 2006
    Location
    Oregon
    Beans
    4,285
    Distro
    Ubuntu Development Release

    Re: MythTV could not connect to database

    Can you get into Mythweb? that would verify the backend is up and running properly.

    Does the remote frontend work?
    *Don't PM me directly for support, open a new thread
    *Looking for a MythTV quick start guide?

  6. #6
    Join Date
    Jun 2007
    Location
    Southampton, England
    Beans
    45

    Re: MythTV could not connect to database

    Ive not upgraded the remote frontend yet.

    Funnily enough this morning the backend wont start and im caught in a continous loop of confirming country i reside in and verify database settings. Im going to reboot it and try again.

    When the backend is up mythweb works fine. When its not up (according to top) mythweb doesnt work with the following backtrace.

    Code:
       datetime:  2012-10-20 09:57:47 (BST)
        errornum:  256
      error type:  User Error
    error string:  !!NoTrans: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [#2002]
    
    Backtrace
    Array
    (
        [0] => Array
            (
                [file] => /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php
                [line] => 63
                [function] => error
                [class] => Database
                [object] => Database_mysql Object
                    (
                        [dbh] => 
                        [error] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [#2002]
                        [err] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
                        [errno] => 2002
                        [last_sh] => Database_Query_mysql Object
                            (
                                [dbh] => 
                                [query] => Array
                                    (
                                        [0] => SET NAMES utf8;
                                    )
    
                                [last_query] => SET NAMES utf8;
                                [warnings] => Array ( )
                                [num_args_needed] => 0
                                [num_rows] => 
                                [affected_rows] => 
                                [insert_id] => 
                                [db] => Database_mysql Object
     *RECURSION*
                            )
    
                        [fatal_errors] => 1
                        [query_count] => 0
                        [query_time] => 0
                        [global_name] => 
                        [destruct_handlers] => Array ( )
                    )
    
                [type] => ->
                [args] => Array ( )
            )
    
        [1] => Array
            (
                [file] => /usr/share/mythtv/mythweb/classes/Database.php
                [line] => 261
                [function] => execute
                [class] => Database_Query_mysql
                [object] => Database_Query_mysql Object
                    (
                        [dbh] => 
                        [query] => Array
                            (
                                [0] => SET NAMES utf8;
                            )
    
                        [last_query] => SET NAMES utf8;
                        [warnings] => Array ( )
                        [num_args_needed] => 0
                        [num_rows] => 
                        [affected_rows] => 
                        [insert_id] => 
                        [db] => Database_mysql Object
                            (
                                [dbh] => 
                                [error] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [#2002]
                                [err] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
                                [errno] => 2002
                                [last_sh] => Database_Query_mysql Object
     *RECURSION*
                                [fatal_errors] => 1
                                [query_count] => 0
                                [query_time] => 0
                                [global_name] => 
                                [destruct_handlers] => Array ( )
                            )
    
                    )
    
                [type] => ->
                [args] => Array
                    (
                        [0] => Array ( )
                    )
    
            )
    
        [2] => Array
            (
                [file] => /usr/share/mythtv/mythweb/classes/Database.php
                [line] => 124
                [function] => query
                [class] => Database
                [object] => Database_mysql Object
                    (
                        [dbh] => 
                        [error] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [#2002]
                        [err] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
                        [errno] => 2002
                        [last_sh] => Database_Query_mysql Object
                            (
                                [dbh] => 
                                [query] => Array
                                    (
                                        [0] => SET NAMES utf8;
                                    )
    
                                [last_query] => SET NAMES utf8;
                                [warnings] => Array ( )
                                [num_args_needed] => 0
                                [num_rows] => 
                                [affected_rows] => 
                                [insert_id] => 
                                [db] => Database_mysql Object
     *RECURSION*
                            )
    
                        [fatal_errors] => 1
                        [query_count] => 0
                        [query_time] => 0
                        [global_name] => 
                        [destruct_handlers] => Array ( )
                    )
    
                [type] => ->
                [args] => Array
                    (
                        [0] => SET NAMES utf8;
                    )
    
            )
    
        [3] => Array
            (
                [file] => /usr/share/mythtv/mythweb/includes/database.php
                [line] => 49
                [function] => connect
                [class] => Database
                [type] => ::
                [args] => Array
                    (
                        [0] => mythconverg
                        [1] => mythtv
                        [2] => FEL5FIZr
                        [3] => localhost
                        [4] => 
                        [5] => mysql
                    )
    
            )
    
        [4] => Array
            (
                [file] => /usr/share/mythtv/mythweb/includes/init.php
                [line] => 40
                [args] => Array
                    (
                        [0] => /usr/share/mythtv/mythweb/includes/database.php
                    )
    
                [function] => require_once
            )
    
        [5] => Array
            (
                [file] => /usr/share/mythtv/mythweb/mythweb.php
                [line] => 20
                [args] => Array
                    (
                        [0] => /usr/share/mythtv/mythweb/includes/init.php
                    )
    
                [function] => require_once
            )
    
    )
    !!
        filename:  /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php
      error line:  64
    
    ==========================================================================
    
    Backtrace: 
    
        file:  /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php
        line:  64
       class:  
    function:  trigger_error
        type:  
        args:  Array
    (
        [0] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [#2002]
    
    Backtrace
    Array
    (
        [0] => Array
            (
                [file] => /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php
                [line] => 63
                [function] => error
                [class] => Database
                [object] => Database_mysql Object
                    (
                        [dbh] => 
                        [error] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [#2002]
                        [err] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
                        [errno] => 2002
                        [last_sh] => Database_Query_mysql Object
                            (
                                [dbh] => 
                                [query] => Array
                                    (
                                        [0] => SET NAMES utf8;
                                    )
    
                                [last_query] => SET NAMES utf8;
                                [warnings] => Array ( )
                                [num_args_needed] => 0
                                [num_rows] => 
                                [affected_rows] => 
                                [insert_id] => 
                                [db] => Database_mysql Object
     *RECURSION*
                            )
    
                        [fatal_errors] => 1
                        [query_count] => 0
                        [query_time] => 0
                        [global_name] => 
                        [destruct_handlers] => Array ( )
                    )
    
                [type] => ->
                [args] => Array ( )
            )
    
        [1] => Array
            (
                [file] => /usr/share/mythtv/mythweb/classes/Database.php
                [line] => 261
                [function] => execute
                [class] => Database_Query_mysql
                [object] => Database_Query_mysql Object
                    (
                        [dbh] => 
                        [query] => Array
                            (
                                [0] => SET NAMES utf8;
                            )
    
                        [last_query] => SET NAMES utf8;
                        [warnings] => Array ( )
                        [num_args_needed] => 0
                        [num_rows] => 
                        [affected_rows] => 
                        [insert_id] => 
                        [db] => Database_mysql Object
                            (
                                [dbh] => 
                                [error] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [#2002]
                                [err] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
                                [errno] => 2002
                                [last_sh] => Database_Query_mysql Object
     *RECURSION*
                                [fatal_errors] => 1
                                [query_count] => 0
                                [query_time] => 0
                                [global_name] => 
                                [destruct_handlers] => Array ( )
                            )
    
                    )
    
                [type] => ->
                [args] => Array
                    (
                        [0] => Array ( )
                    )
    
            )
    
        [2] => Array
            (
                [file] => /usr/share/mythtv/mythweb/classes/Database.php
                [line] => 124
                [function] => query
                [class] => Database
                [object] => Database_mysql Object
                    (
                        [dbh] => 
                        [error] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [#2002]
                        [err] => Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
                        [errno] => 2002
                        [last_sh] => Database_Query_mysql Object
                            (
                                [dbh] => 
                                [query] => Array
                                    (
                                        [0] => SET NAMES utf8;
                                    )
    
                                [last_query] => SET NAMES utf8;
                                [warnings] => Array ( )
                                [num_args_needed] => 0
                                [num_rows] => 
                                [affected_rows] => 
                                [insert_id] => 
                                [db] => Database_mysql Object
     *RECURSION*
                            )
    
                        [fatal_errors] => 1
                        [query_count] => 0
                        [query_time] => 0
                        [global_name] => 
                        [destruct_handlers] => Array ( )
                    )
    
                [type] => ->
                [args] => Array
                    (
                        [0] => SET NAMES utf8;
                    )
    
            )
    
        [3] => Array
            (
                [file] => /usr/share/mythtv/mythweb/includes/database.php
                [line] => 49
                [function] => connect
                [class] => Database
                [type] => ::
                [args] => Array
                    (
                        [0] => mythconverg
                        [1] => mythtv
                        [2] => FEL5FIZr
                        [3] => localhost
                        [4] => 
                        [5] => mysql
                    )
    
            )
    
        [4] => Array
            (
                [file] => /usr/share/mythtv/mythweb/includes/init.php
                [line] => 40
                [args] => Array
                    (
                        [0] => /usr/share/mythtv/mythweb/includes/database.php
                    )
    
                [function] => require_once
            )
    
        [5] => Array
            (
                [file] => /usr/share/mythtv/mythweb/mythweb.php
                [line] => 20
                [args] => Array
                    (
                        [0] => /usr/share/mythtv/mythweb/includes/init.php
                    )
    
                [function] => require_once
            )
    
    )
    
        [1] => 256
    )
    
        file:  /usr/share/mythtv/mythweb/classes/Database.php
        line:  261
       class:  Database_Query_mysql
    function:  execute
        type:  ->
        args:  Array
    (
        [0] => Array ( )
    )
    
        file:  /usr/share/mythtv/mythweb/classes/Database.php
        line:  124
       class:  Database
    function:  query
        type:  ->
        args:  Array
    (
        [0] => SET NAMES utf8;
    )
    
        file:  /usr/share/mythtv/mythweb/includes/database.php
        line:  49
       class:  Database
    function:  connect
        type:  ::
        args:  Array
    (
        [0] => mythconverg
        [1] => mythtv
        [2] => FEL5FIZr
        [3] => localhost
        [4] => 
        [5] => mysql
    )
    
        file:  /usr/share/mythtv/mythweb/includes/init.php
        line:  40
       class:  
    function:  require_once
        type:  
        args:  Array
    (
        [0] => /usr/share/mythtv/mythweb/includes/database.php
    )
    
        file:  /usr/share/mythtv/mythweb/mythweb.php
        line:  20
       class:  
    function:  require_once
        type:  
        args:  Array
    (
        [0] => /usr/share/mythtv/mythweb/includes/init.php
    )
    
    
    ==========================================================================
    
    $_SESSION: Array
    (
        [language] => English
    )
    
    ==========================================================================
    
    $_SERVER: Array
    (
        [REDIRECT_STATUS] => 200
        [db_server] => localhost
        [db_name] => mythconverg
        [db_login] => mythtv
        [db_password] => FEL5FIZr
        [HTTP_HOST] => shabba
        [HTTP_CONNECTION] => keep-alive
        [HTTP_USER_AGENT] => Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.94 Safari/537.4
        [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
        [HTTP_ACCEPT_ENCODING] => gzip,deflate,sdch
        [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.8
        [HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.3
        [HTTP_COOKIE] => mythweb_id=do7dc4dq3thh7ithj8pp6bmo70
        [PATH] => /usr/local/bin:/usr/bin:/bin
        [SERVER_SIGNATURE] => <address>Apache/2.2.22 (Ubuntu) Server at shabba Port 80</address>
    
        [SERVER_SOFTWARE] => Apache/2.2.22 (Ubuntu)
        [SERVER_NAME] => shabba
        [SERVER_ADDR] => 192.168.1.66
        [SERVER_PORT] => 80
        [REMOTE_ADDR] => 192.168.1.65
        [DOCUMENT_ROOT] => /var/www
        [SERVER_ADMIN] => webmaster@localhost
        [SCRIPT_FILENAME] => /var/www/mythweb/mythweb.php
        [REMOTE_PORT] => 49479
        [REDIRECT_URL] => /mythweb/
        [GATEWAY_INTERFACE] => CGI/1.1
        [SERVER_PROTOCOL] => HTTP/1.1
        [REQUEST_METHOD] => GET
        [QUERY_STRING] => 
        [REQUEST_URI] => /mythweb/
        [SCRIPT_NAME] => /mythweb/mythweb.php
        [PHP_SELF] => /mythweb/mythweb.php
        [REQUEST_TIME] => 1350723467
        [STATUS] => 200
        [URL] => /mythweb/
    )
    
    ==========================================================================
    
    $constant_list["user"]: Array
    (
        [ERROR] => 512
        [E_ASSERT_ERROR] => 4096
        [FATAL] => 256
        [PHP_MIN_VERSION] => 5.3
        [WARNING] => 1024
    )
    TIA

  7. #7
    Join Date
    Jun 2007
    Location
    Southampton, England
    Beans
    45

    Re: MythTV could not connect to database

    ok backend is starting up now after a reboot but I still get this window asking me to verify database settings.
    Mythweb is working fine and the backend is up.
    As soon as I confirm database settings, the frontend starts.

    Im clutching at straws but could it be anything to do with the order they start?

  8. #8
    Join Date
    Jun 2007
    Location
    Southampton, England
    Beans
    45

    Re: MythTV could not connect to database

    Still getting presented with a window to configure the database.
    The backend starts, mysqld starts.
    Mythweb doesnt work even after confirming database configuration.

    Code:
    Array
    (
        [0] => Array
            (
                [file] => /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php
                [line] => 63
                [function] => error
                [class] => Database
                [object] => Database_mysql Object
                    (
                        [dbh] => 
                        [error] => Can't connect to MySQL server on '127.0.0.1' (111) [#2003]
                        [err] => Can't connect to MySQL server on '127.0.0.1' (111)
                        [errno] => 2003
                        [last_sh] => Database_Query_mysql Object
                            (
                                [dbh] => 
                                [query] => Array
                                    (
                                        [0] => SET NAMES utf8;
                                    )
    
                                [last_query] => SET NAMES utf8;
                                [warnings] => Array ( )
                                [num_args_needed] => 0
                                [num_rows] => 
                                [affected_rows] => 
                                [insert_id] => 
                                [db] => Database_mysql Object
     *RECURSION*
                            )
    
                        [fatal_errors] => 1
                        [query_count] => 0
                        [query_time] => 0
                        [global_name] => 
                        [destruct_handlers] => Array ( )
                    )
    
                [type] => ->
                [args] => Array ( )
            )
    
        [1] => Array
            (
                [file] => /usr/share/mythtv/mythweb/classes/Database.php
                [line] => 261
                [function] => execute
                [class] => Database_Query_mysql
                [object] => Database_Query_mysql Object
                    (
                        [dbh] => 
                        [query] => Array
                            (
                                [0] => SET NAMES utf8;
                            )
    
                        [last_query] => SET NAMES utf8;
                        [warnings] => Array ( )
                        [num_args_needed] => 0
                        [num_rows] => 
                        [affected_rows] => 
                        [insert_id] => 
                        [db] => Database_mysql Object
                            (
                                [dbh] => 
                                [error] => Can't connect to MySQL server on '127.0.0.1' (111) [#2003]
                                [err] => Can't connect to MySQL server on '127.0.0.1' (111)
                                [errno] => 2003
                                [last_sh] => Database_Query_mysql Object
     *RECURSION*
                                [fatal_errors] => 1
                                [query_count] => 0
                                [query_time] => 0
                                [global_name] => 
                                [destruct_handlers] => Array ( )
                            )
    
                    )
    
                [type] => ->
                [args] => Array
                    (
                        [0] => Array ( )
                    )
    
            )
    
        [2] => Array
            (
                [file] => /usr/share/mythtv/mythweb/classes/Database.php
                [line] => 124
                [function] => query
                [class] => Database
                [object] => Database_mysql Object
                    (
                        [dbh] => 
                        [error] => Can't connect to MySQL server on '127.0.0.1' (111) [#2003]
                        [err] => Can't connect to MySQL server on '127.0.0.1' (111)
                        [errno] => 2003
                        [last_sh] => Database_Query_mysql Object
                            (
                                [dbh] => 
                                [query] => Array
                                    (
                                        [0] => SET NAMES utf8;
                                    )
    
                                [last_query] => SET NAMES utf8;
                                [warnings] => Array ( )
                                [num_args_needed] => 0
                                [num_rows] => 
                                [affected_rows] => 
                                [insert_id] => 
                                [db] => Database_mysql Object
     *RECURSION*
                            )
    
                        [fatal_errors] => 1
                        [query_count] => 0
                        [query_time] => 0
                        [global_name] => 
                        [destruct_handlers] => Array ( )
                    )
    
                [type] => ->
                [args] => Array
                    (
                        [0] => SET NAMES utf8;
                    )
    
            )
    
        [3] => Array
            (
                [file] => /usr/share/mythtv/mythweb/includes/database.php
                [line] => 49
                [function] => connect
                [class] => Database
                [type] => ::
                [args] => Array
                    (
                        [0] => mythconverg
                        [1] => mythtv
                        [2] => FEL5FIZr
                        [3] => 127.0.0.1
                        [4] => 
                        [5] => mysql
                    )
    
            )
    
        [4] => Array
            (
                [file] => /usr/share/mythtv/mythweb/includes/init.php
                [line] => 40
                [args] => Array
                    (
                        [0] => /usr/share/mythtv/mythweb/includes/database.php
                    )
    
                [function] => require_once
            )
    
        [5] => Array
            (
                [file] => /usr/share/mythtv/mythweb/mythweb.php
                [line] => 20
                [args] => Array
                    (
                        [0] => /usr/share/mythtv/mythweb/includes/init.php
                    )
    
                [function] => require_once
            )
    
    )
    !!
        filename:  /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php
      error line:  64
    
    ==========================================================================
    
    Backtrace: 
    
        file:  /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php
        line:  64
       class:  
    function:  trigger_error
        type:  
        args:  Array
    (
        [0] => Can't connect to MySQL server on '127.0.0.1' (111) [#2003]
    
    Backtrace
    Array
    (
        [0] => Array
            (
                [file] => /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php
                [line] => 63
                [function] => error
                [class] => Database
                [object] => Database_mysql Object
                    (
                        [dbh] => 
                        [error] => Can't connect to MySQL server on '127.0.0.1' (111) [#2003]
                        [err] => Can't connect to MySQL server on '127.0.0.1' (111)
                        [errno] => 2003
                        [last_sh] => Database_Query_mysql Object
                            (
                                [dbh] => 
                                [query] => Array
                                    (
                                        [0] => SET NAMES utf8;
                                    )
    
                                [last_query] => SET NAMES utf8;
                                [warnings] => Array ( )
                                [num_args_needed] => 0
                                [num_rows] => 
                                [affected_rows] => 
                                [insert_id] => 
                                [db] => Database_mysql Object
     *RECURSION*
                            )
    
                        [fatal_errors] => 1
                        [query_count] => 0
                        [query_time] => 0
                        [global_name] => 
                        [destruct_handlers] => Array ( )
                    )
    
                [type] => ->
                [args] => Array ( )
            )
    
        [1] => Array
            (
                [file] => /usr/share/mythtv/mythweb/classes/Database.php
                [line] => 261
                [function] => execute
                [class] => Database_Query_mysql
                [object] => Database_Query_mysql Object
                    (
                        [dbh] => 
                        [query] => Array
                            (
                                [0] => SET NAMES utf8;
                            )
    
                        [last_query] => SET NAMES utf8;
                        [warnings] => Array ( )
                        [num_args_needed] => 0
                        [num_rows] => 
                        [affected_rows] => 
                        [insert_id] => 
                        [db] => Database_mysql Object
                            (
                                [dbh] => 
                                [error] => Can't connect to MySQL server on '127.0.0.1' (111) [#2003]
                                [err] => Can't connect to MySQL server on '127.0.0.1' (111)
                                [errno] => 2003
                                [last_sh] => Database_Query_mysql Object
     *RECURSION*
                                [fatal_errors] => 1
                                [query_count] => 0
                                [query_time] => 0
                                [global_name] => 
                                [destruct_handlers] => Array ( )
                            )
    
                    )
    
                [type] => ->
                [args] => Array
                    (
                        [0] => Array ( )
                    )
    
            )
    
        [2] => Array
            (
                [file] => /usr/share/mythtv/mythweb/classes/Database.php
                [line] => 124
                [function] => query
                [class] => Database
                [object] => Database_mysql Object
                    (
                        [dbh] => 
                        [error] => Can't connect to MySQL server on '127.0.0.1' (111) [#2003]
                        [err] => Can't connect to MySQL server on '127.0.0.1' (111)
                        [errno] => 2003
                        [last_sh] => Database_Query_mysql Object
                            (
                                [dbh] => 
                                [query] => Array
                                    (
                                        [0] => SET NAMES utf8;
                                    )
    
                                [last_query] => SET NAMES utf8;
                                [warnings] => Array ( )
                                [num_args_needed] => 0
                                [num_rows] => 
                                [affected_rows] => 
                                [insert_id] => 
                                [db] => Database_mysql Object
     *RECURSION*
                            )
    
                        [fatal_errors] => 1
                        [query_count] => 0
                        [query_time] => 0
                        [global_name] => 
                        [destruct_handlers] => Array ( )
                    )
    
                [type] => ->
                [args] => Array
                    (
                        [0] => SET NAMES utf8;
                    )
    
            )
    
        [3] => Array
            (
                [file] => /usr/share/mythtv/mythweb/includes/database.php
                [line] => 49
                [function] => connect
                [class] => Database
                [type] => ::
                [args] => Array
                    (
                        [0] => mythconverg
                        [1] => mythtv
                        [2] => FEL5FIZr
                        [3] => 127.0.0.1
                        [4] => 
                        [5] => mysql
                    )
    
            )
    
        [4] => Array
            (
                [file] => /usr/share/mythtv/mythweb/includes/init.php
                [line] => 40
                [args] => Array
                    (
                        [0] => /usr/share/mythtv/mythweb/includes/database.php
                    )
    
                [function] => require_once
            )
    
        [5] => Array
            (
                [file] => /usr/share/mythtv/mythweb/mythweb.php
                [line] => 20
                [args] => Array
                    (
                        [0] => /usr/share/mythtv/mythweb/includes/init.php
                    )
    
                [function] => require_once
            )
    
    )
    
        [1] => 256
    )
    
        file:  /usr/share/mythtv/mythweb/classes/Database.php
        line:  261
       class:  Database_Query_mysql
    function:  execute
        type:  ->
        args:  Array
    (
        [0] => Array ( )
    )
    
        file:  /usr/share/mythtv/mythweb/classes/Database.php
        line:  124
       class:  Database
    function:  query
        type:  ->
        args:  Array
    (
        [0] => SET NAMES utf8;
    )
    
        file:  /usr/share/mythtv/mythweb/includes/database.php
        line:  49
       class:  Database
    function:  connect
        type:  ::
        args:  Array
    (
        [0] => mythconverg
        [1] => mythtv
        [2] => FEL5FIZr
        [3] => 127.0.0.1
        [4] => 
        [5] => mysql
    )
    
        file:  /usr/share/mythtv/mythweb/includes/init.php
        line:  40
       class:  
    function:  require_once
        type:  
        args:  Array
    (
        [0] => /usr/share/mythtv/mythweb/includes/database.php
    )
    
        file:  /usr/share/mythtv/mythweb/mythweb.php
        line:  20
       class:  
    function:  require_once
        type:  
        args:  Array
    (
        [0] => /usr/share/mythtv/mythweb/includes/init.php
    )
    
    
    ==========================================================================
    
    $_SESSION: Array
    (
        [language] => English
    )
    
    ==========================================================================
    
    $_SERVER: Array
    (
        [REDIRECT_STATUS] => 200
        [db_server] => 127.0.0.1
        [db_name] => mythconverg
        [db_login] => mythtv
        [db_password] => FEL5FIZr
        [HTTP_HOST] => shabba
        [HTTP_CONNECTION] => keep-alive
        [HTTP_USER_AGENT] => Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.94 Safari/537.4
        [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
        [HTTP_ACCEPT_ENCODING] => gzip,deflate,sdch
        [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.8
        [HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.3
        [PATH] => /usr/local/bin:/usr/bin:/bin
        [SERVER_SIGNATURE] => <address>Apache/2.2.22 (Ubuntu) Server at shabba Port 80</address>
    
        [SERVER_SOFTWARE] => Apache/2.2.22 (Ubuntu)
        [SERVER_NAME] => shabba
        [SERVER_ADDR] => 192.168.1.66
        [SERVER_PORT] => 80
        [REMOTE_ADDR] => 192.168.1.65
        [DOCUMENT_ROOT] => /var/www
        [SERVER_ADMIN] => webmaster@localhost
        [SCRIPT_FILENAME] => /var/www/mythweb/mythweb.php
        [REMOTE_PORT] => 52289
        [REDIRECT_URL] => /mythweb/
        [GATEWAY_INTERFACE] => CGI/1.1
        [SERVER_PROTOCOL] => HTTP/1.1
        [REQUEST_METHOD] => GET
        [QUERY_STRING] => 
        [REQUEST_URI] => /mythweb/
        [SCRIPT_NAME] => /mythweb/mythweb.php
        [PHP_SELF] => /mythweb/mythweb.php
        [REQUEST_TIME] => 1351604068
        [STATUS] => 200
        [URL] => /mythweb/
    )
    
    ==========================================================================
    
    $constant_list["user"]: Array
    (
        [ERROR] => 512
        [E_ASSERT_ERROR] => 4096
        [FATAL] => 256
        [PHP_MIN_VERSION] => 5.3
        [WARNING] => 1024
    )
    Anyone any ideas?

  9. #9
    Join Date
    Jun 2007
    Location
    Southampton, England
    Beans
    45

    Re: MythTV could not connect to database

    BUMP

    This is becoming a PITA each time. I can no longer access mythweb with the above errors.

    Anyone offer some help?

    TIA

  10. #10
    Join Date
    Jun 2007
    Location
    Southampton, England
    Beans
    45

    Re: MythTV could not connect to database

    Somewhat closer.

    If I edit my /etc/apache2/sites-available/mythweb.conf

    from
    Code:
     setenv db_server        "127.0.0.1"
                setenv db_name          "mythconverg"
                setenv db_login         "mythtv"
                setenv db_password      "FEL5FIZr"
    to the ip address

    Code:
    setenv db_server        "192.168.1.66"
                setenv db_name          "mythconverg"
                setenv db_login         "mythtv"
                setenv db_password      "FEL5FIZr"
    I can access mythweb fine. So it looks like I have probles connecting to mysql on 127.0.0.1 for some reason.

    Im not sure where next to look....

Page 1 of 4 123 ... LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •