Skip to main content

Questions tagged [database]

Database is an organized collection of data.

Filter by
Sorted by
Tagged with
0 votes
0 answers
10 views

SAN GPFS for db2 hadr share archive log

Did any one use SAN GPFS for db2 hadr shared archive log. Or any other solution for shared archive log between 2 different Sites. Primary site has 2 databasea and DR site has 2 AUX databases
Khattak's user avatar
0 votes
1 answer
225 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 ...
Abd Alhaleem Bakkor's user avatar
0 votes
0 answers
175 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 ...
MD.Favaz's user avatar
0 votes
0 answers
26 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: ...
Kami-kun's user avatar
0 votes
1 answer
46 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 ...
shuagga's user avatar
1 vote
1 answer
2k 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 ...
Educpf's user avatar
  • 53
1 vote
1 answer
904 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 <...
zircon's user avatar
  • 113
0 votes
1 answer
28 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 ...
cookie_marsh's user avatar
0 votes
0 answers
148 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, ...
Fabio's user avatar
  • 487
0 votes
0 answers
101 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 ...
Federico Loro's user avatar
1 vote
3 answers
760 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 (...
Fabio's user avatar
  • 487
1 vote
0 answers
796 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 ...
A.brashear's user avatar
1 vote
1 answer
336 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 "...
DF8OE's user avatar
  • 33
1 vote
1 answer
2k 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 ...
KSroido's user avatar
  • 25
1 vote
0 answers
959 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 ...
kalview's user avatar
  • 111
0 votes
1 answer
15k 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 ...
BlackCrystal's user avatar
-1 votes
2 answers
123 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 ...
1toneboy's user avatar
  • 441
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 ...
Prototype700's user avatar
0 votes
1 answer
183 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) ...
Anthon's user avatar
  • 79.9k
1 vote
0 answers
193 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, ...
Christianus's user avatar
0 votes
1 answer
636 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 ...
Megidd's user avatar
  • 1,559
0 votes
1 answer
3k 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 ...
CHEWKOK's user avatar
  • 25
0 votes
1 answer
194 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 ...
timesharer's user avatar
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 -...
canic's user avatar
  • 61
0 votes
1 answer
126 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 ...
Éric F's user avatar
  • 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....
Ratan Thapa's user avatar
0 votes
1 answer
84 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-...
Stan's user avatar
  • 101
0 votes
2 answers
335 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&...
Nicholas Saunders's user avatar
1 vote
1 answer
204 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 ...
Warjeh's user avatar
  • 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 ...
Franc's user avatar
  • 299
1 vote
0 answers
127 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 ...
addi jeo's user avatar
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 ...
MechaLinuxZilla's user avatar
0 votes
2 answers
952 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 ...
Nicholas Saunders's user avatar
1 vote
1 answer
528 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 ...
Porcupine's user avatar
  • 2,056
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. ...
Abdul Moiz's user avatar
0 votes
1 answer
42 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 ...
miguel ramires's user avatar
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 ...
aga.91's user avatar
  • 13
0 votes
1 answer
92 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 ...
Paralyz3d's user avatar
  • 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 ...
Village's user avatar
  • 3,717
1 vote
0 answers
225 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 ...
Kevin Dobson's user avatar
0 votes
2 answers
688 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 ...
ricardo3889's user avatar
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 ...
bhanuvinayes's user avatar
2 votes
1 answer
845 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 ...
Chris K's user avatar
  • 60
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. ...
Rodrigo Oliveira's user avatar
1 vote
2 answers
4k views

What does this error mean? AH01215: Schema .myuser@mydb. Password .mypass [closed]

I'm trying to deploy a page called 'Create' on my Redhat 7 linux web server using Apache. When I try to reach my page, I get the following error message from my error log: [cgi:error] [pid 23367:tid ...
casper1111's user avatar
0 votes
0 answers
19 views

Grails web application loses connection to postgres database, what could be causing this?

I am running Postgres on a Ubuntu instance with Tomcat as my application server. Suddenly my deployed applications are no longer connecting to their respective database. Looking at the logs catalina....
Mike Croteau's user avatar
3 votes
1 answer
71 views

DBMS access on files in linux

I've read that usually the records of a table (in a database) are organized in a file that is managed by the DBMS, not by the OS. That is, the DBMS decides the order of the blocks in a file, the ...
AleWolf's user avatar
  • 131
1 vote
1 answer
65 views

Maximize coverage of a dataset

I have a dataset of the following format. Field 1 lists an identifier, field 3 lists data points, and field 2 counts those data points. id1 5 E1, E2, E3, E4, E5 id2 4 E3, E4, E5,...
Ryan O'Hara's user avatar
1 vote
2 answers
388 views

(Debian 9) Why is there a postgresql server running on my local machine?

I began following https://www.postgresql.org/docs/9.6/runtime.html for setting up a local postgresql server for testing and development purposes. I discovered that I already have the postgresql ...
jth's user avatar
  • 195
-2 votes
3 answers
118 views

Web server in ubuntu [closed]

I am new to linux server development. I want to create a webserver for our college so that it can be accessed by everyone over internet in our android app. Anyone please answer whether i can ...
Lisa Williamson's user avatar