+ Post New Thread
Results 1 to 8 of 8
Web Development Thread, School Website - Very Strange Problem in Coding and Web Development; Hi Very strange problem hope someone can point me in the right direction. School website hosted externally. Everything to do ...
  1. #1

    Join Date
    Oct 2007
    Location
    scotland
    Posts
    45
    Thank Post
    15
    Thanked 1 Time in 1 Post
    Rep Power
    0

    School Website - Very Strange Problem

    Hi

    Very strange problem hope someone can point me in the right direction.

    School website hosted externally. Everything to do with the website works fine when browsed to from any computer external to the school network.

    The problem occurs when anyone browses to the website via an internal school pc.

    This error occurs:
    Connection to the database failed. Please try again later.

    PHP Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in d:\domains\wellingtonschool.org\wwwroot\functions. php on line 9

    It only appears when accessing a php page, which just happens to be the most important pages! Browsing to any standard .htm pages no problem, page displays as normal. I cant login to the site to update the news sections as i get this error. Only started happening from tuesday this week.

    I have tried this on IE 6, IE7 and IE8, and firefox same exact error on each.

    Browsing to one of the php pages from an external pc works perfectly.

    Any pointers?
    No local cached copy on the web filter - smoothie.
    Bypassing web filter same problem.
    Hosting company nothing wrong they say - company that developed website no help they see it working fine from their end, so something local to the school? our isp? dunno..

    mods move this to another forum if its in the wrong one.

    thanks
    miller

  2. #2
    budgester's Avatar
    Join Date
    Jan 2006
    Location
    Enfield, Middlesex
    Posts
    486
    Thank Post
    4
    Thanked 37 Times in 30 Posts
    Rep Power
    24
    Quote Originally Posted by gmiller View Post
    Hi

    Very strange problem hope someone can point me in the right direction.

    School website hosted externally. Everything to do with the website works fine when browsed to from any computer external to the school network.

    The problem occurs when anyone browses to the website via an internal school pc.

    This error occurs:
    Connection to the database failed. Please try again later.

    PHP Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in d:\domains\wellingtonschool.org\wwwroot\functions. php on line 9

    It only appears when accessing a php page, which just happens to be the most important pages! Browsing to any standard .htm pages no problem, page displays as normal. I cant login to the site to update the news sections as i get this error. Only started happening from tuesday this week.

    I have tried this on IE 6, IE7 and IE8, and firefox same exact error on each.

    Browsing to one of the php pages from an external pc works perfectly.

    Any pointers?
    No local cached copy on the web filter - smoothie.
    Bypassing web filter same problem.
    Hosting company nothing wrong they say - company that developed website no help they see it working fine from their end, so something local to the school? our isp? dunno..

    mods move this to another forum if its in the wrong one.

    thanks
    miller
    Are they using a particular PHP package ? Drupal, Wordpress ?

    MYSQL and PHP on a windows server with IIS ? Thats a recipe for a PITA to start with.

  3. Thanks to budgester from:

    Oops_my_bad (28th April 2009)

  4. #3

    Join Date
    Oct 2007
    Location
    scotland
    Posts
    45
    Thank Post
    15
    Thanked 1 Time in 1 Post
    Rep Power
    0
    The info i can see from the helm control system is php version 4, asp.net version 1 and mysql4.

    Not sure what its running on, i can find out if need be.
    Thanks
    miller

  5. #4
    mossj's Avatar
    Join Date
    Dec 2008
    Location
    Leicester
    Posts
    1,466
    Thank Post
    157
    Thanked 189 Times in 174 Posts
    Rep Power
    52
    Can you connect to the mysql db using a different program i.e "navicat lite" from a pc that has the problems? can you not change localhost to something nicer as I think thats where your problem lies (could be wrong...) i.e fully qullified

  6. #5

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,839
    Thank Post
    876
    Thanked 1,678 Times in 1,459 Posts
    Blog Entries
    12
    Rep Power
    444
    It might be a DNS problem as you can access it externally. What is the DNS setup like?

  7. #6
    Marci's Avatar
    Join Date
    Jun 2008
    Location
    Wakefield, West Yorkshire
    Posts
    888
    Thank Post
    84
    Thanked 234 Times in 193 Posts
    Rep Power
    82
    'localhost' simply means that the SQL Server is running locally on that machine... pointless changing it to anything else - it should work fine. Need to see the content of d:\domains\wellingtonschool.org\wwwroot\functions. php basically. If it has security details contained (ie: user & pass) than pm it to me and I'll take a look. If it hasn't, then post it in here in code tags...

    t only appears when accessing a php page, which just happens to be the most important pages! Browsing to any standard .htm pages no problem, page displays as normal.
    Standard HTM files don't have dynamic content pulled from a database, so don't try to contact the database, and thus don't get a connection error. PHP pages generally will involve dynamic content pulled from the database, and thus generate the errors.

    We've had issues with LEA proxies causing such issues in the past...

  8. #7

    Join Date
    Apr 2006
    Posts
    388
    Thank Post
    23
    Thanked 95 Times in 61 Posts
    Rep Power
    44
    Are you *sure* you're not pointing to two different servers?

    If you ping the server from inside the school, do you get the same results as if you ping it from outside?

  9. #8

    Join Date
    Oct 2007
    Location
    scotland
    Posts
    45
    Thank Post
    15
    Thanked 1 Time in 1 Post
    Rep Power
    0

    sorry..

    apologies for not updating this thread sooner and for not replying to those who posted i got caught up.

    the problem is resolved now. the problem was a dns issue, the isp changed the ip address of the website and did not notify me. internally there was a dns entry for the school website pointing to the now old address and theres the problem..

    thanks for the help tho appreciate it.
    miller

SHARE:
+ Post New Thread

Similar Threads

  1. Strange Excel Problem
    By Jon in forum Windows
    Replies: 14
    Last Post: 14th July 2011, 04:55 PM
  2. Got a strange problem here..
    By denon101 in forum Windows
    Replies: 6
    Last Post: 1st February 2011, 01:35 PM
  3. Strange internet problem
    By Frazer in forum Internet Related/Filtering/Firewall
    Replies: 3
    Last Post: 4th March 2009, 12:57 PM
  4. Strange AD Problem
    By Michael in forum Windows
    Replies: 3
    Last Post: 25th February 2008, 02:05 PM
  5. Very strange problem...
    By Maxell in forum Windows
    Replies: 7
    Last Post: 5th February 2007, 04:01 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •