Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Questions tagged [database]

Database is an organized collection of data.

Filter by
Sorted by
Tagged with
0 votes
1 answer
42 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 ...
user avatar
  • 13
0 votes
0 answers
40 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 ...
user avatar
0 votes
1 answer
264 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 ...
user avatar
0 votes
0 answers
24 views

How to restore mariadb to default after DB corruption

my DB got corrupted after that there was no free space available. I have tried many solutions, but nothing works so far. I have a backup of my application DB but not of the whole mysql DB. Despite ...
user avatar
0 votes
0 answers
25 views

Understanding Mac Databases/plist - Identity Services and Statuskit

I'm trying to understanding Identity Services and StatusKit information on Mac. Is there a way to differentiate between sent and received within idstatuscache.plist and ids-pub-id.db? What is the ...
user avatar
0 votes
1 answer
47 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 ...
user avatar
0 votes
2 answers
238 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 ...
user avatar
0 votes
0 answers
26 views

Error when installing MySQL on Debian Linux

Today, we noticed our server went down and are attempting to reinstall MySQL. When doing so, we are presented with the following: You might want to run 'apt --fix-broken install' to correct these. ...
user avatar
0 votes
1 answer
43 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) ...
user avatar
  • 75.1k
1 vote
0 answers
56 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, ...
user avatar
0 votes
1 answer
273 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 ...
user avatar
  • 1,315
0 votes
1 answer
788 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 ...
user avatar
  • 25
0 votes
1 answer
74 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 ...
user avatar
1 vote
2 answers
21 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 -...
user avatar
  • 61
0 votes
1 answer
64 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 ...
user avatar
  • 59
1 vote
1 answer
1k 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....
user avatar
0 votes
1 answer
33 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-...
user avatar
  • 101
0 votes
1 answer
163 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&...
user avatar
1 vote
1 answer
126 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 ...
user avatar
  • 13
1 vote
0 answers
34 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 ...
user avatar
  • 113
1 vote
0 answers
52 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 ...
user avatar
0 votes
1 answer
665 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 ...
user avatar
0 votes
2 answers
460 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 ...
user avatar
1 vote
1 answer
222 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 ...
user avatar
  • 1,374
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. ...
user avatar
0 votes
1 answer
23 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 ...
user avatar
0 votes
1 answer
957 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 ...
user avatar
  • 3
0 votes
1 answer
21 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 ...
user avatar
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 ...
user avatar
  • 5,345
1 vote
0 answers
81 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 ...
user avatar
0 votes
2 answers
172 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 ...
user avatar
0 votes
1 answer
2k 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 ...
user avatar
1 vote
1 answer
271 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 ...
user avatar
2 votes
0 answers
28 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. ...
user avatar
1 vote
2 answers
2k 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 ...
user avatar
0 votes
0 answers
17 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....
user avatar
3 votes
1 answer
53 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 ...
user avatar
  • 131
1 vote
1 answer
60 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,...
user avatar
1 vote
2 answers
235 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 ...
user avatar
  • 35
-2 votes
3 answers
67 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 ...
user avatar
1 vote
0 answers
40 views

Host data that everybody can update

I work with C# in my spare time and have written a number of programs as one of my hobbys. So I dont consider myself a programmer, I just like to write solutions for problems I come across. My latest ...
user avatar
  • 11
1 vote
1 answer
470 views

multiple [[collectd]] in influx.conf

I have following collectd instance running in influx.conf file and everything is good, but now I want to setup another instance totally isolated with existing one how do I do that? And can I do ...
user avatar
  • 1,530
2 votes
2 answers
294 views

establish connection between Redhat7 and MSSQL database over kerberos [jdbc driver]

i'm working on very annoying issue, namely our java app on redhat 7 is created to connect to mssql, which cannot parse principal stored in keytab generated by our company automats. Principal stored ...
user avatar
1 vote
1 answer
162 views

Disk I/O misalignment (I/O unaligned) issue ... who is to blame?

If an application, such as a database, is using the OS for writing/reading (that is, it is not directly writing to disk, i.e not using DIRECT IO or such) ... who would be to blame for I/O misalignment?...
user avatar
3 votes
1 answer
220 views

Does 'sudo apt-get purge postgr*' remove database files?

I ran sudo -u postgres psql -c "show data_directory" and it shows /var/lib/postgresql/9.5/main. If I understand correctly, this is the directory that stores the database files. I ran sudo apt-get ...
user avatar
  • 43
0 votes
2 answers
275 views

Problem with Workbench

I am on Debian stretch, I am using PHP 7.1, Here is the output Info from Workbench. > MySQL Workbench Community (GPL) for Linux/Unix version 6.3.8 CE build 1228 (64 bit) Configuration Directory: /...
user avatar
  • 61
0 votes
0 answers
101 views

Recommended recordsize for a zfs dataset hosting a Netatalk CNID backend database? (.AppleDB)

Which is the recommended record size for a zfs dataset hosting a Netatalk CNID backend database?? (.AppleDB) The plan is to use a zfs dataset exclusively for the Netatalk CNID backend, and configure ...
user avatar
3 votes
2 answers
2k views

Kernel Support | Processors List

Where can I find the supported Processors for each Kernel Version? For example (KBL Processors) is only supported for Kernel Kernel 4.5
user avatar
  • 31
0 votes
1 answer
54 views

LAMP DB-agnostic way to create a DB stack

Is there a LAMP-MySQL (or equivalent) agnostic way to create a DB stack that includes: DB-user and a relative password DB with the same name as of the user Setting a host for the DB (say, localhost) ...
user avatar
0 votes
1 answer
448 views

How to compile a ".pc" file on Debian 9?

I need to compile a Pro*C - .pc file on Ubuntu. So far what I have realised is that I need a Pro*C compiler to translate the Pro*C - .pc file into pure / standard C code.  But I need to have Oracle ...
user avatar
  • 1