Questions tagged [database]

Database is an organized collection of data.

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

How can I impliment this on an x86_64 or raspberry Pi?

I would like to do something similar to Kiwix. Can anybody tell me how I could re-create this myself, or at least the main steps needed to build a similar project? https://www.kiwix.org/en/ It sounds ...
0
votes
0answers
11 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 ...
0
votes
1answer
34 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 ...
1
vote
2answers
19 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 -...
0
votes
0answers
4 views

Unable to load data into BigQuery US Dataset, but can load into East-Asia Dataset

So the issue is, I am unable to load data to GCP BigQuery in dataset 'dw' located in US location. However I am able to load the data in East-Asia location. I am trying to load data to partitioned ...
0
votes
1answer
20 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 ...
1
vote
1answer
327 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....
0
votes
1answer
19 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-...
0
votes
1answer
72 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&...
0
votes
0answers
13 views

can LO Base data entries be inserted with BASH

I need to set up a basic DB that retrieves daily data from a webpage and was wondering if I could get away with using LO's BASE. My only requirement is that I need to be able to insert tuples of data ...
0
votes
0answers
16 views

Unable to connect to server with postgreSQL12 and pgAdmin4 (PoP!_OS)

I installed postgresql-12 and pgAdmin4 in my Linux Pop!_OS 20.1 yasterday. I connected at one of my work's server easily with pgAdmin4. But when I tried to connect to the others, I have the errors: ...
0
votes
0answers
78 views

How to open oracle xe GUI in linux?

I have installed oracle xe 19c database on oracle linux 8 using yum -y install xxx.rpm method. I know that there is one more step to do for oracle xe 18c, I should run /etc/init.d/oracle-xe configure. ...
0
votes
0answers
85 views

How to create new mdb or accdb file with Libreoffice base 7

I got an assignment to create a new database file in mdb or accdb format (because my teacher is a windows user). I've libreoffice 7.0 and added UCanAccess driver class path. But, this is for open an ...
0
votes
0answers
58 views

Not able to connect with Azure MS SQL server DB connection

Not able to connect with Microsoft Azure Sql server DB Connection Error: odbcinst.ini: [ODBC Driver 17 for SQL Server] Description=Microsoft ODBC Driver 17 for SQL Server Driver=/opt/microsoft/...
0
votes
0answers
172 views

Using metasploit on Fedora 32

I am trying to use metasploit on fedora 32 (kernel: 5.8.11) and I have a problem with metasploit's databse. I installed metasploit from this site: https://www.metasploit.com/download When i type in ...
1
vote
1answer
80 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 ...
1
vote
0answers
33 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 ...
1
vote
0answers
37 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 ...
0
votes
0answers
6 views

taking mysql5.6 db backup with views

how to take db backup with views in mysql5.6 while views are corrupted or table name changed. if I first rectify views then I will be able to take dump. But I want to take dump , I will rectify ...
0
votes
1answer
309 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
2answers
226 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 ...
0
votes
0answers
87 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 ...
3
votes
0answers
1k 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. ...
0
votes
1answer
22 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 ...
0
votes
1answer
296 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 ...
0
votes
1answer
19 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 ...
2
votes
3answers
1k 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 ...
1
vote
0answers
36 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 ...
0
votes
2answers
96 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 ...
0
votes
1answer
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 ...
1
vote
1answer
52 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 ...
2
votes
0answers
26 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. ...
1
vote
2answers
946 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 ...
0
votes
0answers
13 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....
3
votes
1answer
40 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 ...
1
vote
1answer
55 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,...
1
vote
2answers
154 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 ...
-2
votes
3answers
61 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 ...
1
vote
0answers
34 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 ...
1
vote
1answer
347 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 ...
2
votes
2answers
189 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 ...
1
vote
1answer
122 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?...
3
votes
1answer
128 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 ...
0
votes
2answers
220 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: /...
0
votes
0answers
76 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 ...
2
votes
2answers
1k 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
0
votes
1answer
53 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) ...
0
votes
1answer
365 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 ...
-1
votes
3answers
2k views

Grep content for multiple files

My OS is Sun Solaris. SunOS sintscdldmu001 5.11 11.3 sun4v sparc sun4v I gave the command alter database backup controlfile to trace; and happened to forget it. When i needed the contents of the ...
0
votes
0answers
69 views

A simple utility to backup of both database (MySQL) and document root into one file

In Ubuntu-LAMP with Bash I host a few personal websites. All websites are under document root (/var/www/html). This is how I currently create immediate backups on maximally-self-managed cloud ...