Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 7 replies
  • Subscribers 5 subscribers
  • Views 1957 views
  • Users 0 members are here
Options
Suggested
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

ERROR TO OPEN HOTSPOT PAGE ON USER PORTAL

Antonio Ferreira1

Hello experts, in my Sophos UTM v. 9.705-3, I have had definied hotspot configuration and added some users in Wireless Protection -> Hotspot -> Administrative Users, so they can manage vouchers. However today when ALL of these users where open Users Portal, the option "Hotspot" just does not open to generate vouchers. I got to UTM -> Wireless Protection -> Hotspot -> Live Log and got the following error:

2021:05:11-08:32:32 fwa01-2 hotspotd[9282]: Failed to connect to database: could not connect to server: Connection refused

Already restarted Hotspot service but the error persists.

Some help please.



This thread was automatically locked due to age.
Parents
  • FormerMember
    0 FormerMember

    Hi ,

    Thank you for reaching out to the Community! 

    Have you noticed any database errors in system logs? or core dumps on your firewall? 

    Provide the output of the following commands: 

    ps aux | grep postgres

    cd /var/storage/cores

    ls -larth

    Thanks,

  • 0 in reply to FormerMember

    Hi H_Patel and thank you for the reply, bellow the output of the commands that you ask:

    ps aux | grep postgres

    <M> fwa01:/home/login # ps aux | grep postgres
    postgres 4286 0.0 0.1 14520 9492 ? Ss May06 0:15 /usr/local/bin/repctl
    root 7820 0.0 0.0 5672 748 pts/0 S+ 07:48 0:00 grep postgres
    <M> fwa01:/home/login #

    <M> fwa01:/home/login # cd /var/storage/cores
    <M> fwa01:/var/storage/cores # ls -larth
    total 2.3G
    drwxr-xr-x 14 root root 4.0K Aug 18 2015 ..
    -rw-r--r-- 1 root root 55M Oct 29 2017 confd.plx.9088
    -rw-r--r-- 1 root root 4.1M Oct 23 2018 net.13279
    -rw-r--r-- 1 root root 4.1M Oct 23 2018 net.14431
    -rw-r--r-- 1 root root 89M Oct 23 2018 confd.plx.23446
    -rw-r--r-- 1 root root 1.1G May 29 2019 httpproxy.EpollWorker_26.6289
    -rw-r--r-- 1 root root 3.5M Jul 3 2019 httpd.1486
    -rw-r--r-- 1 root root 3.5M Jul 3 2019 httpd.2309
    -rw-r--r-- 1 root root 3.5M Jul 4 2019 httpd.26455
    -rw-r--r-- 1 root root 3.5M Jul 4 2019 httpd.26749
    -rw-r--r-- 1 root root 3.5M Jul 5 2019 httpd.14807
    -rw-r--r-- 1 root root 129M Dec 6 2019 named.5505
    -rw-r--r-- 1 root root 78M Jan 23 2020 urid.5841
    -rw-r--r-- 1 root root 625M Jan 23 2020 httpproxy.MemdCli.6096
    -rw-r--r-- 1 root root 263M Nov 6 2020 mdw.plx.4549
    -rw-r--r-- 1 root root 2.5M May 6 08:54 argos.7157
    -rw-r--r-- 1 root root 2.5M May 6 08:55 argos.7358
    -rw-r--r-- 1 root root 2.5M May 6 08:55 argos.7396
    -rw-r--r-- 1 root root 2.5M May 6 08:56 argos.7428
    -rw-r--r-- 1 root root 2.5M May 6 08:56 argos.7457
    drwx------ 2 root root 4.0K May 6 08:56 .
    <M> fwa01:/var/storage/cores #

    I'll apreciate any help.

Reply
  • 0 in reply to FormerMember

    Hi H_Patel and thank you for the reply, bellow the output of the commands that you ask:

    ps aux | grep postgres

    <M> fwa01:/home/login # ps aux | grep postgres
    postgres 4286 0.0 0.1 14520 9492 ? Ss May06 0:15 /usr/local/bin/repctl
    root 7820 0.0 0.0 5672 748 pts/0 S+ 07:48 0:00 grep postgres
    <M> fwa01:/home/login #

    <M> fwa01:/home/login # cd /var/storage/cores
    <M> fwa01:/var/storage/cores # ls -larth
    total 2.3G
    drwxr-xr-x 14 root root 4.0K Aug 18 2015 ..
    -rw-r--r-- 1 root root 55M Oct 29 2017 confd.plx.9088
    -rw-r--r-- 1 root root 4.1M Oct 23 2018 net.13279
    -rw-r--r-- 1 root root 4.1M Oct 23 2018 net.14431
    -rw-r--r-- 1 root root 89M Oct 23 2018 confd.plx.23446
    -rw-r--r-- 1 root root 1.1G May 29 2019 httpproxy.EpollWorker_26.6289
    -rw-r--r-- 1 root root 3.5M Jul 3 2019 httpd.1486
    -rw-r--r-- 1 root root 3.5M Jul 3 2019 httpd.2309
    -rw-r--r-- 1 root root 3.5M Jul 4 2019 httpd.26455
    -rw-r--r-- 1 root root 3.5M Jul 4 2019 httpd.26749
    -rw-r--r-- 1 root root 3.5M Jul 5 2019 httpd.14807
    -rw-r--r-- 1 root root 129M Dec 6 2019 named.5505
    -rw-r--r-- 1 root root 78M Jan 23 2020 urid.5841
    -rw-r--r-- 1 root root 625M Jan 23 2020 httpproxy.MemdCli.6096
    -rw-r--r-- 1 root root 263M Nov 6 2020 mdw.plx.4549
    -rw-r--r-- 1 root root 2.5M May 6 08:54 argos.7157
    -rw-r--r-- 1 root root 2.5M May 6 08:55 argos.7358
    -rw-r--r-- 1 root root 2.5M May 6 08:55 argos.7396
    -rw-r--r-- 1 root root 2.5M May 6 08:56 argos.7428
    -rw-r--r-- 1 root root 2.5M May 6 08:56 argos.7457
    drwx------ 2 root root 4.0K May 6 08:56 .
    <M> fwa01:/var/storage/cores #

    I'll apreciate any help.

Children
Unfiltered HTML