Guest User!

You are not Sophos Staff.

This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

users cannot connect to the database through Sophos policy then we have to remove them and recreate them again in the group then they start working.

Dear Sir/Madam.

 

This is Nabi Momand from Afghanistan Employed with one of the Well-known Bank in Afghanistan which famous in Islamic Banking and getting award for such service. And we are the one who is using your company product in our respective Bank.

 

Sir In last few days we are facing an interesting problem with our Sophos Firewall version SG310. And we are using above mentioned firewall in last 1 year since then we haven’t faced such problem.

And we are using Oracle software for our banking transaction system. Namely Flex Cube and OBIE. And we have created a group for the mentioned software, but once we accidently restart our Sophos firewall since then some of our users cannot connect to the database through Sophos policy then we have to remove them and recreate them again in the group then they start working.

 

So we have search to find out if someone ales mighty have such issue but we couldn’t reach out the sulotion.so I would like to request one of your Sophos expert to solve this issue for us that our users not to face such problem in the future.

Hope we get some guidance and assistance from your experts in sooner time



This thread was automatically locked due to age.
  • Rather than dig through the log for something that happened in the last days, open the Web Filtering Live Log. Activate it at the bottom of the 'Global' tab in 'Web Filtering'. Give it a moment to initialize and then try your access. Please let us know your result.

    Cheers - Bob
     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
  •  Dear Sir

     Thank you Very  Much for supporting  and as you advised , i able to find   web filter logs as below   Internet access logs and Flex Cube Logs ,

    Below Logs Releated to User When Access Internet:

    2016:02:13-09:22:24 aubsophos01 httpproxy[5710]: id="0001" severity="info" sys="SecureWeb" sub="http" name="http access"
    action="pass" method="GET" srcip="10.1.3.107" dstip="52.48.231.219" user="" ad_domain="" statuscode="302" cached="0"
    profile="REF_DefaultHTTPProfile (Default Web Filter Profile)" filteraction="REF_HttCffAllowExe (IT Policy)" size="0"
    request="0xddbe4000" url="ssc.api.bbc.com/
    d9c1b7b9a45a&c2=18897612&ns_type=view&ns_site=bbc-global-
    test&c1=2&b_vs_un=ws&b_imp_src=ws&b_imp_ver=1.0.0.0&name=pashto&b_vs_ls=pashto&b_synd_partner=bbc%7Crd
    %7Cgroup0&b_site_section=homepage&b_page_type=IDX%7Cna&c8=%DA%A9%D9%88%D8%B1%D9%BE%D8%A7%DA%BC%D9%87+-+BBC
    +Pashto&b_app_type=web&b_app_name=news
    %7Cweb&b_article_id=16100193&b_article_date=1268147133&b_article_update=1455301472&b_ad_enabled=1&c7=http%3A%2F%2Fwww.bbc.com
    %2Fpashto&b_c7=%2Fpashto&ns" referer="http://www.bbc.com/pashto" error="" authtime="0" dnstime="0" cattime="142" avscantime="0"
    fullreqtime="309574" device="0" auth="0" ua="Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET
    CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.3)" exceptions="" category="141"
    reputation="trusted" categoryname="Portal Sites"


    Below Logs Replated to User When Access Flex Cube:

    2016:02:13-09:22:57 aubsophos01 httpproxy[5710]: id="0001" severity="info" sys="SecureWeb" sub="http" name="http access"
    action="pass" method="GET" srcip="10.1.3.107" dstip="172.16.254.5" user="" ad_domain="" statuscode="200" cached="4"
    profile="REF_DefaultHTTPProfile (Default Web Filter Profile)" filteraction="REF_HttCffAllowExe (IT Policy)" size="20391"
    request="0xa8c9800" url="172.16.254.5/.../TaskTbls.xsl"
    referer="172.16.254.5/.../SMMDIFRM.jsp error="" authtime="0" dnstime="0" cattime="142" avscantime="8011"
    fullreqtime="15387" device="0" auth="0" ua="Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET
    CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.3)" exceptions="" category="9998"
    reputation="unverified" categoryname="Uncategorized" content-type="text/html"

  • let me make sure i understood this correctly:

    you have 2 user groups; 1 group can access the database but not in the internet, 1 group can access the database AND the internet?

    and the problem is that once you want to allow both database AND internet than nothing can be accessed?

    Why even use Web Protection for the Database Access? 

    Feel free to send me a PM with a skype or messenger contact, can have a look with Teamviewer. We use a simillar setup at my work place but not with two usersgroups in the webfilter.

    ---

    Sophos UTM 9.3 Certified Engineer

  • Thank you Very Much & You can Contact with me as my below Skype & Viber ID, then i will give you TV User name and password then u can check my Sophos UTM Issue ,

    Skype: nabimohmand
    Viber:+93782148285

    Note: My working time  is from 08:00 am up to 03:00 pm

    regards

  • Thank you very much Mr. Ben ,my issue now solved we are highly appreciated.
  • you are welcome :-) remember, anything that goes over http/https will pass through the webfilter if activated for a group.

    ---

    Sophos UTM 9.3 Certified Engineer