Re: I moved my server, changed ip and now..
Re: I moved my server, changed ip and now..
- Subject: Re: I moved my server, changed ip and now..
- From: Kieran Kelleher <email@hidden>
- Date: Sun, 13 Apr 2008 21:32:02 -0400
Hi James,
Just saw this thread now (it is Sunday after all, and I really needed
to take a break from work and development this weekend!) .... here is
something to remember in general about mysql authentiction:
Mysql authenticates on 3 things, the login id, the password and the
client host...... so root@localhost and root@'192.%' are two different
users as far as mysql is concerned. The % is a wildcard.
So, the best way (usually) to solve this kind of issue is to ssh into
the same server as your webobjects app is running on, then in the
terminal do:
$mysql -u <webobjectsappuser> -h <hostname> -p<password> <databasename>
........ because that is really what the app is doing. If you can do
the above from command-line on same server as webobjects is running,
then the webobjects app can also connect to mysql with the same
'webobjectsappuser' and 'password'.
Note that there is no space between the 'p' and the '<password>' (that
is how to connect non-interactively without getting a passowrd request
after hitting <return> key.)
Also note that hostname is the hostname of the mysql server.
On Apr 13, 2008, at 8:56 AM, James Cicenia wrote:
Rebooted Myself! LOL (seriously though I had rebooted that darn
server multiple times)
I think I am having two problems...the localhost thing which screwed
with the msyql, which then needed the real ip of the server?!
I still don't like the host command not bringing anything back. ??
On Apr 13, 2008, at 7:47 AM, Miguel Arroz wrote:
Hi!
I told you to reboot... if not the servers, yourself! :)
I guess that creating the mysql user did the trick. I hate MySQL on
that (and on a lot of other stuff), it's a mess to configure.
Still didn't fully understand that localhost thing, but...
Yours
Miguel Arroz
On 2008/04/13, at 13:27, James Cicenia wrote:
Suddenly it works this morning...
????
I don't know why, but it does.
On Apr 13, 2008, at 7:17 AM, James Cicenia wrote:
New information....
So I went to sleep, go up, tried again. This time something
different!
I added a new mysql user with the specfic ip as the server. Then
when
I restarted my WO Server it started.. however, now, it only works
if I
have the IP instead of the domain name in the URL? I think this is
because I am using localhost in the hosts setup. Which brings me
back
to that weird host lookup problem.
James
On Apr 13, 2008, at 5:52 AM, Mr. Pierre Frisch wrote:
James,
Could you have a look into /etc/hostconfig and check the
parameter: HOSTNAME=-AUTOMATIC-
I would also dump the file /etc/resolv.conf
Cheers
Pierre
--
Pierre Frisch
email@hidden
On Apr 12, 2008, at 22:07, James Cicenia wrote:
1) Yes I swear and moved it to a new colo.
2) telnet localhost 3306
Trying ::1...
telnet: connect to address ::1: Connection refused
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
=
5.1.12-beta-log+5h,?9?q,<wckolP,))2\Connection closed by
foreign host.
3) No.
4) I tried all four, localhost, 127.0.0.1, 217.yada, and
mydomain.com
5) again gives me that weird:
Escape character is '^]'.
=
5.1.12-beta-logeXi'"uKV,Na"~yekl\gs*Connection closed by
foreign host.
6) Which error which stack trace?
7) I am using tiger 10.4.11
-j-
On Apr 13, 2008, at 12:01 AM, Mike Schrag wrote:
1) First of all, are you sure you're telling us everything?
Did you ONLY change the IP address ... NOTHING else?
2) If you "telnet localhost 3306", does it connect to MySQL?
3) Did you do anything weird, like turn on IPV6 or something
that might cause possible incompatibilities between things?
4) What exactly is the connection string you're using for your
database from WO? Is it localhost, is it 127.0.0.1, or the
new IP?
5) If it's not localhost, can you "telnet thehostthatitisusing
3306" and does THAT connect?
6) You're including an error message that I've never seen
before, but no stack trace. What is the FULL error WITH stack
trace?
7) Just for grins, try sudo'ing the telnet command as the user
your app is running as (this is a total mojo check, but with
Leopard's crazy new ACL's and sandboxing, you never know what
might be possible).
ms
On Apr 13, 2008, at 12:43 AM, James Cicenia wrote:
Still stumped...
I can't understand it. Everything looks good, my php apps
work, my phpmyadmin works,
but WO won't connect to the database?!
Anybody?
Thanks
On Apr 12, 2008, at 7:56 PM, Mr. Pierre Frisch wrote:
Did you run the command line tool changeip?
For MySQL yo need to check the access rights as they are by
machine i.e. by IP address.
Pierre
--
Pierre Frisch
email@hidden
On Apr 12, 2008, at 16:11, James Cicenia wrote:
My apps start but can't open a connection to the mysql
database.
It is running. I can access it via phpMyAdmin and remotely.
So...
What is hanging up my WebObject Applications?
Did i miss something in the IP change? I am running OS X
Tiger
Server on an Intel dual core XServe.
Thanks
James Cicenia
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden
)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden
)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-
email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-deploy mailing list (email@hidden
)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-deploy mailing list (email@hidden
)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
Miguel Arroz
http://www.terminalapp.net
http://www.ipragma.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
| References: | |
| | >I moved my server, changed ip and now.. (From: James Cicenia <email@hidden>) |
| | >Re: I moved my server, changed ip and now.. (From: "Mr. Pierre Frisch" <email@hidden>) |
| | >Re: I moved my server, changed ip and now.. (From: James Cicenia <email@hidden>) |
| | >Re: I moved my server, changed ip and now.. (From: Mike Schrag <email@hidden>) |
| | >Re: I moved my server, changed ip and now.. (From: James Cicenia <email@hidden>) |
| | >Re: I moved my server, changed ip and now.. (From: "Mr. Pierre Frisch" <email@hidden>) |
| | >Re: I moved my server, changed ip and now.. (From: James Cicenia <email@hidden>) |
| | >Re: I moved my server, changed ip and now.. (From: James Cicenia <email@hidden>) |
| | >Re: I moved my server, changed ip and now.. (From: Miguel Arroz <email@hidden>) |
| | >Re: I moved my server, changed ip and now.. (From: James Cicenia <email@hidden>) |