postgresql – could not connect to server: can’t connect postgres on the server to postico on my local

when I connect postgres on the server to postico on my local I get this error

could not connect to server: Operation timed out
Is the server running on host "http://159.65.65.203/" (92.242.140.2) and accepting
TCP/IP connections on port 5432?

I could not find anywhere postgresql.conf and pg_hba.conf files, so i created the files, as you see in the below image

enter image description here

I found this explanation but still does not solve my issue

Ubuntu does not use the standard pg_ctl for postgreSQL. Instead, it 
uses pg_ctlcluster.
That in turn controls the different PostgreSQL clusters. When you do 
an install of a new cluster, pg_ctlcluster is smart enough to put
postgresql.conf & pg_hba.conf into separate dirs.
So to be specific, /usr/lib/tmpfiles.d/postgresql.conf is just a tmp 
file that you can ingnore, /etc/postgresql/9.4/main/postgresql.conf is 
the original version for the 9.4 cluster and
/var/lib/postgresql/9.4/main/postgresql.auto.conf is the actual, live
version of the 9.4 cluster that you need to change to affect the 9.4
cluster. Likewise for the pg_hba.conf.
reference https://www.postgresql.org/message- 
id/CANu8FiygR5CdeqRTiE0YM+BQk6aK+qZyw2frH_FWV27J1exong@mail.gmail.com

here how i configured postgresql.conf

port=5432
listen_addresses='*'

here how i configured pg_hba.conf

 host    all             all              0.0.0.0/0                       md5
 host    all             all              ::/0                            md5

when i run

Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program 
name
tcp        0      0 0.0.0.0:80              0.0.0.0:*               LISTEN      -
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      -
tcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN      
29761/postgres
tcp6       0      0 :::22                   :::*                    LISTEN      -

Clearly 5432 is not open for all connections.
when i make an api call using postman seems to work.
I use mac currently firewall not on, i have my server on digitalocean use Ubuntu 16.04.6 (LTS) x64.

This is the path of postgres files

postgres@borroupapi:~/9.5/main$

when i run find / -name postgresql.conf i get this

/usr/lib/tmpfiles.d/postgresql.conf

but i cant find the path as logged in postgres user

Problems with using a non-reserved top-level domain for local DNS resolution

What are the problems with using a live top-level domain for internal name resolution?

You may find yourself unable to reach real hosts belonging to the real organization registering that domain in the future, because your DNS queries will be short circuiting that access. You may also leak queries reflecting internal organization (server names) in some circumstances (e.g., a laptop “off the network” querying public DNS instead of corporate DNS).

Specifically, what are the security implications?

If you have systems somehow querying “real” DNS, they’ll either leak dns names and/or be potentially redirected to hosts they didn’t intend to go to. That could lead to credential leakage as a worst-case scenario.

In addition, does this somehow conflict with some fundamental way on
how DNS and name resolution is supposed to work?

Well, it’s bad manners, and any breakage that resulted would be well-deserved.

See this answer for a list of TLDs that are safe for private use.

How do I change local site alias?

I’ve recently upgraded from Drush 8 to Drush 9. In Drush 8, I use drush @project.local.sitename status; in Drush 9, I have to run drush @project-local.sitename status.

How can I replace the hyphen with a dot just like the command in Drush 8?

windows server 2012 r2 – How Apache Limit POST are set to accept Strictly local service Request?

I am trying to harden an Apache 2.4 Web server running 2 wordpress sites with separate vhost settings. Deployed on Windows 2012 r2. I was hacked a few weeks ago and the server was completely lost. On the new server they are still trying to hack the site with post request injections/code executions. I’m having trouble trying to block all POST request that are not sent by the server on submission.

Things I have tried include

  • <Location>, <Directory>, <Limit> tags with their attributes like GET,PUT, POST PUT DELETE trying varied combos with various Require statements ie. local, ip, host, and order allow, deny patterns. Allow all from

  • <Directory "/">, <Location >,<LimitExcept > Tags including attributes such as GET,POST and combos.

  • Various <if > statements

  • AllowMethod Statements

  • Whitelisting Directories in the .htacess

Placing attempts in different file context. Such as httpd.conf, Vhost.conf, .htaccess. Any file I found referenced in Apache docs related to the directive context. Even placed it where it should not work for giggles. Nothing, I read in the docs or on stack overflow seemed to work.

All auth Modules loaded like mod_auth, mod_host etc. Just assume Modules are fine.

What I would like to achieve is to deny or <Limit POST> request. Strictly allowing them in a dynamic <Directory "/.*"> or ` being responded to only when the server submits the Request using the server IP. Therefore the IP:port of the request should be the “remote address” because the apache local service sends the request method via PHP. I believe this to be correct logic.

The last thing I had time to try before leaving work, is the below code attempting a dynamic `<Directory “/.*”> tag I do not want to dig through WordPress for every form and create a tag for each directory.

Thank you for the help, please include a code example with your answer.

<Directory "/.*">
<if "%{REQUEST_METHOD} == 'POST'">
<Limit POST PUT DELETE>
Require req, http %{REMOTE_ADDR} == 'xx.xx.xx.xx:xx'
</Limit>
</if>
</Directory>

Now I tried

<Directory "/"> 
<if "($_SERVER('%{REMOTE_ADDR}') == 'xx.xx.xx.xx'">
<Limit POST>
allow from all
</Limit>
</if>
</Directory>
<Directory "/"> 
<if "($_SERVER('REMOTE_ADDR') == 'xx.xx.xx.xx'">
<Limit POST>
allow from all
</Limit>
</if>
</Directory>

No plugin, No nginx,E xpress, Or IIS Suggestions. Only relevant solutions to this config.

linux – Packets taking DNAT rule to local IP disappearing

I’ve been dealing with quite an odd issue for about the past week now, and I’m wondering if anyone had any advice to continue debugging. We have a machine with two ethernet interfaces, one of which serves as our internet connection (let’s say IP A), and the other which has a subnet of our network’s traffic (which includes IP A) mirrored to it through our router; that interface has IP B. We have an application that takes in traffic from the mirrored interface and filters it, dumping some packets to tun interfaces (let’s simplify and only say tun0 here, though in the real application we have one for each core on which the filtering is performed). We then attempt to DNAT packets received on tun0 back to IP B on port C so that another application can ingest them.

We have a rule set up in the nat table’s PREROUTING chain to perform the DNAT, as follows:

iptables -t nat -I PREROUTING -p tcp -i tun0 -j DNAT --to <B>:<C>

I have confirmed that this rule is being hit, both with packet traces as well as looking at the packet numbers from iptables. After that, however, the packets seem to disappear—I would expect them to next enter the INPUT chain as IP B is a local address (I’ve confirmed ip route get <B> refers to lo), however the packets don’t enter the INPUT or FORWARD chains, which leads me to believe they’re dropped in the routing decision. Everything that I’ve seen online seems to point to this being an issue with rp_filter, forwarding or route_localnet, however I’ve confirmed all of the following:

net.ipv4.conf.all.rp_filter = 0
net.ipv4.conf.tun0.rp_filter = 0
net.ipv4.conf.lo.rp_filter = 0
net.ipv4.ip_forward = 1
net.ipv4.conf.tun0.forwarding = 1
net.ipv4.conf.lo.forwarding = 1
net.ipv4.conf.all.route_localnet = 1
net.ipv4.conf.tun0.route_localnet = 1
net.ipv4.conf.lo.route_localnet = 1

When I turn on martian logging, I see the following:

IPv4: martian source <B> from <A>, on dev tun0

Which seems to confirm that the DNAT is having some effect, but given that rp_filter=0 this confuses me.

At this point, I’m out of ideas on how to continue debugging, as the packets seem to disappear from the face of the earth after the DNAT step other than the martian logs, and would greatly appreciate some guidance! Thanks!

How to link my local jenkins with my kubernetes engine on GCP

I am here for a problem that I have encountered for days to link my local jenkins and my kubernetes cluster hosted on GCP.
I launched this command gcloud container clusters get-credentials cluster-devops --zone=us-central1-c locally to generate ./kube folder locally i got a config file associate.
After ,I had to download the kubernetes plugin on jenkins and I then indicated my cluster address and load my config file as a secret file and I get the following error.
I can see it’s a permissions problem but I don’t know how to fix it.
Thank you for your contribution.
enter image description here

Restore local WhatsApp backup after factory reset

The phone is a Samsung J7 Prime. Lately, the memory was getting full and this ended up in causing Google Play Services to stop working and crashed Google Play Store which was not available anymore. Tried cleaning and increasing the available memory and following Google guides to get back to normal to no avail. Last resort was to factory reset. I made sure to use Samsung Smart Switch and Cloud Backup after doing a local WhatsApp backup since Google Drive wasn’t accessible anymore. After the reset, the shock was that the local WhatsApp backup files were all gone. Tried using several recovery software but all failed to see the deleted backup files or any deleted file for that matter. I also read that file recovery needs rooting which is not something I’m keen on doing this as the phone is not mine. What are my options at this stage and is there any possibility to get back the deleted backup files? This happened yesterday late evening and the phone hasn’t been used much since.

P.S. Samsung Cloud Storage sucks as it requires 2FA and to sign in requires an SMS which is not being received (that’s another issue that I’m not addressing here) and I’m not even sure if the backup files were copied to this storage in the first place.

Television ads in a local Merket

I want tv ads but i need a few tips

its for Zeus.host. In footer.

I was thinking something animated. Any suggestions for how to make a good video ad.

I will create 30 high DA local citations/Local listing for your Business for $4

I will create 30 high DA local citations/Local listing for your Business

Hello everybody!
Welcome to my gig. Are you looking for a Local listing service? Then you are in the right gig. I will create 30 local citations for your business in High DA site.

Citation is the online reference for your Business Name, Address & phone number (NAP). Local citations help you to grow your business in the local area and boost your local ranking. Local citations help you to get

targeted traffic on your google map. local citation for that one who is looking for

natural & real traffic.

My service is one of the best. Let,s try it.


Advantage of picking my service :


  • local IP
  • 100% Manual Work
  • High DA site
  • Use All Your information
  • 24/7 support
  • Quick service

What I need from You :

  1. Your business name
  2. Full Address
  3. Website name
  4. Business Phone number
  5. Business Description

I will send you all details in an excel sheet & screen short proof.

Contact me before placing the order.

If you order once, I promise you will come back again

Thank you.

.(tagsToTranslate)LocalSEO(t)Locallisting(t)localcitation(t)SEO(t)localbusiness

7 – Local action on node but path a child of node?

I have created two local actions which I want to display on my nodes, General Configuration and Advanced Configuration.

General Configuration will show at node/%node, but Advanced Configuration is showing at node/%node/config. Is there anyway to keep the path as node/%node/config/advanced but have the local action display on node/%node?

  $items('node/%node/config') = array(
    'title' => 'General Configuration',
    'type' => MENU_LOCAL_ACTION,
  );
  $items('node/%node/config/advanced') = array(
    'title' => 'Advanced Configuation',
    'type' => MENU_LOCAL_ACTION,
    'weight' => 2,
  );

Thanks for any help