Skip to main content

Questions tagged [remote]

The tag has no usage guidance.

26 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3 votes
0 answers
3k views

PostgreSQL FATAL canceling authentication due to timeout

I have a PostgreSQL 9.4 Database running on my CentOS 7 Server. This database has only ever been available to users on the LAN, however recently I needed to make it available to users outside the LAN ...
TheLovelySausage's user avatar
3 votes
0 answers
2k views

Timeout on remote query over database link

We are trying to verify if a database link is up before inserting data into a remote database. We have no control over the remote database's behavior and status. We need to set a timeout on a query ...
Hugues's user avatar
  • 31
2 votes
0 answers
3k views

MySql Workbench Couldn't find section mysqld in the remote config file /etc/mysql/my.cnf

if you get this trying to connect to your remote server using MySql Workbench, then try to (on your remote server) navigate to /etc/mysql/my.cnf and add [mysqld] then it should look like: !...
Nils Riga's user avatar
2 votes
0 answers
2k views

Postgresql slow remote execution when using alternative clients

I noticed a strange perfomance issue when running sql queries on a remote Postgresql Server. Everything good when using psql: Connect via ssh and run things locally $ ssh [email protected] user@...
user1068464's user avatar
1 vote
0 answers
4k views

Remote Access in Centos 8 and MySQL 8

I cannot access MySQL 8.0 on a Centos 8 server remotely with an error: ERROR 2026 (HY000): SSL connection error: unknown error number I can see port 3306 when doing a port scan remotely using nmap ...
I'm Root James's user avatar
1 vote
0 answers
7k views

PostgreSQL, could not connect to remote server via port 5432

I know other people have posted similar questions but none of the solutions applied here. I have installed Postgresql-9.6 under CentOS 7 on my virtual private server, and I am trying to connect to the ...
yimcai's user avatar
  • 11
1 vote
0 answers
335 views

SQL Server 2014 - remote login to AOAG named instance, listener port does not work

Your help is greatly appreciated. I spent a few hours trying to troubleshoot this and before I go to the firewall/network possibilities, i would like to check if my setup has any errors I am unable ...
Debbie's user avatar
  • 303
1 vote
0 answers
229 views

Unable to get anything other than 'Remote scan' when selecting from linked MySql server

I have a linked server in SQL Server 2012 (SP3) that points to a MySql 5.1.61 server on another machine. Whatever I do, I don't seem to be able to get any where filtering to occur on the remote side. ...
GSerg's user avatar
  • 1,352
1 vote
0 answers
59 views

How can I partition records vertically across machines?

I recently asked two questions: (1) how to store and connect partial records in two or more machines, with the record halves correctly associated, and (2) how to determine the increase in time/space ...
Lori's user avatar
  • 121
1 vote
0 answers
51 views

Security: direct remote access vs webinterface

I need to remotely connect to my (mongoDB) database and I currently allow direct access to the DB server port with user/pw login. I often read that this is generally a bad idea and that one should ...
Chris's user avatar
  • 129
1 vote
0 answers
222 views

Restore postgresql database from remote sql file

I would like to know if it's possible to restore a database from a remote sql file. The problem: - Working with PostgreSQL 9.2.4 - I have an small remote server with 10GB left in storage - I have a ...
alex_pc89's user avatar
  • 113
1 vote
0 answers
232 views

Materialized view for a yet-to-be-defined DBlink

In our product we have a main application with an oracle 11g DB and an optional module with another DB. We want the two to communicate through a dblink and I was told to put some code for the ...
user881430's user avatar
0 votes
0 answers
31 views

Communication link error when Running a stored procedure that hits a a separate server via linked server

I’ve ran into an issue where we’re trying to execute a stored procedure from server A which fetches data in a variable from server B. The SP calls a linked server that exists on server A. However, ...
Joe Sequel 's user avatar
0 votes
0 answers
28 views

Access MySQL remotely with terminal and PHPMyAdmin

First I must say that it's the first time I'm doing this kind of stuff, I'm a bit confused. I've uploaded a MySQL database to a website I bought few hours ago which I can access through PHPMyAdmin. I'...
Zep's user avatar
  • 1
0 votes
0 answers
41 views

Postgresql: Does execute() or fetch() download result from remote?

When getting a query result from a remote server, does the execution of the query transmit the result to the local machine, or is it buffered on remote and only downloaded when fetching the result? ...
Radio Controlled's user avatar
0 votes
0 answers
202 views

what permissions does user need to have to use linked server and its default remote user mapping

i have some linkedserver and for it created default maping that mapping list is empty and all goes thrue 'Be made using this seciurity context' and this works fine - i can querry this linked from any ...
Dorian's user avatar
  • 103
0 votes
1 answer
381 views

Access Oracle Database remotely via DBeaver

I have two machines, a windows 10 notebook with oracle database installed, and a Raspberry Pi 4 with DBeaver installed. On the Raspberry I have PostgreSQL which I can access locally via dbeaver, but ...
Caio Vital's user avatar
0 votes
1 answer
3k views

MariaDB remote access ERROR 1045 (28000): Access denied

MariaDB 10.3.27. Debian 10 Buster. I've followed the instructions to grant remote access to a user to my remote MariaDB server: Edited /etc/mysql/my.cnf: [mysqld] #skip-networking #bind-address = &...
schrodingerscatcuriosity's user avatar
0 votes
1 answer
684 views

Cannot allocate memory for the buffer pool when using remote access MySQL

I tried to separate the webserver and mysql server. MySQL server = 16GB RAM and the config of Innodb_buffer_pool_size = 10GB. And my Web server = 4GB RAM My website connect to my database server ...
Rendy Proklamanta's user avatar
0 votes
0 answers
147 views

SQL remote connection with new user fails

Besides the sa user in the SQL server, I created a new user (called test) which only has read permissions. The user was created via MSSMS, with the following properties: Sql server authentication ...
Freya's user avatar
  • 173
0 votes
1 answer
2k views

Mysql Remote IP blocked

I have a peculiar issue with some database connections: I've got this (test) script on 2 different servers: $link = mysql_connect($db_server, $db_user, $db_passwd); if (!$link) { die('Could not ...
dvdmierden's user avatar
0 votes
0 answers
882 views

Can't connect to other instance of SQL Server 2012

I'm working through a Microsoft exam study book. I have set up 2 SQL Servers (both 2012 Standard on Server 2008 R2) and a DC. The book wants me to remotely connect SQL-A to SQL-B. Unfortunately the ...
Nikewatch's user avatar
  • 113
0 votes
1 answer
61 views

Can mariaDB contain indices only with data coming from remote tables?

I'm trying to think through a setup with a central mariaDB instance (A) accessing data on physically remote servers (B). All queries to the database (A) can be answered from indices only. Indices are ...
frequent's user avatar
  • 263
0 votes
1 answer
2k views

ORA-03114 Unable to connect to remote Oracle database

I have an Oracle Database installed on Oracle Linux Server which I'm trying to connect to from my PC. I have configured the listener in the following way [oracle@ol8ngs1 ~]$ lsnrctl status LSNRCTL ...
dontMashMe's user avatar
-1 votes
1 answer
140 views

Unable to connect to mysql remote

I am struggling to connect MySQL database with my application, I am having the following set up 3 Applications running in cluster mode and trying to connect with same DB. MySQL database running on ...
Umesh Awasthi's user avatar
-2 votes
1 answer
735 views

Connect an desktop application to my SQL Server using internet

I want to connect a desktop app to a SQL Server using internet, not local. The app will run on every network in the world with internet and the data will retrieve and send from my PC using SQL Server.....
Allan Ramirez's user avatar