Questions tagged [database]
Database is an organized collection of data.
204
questions
-2
votes
0
answers
54
views
Malicious code - find in database linuux
I'm looking to locate a what looks look a base 64 malicious code. The code changes everytime it's loaded so I'm unable to search for anything specific, however, the amount of characters seem to be ...
0
votes
0
answers
13
views
ShellOS pacman cannot find database file (Arch derivative)
Currently running theShell OS 7.0 (Arch variant) on a VM. I went to update the software (as this version is several years out of date) and pacman just spat this out:
~ $ Welcome, user. Enter command: ...
- 11
0
votes
0
answers
25
views
How to rename a one file name with another file part name in the same directory?
the database I am using is Unix and I am trying to automate where I want it to rename the file for me when I run it instead of me going to file and manually rename it.
For example.
Two files in the ...
- 1
0
votes
1
answer
43
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
0
votes
0
answers
43
views
nslookup dbwr-scan does not have desired results on Rocky Linux 8.7
The following command fails to resolve the scan addresses
-------------------------------------------------
[root@dbwr1 ~]# nslookup dbwr-scan
Server: 192.168.1.1
Address: 192.168.1.1#53
Non-...
- 1
1
vote
1
answer
699
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 ...
- 41
0
votes
1
answer
300
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 <...
- 103
0
votes
1
answer
26
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
50
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, ...
- 407
0
votes
0
answers
53
views
InfluxDB InfluxQL v1.8 : Wrong timestamp used for writing to database
I wrote a bash script for inserting the summary of the daily energy database "xxx_d" into the monthly database "xxx_m" - triggered on every 1st day of the month at 02 o'clock by a ...
- 1
0
votes
0
answers
18
views
RMAN backup restoration
restoring datafile 00091 to /u02/oradata/hfd1/user/def04.dbf
Channel ORA_DISK_1: reading from backup piece /orac/backups/monthly/hfd2_rman_backup_monthly/rman_backup_04042023/HFD2_DB_bvlopk46_14719_1
...
- 2,732
0
votes
0
answers
114
views
Connection error: (Unable to connect to any servers, {127.0.0.1:9042: ConnectionRefusedError(111, Tried connecting to [(127.0.0.1, 9042)]
Sometimes when I try cqlsh command on my Ubuntu 22.04 machine I get the following error:
Connection error: (Unable to connect to any servers, {127.0.0.1:9042:
ConnectionRefusedError(111, Tried ...
- 158
0
votes
0
answers
22
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 ...
0
votes
0
answers
114
views
Why should we run "Cassandra" before we can run "cqlsh" command?
I have installed Cassandra via apt install cassandra on Ubuntu 22.04 and enabled and started systemd/ cassandra.service and when I try systemctl status cassandra I get this result:
cassandra.service -...
- 158
0
votes
3
answers
321
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 (...
- 407
1
vote
0
answers
555
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
0
votes
0
answers
14
views
Infinispan 13.0 connection increasing gradually during performance testing
I am using Infinispan 13.0. During the performance testing the Infinispan connection increasing gradually but after completing the performance testing this connection was not closed.
In older version, ...
- 1
0
votes
0
answers
103
views
Mismatch in the SID being used and that is causing the problem in connecting to DB
So i have error in Oracle Fusion Middleware, and server listen OSBPDB Service Name, but i need to change to listen on XEPDB1. How to do it? Does anyone know?
Error is
oracle.security.jps.JpsException: ...
- 1
1
vote
1
answer
142
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 "...
- 31
0
votes
1
answer
1k
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 ...
- 13
1
vote
0
answers
747
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 ...
- 11
0
votes
1
answer
9k
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 ...
- 726
0
votes
1
answer
63
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 ...
- 103
0
votes
2
answers
2k
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 ...
- 73
0
votes
1
answer
142
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) ...
- 78.4k
1
vote
0
answers
128
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
581
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,529
0
votes
1
answer
2k
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
141
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 ...
- 251
1
vote
2
answers
26
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
113
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 ...
- 79
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
73
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
264
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
185
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
38
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 ...
- 229
1
vote
0
answers
113
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
771
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
443
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 updatebd doesn't include the path pointed by the symbolic links in the database.
How can I include the path ...
- 1,700
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
30
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
2k
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
47
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
2k
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,715
1
vote
0
answers
161
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
401
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 ...
- 43
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
599
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 ...
- 50
2
votes
0
answers
45
views
The best choice database (millions files - most less than 100 mb) [closed]
What the best choice to use in my case? ANy suggestion? I have millions of file (70 millions today) - (most less than 100mb), but I need to use a databse for indexes and store this file.
...
