Questions tagged [database-connection]
The database-connection tag has no usage guidance.
51
questions
0
votes
0answers
19 views
PostgreSql query-execution-times become very large at Hanami App (Sequel)
I have a Hanami App which uses PostgreSql (9.5) as db-server (Rom and Sequel under the hood). It works quite well, but after some time with less interaction (i.e. over night), I observe very slow ...
1
vote
1answer
32 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 ...
0
votes
0answers
24 views
Unable to generate Hibernate reverse engineering using Embedded Derby connection in NetBeans IDE
I'm using embedded derby with Hibernate but
when I try to generate Reverse Engineering after creating Hibernate.cfg.xml I'm getting following error.
Cannot establish database connection with ...
0
votes
0answers
56 views
Can't connect to SQL 2012 SP4 DB after disabling TLS1
I recently disabled TLS 1.0 on our Test SharePoint 2013 farm following guidance found on these 2 blogs:
Rodney Viana
docs.microsoft.com
There was an issue on the site that prompted me to test ...
0
votes
0answers
29 views
Database Connection in AWS Window Web Server to AWS window database server is too Slow
I have two windows server in AWS, One Web Server (hosted in a ASP.NET Core web application) second one is Windows server with SQL Server (stranded version).
I have problem in connection application ...
0
votes
1answer
464 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 ...
0
votes
0answers
35 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 ...
0
votes
1answer
510 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 ...
0
votes
1answer
44 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 ...
0
votes
1answer
270 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 ...
0
votes
1answer
370 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. ...
0
votes
1answer
195 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/...
google-cloud-platform
0
votes
0answers
2k 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-...
1
vote
1answer
3k 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 ...
0
votes
1answer
15k 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 ...
1
vote
1answer
55 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.
...
0
votes
1answer
565 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 ...
1
vote
1answer
786 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 ...
0
votes
1answer
46 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 ...
0
votes
1answer
6k 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 ...
1
vote
2answers
636 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 ...
0
votes
0answers
1k 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 ...
1
vote
1answer
3k 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-...
1
vote
1answer
177 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: [...
5
votes
3answers
8k 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 ...
0
votes
0answers
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 ...
0
votes
0answers
33 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....
1
vote
1answer
2k 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 ...
1
vote
2answers
24k 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....
-3
votes
1answer
1k 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 ...
1
vote
2answers
760 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 ...
0
votes
0answers
85 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 ...
0
votes
0answers
179 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 ...
1
vote
1answer
818 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 ...
1
vote
1answer
705 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 ...
2
votes
1answer
7k 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 ...
0
votes
1answer
501 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 ...
0
votes
1answer
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 ...
0
votes
2answers
551 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 ...
4
votes
1answer
2k 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 ...
2
votes
1answer
77 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 ...
-1
votes
1answer
271 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 ...
0
votes
1answer
167 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 ...
1
vote
1answer
1k views
Performance factors in remote database access
I have a Java application which accesses a database. I tested it on my local machine with local database and it works just fine. But when I test it in our test environment where the application server ...
0
votes
2answers
10k views
How to connect MySQL database of local server in NetBeans 7.0.1 ( windows)? [closed]
I am using NetBeans IDE 7.0.1 on Windows 7 very first time for my php. Actually in my company there is a local server ( 192.168.1.99) where all projects resides and we access phpmyadmin of ...
1
vote
2answers
5k views
How to connect to MySql in another Ubuntu machine?
Hi How do i connect to MySql from another Ubuntu machine. I tried this
mysql -h 'IP' -P 3306 -u test -ptest
I get ERROR 2003 (HY000): Can't connect to MySQL server on 'IP' (111). then i tried
...
6
votes
6answers
25k views
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 ...
2
votes
3answers
3k views
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 ...
1
vote
2answers
397 views
cannot at all find sql instance (while installing an asp.net app on IIS)
So I'm really not a DBA, I'm an app dev.
I had to install my asp.net mvc3 app on my client's(a large company) IIS6 + Win2k3 machine, with absolutely no help from their sysadmins.
The final problem ...
6
votes
1answer
3k views
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 ...
