+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep2 Support (https://lckb.dev/forum/forumdisplay.php?fid=166)
+------ Forum: Solved Topics (https://lckb.dev/forum/forumdisplay.php?fid=144)
+------ Thread: libmysqlclient error (/showthread.php?tid=2078)
- Sutz - 06-25-2013
I found a release of the libs in the ep2 release.
I had already done the yum update
still no mysql connection from lc server but is working with mysql -h ip -u username -p
2
wtf..............
- CyberClaus - 06-25-2013
Do something for me, in terminal put : ifconfig
now tell me if the loopback connection is set as 127.0.0.1
and another thing, its a physical machine or a VM?
- Sutz - 06-25-2013
yea my loopback is 127.0.0.1
I forgot to say, my mysql server is on a spare pc on my home network on 192.168.1.155
Vbox is on my laptop running under 192.168.1.157 an my laptop is 192.168.1.150
Vbox & my laptop can connect to mysql on 192.168.1.155 in Windows navi & linux mysql client
but the lc server fails connection.
LC server & lunix mysql client are on the same vbox image
if one can connect the other should also but it dont.I have now changed the login username to root without password an still not working but the other two work fine still.
- CyberClaus - 06-25-2013
ok, you have something closing the connection/port
Did you disabled iptables and tested?
Also, your configuracion is set correctly?
And another thing, the configuration of the mysql is done correctly?
- Sutz - 06-25-2013
[Server]
Number=1
IP=192.168.1.157
Port=50483
UserPort=4102
MAXSIZE=1000
[Char DB]
IP=192.168.1.155
DBName=ep2_db
User=root
Password=
[Post DB]
IP=192.168.1.155
DBName=ep2_post
User=root
Password=
How do i turn off iptables, Im quite the n00b when it comes to linux xD
- CyberClaus - 06-25-2013
ahhhhhhhhhhhhhhhhhhhhhhhhhhhhh!!!! i know whats wrong XD
tell me something, this test server you building, is for your own use or you will put it live?
- CyberClaus - 06-25-2013
to disable iptables you issue the following commands : service iptables stop
BUT, do this if you not putting it live
- Sutz - 06-25-2013
yep its just a local test server for me to mess with, totally local setup
ty for the command will test now.
- CyberClaus - 06-25-2013
if even that way doesnt work, then you need to give permissions to the root user
- Sutz - 06-25-2013
nope it didnt work.
if even that way doesnt work, then you need to give permissions to the root user
But doing this connects an i can see my databases from the same vbox lc server is on:
mysql -h 192.168.1.155 -u root