Questions tagged [database-connection]

57 questions
7
votes
4 answers

Postgresql Connection Timed out

when I am connecting to psql on remote server >psql -h {hostname} psql: could not connect to server: Connection timed out (0x0000274C/10060). Is the server running on host "{hostname}" (194.58.98.133) and accepting TCP/IP connections on port…
Clyde
  • 171
  • 1
  • 1
  • 2
6
votes
3 answers

RDS 2012R2: RD Connection Broker HA - cannot connect to SQL

I have a brand new RDS environment I am trying to set up. I'm trying to follow this guide: https://msfreaks.wordpress.com/2013/12/09/windows-2012-r2-remote-desktop-services-part-1/ and have gotten pretty far, but I'm failing at the Configure RD…
6
votes
6 answers

How might one mass kill connections to MySQL?

I've opened too many connections to MySQL and now I can't access it. It says "Too many connections". How can I close all of these connections? I also don't know how to restart it, which may resolve the problem.
Lucas
  • 161
  • 1
  • 1
  • 2
6
votes
1 answer

Find what is causing failed connections in mysql

I have a replicated MySQL environments were the master db gets a continuous "Aborted_connects". How can I find out what IP and what user are causing the aborted connections. There are about 500 connections created by 25 applications. I only have…
Clutch
  • 970
  • 1
  • 8
  • 13
5
votes
1 answer

Should a connection pooler be run on my database server or my app server?

I'm getting ready to start using PGBouncer, but I'm unsure of whether it should be used on my database server or on the app servers. If it's on the app servers, there will necessarily be multiple pools of connections, vs one central pool of…
orokusaki
  • 2,693
  • 4
  • 28
  • 42
2
votes
1 answer

What's the best way to speed-up data retrieving from a remote MySQL database server?

Scenario Two servers: ApplicationServer1 and MySQLServer1 MySQL remote database server is connected to ApplicationServer1 through an SSH tunnel (kept alive using autossh) The problem Since I separated the database from the application, the latter…
BlackOut
  • 29
  • 2
2
votes
1 answer

Connection to SQL Server 2008 R2 Database Server is SLOW

The database server is a VM running SQL Server 2008 R2 on top of Windows Server 2012, 24GB RAM allocated and 2TB of disk space. Overall, the database connections are very slow and one thing that stands out is that the connection to the database…
2
votes
1 answer

What is the most efficient way to connect my application on one VM to my Postgres DB on another VM?

I have 1 physical machine with 2 VMs (VMWare esxi) - one for database (PostgreSQL 9.2.1), and one for application. I'd like my application to connect to my database in an efficient way, and I've heard that using a file system socket is more…
orokusaki
  • 2,693
  • 4
  • 28
  • 42
2
votes
3 answers

How to tell if any MySQL connections has been dropped or timed out?

A client is using PHP to connect to MySQL. The PHP scripts and the MySQL database are located on 2 different Linux servers. He complained that database connections were being dropped or timed out and asked me to take a look. Is there any place in…
Continuation
  • 3,050
  • 5
  • 29
  • 38
1
vote
1 answer

Secure remote access to SQL Server in a multi-tenant environment using TLS tunnels

A similar question was answered here, and the option of opening an SSH tunnel was lightly touched, but the consensus was that VPN tunnels would be the easiest solution, which is true if the client is an "internal" user. This question is a little…
Louis Somers
  • 616
  • 6
  • 15
1
vote
1 answer

Problems while establishing a remote connection to MySQL using DataGrip

I'm new to these things, I'm familiar with the command lines and the SQL commands. I am currently working on a MySQL database that I have installed on a Linux server (Ubuntu Server) remotely outside my city. In the office I use a macOS machine to…
kitsune
  • 113
  • 1
  • 4
1
vote
1 answer

SQL Developer - The Network Adapter could not establish the connection

This is my first time connecting to an Oracle server. I'm using SQL Developer. They only gave me an IP, the default port (1521), a user name and a password. So I filled them in in the "New / Select Database Connection" dialog. When pressing "Test",…
bitoolean
  • 13
  • 1
  • 1
  • 4
1
vote
1 answer

Local PC to Cloud - Network Connectivity Issue

What I'm trying to do: I trying to setup SQL Server log shipping between my desktop and Oracle Cloud. I have a developer edition of MSSQL installed in both my desktop and Oracle Cloud instance. Windows Server in Cloud instance is in workgroup. SQL…
1
vote
2 answers

Cannot connect to Azure Database

I'm having difficulties with connecting to my deployed database on Azure. I'm new to Azure, currently trial license. I have a web application created in ASP.NETCore C# with Visual Studio 2015 (still in debug phase). It's already deployed and…
miki9009
  • 21
  • 4
1
vote
1 answer

MySQL Workbench and error Lost connection to MySQL server(system error 10060)

I am begginer in administration of servers. So decided to learn about it a little bit. All actions I perform in the same OS. I setup Microsoft SQL Server 2008 R2 on my virtual mashine(PC name: WIN-EBEI837K420 or IP: 192.168.1.100). SQL Server…
1
2 3 4