som este len mlada lamka :: Something smarter than us is going to emerge


node:	som este len mlada lamka
template:	4
parent:	fedora and Red Hat
owner:	dj-jr
viewed by:
created:	03.07.2013 - 17:34:30

cwbe coordinatez:
101
63540
2799415
7242320

ABSOLUT
KYBERIA

permissions
you:	r,
system:	public
net:	yes

CentOS release 6.4 (Final), MySQL Server version: 5.5.32, Apache/2.2.15, PHP 5.4.16

mysql_connect("localhost",...) - funguje
mysql_connect("domena.sk",...) - nefunguje

vobec neviem (a to uz mam co to googlenia za sebou) co spravit, aby som toto mohol uskutocnit... nieco som nasiel ako /etc/my.cnf ... a bind-address, ale nejako si to neviem dat dokopy... vedel by mi tu niekto poradit, alebo ma aspon nasmerovat ?

dakujem

Linux is like a teepee... No Gates, no Windows, Apache inside...

0000010100063540027994150724232007242329

nemam poruke rh6 ani php ale
skus zo shellu connect na tu mysql instanciu
mysql -h localhost -P 3306 (alebo aky port)
mysql -h domena.sk -P 3306
ak sa to pripoji alebo odmietne kvoli chybajucemu menu/heslu tak s velkou pravdepodobnostou nemas vyriesene granty
tj v mysql
show grants for 'user'@'localhost'
show grants for 'user'@'domena.sk'
pretoze to su dvaja rozlicni useri
mysql -h localhost -P 3306 -u username -p
mysql -h domena.sk -P 3306 -u username -p

000001010006354002799415072423200724232907242337

[root@liaserver dusan]# mysql -h localhost -u test -P 3306 -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 25733
Server version: 5.5.32 MySQL Community Server (GPL) by Remi

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql> q
Bye
[root@liaserver dusan]# mysql -h liaserver.sk -u test -P 3306 -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 'liaserver.sk' (111)

na granty som myslel... este sa opytam, mam vypnute ssh, moze to byt kvoli tomu?

Linux is like a teepee... No Gates, no Windows, Apache inside...

00000101000635400279941507242320072423290724233707242443

to by pisal zlyhanie auth., on sa nevie ani pripojit.
kam ti to resolvuje resp. kde mas nabindovane mysql?

ping liaserver.sk
ip addr
netstat -ntl | grep 3306

0000010100063540027994150724232007242329072423370724244307242591

[root@liaserver dusan]# ping liaserver.sk -c 5
PING liaserver.sk (62.197.207.159) 56(84) bytes of data.
64 bytes from ttxd159.ttx-net.sk (62.197.207.159): icmp_seq=1 ttl=64 time=0.447 ms
64 bytes from ttxd159.ttx-net.sk (62.197.207.159): icmp_seq=2 ttl=64 time=0.631 ms
64 bytes from ttxd159.ttx-net.sk (62.197.207.159): icmp_seq=3 ttl=64 time=0.572 ms
64 bytes from ttxd159.ttx-net.sk (62.197.207.159): icmp_seq=4 ttl=64 time=0.595 ms
64 bytes from ttxd159.ttx-net.sk (62.197.207.159): icmp_seq=5 ttl=64 time=0.599 ms

--- liaserver.sk ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4002ms
rtt min/avg/max/mdev = 0.447/0.568/0.631/0.070 ms

[root@liaserver dusan]# ip addr
1: lo: mtu 16436 qdisc noqueue state UNKNOWN
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eth0: mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether 1c:6f:65:46:fa:34 brd ff:ff:ff:ff:ff:ff
inet 192.168.0.10/24 brd 192.168.0.255 scope global eth0
inet6 fe80::1e6f:65ff:fe46:fa34/64 scope link
valid_lft forever preferred_lft forever

[root@liaserver dusan]# netstat -ntl | grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN

Linux is like a teepee... No Gates, no Windows, Apache inside...

000001010006354002799415072423200724232907242337072424430724259107242605

takze sa snazis pripojit na mysql na stroji 62.197.207.159

a to nie je ten isty ako tvoj localhost/192.168.0.10

00000101000635400279941507242320072423290724233707242443072425910724260507242614

ouch, takze ako som pisal... som este len mlada lamka... apreto som mal bloknuty port na roatri... zahada vyriesena...

Linux is like a teepee... No Gates, no Windows, Apache inside...