Keine MySQL verbindung.

11/04/2010 13:46 Ӻluw#1
Hallo.

Letztens hat -Tuniii- auf meinem Server versucht das Api Tool zu fixxen.
(Hat er/sie kp :D aber nich geschafft)

So, immer wenn Ich mich in Navicat einloggen möchte kommt folgendes:
Code:
2003 - Can' t connect to MySQL server "HamachiIP" (10060)
Er/sie hat iwas in VirtualPc eingegeben, kann mich aber nich mehr genau daran erinnern.

cd ... iwas mit rules oderso.

Jetz können sich keine Spieler mehr registrieren.
Is halt ein riesen Problem.^^



mfg
11/04/2010 13:47 2good4you111#2
bestimmt 3306 nicht bei den rules freigegeben xDD

war zu 90% ne ipfw firewall....
Am besten rules über filezilla bearbeiten falls port 22 Frei ist....
11/04/2010 13:50 Ӻluw#3
Quote:
Originally Posted by 2good4you111 View Post
bestimmt 3306 nicht bei den rules freigegeben xDD

war zu 90% ne ipfw firewall....
Am besten rules über filezilla bearbeiten falls port 22 Frei ist....
Ja genau sowas hat er/sie gemacht^^

Kannst du mir vllt. den Pfad zu der Datei sagen?^^
(kenn mich nich aus :D)

EDIT. Habs anders hinbekomm das zu fixxen. Hoffe ich^^
11/04/2010 13:52 2good4you111#4
[Only registered and activated users can see links. Click Here To Register...]
Komplettes tut
11/04/2010 13:55 Ӻluw#5
Quote:
Originally Posted by 2good4you111 View Post
[Only registered and activated users can see links. Click Here To Register...]
Komplettes tut
Ich will meinen Server nich fixxen sondern brauch ich wieder eine MySQL Verbindung.
11/04/2010 13:57 2good4you111#6
mom ich erstell dir kurz eine ipfw.rules
11/04/2010 14:01 2good4you111#7
Code:
IPF="ipfw -q add"
ipfw -q -f flush

#P2P FiXX
$IPF 4 allow all from serverip to any 12001
$IPF 5 allow all from 127.0.0.0/8 to any 12001
$IPF 6 deny all from any to me 12001
$IPF 7 allow all from serverip to any 14000
$IPF 8 allow all from 127.0.0.0/8 to any 14000
$IPF 9 deny all from any to me 14000
$IPF 10 allow all from serverip to any 14001
$IPF 11 allow all from 127.0.0.0/8 to any 14001
$IPF 12 deny all from any to me 14001
$IPF 13 allow all from serverip to any 14002
$IPF 14 allow all from 127.0.0.0/8 to any 14002
$IPF 15 deny all from any to me 14002
$IPF 16 allow all from serverip to any 14003
$IPF 17 allow all from 127.0.0.0/8 to any 14003
$IPF 18 deny all from any to me 14003
$IPF 19 allow all from serverip to any 14004
$IPF 20 allow all from 127.0.0.0/8 to any 14004
$IPF 21 deny all from any to me 14004
$IPF 22 allow all from serverip to any 14061
$IPF 23 allow all from 127.0.0.0/8 to any 14061
$IPF 24 deny all from any to me 14061
$IPF 25 allow all from serverip to any 14099
$IPF 26 allow all from 127.0.0.0/8 to any 14099
$IPF 27 deny all from any to me 14099
$IPF 28 allow all from serverip to any 17000
$IPF 29 allow all from 127.0.0.0/8 to any 17000
$IPF 30 deny all from any to me 17000
$IPF 31 allow all from serverip to any 17001
$IPF 32 allow all from 127.0.0.0/8 to any 17001
$IPF 33 deny all from any to me 17001
$IPF 34 allow all from serverip to any 17002
$IPF 35 allow all from 127.0.0.0/8 to any 17002
$IPF 36 deny all from any to me 17002
$IPF 37 allow all from serverip to any 17003
$IPF 38 allow all from 127.0.0.0/8 to any 17003
$IPF 39 deny all from any to me 17003
$IPF 40 allow all from serverip to any 17004
$IPF 41 allow all from 127.0.0.0/8 to any 17004
$IPF 42 deny all from any to me 17004
$IPF 43 allow all from serverip to any 17061
$IPF 44 allow all from 127.0.0.0/8 to any 17061
$IPF 45 deny all from any to me 17061
$IPF 46 allow all from serverip to any 17099
$IPF 47 allow all from 127.0.0.0/8 to any 17099
$IPF 48 deny all from any to me 17099
$IPF 49 allow all from serverip to any 19000
$IPF 50 allow all from 127.0.0.0/8 to any 19000
$IPF 51 deny all from any to me 19000
$IPF 52 allow all from serverip to any 19001
$IPF 53 allow all from 127.0.0.0/8 to any 19001
$IPF 54 deny all from any to me 19001
$IPF 55 allow all from serverip to any 19002
$IPF 56 allow all from 127.0.0.0/8 to any 19002
$IPF 57 deny all from any to me 19002
$IPF 58 allow all from serverip to any 19003
$IPF 59 allow all from 127.0.0.0/8 to any 19003
$IPF 60 deny all from any to me 19003
$IPF 61 allow all from serverip to any 19004
$IPF 62 allow all from 127.0.0.0/8 to any 19004
$IPF 63 deny all from any to me 19004
$IPF 64 allow all from serverip to any 19061
$IPF 65 allow all from 127.0.0.0/8 to any 19061
$IPF 66 deny all from any to me 19061
$IPF 67 allow all from serverip to any 19099
$IPF 68 allow all from 127.0.0.0/8 to any 19099
$IPF 69 deny all from any to me 19099
$IPF 70 allow all from serverip to any 21000
$IPF 71 allow all from 127.0.0.0/8 to any 21000
$IPF 72 deny all from any to me 21000
$IPF 73 allow all from serverip to any 21001
$IPF 74 allow all from 127.0.0.0/8 to any 21001
$IPF 75 deny all from any to me 21001
$IPF 76 allow all from serverip to any 21002
$IPF 77 allow all from 127.0.0.0/8 to any 21002
$IPF 78 deny all from any to me 21002
$IPF 79 allow all from serverip to any 21003
$IPF 80 allow all from 127.0.0.0/8 to any 21003
$IPF 81 deny all from any to me 21003
$IPF 82 allow all from serverip to any 21004
$IPF 83 allow all from 127.0.0.0/8 to any 21004
$IPF 84 deny all from any to me 21004
$IPF 85 allow all from serverip to any 21061
$IPF 86 allow all from 127.0.0.0/8 to any 21061
$IPF 87 deny all from any to me 21061
$IPF 88 allow all from serverip to any 21099
$IPF 89 allow all from 127.0.0.0/8 to any 21099
$IPF 90 deny all from any to me 21099
$IPF 91 allow all from 127.0.0.0/8 to any 3306
$IPF 92 allow all from any to me 3306

#Standart Regeln

$IPF 10000 allow all from any to any via lo0
$IPF 20000 deny all from any to 127.0.0.0/8
$IPF 30000 deny all from 127.0.0.0/8 to any
$IPF 40000 allow all from any to any
Versuchs mal...
/etc/ipfw.rules
Das in diese datei rein
11/04/2010 14:32 Ӻluw#8
hab mal nachgeschaut.
ich habe da keine datei die ipfw.rules heißt.
muss woanders dran liegen.