Ctitire din Navicat

Totalitatea subiectelor care nu respectă regulamentul impus in sectiunea "Probleme şi Întrebări" vor fi stocate aici.
Închis
Avatar utilizator
sevastian25
Nivel 3

Nivel 3
Mesaje: 360
Membru din: 24 Aug 2014, 22:52
Server: Metin2
Regat: Jinno
Aprecieri: 24  
Mulţumiri: 57  
Medalii

Salutari Just4Metin

Deci in legatura cu topicu facut de mine, am rezolvat cu implementarea liburi etc.
In DB (/usr/home/game/channels/g1/db) am un fisier "CONF.TXT" care contine:

Cod: Selectaţi tot

WELCOME_MSG = "DB Server has been started"

SQL_ONEX = 0

SQL_ACCOUNT = "localhost account ezio DevelopersEzio 0"
SQL_PLAYER = "localhost player ezio DevelopersEzio 0"
SQL_COMMON = "localhost common ezio DevelopersEzio 0"
SQL_HOTBACKUP = "localhost hotbackup ezio DevelopersEzio 0"

TABLE_POSTFIX = "	"

BIND_PORT               = 21000
DB_SLEEP_MSEC           = 10
CLIENT_HEART_FPS        = 10
HASH_PLAYER_LIFE_SEC    = 600
BACKUP_LIMIT_SEC        = 3600
PLAYER_ID_START = 100
PLAYER_DELETE_LEVEL_LIMIT = 105
PLAYER_DELETE_CHECK_SIMPLE = 1
ITEM_ID_RANGE = 2000000000 2100000000
MIN_LENGTH_OF_SOCIAL_ID	= 6
SIMPLE_SOCIALID = 1
Odata ce Modific "SQL_ONEX = 0" in "SQL_ONEX = 1" serverul imi citeste din navicat, adica nu mai citeste fisierele .txt ci pe alea .sql din navicat.

Uite asa imi arata cand serverul incepe sa citeasca din navicat
http://postimg.org/image/5ofu9cdpn/

Dar dupa ce se incarca serverul si porneste complet imi arata asa si imi da Erroare Connectare La Server.
http://postimg.org/image/c4oszfm97/

Asa imi arata cand serverul citeste data de baze TXT
http://postimg.org/image/aodahajcb/

Iar dupa ce serverul porneste complete cu data de baze TXT imi arata asa si ma pot conecta la server fara probleme.
http://postimg.org/image/tj917pje3/

Uitat si fisierul start.sh

Cod: Selectaţi tot

#!/bin/sh
echo -e "\033[36m ServerFile r40k by Adelin\033[0m"
echo -e "\033[36m Skype: Adelin.sarb& facebook.com/Adelin.sarb\033[0m"

echo -e "\033[32m  
1 - (1) Pornesc Toate CH(auth)- nu se foloseste \n
2 - (2) Pornesc CH1 \n
3 - (3) Pornesc CH1 si Ch2 \n
4 - (4) Pornesc Toate CH ( 6 ) \n 
5 - (5) Anuleaza Actiunea! \033[0m"

read chs

case $chs in 
1*) 

	echo -e "\033[31m \n PORNESC LOGINU ..\033[0m"
	cd /usr/home/game/channels/channel1/ch1_1 && sh auth.sh &
	sleep 3
	cd /usr/home/game/channels/channel2/ch2_1 && sh auth.sh &
	sleep 3
	cd /usr/home/game/channels/channel3/ch3_1 && sh auth.sh &
	sleep 3
	cd /usr/home/game/channels/channel4/ch4_1 && sh auth.sh &
	sleep 3
	cd /usr/home/game/channels/channel5/ch5_1 && sh auth.sh &
	sleep 3
	cd /usr/home/game/channels/channel6/ch6_1 && sh auth.sh &
	sleep 3
	cd /usr/home/game/channels/channel1/ch1_2 && sh auth.sh &
	sleep 3
	cd /usr/home/game/channels/channel2/ch2_2 && sh auth.sh &
	sleep 3
	cd /usr/home/game/channels/channel3/ch3_2 && sh auth.sh &
	sleep 3
	cd /usr/home/game/channels/channel4/ch4_2 && sh auth.sh &
	sleep 3
	cd /usr/home/game/channels/channel5/ch5_2 && sh auth.sh &
	sleep 3
	cd /usr/home/game/channels/channel6/ch6_2 && sh auth.sh &
	sleep 3
	cd /usr/home/game/channels/channel1/ch1_3 && sh auth.sh &
	sleep 3
	cd /usr/home/game/channels/channel2/ch2_3 && sh auth.sh &
	sleep 3
	cd /usr/home/game/channels/channel3/ch3_3 && sh auth.sh &
	sleep 3
	cd /usr/home/game/channels/channel4/ch4_3 && sh auth.sh &
	sleep 3
	cd /usr/home/game/channels/channel5/ch5_3 && sh auth.sh &
	sleep 3
	cd /usr/home/game/channels/channel6/ch6_3 && sh auth.sh &
	sleep 3
	cd /usr/home/game/channels/channel1/ch1_4 && sh auth.sh &
	sleep 3
	cd /usr/home/game/channels/g1/auth && sh auth.sh &
	sleep 3
	echo -e "\033[36m ServerFile r40k pus .tar.gz de catre Adelin aka macu4u\033[0m"
	echo -e "\033[36m de pe Adelin.ro\033[0m"
	echo -e "\033[36m Skype: Adelin.sarb& facebook.com/Adelin.sarb\033[0m"
;;
2*)

	echo -e "\033[31m PORNESC BAZA DE DATE ..\033[0m"
	cd /usr/home/game/channels/g1/db
	rm -rf syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt 
	./db &
	sleep 5
	clear
	echo -e "\033[31m \n PORNESC LOGINU ..\033[0m"
	cd /usr/home/game/channels/g1/auth/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./auth &
	sleep 3
	clear
	echo -e "\033[31m \n PORNESC CHANNEL1_3CORE ..\033[0m"
	cd /usr/home/game/channels/channel1/ch1_1/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	cd /usr/home/game/channels/channel1/ch1_2/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	cd /usr/home/game/channels/channel1/ch1_3/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	clear
	cd /usr/home/game/channels/channel1/ch1_4/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	clear
	cd /usr/home/game/channels/channel1/ch1_5/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	clear
	echo -e "\033[31m \n PORNESC CHANNEL99 ..\033[0m"	
	cd /usr/home/game/channels/game99/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	clear
	echo -e "\033[36m ServerFile r40k pus .tar.gz de catre Adelin aka macu4u\033[0m"
	echo -e "\033[36m de pe Adelin.ro\033[0m"
	echo -e "\033[36m Skype: Adelin.sarb& facebook.com/Adelin.sarb\033[0m"
;;
3*)
	
	echo -e "\033[31m PORNESC BAZA DE DATE ..\033[0m"
	cd /usr/home/game/channels/g1/db
	rm -rf syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt 
	./db &
	sleep 5
	clear
	echo -e "\033[31m \n PORNESC LOGINU ..\033[0m"
	cd /usr/home/game/channels/g1/auth/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./auth &
	sleep 3
	clear
	echo -e "\033[31m \n PORNESC CHANNEL1_5CORE ..\033[0m"
	cd /usr/home/game/channels/channel1/ch1_1/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	cd /usr/home/game/channels/channel1/ch1_2/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	cd /usr/home/game/channels/channel1/ch1_3/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	clear
	cd /usr/home/game/channels/channel1/ch1_4/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	clear
	cd /usr/home/game/channels/channel1/ch1_5/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	clear
	echo -e "\033[31m \n PORNESC CHANNEL99 ..\033[0m"	
	cd /usr/home/game/channels/game99/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	echo -e "\033[31m \n PORNESC CHANNEL2_3CORE ..\033[0m"
	cd /usr/home/game/channels/channel2/ch2_1/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	cd /usr/home/game/channels/channel2/ch2_2/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	cd /usr/home/game/channels/channel2/ch2_3/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	clear
	echo -e "\033[36m ServerFile r40k pus .tar.gz de catre Adelin aka macu4u\033[0m"
	echo -e "\033[36m de pe Adelin.ro\033[0m"
	echo -e "\033[36m Skype: Adelin.sarb& facebook.com/Adelin.sarb\033[0m"
;;
4*)

	echo -e "\033[31m PORNESC BAZA DE DATE ..\033[0m"
	cd /usr/home/game/channels/g1/db
	rm -rf syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./db &
	sleep 5
	clear
	echo -e "\033[31m \n PORNESC LOGINU ..\033[0m"
	cd /usr/home/game/channels/g1/auth/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./auth &
	sleep 3
	clear
	echo -e "\033[31m \n PORNESC CHANNEL1_3CORE ..\033[0m"
	cd /usr/home/game/channels/channel1/ch1_1/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	cd /usr/home/game/channels/channel1/ch1_2/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	cd /usr/home/game/channels/channel1/ch1_3/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	cd /usr/home/game/channels/channel1/ch1_4/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	cd /usr/home/game/channels/channel1/ch1_5/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	echo -e "\033[31m \n PORNESC CHANNEL2_3CORE...\033[0m"
	cd /usr/home/game/channels/channel2/ch2_1/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	cd /usr/home/game/channels/channel2/ch2_2/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	cd /usr/home/game/channels/channel2/ch2_3/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	echo -e "\033[31m \n PORNESC CHANNEL3_3CORE...\033[0m"
	cd /usr/home/game/channels/channel3/ch3_1/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	cd /usr/home/game/channels/channel3/ch3_2/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	cd /usr/home/game/channels/channel3/ch3_3/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	echo -e "\033[31m \n PORNESC CHANNEL4_3CORE...\033[0m"
	cd /usr/home/game/channels/channel4/ch4_1/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	cd /usr/home/game/channels/channel4/ch4_2/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	cd /usr/home/game/channels/channel4/ch4_3/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	echo -e "\033[31m \n PORNESC CHANNEL5_3CORE ..\033[0m"
	cd /usr/home/game/channels/channel5/ch5_1/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	cd /usr/home/game/channels/channel5/ch5_2/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	cd /usr/home/game/channels/channel5/ch5_3/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	echo -e "\033[31m \n PORNESC CHANNEL6_3CORE ..\033[0m"
	cd /usr/home/game/channels/channel6/ch6_1/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	cd /usr/home/game/channels/channel6/ch6_2/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	cd /usr/home/game/channels/channel6/ch6_3/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	echo -e "\033[31m \n PORNESC CHANNEL99_3CORE ..\033[0m" 
	cd /usr/home/game/channels/game99/
	rm -rf game.core syserr syslog udp_packet_info.txt stdout pid packet_info.txt p2p_packet_info.txt
	./game &
	sleep 3
	clear
	echo -e "\033[36m ServerFile r40k pus .tar.gz de catre Respect aka adelin.sarb\033[0m"
	echo -e "\033[36m de pe adelin.sarb\033[0m"
	echo -e "\033[36m Skype: adelin.sarb & facebook.com/adelin.sarb\033[0m"
;;
5*)
	clear
	echo -e "\033[32m \n Actiune Anulata!\033[0m"
;;
esac
Daca aveti vreo idee ce are si ce as putea sa fac ca serverul sa citeasca din Navicat (SQL) si sa ma pot conecta cu success la server va rog ajutatima chiar nu pot sai dau de cap de unul singur X_X.
Sus
Avatar utilizator
sevastian25
Nivel 3

Nivel 3
Mesaje: 360
Membru din: 24 Aug 2014, 22:52
Server: Metin2
Regat: Jinno
Aprecieri: 24  
Mulţumiri: 57  
Medalii

up
Sus
Avatar utilizator
[OwN]Catalin
Nivel 2

Nivel 2
Mesaje: 235
Membru din: 03 Oct 2015, 09:16
Server: Metin2 Cronos
Regat: Jinno
Aprecieri: 73  
Mulţumiri: 108  
 Contact:
Vezi detalii
Medalii

Pare sa fie bine verifica încă o data de la cap la coadă sa vezi daca ai facut ceva gresit

[ Mesaj scris via Android ] Imagine
Sunt aici sa va ajut si pe voi, cum si eu am fost sis sunt ajutat
Nu te uita :) Imagine
Imagine
Afișează semnătura
Sus
Avatar utilizator
B.Eduard
Video Artist

Video Artist
Mesaje: 7548
Membru din: 08 Aug 2013, 10:42
Regat: Jinno
Aprecieri: 280  
Mulţumiri: 1145  
 Contact:
Vezi detalii
Medalii

Dacă în 3 zile autorul subiectului nu va da niciun semn de viata în topic, subiectul va fi mutat în Arhivă Probleme şi Întrebări.
Afișează semnătura
Sus
Închis
Navicat 12.1.27 (ultima versiune de navicat 12) cu keygen
Răspunsuri
2 Vizualizări
1125
Citește mai mult
navicat
Răspunsuri
7 Vizualizări
590
Citește mai mult
Bug navicat
Răspunsuri
7 Vizualizări
712
Citește mai mult
Navicat
Răspunsuri
0 Vizualizări
110
Citește mai mult

Înapoi la “Arhivă Probleme şi Întrebări”

  • Informaţie

  • Cine este conectat

    Utilizatori ce ce navighează pe acest forum: Niciun utilizator înregistrat și 65 vizitatori

+ Anunțul tău aici + Anunțul tău aici + Anunțul tău aici + Anunțul tău aici