Questions tagged [remote]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
3
votes
2answers
3k views

PostgreSQL error: remote query result rowtype does not match the specified FROM clause rowtype, on remote function call

This is my remote function: CREATE OR REPLACE FUNCTION public._test1() RETURNS record LANGUAGE plpgsql AS $function$ DECLARE rec record; BEGIN select 1,2 into rec; return rec; END $function$; ...
0
votes
0answers
16 views

Remote access problem - PostgreSQL

I'm don't know much about database management, so to enable the remote access to my postgresql db I followed some tutorials. I've updated pg_hba_conf and postgresql_conf files. In pg_hba_conf I added ...
0
votes
1answer
642 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 ...
0
votes
1answer
988 views

MongoDB, Getting Started and Connecting with Compass

I'm trying to connect to my mongoDB running as a service on my rPi3B+, using openSuse Tumbleweed 64bit, mongo version 3.6.2, from my laptop sharing the same LAN/Wifi (pi on LAN & laptop on Wifi). ...
0
votes
1answer
2k views

How to connect to remote MySQL from a specific IP?

I have two IPs (192.168.13.1 and 192.168.13.2) in my Server A and have provided select access to another Server B for secondary IP/virtual IP (192.168.13.2). mysql> show grants for web_app@192....
2
votes
0answers
2k 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 ...
3
votes
2answers
1k views

Unable to remotely connect to Postgresql 9.5 instance

I am struggling to connect to a remote Postgresql 9.5 instance running on Ubuntu 16.10. The usual: psql: could not connect to server: Connection timed out Is the server running on host "xx....
0
votes
1answer
17 views

Making an Oracle XE instance network wide available

Im fairly new to Oracle so please bear with me. I want to install an Oracle 18c XE DBMS on a server and access it's databases remotely via DBeaver. First of all there is some confusion on which client ...
0
votes
1answer
29 views

Remote PostgreSQL DB with local buffer … how could it look like

I have a sensor which is generating a data vector let's say every second (adjustable to up to 100 vectors per second) at a remote location. The location got 4G modem to send the data. Due to power ...
0
votes
1answer
369 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 ...
0
votes
1answer
42 views

MariaDB Galera + Remote Backup

I'm using CentOS 8 and I have a MariaDB 10.5.4 Galera set up with three nodes. Now, I want it to create a backup to my central server from time to time. I'm thinking of mysqldump but restoration would ...
0
votes
1answer
27 views

PostgreSQL remote access

I added remote host info on pg_hba.conf as: host db1 all 10.6.169.88/27 trust and also I did listen_addresses = ‘*’ tcpip_socket = true on postgresql.conf. But still the remote client can not ...
0
votes
0answers
41 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 ...
0
votes
1answer
18 views

Remote mysql only works from my computer, but no others

I need a direct connection to a MySQL server on a remote web server. So I've added to cpanel access hosts list an IP of the computer I wish to connect to the remote web server. But I can't connect, ...
5
votes
1answer
4k views

Windows to DB2 Connection: Connection authorization failure occurred. Reason: Local security service non-retryable error

Error creating SQL Model Connection connection to TSMDB1. (Error: [jcc][t4][2010][11246][3.68.61] Connection authorization failure occurred. Reason: Local security service non-retryable error. ...
0
votes
0answers
11 views

MS Access - used locally, want to move to use remotely

In my company we have an (old) MS Access software. (Used mainly to manage customers & invoices). In the software it's possible to choose the data file to work against (.mdb file). The goal is to ...
0
votes
1answer
33 views

Creating a database link from Oracle Cloud server to remote access database

I work for a small company that currently use Apex to run reports on our accounts system. Oracle is installed on our local server and part of the data is gained via a database link to an access ...
0
votes
1answer
212 views

How to insert into temp table on Server A results from dynamic SQL open query stored proc call to remote server B via Remote Query showplan operator?

I have to call a stored procedure on server B from server A using open query via dynamic SQL, and insert the results into a temp table created on server A. I noticed in the execution plan, it's using ...
2
votes
1answer
72 views

Is it possible to force a query to ignore the server option “remote proc transaction promotion” so it doesn't promote remote proc transaction?

I have a specific query that executes a stored procedure on a remote linked server and inserts the results into a local temp table. I don't want it to promote a remote procedure transaction but I can'...
18
votes
2answers
59k views

can't connect to remote postgresql database

I'm trying to connect to a remote psql database. Before I added the pg_hba.conf entry with the client's IP address, I was getting an error message : xdev@xdevbox:~$ psql -U postgres testdb -h 10.1.1....
0
votes
0answers
19 views

Backup ScyllaDB/Cassandra remotely with compression

How can I backup ScyllaDB/Cassandra remotely? With PostgreSQL I can do something like this (backup, zip, transfer): mkdir -p tmp/backup OUTFILE=tmp/backup/db_backup_`date +%Y-%m-%d_%H%M%S`.sql.xz ...
-1
votes
1answer
114 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 ...
0
votes
2answers
508 views

TNS connection forward

There are 3 machines as follows: Machine A - Remote Exadata DB machine Machine B - Remote machine from which only I can connect to port 1521 of Machine A Machine C - Local Machine (To run SQL ...
1
vote
4answers
2k views

How to make a remote mysqldump?

I know that's it's possible to do a remote mysqldump if I specify --host but is it possible to create the file in the remote server as well?
1
vote
2answers
728 views

How to Backup Remote Database to FTP server

I can connect to a remote SQL Server via Management Studio. But, when I create backups, they get created on the server's disk. How can I transfer them to an FTP server? I only have a login to the MS ...
2
votes
1answer
122 views

How to attach a sql db with blobs using a shared folder?

I use the following query for attaching a sql db: CREATE DATABASE [myDb] ON (FILENAME=N'C:\myDb\myDb.mdf'), (FILENAME=N'C:\myDb\myDb_log.ldf'), (FILENAME=N'C:\myDb\FILESTORE') FOR ATTACH In ...
0
votes
0answers
880 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: !...
4
votes
1answer
35k views

Connect to SQL Server over Internet

I want to connect to SQL Server via Internet: I turned off the firewall I enabled the the DMZ in the router, host address is 192.168.1.24 which is the SQL Server LAN IP I open port in the router for ...
2
votes
0answers
619 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 user@example.org user@...
1
vote
1answer
217 views

Read MS Sql query high latency w.r.t. Remote Query

I'm trying to read a table in a MS SQL Server using python, specifically SQLalchemy, pymssql, and pandas.read_sql. I want to execute the query, put the results into a pandas Dataframe, and continue on ...
0
votes
1answer
1k views

SQL Server Management Studio - Debugger buttons greyed

I have for mission to enable Transact SQL from a remote computer. My database is on a server and i'm trying to use the debug from a computer on the same network. My firewalls are all open on both side....
6
votes
4answers
7k views

Connect to SQL Server behind NAT from remote machine

The scenario is that this is a SQL Server behind a corporate firewall with your standard setup to allow only minimal outbound traffic and zero inbound. However, port 80/443 are open, per the usual ...
7
votes
1answer
7k views

SQL Server: Failed to start debugger - Data is Null

I'm a developer working on a web application using an instance of SQL Server 2014. I use Visual Studio 2010 sp1 for development. For a task I'm currently working on, I'd like to use the SQL Server ...
0
votes
2answers
115 views

Unable to connect oracle 12 database remotely while local connection works

I have two oracle test nodes. On node 2 as root I am able to connect without credential with the command, su - oraabc -c "/oracle/ABC/12102/bin/sqlplus / as sysdba" Output: SQL*Plus: Release 12.1.0....
0
votes
1answer
304 views

How to insert data from a local MSSQL db table to a remote MSSQL db table using WCF application coded in .NET [closed]

I made a WPF application using VS2013, coded in .NET. It is working fine in my local SQL Server. But I want to use it to upload data from a local database to a remote database. How can I do this? I ...
1
vote
1answer
2k views

Oracle database connection instant timeout

I have to check automatically if a connection to another database in oracle is vaild. I want a trigger to perform different actions based on whether the connection is vaild while it's running or not. ...
0
votes
1answer
156 views

Optimize Oracle 11g SQL*Plus connection for large remote SELECTs [closed]

Which options should I set in SQL*Plus for a script that runs multiple SELECTs, (some are JOINs) to SPOOL the results as text (CSV) in order to optimize these SELECTs, specifically one resulting in a ...
5
votes
1answer
5k views

Cannot remotely access PostgreSQL on EC2 instance

I was unable to access a remote AWS postgres database via things like psql -h *EC2ExternalIP* -U *me*. I would get: psql -h *EC2ExternalIP* -U *me* psql: could not connect to server: Operation timed ...
2
votes
1answer
28 views

Connecting to server which located remotely throws timeout exception

Below are the steps which I follow while connecting manually: Connect to VPN RDP to the remote machine using my credentials Open SQL Server Management Studio Connect to Server > database engine, ...
1
vote
2answers
953 views

Unable to update MySQL table from linked server on SQL Server 2014

I'm using SQL Server 2014, with a linked server to a MySQL database on AWS. I need to update rows on that linked server, using data that exists on another linked server. And if that wasn't complicated ...
2
votes
1answer
1k views

Remote Query Cost - High Row Count

I have a query that calls a remote table through Linked Server. However, in the execution plan the Remote Query is 71% of total cost and the time taken to run is over 4mins. It returns all rows in the ...
4
votes
4answers
10k views

Command line tool / script to backup a remote SQL Server database to local disk

I've been researching and googling for 10 hours and couldn't find anything, so I decided to ask here. I'm looking for a command line tool or a script (running under windows) that can backup a remote ...
1
vote
3answers
2k views

secure way to connect with remote Mysql database

I created my application using MySQL and it relies completely on the database I have around 190 tables, and I'm afraid of security breaches and another problem is for remote access I have to add the ...
0
votes
2answers
428 views

Unable to connect from remote computer, while local connection works

I have a Windows 2008 R2 64-bit server with SQL server 2008 R2 installed on it. I manage to log to SQL server with SSMS with the sa SQL account and with a test SQL account. But when I try to connect ...
2
votes
1answer
720 views

Remote login via rman working for one instance but not another

I have Oracle 12c installed on two servers. On server UAT I have an instance RMCAT that hosts an RMAN recovery catalog. On server EXT I have two instances, extdev02 and extuat01. I can use the ...
1
vote
0answers
4k 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 ...
3
votes
2answers
992 views

Connect to SQL Server on Linux over the network

I have setup Microsoft SQL Server on an Ubuntu VM. I know how to connect to SQL Server on Windows using SSMS -> but unfortunately I can not install SSMS on Ubuntu. Which leads me to the question ...
7
votes
2answers
41k views

Connecting to an external database with pgAdmin III

I'm trying to connect to an external database from pgAdmin III (which is installed on both machines). The client complains: Access to database denied The server doesn't grant access to the ...
0
votes
0answers
88 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 ...
0
votes
0answers
168 views

Tuning MySQL 5.0 / Linux TCP/IP settings for remote connections

I have installed MySQL 5.0 on a remote server over the internet and connected my JAVA application to it. It works fine, yet I see some delay retrieving results from the database compared to MySQL ...