+- 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: Ep3 Support (https://lckb.dev/forum/forumdisplay.php?fid=150)
+------ Forum: Solved topics (https://lckb.dev/forum/forumdisplay.php?fid=151)
+------ Thread: mysql problem in LAN (/showthread.php?tid=3019)
Pages:
1
2
- ocnaiblack - 12-23-2013
[I am Italian and use google translate]
Hello my kiamo Samir said: ocnai ....... Today I would like to submit an application on the LAN network (my problem with mysql)?
I recently ep3 not started on debian i3860 with php5/phpmyadmin/mysql-server & client / apache and ......
But now I find myself in lan only see the phpmyadmin site (which, however, fails to connect with mysql).
In fact I must say that if it was not for hamachi could not even play.
The virtual machine has 2 network, a nat, and with only one host (I also tried the bridge, and the inside, but it does not change anything).
Now if you would like to receive the reflections, is that I speak for two days, and I can not stand not to use Navicat and tools.
Can you you tell me if it is a problem of VirtualBox or debian or mysql?
P.S. installed firestarter and stopped.
Note that with hamachi ipv4 the game works, but Navicat and tool no!
- LikeToMove - 12-23-2013
First of all you MUST learn some linux basics (and mysql tuts too).
Anyway, if Im not wrong you have a problem to connect to your MySQL db over the nat..
First step: install nmap on your machine using apt-get install nmap
Start your mysqld daemon
Check if mysqld is trying to listen on your net (lo, eth0, eth1):
type as root the command ifconfig
read and copy yout eth ip
type nmap 127.0.0.1 and nmap 192.168.[CeNsOrEd].[CeNsOrEd]
If you see your listening mysqld port (3306) you need just to add wildcard % to your mysql users hosts. (If you dont understand what Im speaking for try with Google)
Good luck
- ocnaiblack - 12-23-2013
I completely understand (thanks to google), and I thank you again for your good will.
21:00 But I will try when I get a free table.
My house is not big, Im sorry that I can not give an immediate answer.
Edit: however from phpmyadmin I created a user Light with password 1 and all the privileges, but does not work.
- ocnaiblack - 12-23-2013
vrey thx for %, resolved!!!!!!!!!!!!!!!!!!!! very thx; tool and navicat correctly connection in lan; but with the game does not start!!!!
not with ipv4 eth0: 192.168.56.101.
but, with hamachi yes.
EDIT: all port are open!!! tested with nmap (nmap 127.0.0.1 and nmap 192.168.56.101).
EDIT2: I have to communicate id and password in the file mysql sl.dta? how can I?
- LikeToMove - 12-24-2013
If you want to use your eth IP as your server game IP you must edit your GameServer and LoginServer config files correctly.
GameServer:
[Server]
Number=1
SubNumber=1
IP=192.168.56.101
Port=4101
AllowExternalIP=TRUE
and LoginServer:
[Server]
No=1
IP=192.168.56.101
Port=4001
AllowExternalIP=TRUE
Your sl.dta must be this:
test 192.168.56.101 4001
For the game trouble you need to detect the problem during daemon starts by typing this:
./StarterGameServer_1.sh start
./StarterGameServer_1.sh console
Dont forgot to press Like button if my post helps you
- ocnaiblack - 12-24-2013
I feel ok
does not work, even though I had everything set up before.
Now I try to find these 2 files:
./StarterGameServer_1.sh start
./StarterGameServer_1.sh console
found:
./StarterGameServer_1.sh
I can not find:
./StarterGameServer_1.sh start
./StarterGameServer_1.sh console
- LikeToMove - 12-24-2013
found:
./StarterGameServer_1.sh
I can not find:
./StarterGameServer_1.sh start
./StarterGameServer_1.sh console
Its the same file, all *.sh files are scripts. You can use these files giving more commands like start, stop, console, status at the end.
- ocnaiblack - 12-24-2013
ok I understand, now I try to use it to my advantage
- ocnaiblack - 12-24-2013
unfortunately I can not find the solution, the client does not connect with local IP, that IP editor should I use?
unfortunately I can not find the link.
Note: the client connecct corretly only with hamachi
Note2: Ive download checkToll of ep2 ma the game dont work (lan)
- ocnaiblack - 12-24-2013
root@debian:/home/light# nmap 10.0.2.15
Starting Nmap 6.00 ( 2 ) at 2013-12-24 23:23 CET
Nmap scan report for 10.0.2.15
Host is up (0.0000080s latency).
Not shown: 996 closed ports
PORT STATE SERVICE
22/tcp open ssh
80/tcp open http
111/tcp open rpcbind
3306/tcp open mysql
Nmap done: 1 IP address (1 host up) scanned in 0.30 seconds
root@debian:/home/light# nmap 192.168.56.101
Starting Nmap 6.00 ( 2 ) at 2013-12-24 23:25 CET
Nmap scan report for 192.168.56.101
Host is up (0.000021s latency).
Not shown: 995 closed ports
PORT STATE SERVICE
22/tcp open ssh
80/tcp open http
111/tcp open rpcbind
3306/tcp open mysql
4001/tcp open newoak
Nmap done: 1 IP address (1 host up) scanned in 0.20 seconds
root@debian:/home/light# nmap 25.131.96.211
Starting Nmap 6.00 ( 2 ) at 2013-12-24 23:26 CET
Nmap scan report for 25.131.96.211
Host is up (0.000010s latency).
Not shown: 996 closed ports
PORT STATE SERVICE
22/tcp open ssh
80/tcp open http
111/tcp open rpcbind
3306/tcp open mysql
Nmap done: 1 IP address (1 host up) scanned in 0.20 seconds
PORT 4101 IS CLOSED!!!!!!!!!!!!!!!!!!!
HOWEVER I HAVE DISABLED FIREWALL
root@debian:/home/light# nmap sS 192.168.56.101 -p4101
Starting Nmap 6.00 ( 2 ) at 2013-12-24 23:49 CET
Failed to resolve given hostname/IP: sS. Note that you cant use /mask AND 1-4,7,100- style IP ranges. If the machine only has an IPv6 address, add the Nmap -6 flag to scan that.
Nmap scan report for 192.168.56.101
Host is up (0.00014s latency).
PORT STATE SERVICE
4101/tcp closed brlp-0
NOW PORT OPEN!!!! BUT GAME NOT WORK (CONNECT)
NOTE: windows firewall is disabled