Was able to install Interworx and login. Then for the acid test, I rebooted the server. Now Nodeworx will not come up. The page is the standard “Unable to connect”. Any ideas?
Just checked my email and now I’m getting spammed with the following message.
Uncaught IWorx_Exception_DbUtil: DB Error: connect failed [nativecode=Can’t connect to local MySQL server through socket ‘/usr/local/interworx/mysql/iworx-db.sock’ (2)] ** mysql://iworx:fjt8wn1lkj@unix(/usr/local/interworx/mysql/iworx-db.sock)/iworx
A system error has occurred. Please try your request again in a few minutes.
If the error persists, please contact support.
Sorry, I can do things, but I’m not swift like you guys!
Yes, I read it and it didn’t look like his errors were the same as mine. MariaDB was running, but I restarted it and still the same result. Part of the iworx.log is below. I’d run cvspermsfix.pex if I knew how. I have performed a search when I had a chance, but haven’t found anything to help me yet. The logs below look different than Ramon’s, but maybe I’m wrong.
I think this should help you, as your error is db connect failure.
Many thanks
John
B]MySQL/MariaDB didn’t want to start, seems it can’t read the /etc/my.cnf.d directory, so uncommented it in /etc/my.cnf, because there is no configuration in these files:[/B]
#!includedir /etc/my.cnf.d
Restart and status is OK now:
# systemctl restart mariadb.service
# systemctl status mariadb.service
mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled)
Active: active (running) since Tue 2015-03-31 21:05:48 CEST; 7s ago
Process: 20772 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
Process: 20742 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Main PID: 20771 (mysqld_safe)
CGroup: /system.slice/mariadb.service
??20771 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
??21071 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-fi...
Don’t be sorry, I appreciate all the help I can get. I apologize for not knowing more as to what is going on.
B
From what I can gather, he restarted the database. I’ve already tried that serveral times. I too did status request, and it looked good and was running. But I did it again as you can see below.
[root@bum314 bum]# systemctl status mariadb.service
mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled)
Active: active (running) since Fri 2015-04-17 15:46:41 CDT; 1min 13s ago
Process: 3202 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
Process: 3171 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Main PID: 3201 (mysqld_safe)
CGroup: /system.slice/mariadb.service
├─3201 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
└─3357 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-fi…
Apr 17 15:46:39 bum314.bummer-inc.com mysqld_safe[3201]: 150417 15:46:39 mysqld_safe Logging to ‘/var/log/mariadb/mariadb.log’.
Apr 17 15:46:39 bum314.bummer-inc.com mysqld_safe[3201]: 150417 15:46:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Apr 17 15:46:41 bum314.bummer-inc.com systemd[1]: Started MariaDB database server.
No, you’re reading correctly. I never had a problem with mariadb. But I still can not login to Nodeworx and am getting the following all the time via email.
Uncaught IWorx_Exception_DbUtil: DB Error: connect failed [nativecode=Can’t connect to local MySQL server through socket ‘/usr/local/interworx/mysql/iworx-db.sock’ (2)] ** mysql://iworx:fjt8wn1lkj@unix(/usr/local/interworx/mysql/iworx-db.sock)/iworx
A system error has occurred. Please try your request again in a few minutes.
If the error persists, please contact support.
I just don’t know what to do to correct it. I know it has to be easy, but I don’t know where to look or what to do.
Many thanks, I think you just need to run cvspemfix.pex (sorry may have mistyped) from ramond post, by ssh into server, cd /~iworx, cvspemfix.pex. There’s probably man cvspemfix as well for info, although I could be wrong sorry. Lastly, it maybe in a folder called scripts.
Well, I tried! It took a little while to execute, so I thought this was it. But, it wasn’t. Nothing has changed. I know I ididn’t have to, but just to be sure, I rebooted the server.
Did you comment out from my.cnf the MySQL folder not containing anything. You’ll need to read through ramond post and then restart databases, then I would rerun the pex file again.
If this still does not work, can you post your log showing error, sorry even if it is the same error
I’ll go back and try to duplicate exactly what Ramond did. I have other Interworx contol panels that I use. This was 2 week demo given to me by sales to play with. My time is almost up! But, this is a dedicated server, so if I mess anything up, there3 is not loss other than having to re-install. I want to test and work with this.
ERROR: /usr/local/interworx/include/IWorxDbUtil.php(96): Uncaught IWorx_Exception_DbUtil: DB Error: connect failed [nativecode=Can’t connect to local MySQL server through socket ‘/usr/local/interworx/mysql/iworx-db.sock’ (2)] ** mysql://i$
Yes, I always get the messy ones. It was fine until the reboot. As you can see below, the database is running. It always has been running, never had a problem with that (that I know of). I think it’s looking in the wrong place, but I don’t know thqat much like you guys do.
[root@bum314 bum]# systemctl status mariadb.service
mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled)
Active: active (running) since Mon 2015-04-20 15:04:07 CDT; 1 day 2h ago
Process: 2136 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
Process: 1423 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Main PID: 2135 (mysqld_safe)
CGroup: /system.slice/mariadb.service
├─2135 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
└─2352 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock
Apr 20 15:04:05 bum314.bummer-inc.com mysqld_safe[2135]: 150420 15:04:05 mysqld_safe Logging to ‘/var/log/mariadb/mariadb.log’.
Apr 20 15:04:05 bum314.bummer-inc.com mysqld_safe[2135]: 150420 15:04:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Apr 20 15:04:07 bum314.bummer-inc.com systemd[1]: Started MariaDB database server.
I am hopig they’ll extend the the demo longer. It’s good for them and me. I’m not putting anything on it, it’s for testing and such. Plus, I do own other Interworx control panels. I’m going to build another box, but I want to put CentOS 7 on it from the start.
If you have any questions, please let me know. Like I said, I’ll find the strange stuff and I don’t even look for it!
But, this is a dedicated server, so if I mess anything up, there3 is not loss other than having to re-install. I want to test and work with this.