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 - -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
