Questions tagged [remote]
The remote tag has no usage guidance.
136
questions
0
votes
1
answer
522
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 ...
CommunityBot
- 1
1
vote
1
answer
919
views
MariaDB bound to 0.0.0.0, but doesn't appear to be listening to all IPs?
My 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 192.168.1.10 ...
CommunityBot
- 1
0
votes
0
answers
20
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?
...
- 101
4
votes
5
answers
19k
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 ...
- 485
0
votes
1
answer
2k
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 = &...
CommunityBot
- 1
0
votes
0
answers
47
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 ...
- 101
0
votes
1
answer
1k
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 ...
CommunityBot
- 1
2
votes
3
answers
40
views
How do I block all IP addresses from connecting remotely to Cassandra?
I want access to remote cassandra with one ip address. how can I change cassandra.yaml to block all ip address except ip that I want to connect?
Can I do by cassandra.yaml ?
- 2,697
1
vote
1
answer
130
views
Enable remote access to database via proxy server
What's the most painless way to create something like a proxy server so that my dev team can access a database from anywhere?
The server in question is a managed MongoDB database. Currently, I am just ...
- 121
0
votes
1
answer
206
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 ...
- 2,632
1
vote
2
answers
3k
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....
CommunityBot
- 1
2
votes
2
answers
8k
views
Connecting remote MySQL database to local MySQL database?
I want to write PHP code to be embedded in a Drupal7 module.
I want to call a procedure which can copy newly generated data in the local MySQL database to a remote MySQL database.
When data is ...
0
votes
2
answers
4k
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
23
votes
2
answers
83k
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....
- 1
1
vote
1
answer
535
views
How to set up MySQL remote hosts IP address for users with dynamic IP's
Background
I need remote access from my Delphi PC application to a MySQL database hosted on a shared server at my ISP. This DB is not associated with any web site. All there is on my ISP account is ...
- 12.6k
0
votes
1
answer
47
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 ...
- 39.5k
0
votes
1
answer
685
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 ...
CommunityBot
- 1
0
votes
1
answer
902
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 ...
- 109
0
votes
1
answer
210
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
...
- 101
-1
votes
1
answer
363
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".
...
- 44.3k
0
votes
3
answers
265
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 ...
- 44.3k
4
votes
2
answers
8k
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$;
...
- 141
0
votes
1
answer
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).
...
CommunityBot
- 1
2
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
...
3
votes
2
answers
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....
- 111
0
votes
1
answer
591
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 ...
- 2,724
0
votes
1
answer
144
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 ...
- 78.3k
0
votes
1
answer
578
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 ...
- 7,238
0
votes
1
answer
80
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 ...
- 111
1
vote
0
answers
3k
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 ...
- 221
0
votes
1
answer
226
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, ...
- 135
5
votes
1
answer
7k
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. ...
- 24.3k
0
votes
1
answer
470
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 ...
- 2,724
0
votes
1
answer
2k
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 ...
- 80.3k
2
votes
1
answer
376
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'...
- 80.3k
-1
votes
1
answer
135
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 ...
CommunityBot
- 1
0
votes
2
answers
671
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 ...
CommunityBot
- 1
1
vote
4
answers
3k
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?
- 179k
1
vote
2
answers
979
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 ...
CommunityBot
- 1
2
votes
1
answer
404
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 ...
- 452
0
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:
!...
5
votes
1
answer
47k
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 ...
- 7,889
2
votes
0
answers
1k
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@...
CommunityBot
- 1
1
vote
1
answer
322
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 ...
CommunityBot
- 1
0
votes
1
answer
4k
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....
- 10.9k
6
votes
4
answers
8k
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 ...
- 80.3k
7
votes
1
answer
8k
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
2
answers
276
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....
- 39.5k
0
votes
1
answer
2k
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 ...
- 24.4k
1
vote
1
answer
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. ...
CommunityBot
- 1