Questions tagged [linux]
A widely-used open-source operating system that is particularly popular on servers.
992
questions
1
vote
0
answers
78
views
TDE error when attempting to encrypt a datafile
I'm encountering error
ORA-28374: typed master key not found in wallet
when attempting to run
alter database datafile '+DATA/testdb/datafile/users.2514.1233355332' encrypt;
against an 11g database ...
- 51
0
votes
1
answer
241
views
How do I know my Oracle database is correctly configured and running?
I've installed a fresh Oracle 19.3 on Linux CentOS 8.3. I used the install steps (manual install) from this official Oracle guide.
I tried to start the DB using the standard script:
[oracle@localhost ...
- 11
0
votes
1
answer
537
views
Reset Root Password MySQL on Ubuntu
I know there are tons of posts about this on here but nothing seems to work. I have tried every command I could find it will not work.
I just recently setup mysql on Ubuntu (SQL version is 8.0.23-...
- 1
0
votes
1
answer
718
views
'Could not fsync file' while running VACUUM FULL on a table
I'm getting an error for around half of my tables in Postgres while trying to run VACUUM FULL.
For example, I have a table named 'qwerty', and when i try to vacuum it i get the following error:
ERROR:...
-1
votes
1
answer
406
views
Database not showing
I create a database in the terminal linux ubuntu,gave it all privileges,created the table,inserted the rows.When I open phpmyadmin the database isn't showing how do I connect them?
I did use mysql -u ...
- 1
0
votes
0
answers
101
views
Can I safely delete /var/log/messages-20210328 which is 383M under / directory ? OS version:Oracle Linux Server 6.7. db version Oracle 11g
the content of file is displayed using
# cat /var/log/messages-20210328
Output:
Mar 21 04:31:11 testdb snmpd[17566]: Connection from UDP: [*.*.*.274]:61775->[*.*.*.*]
Mar 21 04:31:11 testdb snmpd[...
0
votes
1
answer
372
views
mysqld_pre_systemd fails when starting MySQL on Fedora
I installed MySQL using dnf (I'm on fedora) and from the officials rpm on the website. Both had the same problem : I have an error when I do systemctl start mysqld.service.
So I checked systemctl ...
- 1
0
votes
0
answers
72
views
SQL Server 2019 on Ubuntu Throwing security.crypto.symkey errors
I'm repeatedly seeing the following error, seemingly for every connection to SQL:
04/06/2021 16:39:25.890647613 Error [security.crypto.symkey] <0000004241/0x00000c34> Setting Variable Length ...
- 101
-1
votes
1
answer
495
views
Linux PostgreSQL mount data from external ntfs disk [closed]
I have similar problem as here: Postgres tablespace on mounted usb
I want to have access to my DB on external hard drive from Raspbian and Windows 10. Not simultaneously. I just want cross-platform DB ...
- 1
0
votes
2
answers
6k
views
mysql: [ERROR] unknown variable 'default-authentication-plugin=mysql_native_password' [closed]
When I installed MySQL 8.0, I selected sha256 password authentication method instead of legacy, When I tried to return to native password authentication it shows an error message:
mysql: [ERROR] ...
0
votes
1
answer
244
views
sqlcmd is running but database shown no running query
We are facing this weird issue on our Azure setup. The database is SQLServer and client is CentOS.
We fire queries using sqlcmd. Sometimes it happens that you see the sqlcmd running, but there is no ...
- 101
1
vote
1
answer
669
views
postgresql + how to recover the wals files
we have postgresql version 9.x on rhel machine , postgresql is the DB of the ambari server
some of the files under folder - /var/lib/pgsql/data/pg_xlog was deleted by mistake
from total 487 files only ...
- 11
-1
votes
1
answer
102
views
Importing big MySQL Database
I am trying to import a 6GB database on RHEL7.
I have been reading for
Here are my main settings in my.cnf:
Why downvote? You are just making sure nobody else will help who needs help.
Please let me ...
- 99
2
votes
1
answer
100
views
Restore from local disk vs SAN on physical machine (SQL Server Linux)
I am new to Linux and our client decided to use SQL Server on Linux. As soon as we started testing, we ran into performance issues.
The server in question is a physical machine configured with a SSD ...
- 171
1
vote
2
answers
10k
views
How to auto start oracle listener on Linux with machine restart?
I've a Linux VM with Oracle database serve and it gets restarted periodically and hence next time, oracle listener is not running. So I've to start it manually with following commands -
export ...
- 153
0
votes
0
answers
260
views
MySql Service is not running in Linux
I am trying to run xampp on linux through terminal, but mysql database is not running
after running the command to start Xampp server I get following output
Starting XAMPP for Linux 8.0.2-0...
XAMPP: ...
michael johnson
1
vote
1
answer
201
views
SQL 2019 Linux, slow at GUI fast at sqlcmd/Query Analyzer
Server information
OS Redhat 7
Memory 100GB
CPU usage 1%
User db size 2 gb each on avg
total 7 user databases
SSMS installed on a jump server
Azure Data studio is also installed
App Gui on application ...
- 171
0
votes
1
answer
200
views
Dumping mssql db from one server and restoring on another on Mac/Linux
Using either MacOS or Linux, my objective is to copy a database from one MSSQL database server to another. The source database server is remote, while the target database server (which will be ...
- 219
0
votes
0
answers
756
views
pg_cron connection refused with postgres login
I am trying to run a function periodically with pg_cron but every time it wants to execute it throws connection refused. the cron job is created using the postgres user.
pg_hba.conf
local all ...
rafaelBackx
1
vote
1
answer
227
views
Wordpress query on MyISAM tables in MariaDB on ZFS takes too long to execute
I use a pretty common setup, some wordpress sites running on Debian 10 (Buster) with mariadb 10.3.27 on ZFS, on a decent server with SSDs and lots of RAM, pretty smooth operation with low CPU ...
- 113
0
votes
1
answer
1k
views
Reverse-proxy for SQL Server
Context: For our testing environment, we were migrating from on-premise SQL Server 2017 to Docker Linux SQL 2017 container. There is a large number of TestScripts in windows that try to connect to ...
- 101
1
vote
1
answer
456
views
Linux Volumes for SQL Server + Docker on Linux [closed]
I am testing out a POC project for SQL on Docker containers on Linux and wanted some background info on how to request the storage on the Linux VM. The plan is to spin up 10 containers with SQL 2019 ...
- 625
1
vote
0
answers
144
views
Help me tune Mysql instance to support more users
I'm currently supporting, A Moodle 3.10 instance, running MySQL 8.0.20. This is running through an Azure Provider as a Standard DS11(2 vcpus, 14 GiB memory). Running as a LAMP stack server.
Currently, ...
1
vote
1
answer
684
views
Why is my Postgres database working for a while and then not able to “start server” once restarted?
Recently, I've started playing around with an old Raspberry Pi 3 b+, and I thought it would be good practice to host a Postgres database on my local network and use it for whatever I want to work ...
- 11
1
vote
1
answer
2k
views
PostgreSQL backup + gzip
We have a need to send PostgreSQL DB backup to CRM developer.
We send them and get feedback that the backup can't be "uzipped", as archive is broken.
The backup script snippet looks like ...
- 119
0
votes
1
answer
2k
views
PostgreSQL Linux PAM Authentication Error
I'm using PSQL version 12.5 on Ubuntu 20.04.1. My pg_hba.conf file looks like this:
# DO NOT DISABLE!
# If you change this first entry you will need to make sure that the
# database superuser can ...
- 103
0
votes
0
answers
141
views
Restore specific date from mysql dump file
i have a big mysql dump-file since 2015 i want to restore all data form 2020 and 2021
Note : schema have a lot of tables and every table have it's own data
and we didn't want all table we need only 3 ...
Islam Edres
1
vote
3
answers
582
views
Many MYSQL processes on Linux
Recently I deploy my parser on server and sometime server start reboot from out of memory, i spectate for memory and find something, exactly after every using parser, (one time on day) ram memory ...
- 21
-1
votes
1
answer
2k
views
barman + how to cleanup the wals folder
we are using the barman - backup and restore for postgresql
we noticed the under folder usage - /var/lib/barman/main-db-server/wals is 110G
example to what we have
824M /var/lib/barman/main-db-...
- 11
0
votes
0
answers
618
views
How can I check my config files my.cnf for example
I have 2 config files, master.cnf and slave.cnf, each containing a group [mysdql0] or [mysqld1] respectively.
I have an almost identical setup across different servers and all but one work correctly ...
- 23
1
vote
0
answers
518
views
Unable to use SSL Certificates in SQL Server on Linux
Hello everyone so here is the problem:
SQL Server 2019 installed on Ubuntu 20.04 (working before setting SSL certificates)
I was following the Official guide of Microsoft to secure my SQL server with ...
- 111
-1
votes
1
answer
51
views
sqlserver on linux Azure performance [duplicate]
Im new to sqlserver, we have a sqlserver running on linux and we are encountering performance issues
i see sometimes SUSPENDED on the queries / selects etc
If i change the max degree of parallelism ...
- 1
1
vote
1
answer
945
views
Automatically and robustly restarting a Galera cluster
Galera clusters, somewhat famously, have a requirement that nodes need to be shut down and brought back up again in a certain order.
There are a few questions here and on other sites about recovering ...
- 115
1
vote
1
answer
2k
views
Ident authentication failed for user "postgres"
I am using PostgreSQL12 on Cent0S8, and I am able to connect to PostgreSQL using the command:
sudo -u postgres psql
However, when I attempt to connect using:
psql -U postgres -h localhost
I recieve ...
- 113
0
votes
0
answers
2k
views
Cannot start new MySQL process - Linux
I have created a new MySQL cluster by this:
mysqld --initialize-insecure --basedir=/var/lib --datadir=/var/lib/mysql2 --defaults-file=/etc/my2.cnf
chown -R mysql:mysql /var/lib/mysql2
chmod 777 /var/...
0
votes
0
answers
1k
views
MariaDB failed to start
I have to fix an issue on a VM for a website that use Mariadb technology. When I type "systemctl start mariadb", it shows :
Job for mariadb.service failed because the control process exited ...
Raphaël -
0
votes
0
answers
872
views
After installing MariaDB, mysql_secure_installation produces error, cannot connect mysqld.sock
After installing MariaDB, mysql_secure_installation produces the error:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
A review of /var/run/...
bittids
0
votes
1
answer
411
views
MySQL Installation: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
Tried to install MySQL on Ubuntu, with these 3 commands:
sudo apt update
sudo apt install mysql-server
mysql_secure_installation
When running the last command, it asks for the password for the root ...
- 101
0
votes
1
answer
233
views
Can't connect to MySQL from remote computer
A MySQL Server is newly installed on linux computer LPNBUNTU.
On local linux I can get a DB-connection and I was finally able to set a root password.
When connected I get
MYSQL>status
root@...
- 101
2
votes
1
answer
6k
views
postgresql: Invalid data directory | Can't open PID file /var/run/postgresql/10-main.pid (yet?) after start: No such file or directory
This error is showing after running this command: sudo systemctl status [email protected]
[email protected] - PostgreSQL Cluster 10-main
Loaded: loaded (/lib/systemd/system/...
- 121
4
votes
1
answer
28k
views
check history along with dates for queries in Postgres
I am running PostgreSQL on my Linux terminal and If we do select pg_backend_pid(); it gives pid for specific session.
Below gives us only the last query executed
select pid,
usename as username,...
- 279
0
votes
1
answer
4k
views
How to access an Oracle database from linux
We have a legacy Oracle database hosting all of the information for a now shutdown website, we need to keep the data on the DB available for a period of time due to GDPR etc. We have had some requests ...
0
votes
2
answers
675
views
How to connect to pluggable database using ipc in Oracle XE 18c?
Here is my listener configuration:
LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 20-NOV-2020 20:01:25
Copyright (c) 1991, 2018, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(...
- 105
0
votes
1
answer
317
views
Cannot login oracle database using other users
I'm currently using oracle xe c18. I can login using sqlplus / AS SYSDBA as oracle user. However, the command does not work for other users. It always shows an error ORA-01017: invalid username/...
- 105
2
votes
1
answer
781
views
Permission error when restoring MsSQL database with full text on Linux
I'm trying to restore a .bak file created on Windows SQL Server to the Linux version of MSSQL, but I get an error like the following:
Msg 7610, Level 16, State 1, Line 112
Access is denied to "/...
- 123
0
votes
0
answers
300
views
CentOS 8 Unable to connect to PostgreSQL 12 Server
When I attempt to connect to postgres in from my linux command line, I receive the following error:
[lloyd@localhost ~]$ sudo -u postgres psql
could not change directory to "/home/lloyd": ...
- 113
0
votes
1
answer
61
views
Unable to connect to DB server from another machine in the same private network
I was setting up a Postgresql DB using Ansible and I was able to successfully install the DB.
My problem is that the DB machine is inside a private network (10.0.0.0/16), but when I try to connect to ...
1
vote
1
answer
4k
views
MySqldump Error 2013: Lost Connection MySQL During create database backup
I am use Prestashop.
am create a script for auto backup of whole database of my site
but from last few given this error and backup terminate at this table.
mysqldump: Error 2013: Lost connection to ...
Sayyed Yusuf Raza
0
votes
0
answers
2k
views
PostgreSQL 12 problem restoring from pg_basebackup on CentOS8
I have recently created a Postgres backup, and attempted to use this backup, at which point I recieve the following error, when I try to start the server with - start postgresql-12.service, I get
:
...
- 113
1
vote
0
answers
374
views
WSL2 Docker Oracle volume mapping: how to switch from Windows to Linux file system
I am running Oracle (V19, V18, and V12) instances under WSL2 (Windows 10 version 2004). For persistence, my Oracle data files are mapped to a folder on my Windows host. I can run the containers from ...
- 131