Questions tagged [linux]
A widely-used open-source operating system that is particularly popular on servers.
1,017 questions
0
votes
0
answers
19
views
Configure Postgres to listen to VRF interface
I'm looking into Linux VRFs i.e. support for virtual routing and forwarding.
The documentation mentions:
Applications that are to work within a VRF need to bind their socket to the VRF device:
...
- 101
0
votes
1
answer
45
views
Create initial Informix dbspace on a new server from script
I'm able to create a new dbspace using the semi-gui tool onmonitor (running a headless Linux server)
But how can I do this from cmd-line / script?
It seems you can use onspaces like
onspaces -c -d $...
- 203
0
votes
1
answer
76
views
Clickhouse - Oracle ODBC connection error
I am trying to create connection between my oracle and clickhouse databases, so I could query oracle through ch like this: SELECT * FROM odbc('DSN=OracleODBC-21', 'sys', 'test'). I have successfully ...
- 101
-2
votes
1
answer
54
views
Not able to start Mysql located into many places
How can i start mysql in Ubuntu? i run whereis and more than one place where mysql is located :
(base) myuser@mypc:~/Documents/mysql-tutorial$ whereis mysql
mysql: /usr/bin/mysql /usr/lib/mysql /etc/...
- 107
1
vote
1
answer
66
views
What are recycled-commitlogs?
Cassandra/ScyllaDB
I have a node with 51000+ recycled commitlogs and want to know if I can just blitz them.
I am Linux not Scylla/Cassandra but these are filling up a datadisk. Normal commitlogs ...
- 11
1
vote
0
answers
29
views
where is your vendor location from Composer?
My vendor directory from Composer is in the Home directory of my Linux user account. And I am very allergic to loading files into projects with something arbitrary as the user account name in the ...
- 43
2
votes
1
answer
232
views
Have multiple users for your DB per action?
I installed my mariaDB and phpMyAdmin. I created a new user with all the Grand and Super priveleges. And I deleted the "root" user for savety.
Perfect.
As I follow an article: make a ...
- 43
1
vote
0
answers
113
views
MariaDB 4-5 times slower than Oracle
since Oracle will increase the costs for running databases my employer is currently evaluating alternatives for oracle databases.
In one application we currently use oracle db with no specific ...
- 11
1
vote
0
answers
32
views
Why are there so many extra cwallet and ewallet files in our OCI DB server TDE folder?
We are trying to turn on data guard cross-region replication on our test OCI database instance. This database is installed on a Linux server. When we try to turn on data guard, we get an error that ...
- 111
0
votes
0
answers
177
views
Issue with Microsoft SQL Server on Ubuntu 24.04
Hello I tried to search for an answer and I couldn't find an answer and maybe someone can help me with something.
I installed Microsoft SQL Server 2022 on Ubuntu 24.04, I allowed port 1433 and 1434.I ...
3
votes
1
answer
206
views
xp_delete_file on linux throws Login failed for user 'servername\Administrator'
We are running a newly set up SQL Server Docker container (mcr.microsoft.com/mssql/server:2019-CU32-ubuntu-20.04). All user databases are restored from an Windows SQL Server installation and so far ...
- 31
0
votes
0
answers
97
views
PSQL: postgres could not open file for writing: permission denied
On my Linux machine, the SQL COPY TO command fails trying to copy to the file fdo.txt. The file access control list for this file is as follows:
# file: home/kaj/fd/fdo.txt
# owner: postgres
# group: ...
- 1
0
votes
1
answer
127
views
How to start mariadb/mysql instances at boot?
I've got a file /etc/mysql/mysqld_multi_cls.cnf with everyting mariadb needs for multiple database instances.
I can start these instances with the following command:
sudo mariadbd-multi --defaults-...
- 43
0
votes
1
answer
84
views
Extra instance of MariaDB or mysql in Debian Linux doesn't work when I change a name during the setup
-- EDIT -- Complete setup in the answer below. -- EDIT --
When I follow an article (link below) on how to setup a extra MariaDB or Mysql on Linux, and it works. However, I don't like the name "...
- 43
0
votes
1
answer
186
views
Is it possible to use PgAdmin 4 over SSH tunnel and 'sudo su - postgres'?
I want to use GUI, e.g., PgAdmin 4, on a PotsgreSQL on Red Hat Enterprise Linux 9, and my Linux username has SUDO permissions.
With command line, I will login through SSH, and call sudo su - postgres, ...
- 57