[mythtv-users] name change effecting mythconverg database

[Nick Ellson]

Not so hot with MySQL, but thus far all the sample scripts and commands 
seem to make sense. I looked at the hostname change procedure, only my 
hostname has not changed, only the domain/FQDN

I am going to UP the logging on mythbankend for "network" in my conf file.


-- 
Nick Ellson
CCDA, CCNP, CCSP, CCAI,
MCSE 2000, Security+, Network+
Network Hobbyist, VFR Private Pilot.


On Mon, 2 Oct 2006, Trey Thompson wrote:

> Are you familiar with MySQL?  You could go through and change all the old
> references/names to the new name.
>
> Someone might even have a handy little script that does all the tables
> automatically, I haven't seen one yet.
>
> Installing phpMyAdmin on your box will help you in managing your MySQL
> databases and data easier than through the command line.
>
> ----- Original Message -----
> From: "Nick Ellson" <grimm at nickellson.com>
> To: "Discussion about mythtv" <mythtv-users at mythtv.org>
> Sent: Monday, October 02, 2006 3:29 PM
> Subject: Re: [mythtv-users] name change effecting mythconverg database
>
>
>
> I was able to grab this from the mythfrontend log. I ran mythtv-setup, it
> complained about both /mythtv.test directory not being writeable, and that
> the back-end was not up.
>
> 2006-10-02 13:27:26.985 Connecting to backend server: 10.0.0.23:6543 (try
> 1 of 5)
> 2006-10-02 13:27:26.985 MythSocket(83525d0:21): new socket
> 2006-10-02 13:27:26.986 MythSocket(83525d0:21): attempting connect() to
> (10.0.0.23:6543)
> 2006-10-02 13:27:26.986 MythSocket(83525d0:21): connect() failed
> (ConnectionRefused)
> 2006-10-02 13:27:26.986 MythSocket(83525d0:21): DownRef: -1
> 2006-10-02 13:27:26.986 MythSocket(83525d0:-1): delete socket
> 2006-10-02 13:27:26.986 Connection timed out.
>                         You probably should modify the Master Server
>                         settings in the setup program and set the
>                         proper IP address.
>
>
> -- 
> Nick Ellson
> CCDA, CCNP, CCSP, CCAI,
> MCSE 2000, Security+, Network+
> Network Hobbyist, VFR Private Pilot.
>
>
> On Mon, 2 Oct 2006, Nick Ellson wrote:
>
>>
>> (Note: Mythbackend and Frontend, same system)
>>
>> I just switch my linux systems at home from a generic ".home" domain to my
>> personal domain ".nickellson.com"
>>
>> Upon rebooting the system, my mythfront end says it is unable to connect
>> to the backend database, is it running. yadda yadda.. and at first I saw
>> MySQL permissions as an issue, so i reran the GRANT command to allow
>> %.nickellson.com and that cleared up. But the front end STILL complains
>> that it cannot connect to the back end database.
>>
>> I used the private IP in both the backend and frontend configs (10.0.0.23)
>>
>> The back end gets to the data (well, no errors in teh backend log anyway)
>> and upon launching the frontend I do see one successful connect to the
>> backend.
>>
>> What can I start looking for to track down the issue? I dumped off my
>> database so i wouldn't loose all the programming. Might this be in the
>> MySQL database itself, because of my renaming the domain on this system?
>>
>> Nick
>> PS: I have until the next air time of Grey's Anatomy to get it working, or
>> the wife will make my life not so fun ;) j/k
>>
>> --
>> Nick Ellson
>> CCDA, CCNP, CCSP, CCAI,
>> MCSE 2000, Security+, Network+
>> Network Hobbyist, VFR Private Pilot.
>>
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>