Questions tagged [database-connection]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
26 views

Django: CONN_MAX_AGE persists connections, with gthread worker class of gunicorn

I am using Django, without MAX_CONN_AGE setting (default = 0), this leads to creation of connection in each request, and connection is not reused in django ORM. This is causing multiple postgres ...
mansi chauhan's user avatar
-1 votes
1 answer
245 views

(PART 3) Docker environment for PHP Framework from scratch

i am runing this docker composer files with this enviroment: version: "3.1" services: mysql: container_name: mysql image: 'mysql:8.0' working_dir: /application command: --...
Minos Framework's user avatar
1 vote
2 answers
14k views

Why does Postgres tell me "no pg_hba.conf entry for host..." when I have already modified this file?

The story so far: I have installed Postgres on my Linux based desktop (HOST). I have created a test database, with test data, on HOST. I have added to the end of the pg_hba.conf file on HOST: host ...
Tom Hosker's user avatar
0 votes
0 answers
237 views

After upgrade from MongoDB 4.x to 5.0.2 shows Connection Refused trying to connect BD from Private Network

I have upgraded my MongoDB from 4.x to 5.0.2 into a Ubuntu 20.04 system. This server is an AWS EC2 Instance. After upgrade I can't connect my applications from other ec2 instances using the same ...
Andre's user avatar
  • 1
0 votes
1 answer
173 views

How to connect to db2 database if we are provided with DB2 ODBC connection via System DSN?

DB2 database connection details are provided as ODBC registry file. The file is imported and the connection details are stored under System DSN. Now by using which GUI tool one can connect to the DB2 ...
Teja Goud Kandula's user avatar
0 votes
0 answers
51 views

Is it possible to set up the database connection if we are provided with ODBC registry file?

One of the users already has all the OBDC connections configured on to the RDC user account. That machine is used to connect to all the databases. A new user on boards into the organization, his log ...
Teja Goud Kandula's user avatar
0 votes
1 answer
603 views

MariaDB Galera Cluster simultaneously got 2000+ Connections on single node How to trace this issue

I am using MariaDB Galera Cluster (Master/Master) having 5 nodes with specs of 32Core 64GB Ram Ubuntu 20.04 Personal Vm-Machines at own Datacenter Top of these nodes, Haproxy is configured which ...
Qazi's user avatar
  • 101
1 vote
0 answers
34 views

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 ...
mohamed al-mahdi's user avatar
-1 votes
1 answer
2k views

Error establishing a database connection in Google Cloud Platform Wordpress site [closed]

Since 14.2. my site is giving this error: Error establishing a database connection I have a Wordpress site at Google Cloud Platform ID XXXXX-XXXXX-XXXXX I have not changed anything for several months,...
Tommi Koskinen's user avatar
1 vote
0 answers
905 views

Get diagnostics information from failed connect from Grafana to InfluxDB

I've tried to set-up a local Grafana instance in a Docker container and I'm trying to connect to my local InfluxDB that is running on the same machine. I can connect to InfluxDB without any issues, ...
Alexander Pacha's user avatar
0 votes
0 answers
36 views

Check health of my system such as database connections, mainframe connections, messaging services etc

I am so new to this topic that I am not even sure I am asking it correctly but I will give my best. We have number of applications talking to databases such as Oracle and Mainframe and uses messaging ...
dbnex14's user avatar
  • 101
2 votes
1 answer
1k views

How to simulate connection timeouts - on Windows 2016 - Windows firewall?

We have an issue with some .Net applications getting connection timeouts when doing SQL requests to Db2. The code have been updated to improve logging when such timeout occurs. But, since we are not ...
rhellem's user avatar
  • 305
0 votes
1 answer
3k views

Adminer or mysql error: no connection could be made because the target machine actively refused it

I have been trying to set up wordpress.org using localbyflywheel, but when I open Adminer I keep getting this error: No connection could be made because the target machine actively refused it, what ...
user554395's user avatar
0 votes
0 answers
54 views

Why can some users connect to a DB and others can't?

I have a geospatial database that one of my users needs to connect to. Whenever he tries to connect from his workstation he gets an invalid connection/connection refused error. He is not able to ...
Kyle's user avatar
  • 1
1 vote
1 answer
2k views

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 ...
Louis Somers's user avatar
0 votes
1 answer
126 views

Use Curl For Finding DataBase Errors?

I have a list of domains in a file say list.txt I've got a report that many of these domains showing "Database Connection Error" I want to know all domains that can't connect with db properly. I ...
Sollosa's user avatar
  • 137
0 votes
1 answer
573 views

Magento Data Migration - Host is not allowed to connect to this MySQL server

In Magento Data Migration process, Host is not allowed to connect to this MySQL server. I check Mysql connection using normal PHP file and able to connect in Mysql service. I also create a remote ...
Emipro Technologies Pvt. Ltd.'s user avatar
0 votes
2 answers
650 views

PostgreSQL trust connection with QGIS

I've setup a local postgresql database, and as it's a local database, I'm not worried about security or authentication. I'm currently using this database with QGis and PostGIS to store geometry data. ...
Juzzbott's user avatar
  • 101
0 votes
1 answer
244 views

connecting google cloud sql to spotfire

I'm trying to connect google cloud SQL to Tibco Spotfire. In Spotfire I opened the "information designer" -> "setup data source" and chose MySQL5. In the connection URL I have jdbc:mysql://google/...
Luc's user avatar
  • 1
0 votes
0 answers
4k views

Connecting to MongoDB Atlas throws Exception 'No suitable servers found'

Connecting to the mongodb atlas and trying to write a simple document gives the following error. What am I doing wrong? $manager = new MongoDB\Driver\Manager("mongodb://admin:admin@test-shard-00-00-...
Nikolai Verner's user avatar
1 vote
1 answer
4k views

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 ...
kitsune's user avatar
  • 113
1 vote
1 answer
19k views

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 ...
bitoolean's user avatar
1 vote
1 answer
69 views

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. ...
tesla747's user avatar
  • 113
0 votes
1 answer
761 views

MS SQL Server 2008 drops connections if number of connections is large

My SQL Server instance is configured for unlimited number of connecting users (DB right click - properties - connections). But when my script tries to execute about 500 simultaneous queries a big part ...
Alex Taran's user avatar
3 votes
1 answer
3k views

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 ...
BlackOut's user avatar
0 votes
1 answer
64 views

Is it possible to connect to a database on an alternative server?

I have a server in one country, but most visits to my site come from another country (e.g., my server is in Germany but my site users are in the USA). This means that the ping time for my users is ...
Alexander Jones's user avatar
0 votes
1 answer
12k views

pg_ctl: could not start server

I am trying to start the PostgreSQL server installed on a remote Redhat server(RHEL 6.7 x86_64) through putty. The command that I used to start the server is /etc/init.d/postgresql-9.5 start But it ...
niraj's user avatar
  • 31
1 vote
2 answers
831 views

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 ...
miki9009's user avatar
0 votes
0 answers
2k views

WordPress database connection not working after port change

I've recently changed a WordPress site that is hosted on a local server from port 80 to port 8080. I did this initially just by editing the binding in IIS. The site kept redirecting itself back to ...
Carel's user avatar
  • 131
1 vote
1 answer
5k views

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-...
SANRIZE's user avatar
  • 11
1 vote
1 answer
421 views

MS Native SQL driver 10.0 and SQL Server 2008 connection creation failure

I'm trying to narrow down and debug quite elusive error: State: 08001 Code: 258 Msg: [Microsoft][SQL Server Native Client 10.0]TCP Provider: Timeout error [258]. State: HYT00 Code: 0 Msg: [...
przemo_li's user avatar
6 votes
3 answers
10k views

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 ...
ITKat's user avatar
  • 61
0 votes
0 answers
3k views

DNS_PROBE_FINISHED_NXDOMAIN when trying to acess page from a local server

I'm working in a company where we use a local server in linux to store some data, particularly our BugZilla, Wiki and a subversion repository. The server is accessed both locally from the development ...
Momergil's user avatar
  • 151
0 votes
0 answers
34 views

How to make MySQL Server > 5.5.45 on OS X Yosemite accessible through tcp? [duplicate]

Right now I do a netstat -n | grep 3306 and nothing come. Beside I try to connect using: $ mysql -h127.0.0.1 -u root -p Enter password: ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0....
user avatar
1 vote
1 answer
4k views

Connect to MariaDB through SSH fails with error 2013 - Lost connection to MySQL server at 'reading initial communication packet'

I'm trying to connect to a remote MariaDB server through SSH using Navicat Premium from Windows but all the time I can't and get this error: 2013 - Lost connection to MySQL server at 'reading ...
ReynierPM's user avatar
  • 720
8 votes
4 answers
98k views

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....
Clyde's user avatar
  • 181
-3 votes
1 answer
2k views

PHP Fatal error: Call to undefined function mysql_pconnect() [closed]

I'm Having same Problem. PHP Fatal error: Call to undefined function mysql_pconnect() in I gone through PHP Fatal error: Call to undefined function mysql_pconnect() in. i have same problem. but ...
Ningappa's user avatar
  • 111
1 vote
2 answers
879 views

Can't connect after NEW Install SQL Server 2012 on Win 7 Pro SP1 with Windows Auth or SQL Server Auth

Trying to install SQL Server 2012 (Eval) to work with the new BI tools using AdventureWorksDW tutorial. Therefore, I feel I've gotten bogged down in SA activities that would be done by others in the ...
David Eiland's user avatar
0 votes
0 answers
97 views

Connect to a Server from my AWS EC2 instance

I have a app running on AWS EC2 which connects to a database in another server. The database connection Uri is as following, jdbc:XXX:172.18.2.107:3306/database This is what I got form my ...
diyoda_'s user avatar
  • 169
0 votes
0 answers
238 views

Moved offices and now cannot connect remotely to postgres

Everything was working in my previous office. I've now moved to a new office, and cannot connect remotely to postgres. SSH works though. My IP is currently 70.90.155.138. Could not connect to ...
Jeremy T's user avatar
  • 101
1 vote
1 answer
1k views

Providing database connection via web server

I am creating a database (in PostgreSQL, but this question is hopefully independent of the underlying DBMS) that will be hosted remotely. Most access will be provided through a web-based front end ...
beldaz's user avatar
  • 243
1 vote
1 answer
832 views

What happens to active connections to my SQL Server DB if I back up the transaction log with the NORECOVERY option?

Some background: I'm migrating my SQL Server DBs to a new machine and I wrote a few Powershell scripts to send/apply full backups and transaction logs asynchronously to the new server, but my question ...
Ranic's user avatar
  • 111
2 votes
1 answer
8k views

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 ...
AbeP's user avatar
  • 135
0 votes
1 answer
562 views

SQL Server 2005 Linked Server using SSMS from laptop vs RDP

I connect to work network via Cisco VPN from my work laptop, which is on AD. Edit I am using SQL authentication to connect from Server A to B; in scenario #1 I can connect. I can even connect from ...
AbeP's user avatar
  • 135
1 vote
1 answer
7k views

can't connect to mysql with a host

I have mariadb installed and running. I can connect to it with this: mysql -u dev -p or mysql -h localhost -u dev -p but I can't connect to it using mysql -h 127.0.0.1 -u dev -p It asks me ...
Anthony's user avatar
  • 253
0 votes
2 answers
629 views

How would I allow access to a VPS based MySQL database only from AWS East based IPs?

I have a MySQL database on my VPS that I only want to be accessible by my local IP (no problem in doing that) and an IroneWorker Ruby app, which may use any of these AWS East IPs. So far, the only ...
Gus Shortz's user avatar
5 votes
1 answer
3k views

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 ...
orokusaki's user avatar
  • 2,863
2 votes
1 answer
156 views

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 ...
orokusaki's user avatar
  • 2,863
-1 votes
1 answer
300 views

Can I connect VM to Wamp installation of Mysql running on same machine? [closed]

On my Windows 7 PC I have Virtual Box running a Centos VM that has PHP installed on it but no MySQL that I brought from the office. I am trying to set up a database for it. I have Wamp installed on ...
Damon's user avatar
  • 99
0 votes
1 answer
174 views

Error 1045 while configuring mysql

I can install the mysql but while configuring it i am getting error like this: ** 1045 : access denied for user root@loaclhost.** i can install it i cant configure it. Please help...I am quite new to ...
user avatar