Questions tagged [database]
Database is an organized collection of data.
206 questions
3
votes
0
answers
50
views
OracleDB: Encrypt Connection Descriptor In Network Communication
I have recently dumped the network traffic from my application server that talks to my Oracle database server.
I configured the Oracle DB server to encrypt the data using TLSv1.2 when sending over the ...
- 165
0
votes
0
answers
50
views
Database Migration from EOL CentOS to MariaDB 11.3.2: Seeking Advice on Potential Compatibility Issues
I am migrating a database from EOL CentOS Linux and am ready to import it into MariaDB 11.3.2 for Debian Linux.
The database code was made with MariaDB 10.19-11.4.1 for Linux (x86_64), which is NOT ...
0
votes
1
answer
73
views
ldd /usr/bin/pg_restore gives error not a dynamic executable
I am trying to determine the libraries needed for pg_restore in the official postgres:15 docker image, but when I run ldd /usr/bin/pg_restore inside the container it returns this error: not a dynamic ...
- 103
0
votes
1
answer
152
views
System call to remove content from file or Append it in the middle?
One issue that I ran into when making a custom database, without creating an entire block-chain based filesystem from scratch, is deletion and insertion from/to the middle.
It's easy to many a binary ...
0
votes
1
answer
882
views
system ID mismatch, node belongs to a different cluster
I have etcd cluster, and now trying to initialize patroni (on server A and server B), but whenever I try to do so I'm getting the error about cluster mismatch. Tried removing 'initialize' from etcd, ...
- 11
0
votes
1
answer
87
views
Script bash - Insertion of data into MariaDB from Oracle database
This script bash makes the data extraction to Oracle DB (another server), processing it and insert into MariaDB (my server), but the insertion it's misaligned and let it some columns in blank.
This ...
- 3
6
votes
1
answer
364
views
How do I go about identifying / using this (exotic?) .db file?
I own a Synology DS220J which I use to host a few different NFS shares / "Shared folders" (as DSM calls them), and I was snooping on some files in order to find out where the thing is ...
- 4,285
0
votes
2
answers
149
views
How to retrieve notes content without knotes?
Now that Knotes from KDE has been killed, buried, wiped from rolling release distros repositories, and also from my computer when trying to reinstall it while ignoring the situation, how can I get my ...
- 219
2
votes
4
answers
965
views
How can I append comma except lastline?
With following shell script,
I read file
and for each line
generates SQL fragments
#!/bin/bash
CURRDATE=$(date +'%Y-%m-%d %H:%M:%S')
echo $CURRDATE
echo $OUTPUT
echo "SET SESSION AUTOCOMMIT = ...
- 564
0
votes
1
answer
489
views
accessing docker database from other docker container(s)
This is a very confusing matter to me.
I have multiple containers, each comes with it's own database, which creates resources overhead.
I've deployed a mariadb container and I want the other ...
0
votes
0
answers
435
views
How to Fix "MySQL error message was : DBI connect failed : Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ?"
I upgraded my VPS with the provider Contabo, and since then, I have been experiencing issues. Unfortunately, they have not been responsive or provided any support.
when i do command : service mysql ...
- 1
0
votes
1
answer
63
views
need the menuconfig database in EXCEL?
Is there a way to obtain the help text, "selected by," "selects," and other fields for every configuration option, just like those available in the menuconfig, without running ...
- 1
1
vote
1
answer
3k
views
"Unable to lock database - Failed to synchronize databases"
I was trying to update the recommended stuff in my manjaro machine but this error occurred.
I have no idea how to solve it.
I was getting the error
Invalid or corrupted databases
so I updated the ...
- 53
1
vote
1
answer
1k
views
how to download postgres data in csv format through bash script?
I am able to connect to db also getting output but it's not coming in proper format. So how to get the output in csv like format and also want to save that in csv format.
psql -d <db> -U <...
- 113
0
votes
1
answer
67
views
Apache Ignite - Automatic Cluster Snapshot Create / Restore Procedure
When trying the Apache Ignite cluster snapshot procedure (snapshot create, restore), the restore operation is not successful.
Before the restore procedure, we have destroyed the cache which we want to ...
- 11
0
votes
0
answers
275
views
Looking for a simple database with graphical interface for personal use, under Linux
I am a former MacOS user, and I was using FileMaker, to organize one or two databases for my research work.
I am looking for something similar, to be used under Linux.
I would need something local, ...
- 565
0
votes
0
answers
263
views
PostgreSQL: indexes and partitions
I have a PostgreSQL database and I noticed a weird behaviour while working with indexes and partitions. The engine version is 10.21.
Now, I have a table with this structure:
guid varchar(50) PK
guid_a ...
1
vote
3
answers
1k
views
How to associate a file to an hash code, and use it to find the file anywhere in the filesystem
I would like to create a tool (a shell script, or maybe a Python script) to generate and associate an hash code to a file, and then be able to use that hash to retrieve the file in the filesystem (...
- 565
1
vote
0
answers
910
views
Unable to start PostgreSQL, error looks like its pointing to DB user not found
Asking for some assistance with trying to start postgresql-9.6.2 service using systemctl (systemd).
I'm installing a monitoring tool that installs an instance of PostgreSQL to support the tool. It ...
- 11
1
vote
1
answer
456
views
influx 1.8 query "first match of a value on a day"
I am using influx 1.8 to monitor my photovoltaik. I want to get much more informations out of the gathered data: everything is there, it must "only" be selected ;)
I have a measurement "...
- 43
2
votes
1
answer
3k
views
how does btrfs' copy-on-write feature influence with database application(such as postgresSQL)?
I'm working on manjaro KDE whoes whoal / partition (excepting /boot/efi partition, of course) has formated to btrfs filesystem, and its copy-on-write feature remains default.
Just now, I was following ...
- 135
1
vote
0
answers
1k
views
CentOs 8 Stream phpMyAdmin - "Access denied" when accessing via browser
after fresh install of phpMyAdmin on CentOS 8 Stream I've got problem with "Access Denied".
There isn't more than only simple text.
Console of browser says:
Failed to load resource: the ...
- 111
1
vote
1
answer
19k
views
How to check if DST (Daylight Saving Time) is inactive in CentOS different versions?
I have few servers with CentOS 7 and 6 as OS. Previously, the time was changed twice a year for DST and the OS automatically did this on each server.
now suddenly a law has been passed that changed ...
- 796
-1
votes
2
answers
210
views
Running SQL databases offline
I'm running a Debian 10 based distro. As an experiment, I downloaded one of these Wikipedia-like sites which gives you a download size of several gigabytes. I was hoping to run it offline.
I don't ...
- 503
0
votes
2
answers
3k
views
How can Nextcloud data be backed up and restored independently? (Versioning / Snapshots)
Whenever multiple users are interacting with a Nextcloud installation, there is a possibility of error. Potentially, a family member may delete an old picture or a co-worker might accidentally tick ...
- 83
0
votes
1
answer
255
views
saslpasswd2 support for Berkeley
I have SASL databases, used by postfix and generated with saslpasswd2, on several CentOS 7 machines ( saslpasswd2/LibSasl: 2.1.26 ). They have the Berkeley DB (hash, version 9, native byte-order) ...
- 81.4k
1
vote
0
answers
300
views
How to play .dvs (DTI's DVSSDiscPlayer format) on Linux systems?
.dvs is the exotic extension of a file / a database of files / a database of streams (cross out wrong). This type of file is used in the CCTV to let the operator watch the recording from, let's say, ...
- 111
0
votes
1
answer
689
views
Your database files were created by PostgreSQL version 13
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
...
- 1,579
0
votes
1
answer
4k
views
How can I run mariadb and phpmyadmin podman containers and access my database from phpmyadmin?
I want to run database on CentOS Stream system using podman containers and access it with phpmyadmin that is running on another container. I created my mariadb container using this command:
podman run ...
- 25
0
votes
1
answer
302
views
What would be a trivial or simple Time-of-check to time-of-use scenario in Bash?
Often when software development concepts are explained in Bash, I understand them better than say in JavaScript.
About Time-of-check to time-of-use (TOCTOU) it was stated in the current opening ...
- 281
1
vote
2
answers
40
views
Quickiest way to check root folders contents sameness?
I have some primitive solution but it is too long by runtime:
find "/home/user" -type d -printf "%P\n" | sort > "source_1d"
find "/mnt/home/user" -type d -...
- 61
0
votes
1
answer
161
views
MSSQL on Linux KDE neon 5.20 : Problem when installing the SQL Server command-line tools
Assumed you have already intalled successfully mssql-server on your KDE neon instance.
At the step to install mssql-tools and unixodbc-dev I have these errors :
sudo apt-get install mssql-tools ...
- 119
1
vote
1
answer
3k
views
connect mssql database on Centos 8 using php 7.4
I cannot figure out the way to connect MSSQL 2014 database on centos 8 using PhP 7.4.
I found GitHub link and downloaded CentOS8-7.4.tar
and extracted the php_sqlsrv_72_ts.so and php_pdo_sqlsrv_72_ts....
- 11
0
votes
1
answer
106
views
Can I install an Oracle DB on a Solaris 10/11 VM (not sparc)?
I have Solaris machines (10/11) which are running on VMware and I am intending on installing a DB on them.
Can I install on Oracle DB if it's not on sparc? if so- where can I find instructions?
If not-...
- 101
0
votes
2
answers
403
views
How to locate a file created through the eXist-db database tool eXide?
I'm trying to find a specific file: note.xml which eXide would seem to have saved. Where is it?
I've tried:
sudo find / -iname \*.xml | grep note
and a few varieties. Perhaps it's not "saved&...
1
vote
1
answer
240
views
Freebsd 12 i386 MongoDB package doesn't exist
Installed Freebsd 12.1 i386, when I am using pkg search mongodb I get "mongodb tools" and "mongodb C driver" and some other "mongodb" related packages but there is no ...
- 113
0
votes
0
answers
53
views
Is it possible to make a database file out of a project directory(containing C files)?
My requirement is to improve time for a pattern search (using grep or any other search tool) in a source code directory containing mainly C source files. I have a big code base that makes it difficult ...
- 309
1
vote
0
answers
141
views
exit code `zero` not showing for right `Command `
I get below error but exit code shows zero . Is there a way to get exit code of db error. Because I will need to send email alert on basis of exit code or db error
mysqldump: Couldn't execute 'SHOW ...
- 65
1
vote
1
answer
2k
views
ClamAV - getcvd: Verification: Can't verify database integrity error message when running freshclam
When I was running freshclam using ClamAV on Zorin Linux OS, it gave me the following errors as shown below. I am new to Linux, so I might need some hand-holding on solving this (step-by-step), if ...
0
votes
2
answers
1k
views
How to install BaseX on CentOS?
How do I install basex on CentOS?
[nsaunders@rolly ~]$
[nsaunders@rolly ~]$ sudo yum install basex
Last metadata expiration check: 0:16:02 ago on Mon 15 Jun 2020 05:19:44 PM PDT.
No match for ...
1
vote
1
answer
670
views
Updatedb include the path pointed by symbolic link
I have created mlocate database with the contents of a particular folder. I see that the updatedb doesn't include the path pointed by the symbolic links in the database.
How can I include the path ...
- 2,176
3
votes
0
answers
2k
views
OS linux ubuntu is killing my mongod service
I am facing this issue consistently, whenever I run some CPU and memory intensive processes so OS kills my mongod service. Due to which service goes into the failed state and everything stops.
...
- 133
0
votes
1
answer
69
views
How to partition the operating system with a small disk
I would like to know what partitioning scheme in RHEL7 is more recommended to configure on a server with little disk space where an Oracle 18c database will be installed.
On the RedHat site they ...
1
vote
1
answer
3k
views
How could I solve the error of psql: Argument list too long?
I have a script that contains the following psql command:
psql -h $PHOST -p $PPORT -U $PUSER -d $PDATABASE -c "SELECT COUNT(*) FROM (${SQL%?}) AS query;"
when I passed a simple query that query one ...
- 13
0
votes
1
answer
166
views
How do I patch in to a file only the insertions and modifications leaving the unmodified lines there?
I have a short file (around 60 lines) which acts like a basic database it has three whitespace separated columns. The first one is name of the product, the second one is the price and the third one is ...
- 147
2
votes
3
answers
3k
views
Is there any inventory software that can create a database from a barcode scanner?
I need to create an inventory on a spreadsheet of all of the books, DVDs, VHS tapes, and cassette tapes in my office. Since there are 3000+ items, this could take a long time. I bought a barcode ...
- 4,277
1
vote
0
answers
309
views
SQL SERVER (LINUX) – syspolicy_purge_history job failing step 3: Erase Phantom System Health Records
No one out there seems to have an answer for this...everything is for windows and no help for those using linux to run SQL Server 2019. Problem is that the 3rd step in this process is to run ...
- 11
0
votes
2
answers
768
views
Filtering rows of a dataframe with AWK to only show entries in a given field with X instances
I have a large dataframe, in which one of the fields("ID") correspond to a unique identifier. However, there are multiple instances of that value, depending on the binary combination of additional ...
- 73
0
votes
1
answer
4k
views
Can we install Oracle Database on Windows Subsystem for Linux
I tried to install Oracle Database on Windows Subsystem for LINUX and when i tried to execute command
./runInstaller following error occured
ERROR: Unable to verify the graphical display setup. This ...
2
votes
1
answer
1k
views
Why is there a ROOT (as opposed to root) account for MySQL and MariaDB?
As far as I can tell, the MySQL and MariaDB database "ROOT" account is completely separate from the operating system's "root" account. Why did someone consider it a good idea to create the ambiguous ...
- 60