Results 1 to 4 of 4
  1. #1
    Newbie
    Join Date
    Jun 2009
    Posts
    6

    Default UT mess with SQL and MySQL Databases

    I am having installation issues with my UT Box. With the configuration below, internet and e-mail traffic are being routed and scanned properly but all internal SQL and MySQL data transfer is being blocked.

    All of our pay and time records are managed in a SQL database and all production activity (the majority of our data transfer) is done in a MySQL database. As soon as I plug in the UT server both databases begin timing out and the users receive errors. It is my understanding from reading other threads, that this traffic shouldn't even be routed through the UT server so I'm not sure where to begin troubleshooting this error.

    UT "Network configuration" set up as transparent bridge w/ all default settings as follows:

    1. IP 172.16.25.51/24
    2. Default Gateway 172.16.25.50
    3. Primary DNS X.X.1.X
    4. Secondary DNS X.X.7.X

    Network Setup:
    1. (2) T1 Modem w/ 5 Static IP addresses .64, .65, .66, .67, .68
    2. Sonicwall w/ NAT configured.
    a. WAN - .66
    b. LAN 172.16.25.50
    c. DMZ 192.168.1.30
    3. DMZ connected to Webserver
    4. Lan connected to UT Server
    a. Eth0 –172.16.25.51
    b. Eth1 – Bridge
    5. Eth1 connected to LAN Switch
    6. Switch to MS Exchange Server 03 – 172.16.25.20
    7. Switch to MS03 DHCP Server and Primary DNS - 172.16.25.21
    8. Switch to MS03 Secondary DNS - 172.16.26.10
    9. Second Switch connected to rest of the Network

    I am unable to convince management to allow me to take the Sonicwall out of the mix until UT proves itself (to them) on its first two tasks of internet and spam filtering.

  2. #2
    Untangle Ninja sky-knight's Avatar
    Join Date
    Apr 2008
    Location
    Phoenix, AZ
    Posts
    26,553

    Default

    You have DMZ on the Sonicwall, I assume the DB servers are on the LAN and attached to the Web server in the DMZ?

    Untangle does not like it when you present local IP addresses on the external interface. You need to configure the thing just so for the DMZ traffic to make it into your lan.

    Give the UT bridge an ip on the DMZ segment, and create a bypass rule for the dmz address space so it goes around the rack when the range presents on external.
    Rob Sandling, BS:SWE, MCP
    NexgenAppliances.com
    Phone: 866-794-8879 x201
    Email: support@nexgenappliances.com

  3. #3
    Newbie
    Join Date
    Jun 2009
    Posts
    6

    Default

    Yes there is a DMZ and web server connected to the Sonicwall, but the SQL and MySQL servers have no connections to the web server; that is why it isn't attached to that side of the Sonicwall. The data on their ports remains completely internal and they send no data to the outside world.

    The two databases are only for tracking production data internally, running the time clocks, and managing employee records.

    Does anybody have any other ideas for this?
    Last edited by tschiel; 06-24-2009 at 05:05 AM.

  4. #4
    Newbie
    Join Date
    Jun 2009
    Posts
    6

    Default

    I hate to be a punk by bumping this up, but does anybody have any ideas that may help me with getting this working properly?!?

Tags for this Thread

Posting Permissions

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

SEO by vBSEO 3.6.0 PL2