Tag: Connect

firebase – Connect with existing MySQL database (OVH) from Cloud Functions

I have an existing database hosted by OVH and managed by PhpMyAdmin.
On the other side, I also have a Firebase project where I use several Cloud Functions.

I would like write, in my existing OVH database, datas from my Firestore collections (thanks to Cloud Functions).

Is there a way to connect my Cloud Functions to an existing database ?

I did read than is possible to connect Cloud Functions to MySQL database with Cloud SQL but it seems only for new database created from Cloud Platform, which is not my usecase as my database is already created and hosted by OVH.

Thank you for your help!

502 error from nginx. It doesn’t seem to be listening to any port, but will connect to default

Facts: Nginx default can be accessed. Gunicorn is running, the website can be accessed via lan. Nginx runs, does not give me any errors. When I check sudo lsof -i -P -n | grep LISTEN , it tells me Nginx is not listening to anything, and that port 80 and 443 are open.

I was following this tutorial to build a flask website, and everything has been functioning great until the end. I have gunicorn serving it at localhost:8000, and can access it via other computers at its lan address. Yet when I try to access it online from 74.114.75.91, my static ip, I just get a 502.
Here my sites-available code.

server {
    # listen on port 80 (http)
    listen 80;
    server_name _;
    location / {
         # redirect any requests to the same URL but on https
         return 301 https://$host$request_uri;
        }
    }

server {
    # listen on port 443 (https)
    listen 443 ssl;
    server_name _;

    # location of the self-signed SSL certificate
    ssl_certificate /home/pi/farmData/certs/cert.pem;
    ssl_certificate_key /home/pi/farmData/certs/key.pem;

    # write access and error logs to /var/log
    access_log /var/log/farmData_access.log;
    error_log /var/log/farmData_error.log;

    location / {
        # forward application requests to the gunicorn server
        proxy_pass http://localhost:8000;
        proxy_redirect off;
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
    }

    location /static {
        # handle static files directly, without forwarding to the application
        alias /home/pi/farmData/app/static;
        expires 30d;
    }
strong text}

How to use SQL Developer SSH tunnel to connect to remote Oracle?

In older versions of SQL Developer it was very clear what to do:
Using SSH in older versions of SQL Developer

In newer versions it complains I have not provided a hostname, but there is no field called hostname. Also, there is this port forward always blank.

enter image description here

Am I misunderstanding something very badly here?

linux – Vnc viewer error: unable connect to socket: Connection refused (111) in CentOS 8

I would like you to help me with the following problem. I will try to give as many details as possible.

I recently installed a vnc server on a Centos8 virtual machine. I have done all the configuration steps, which are in this file, (which by the way is the one that vnc recommends using, since I think vnc was updated and the configuration method is not the same as before). Once this is done, the server is working without problem. (apparently)
The problem arises when I want to connect from another virtual machine (Fedora), the server rejects the connection and gives the following error:

IMAGE

In the server I execute the following instruction

vncviewer localhost:5901

I have consulted in some forums, and it is mentioned that it is a firewall problem that does not let the communication pass. So disable the firewall and Selinux)on both virtual machines, however the problem persists.
I know that the server is running correctly, because I get the following output.

(root@localhost andres)# systemctl status vncserver@:1
● vncserver@:1.service - Remote desktop service (VNC)
   Loaded: loaded (/usr/lib/systemd/system/vncserver@.service; enabled; vendor preset:>
   Active: active (running) since Mon 2021-03-01 13:21:07 EST; 1h 7min ago
  Process: 978 ExecStart=/usr/libexec/vncsession-start :1 (code=exited, status=0/SUCCE>
 Main PID: 994 (vncsession)
    Tasks: 1 (limit: 11260)
   Memory: 1.5M
   CGroup: /system.slice/system-vncserver.slice/vncserver@:1.service
           ‣ 994 /usr/sbin/vncsession andres :1

I also have these ports assigned, which tell me that the server is listening

(root@localhost andres)# netstat -tunlp | grep 5901
tcp        0      0 127.0.0.1:5901          0.0.0.0:*               LISTEN      1381/Xvnc           
tcp6       0      0 ::1:5901                :::*                    LISTEN      1381/Xvnc

Maybe it looks like a duplicate question from the following forum. And indeed it is, I just can’t find a relation, since vnc has been updated and the configuration is not the same (that is, to start the server, I can no longer put the command “vncserver”), and I assume that the solution will not be the same

microservices – How to connect a dockerized multi-container web application to an enterprise AWS ECS test environment?

I have a Go application that is divided into three containers, these containers are called via a docker-compose file and they have environment variables that I believe are held in the cloud including SQS and S3. The issue is, I am having trouble finding out how to actually connect to this environment. I have the in-prod master repo on my computer locally configured, and I also have the AWS cli configured. There are a lot of online examples of how one would go about creating a new cluster, but I just want to connect my docker containers to the test already created cluster and spin up new instances to run the containers on. A little more info about the app is it runs on two ports and our entire test env is hosted on the cloud. Although I am sure there is a way to get the applications to run entirely locally, I am not sure how the original engineer set this up and I believe they wrote this application to be testable on the cloud. The end goal would be having my docker-compose file running my 3 containers in a cluster and being able to hit it with requests in postman with the main app running on port 8000, then pushing my application changes to our test env via our test subdomain.

Sharepoint 2016 not able to connect to database intermittently

I have a Sharepoint 2016 Farm configured with Shared Roles. Below is the Configuration details.

  • 2 X Web Front End Servers with Distributed Cache
  • 2 X Application Servers with Search
  • 1 X Domain Controller
  • 2 X SQL Servers in Failver Cluster (configured with High
    Availability)

Although I am facing an issue wherein One of the Web Front End Server (WFE1) is sometimes not able to connect to database. I see the logs and find the below Error message.

“Unknown SQL Exception 53 occurred. Additional error information from SQL Server is included below.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)“

This issue happens twice in a day. How do I figure out what is happening wrong. Any support will be highly appreciated.

iPhone 11 failing to connect to 3g

So.

For the first time in a long while I am to a location without any 4G or LTE – only 3G. Unfortunately, no matter what I do, I am failing to coax my iPhone 11 even as close as to receive/send any data over it including switching voice and data on the phone’s secondary line (the one with a plan for roaming) to 3G. Text messages seem to go fine.

Here are my current data configuration:

main mobile data screen

secondary line data screen

Is there anything possibly wrong with the configurations that might be a quick fix? Is this a known issue?

mappeddrive – Can’t connect to server until reboot computers

I have a domain with around 90 PC with the domain controller running by Windows Server 2012 R2 and the PCs Windows 7. Every PC has a mapped drive from the server and a database interface that’s linked to the database in the server. Everything was working perfectly until a couple days ago when one PC couldn’t reach the server (mapped drive is disconnected and database access couldn’t be reached)

I checked the PCs connection to the network and it was able to reach other PCs and surf the internet with no problems. So I restarted the PC and that problem was fixed. The day after, almost every PC in the domain had the same problem. And restarting the PC always fixes the problem (Some PCs will reconnect to server after 2 to 3 attempts of restarts)

I tried restarting the server but that just made all PCs that were reconnected by restarting to lose connection again..

If you know anything about this problem please advice..

Is it possible to customize the user database and authentication methods for OpenID Connect?

We are evaluating OpenID for our needs, and I am having trouble finding concise answers to a few questions. We have a current user database with all pertinent info, including hashing mechanisms for passwords. The current app uses this database for simple authentication.

  • Is it possible to import the current user database into a new OpenID?
  • Is it possible to customize the authentication method to use our hashing method to match against password hashes in the database?
  • We will also need to provide a bit of extra information from that database. Can we customize the data that /userinfo returns?

Thanks!

networking – Cannot connect to localhost port 80 in GCP Compute Engine VM

I have setup a Windows Server 2019 with Containers Compute Engine VM in Google Cloud. I have installed IIS. I want to go to the following URL on the local server in a browser, or via wget: http://localhost. However, I am getting back a connection refused. I tried on the Private IP and Public IP from the machine, both failed. Also fails from outside the VM using public IP.

I check with netstat and port 80 is open, and IIS is running. I ran Test-NetConnection and got the following result:

Test-NetConnection -Port 80 -ComputerName 127.0.0.1 -InformationLevel Detailed


ComputerName            : 127.0.0.1
RemoteAddress           : 127.0.0.1
RemotePort              : 80
NameResolutionResults   : 127.0.0.1
MatchingIPsecRules      :
NetworkIsolationContext : Loopback
IsAdmin                 : False
InterfaceAlias          : Loopback Pseudo-Interface 1
SourceAddress           : 127.0.0.1
NetRoute (NextHop)      : 0.0.0.0
TcpTestSucceeded        : True

So apparently the port is open but I just can’t retrieve data from it.

This is super weird because it is on localhost. I also went into the VPC Network and added an HTTP Ingress (port 80) rule for 0.0.0.0/0.

I really can’t figure this out. Why would I not be able to connect to a running port 80 web server on my own machine? Is there some extra firewall in this GCP image somewhere?

Any help would be greatly appreciated.