Questions tagged [remote]
The remote tag has no usage guidance.
134
questions
0
votes
1answer
23 views
Different response time because it does not use the indexes created with the same query and same tables from the web server to the Oracle database
I have a database with Oracle 12c (12.1), where when making a query locally and even from TOAD or another remote tool, it returns the response in milliseconds, reviewing the execution plan I can see ...
0
votes
1answer
79 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 ...
0
votes
1answer
37 views
Your database files were created by PostgreSQL version 13 [closed]
OS is openSUSE Tumbleweed. Previously I had PostgreSQL 13 installed. I just removed it by:
> sudo zypper rm 'postgres*'
> sudo zypper rr PostgreSQL
> sudo rm -rf /usr/local/var/postgres
...
0
votes
1answer
382 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 = &...
1
vote
1answer
79 views
MySQL (MariaDB) bound to 0.0.0.0, but doesn't appear to be listening to all IPs?
My MySQL (actually MariaDB) server accepts connections at port 43210 without problems on the public IP address of, we'll say, 123.123.123.123 on eth0. This is on an Ubuntu 18.04 server that also has ...
0
votes
1answer
180 views
Changes to server configuration option remote access are not supported in SQL Database Managed Instances
Having just set up our new SQL Server Managed Instance, restored a sample database for testing, and run Azure's vulnerability assessment, it produces this high risk finding:
VA2120 - Features that ...
-1
votes
1answer
55 views
Connect to remote sql server is possible only by ipaddress\sqlinstance,portnumber?
I've configured a remote Sql server on host machine. I have performed the follwing steps :
Under Remote Server Connections, check the box against "Allow remote connections to this server".
...
0
votes
3answers
100 views
Allow user to create databases on server and to see only the databases that are created by him, without creating login first
I want to implement the following use case using C# application and MS SQL Server Express 2014. I have a centralized database server in which there are already created some database (which have the ...
0
votes
0answers
166 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
166 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
56 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
284 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
0answers
2k 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
30 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, ...
0
votes
1answer
41 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
1answer
152 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
1k 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
181 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'...
2
votes
1answer
223 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
2k 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:
!...
0
votes
1answer
1k 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).
...
3
votes
2answers
4k 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$;
...
2
votes
0answers
841 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@...
0
votes
1answer
3k 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....
0
votes
2answers
154 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
411 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
957 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 ...
0
votes
1answer
204 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 ...
6
votes
1answer
8k 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
46 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
1k 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 ...
4
votes
4answers
14k 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 ...
0
votes
2answers
627 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
1k 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
5k 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
3k 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 ...
0
votes
0answers
106 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
...
1
vote
1answer
72 views
MariaDB ran mysql_secure_installation, but seeing remote login attemps in logs
I installed MariaDB and ran mysql_secure_installation and answered yes to all questions to remove anonymous user, test DB, remote login, etc.
However, I recently had MariaDB crash and in checking the ...
1
vote
1answer
3k 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
2answers
603 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
2answers
840 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 ...
0
votes
1answer
3k views
Unable to connect to SQL Server 2016 remotely
I am trying to access SQL Server 2016 from outside of my network but each time I try I get this error message.
A network-related or instance-specific error occurred while establishing a connection ...
1
vote
1answer
2k views
How to connect to a SQL Server installed on Windows Server 2012 running on VPS?
I want to connect to my SQL server installed on a windows server 2012, that is running on a VPS(Virtual Private Server) remotely, I have done the following steps:
Enabling SQL Server to allow remote ...
2
votes
1answer
106 views
Is there a server option which limits the amount of rows returned by a remote query?
I have an issue where a system on our network is making a query (select * from table) which might result in 0 to 70k rows being returned.
For large result sets, say around 50k, the calling system is ...
0
votes
1answer
3k views
Connecting to mySQL from 2 different machines
ALL,
Is it possible to modify the permissions of the MySQL DB or I will need to revoke it and grant it again?
My problem is as follows:
I'm running MySQL server on Gentoo Linux and I'm trying to ...
5
votes
1answer
41k 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
1answer
337 views
How to replicate schema changes from local database to a remote?
I was working with some big database and I want to replicate local changes from a local database (I just added some columns to a few tables) to a remote database on other server.
The thing is that I ...
1
vote
1answer
72 views
Enabling both local and remote connections to a mysql server on linux (ubuntu)
Is there any way to enable both remote connections and connections via "localhost" to a mysql server. I tried adding both
bind-address = 127.0.0.1
and
bind-address = externalIP
but it just used ...
0
votes
2answers
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....
3
votes
2answers
2k 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....
