DNS
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsSystem AdministrationDNS

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old December 17th, 2003, 10:23 AM
ads ads is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2001
Location: India
Posts: 192 ads User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 12 m 27 sec
Reputation Power: 7
reverse DNS problem

Hi,
I have setup DNS www.networkshastrihall.com, IP address "202-63-167-192". dig www.networkshastrihall.com works fine.

I have created mysql user as follows :
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON bankaccount.* TO ads123@'www.networkshastrihall.com' IDENTIFIED BY 'xxxxx';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

I want to connect to mysql database as user ads123 as follows :

[root@allweb root]# mysql -h www.networkshastrihall.com -u ads123 -p bankaccount
Enter password:
ERROR 1130: Host '202-63-167-192.exatt.com' is not allowed to connect to this MySQL server.

It seems reverse DNS gives '202-63-167-192.exatt.com' instead 'www.networkshastrihall.com'

I am told it is due to reverse DNS problem. DNS is broken.
I am totally new to reverse DNS concept and I don't know why it is required.
Guide me why reverse DNS required and to solve problem.

Thanks

Reply With Quote
  #2  
Old December 17th, 2003, 11:08 AM
ads ads is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2001
Location: India
Posts: 192 ads User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 12 m 27 sec
Reputation Power: 7
I checked follows :

[root@shastrihallweb root]# host 202.63.167.192
192.167.63.202.in-addr.arpa domain name pointer 202-63-167-192.exatt.com.

It should point to www.networkshastrihall.com.

Help appreciated.
Thanks

Reply With Quote
  #3  
Old December 17th, 2003, 07:39 PM
freebsd freebsd is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jan 2001
Posts: 5 freebsd User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Quote:
It should point to www.networkshastrihall.com
Just because you brought networkshastrihall.com doesn't imply the IP you point your domain to belong to you. If whatever IP you point your own domain to become your own property then everyone on earth can own a hundred of IPs.
When you don't own that IP, you can't control what name it points to. Over 99% of people misinterpreted reverse DNS and blindly believe that you point your domain to a particular IP, then that IP will point back to your domain automatically, that's never true. If you want reverse DNS to work, ask exatt.com to change their existing PTR record to your domain, but I don't think they'd do it even if you are willing to pay them $1000. If you really want reverse DNS to work, go for SpeakEasy.net.

Reply With Quote
  #4  
Old December 17th, 2003, 09:03 PM
ads ads is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2001
Location: India
Posts: 192 ads User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 12 m 27 sec
Reputation Power: 7
I am trying to setup network having
1) Linux server running IPTABLES firewall, squid, dns server.
2) DMZ having apache, mysql and php, mail server.

User will use script from remote host to connect mysql as follows:

MYSQL_CONNECT("localhost", "abc", "abc" ) OR DIE("Unable to connect to database");
@mysql_select_db("abc") or die("Unable to select database");

where local host will be dmz.

Is it O.K. if I give all user give host as "localhost" in script?
Will it invilve any security problem?
If so what is generally done in this type of case.
Thanks for support.

Reply With Quote
  #5  
Old December 17th, 2003, 09:45 PM
freebsd freebsd is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jan 2001
Posts: 5 freebsd User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Sorry, off topic.

Reply With Quote
Reply

Viewing: Dev Shed ForumsSystem AdministrationDNS > reverse DNS problem


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway