I now know for sure it's not a mysql user-permission problem. I have
a working configuration on another server, and when I remove my remote
user permissions from mysql on the old server, I get a different error
("this user does not have permission to...") than the error I get with
the new server ("Failed to connect..."). So here is a summary of
everything I know so far...
I know Mysql is running and listening on port 3306, but it "may" only
be listening locally.
Telnet times out trying to connect on port 3306 to the server Mysql is
on.
In the my.cnf file, "skip-networking" is commented out, and "bind-
address" is removed so Mysql should listen on all interfaces.
I'm confident it's not a mysql user permissions problem since the
error message is different.
I have a firewall rule to allow TCP connections to port 3306.
Mysql version is 5.1.49, included in the OpenbdJam stack.
Any other leads I can check to help narrow down the problem?
On Sep 1, 9:41 am, Matt C <[email protected]> wrote:
> Telnet times out. Does that gaurantee the server itself is refusing
> me (firewall issue), or can that still just be Mysql refusing to talk
> to me?
>
> On Sep 1, 9:18 am, Alex Skinner <[email protected]> wrote:
>
>
>
> > There is a difference between accepting remote connections and your user
> > being able to login remotely.
>
> > Try telnetting to the server remotely e.g. Telnet servername 3306
>
> > If you get a connection you then know it's about setting your user to have
> > remote access privileges.
>
> > A
>
> > On Thursday, 1 September 2011, Matt C <[email protected]> wrote:
> > > This was solved by manually running the commands...
>
> > > # /usr/sbin/groupadd mysql
> > > # /usr/sbin/useradd -r -g mysql mysql
> > > # chown -R mysql .
> > > # chgrp -R mysql .
>
> > > Now OpenBDJam will successfully and fully start up, but I can't access
> > > Mysql from outside localhost. I'm assuming certain options were
> > > defaulted to work like this out of security concerns, but I am trying
> > > to enable outside TCP/IP connections. I've editted the /etc/my.conf
> > > file to include "bind-address = *" and I verified the line that
> > > disables Mysql networking was disabled. I created a passworded user
> > > in Mysql that has access from any host. I added a rule to our
> > > firewall to allow connections to port 3306. Any idea what I might be
> > > missing? One thing that piques my attention is that the following
> > > command...
>
> > > mysqladmin -h `hostname` --port=3306 version
>
> > > results in...
>
> > > Server version 5.1.49
> > > Protocol version 10
> > > Connection localhost.localdomain via TCP/IP
> > > TCP port 3306
> > > Uptime: 15 hours 40 min 19 sec
>
> > > Does "localhost.localdomain" imply that I'm still only accepting local
> > > connections in Mysql?
>
> > > On Aug 31, 10:25 am, Matt C <[email protected]> wrote:
> > >> Sorry to post again so soon. I've now got OpenbdJam installed, but
> > >> when I navigate to the directory and use the command "./openbdjam
> > >> start", I get the following output...
>
> > >> -------------
> > >> MySQL user has not been setup ... doing it now
> > >> /opt/openbdjam/bin/runOnce: line 16: groupadd: command not found
> > >> /opt/openbdjam/bin/runOnce: line 17: useradd: command not found
> > >> chown: `mysql': invalid user
> > >> chgrp: invalid group `mysql'
> > >> chown: `mysql': invalid user
> > >> Starting MySQL5.1...
> > >> Starting Jetty7.1...
> > >> Starting Apache2.2...
> > >> [root@localhost openbdjam]#
> > >> ------------
>
> > >> If I try to start mysql manually by going into its bin directory and
> > >> running "./mysqld start", I get...
>
> > >> -----------
> > >> 110831 10:23:18 [ERROR] Can't find messagefile '/usr/local/mysql/share/
> > >> english/errmsg.sys'
> > >> 110831 10:23:18 [Warning] Can't create test file /usr/local/mysql/data/
> > >> localhost.lower-test
> > >> 110831 10:23:18 [Warning] Can't create test file /usr/local/mysql/data/
> > >> localhost.lower-test
> > >> ./mysqld: Can't change dir to '/usr/local/mysql/data/' (Errcode: 2)
> > >> 110831 10:23:18 [ERROR] Aborting
>
> > >> 110831 10:23:18 [Note]
> > >> -----------
>
> > >> What I suspect might be the problem is that I cannot log in directly
> > >> to our VM as root. I logged in as my user, then su'd. Can anyone
> > >> verify if this is my problem?
>
> > > --
> > > official tag/function reference:http://openbd.org/manual/
> > > mailing list -http://groups.google.com/group/openbd?hl=en
>
> > --
> > Alex Skinner
> > Managing Director
> > Pixl8 Interactive
>
> > Tel: +448452600726
> > Email: [email protected]
> > Web: pixl8.co.uk- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -
--
official tag/function reference: http://openbd.org/manual/
mailing list - http://groups.google.com/group/openbd?hl=en
