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
