Questions tagged [database]

Database is an organized collection of data.

Filter by
Sorted by
Tagged with
0
votes
1answer
44 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
10 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
40 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
33 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
13 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
43 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
41 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
32 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
35 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
110 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
1answer
84 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
47 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 ...
2
votes
0answers
621 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
62 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
18 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
406 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
18 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
74 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
0answers
11 views

Comapring variable in realtime in KSH on oracle database using loop

These are the variables, which I need to loop until they are equal and then end followed by the next set of instructions. None of the below-mentioned loops are functioning as expected. I expect the ...
0
votes
1answer
1k 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
30 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
25 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. ...
0
votes
0answers
351 views

MariaDB 10.2.15 SET GLOBAL max_allowed_packet not working

I am running 3 node galera cluster and everything is good but when today i am trying to change max_allowed_packet size without restarting any services it doesn't work. what i am missing? Version: ...
1
vote
2answers
552 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
24 views

Getting error on ubuntu 18.04 “/usr/lib/postgresql/9.4/bin/repmgr: unrecognized option '--rsync-only'”

I am running the following command for syncing of Postgres DB between node 1 and node 2. su postgres -c 'repmgr -f /etc/repmgr/repmgr.conf --force --rsync-only -h node2 -d repmgr -U repmgr --verbose ...
0
votes
0answers
12 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
27 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
52 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
104 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
60 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
33 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
266 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
155 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
96 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
96 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
198 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
71 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
685 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
274 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
66 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 ...
1
vote
1answer
127 views

mysqldump on mariadb 10 extremely slow [closed]

I'm running a MariaDB 10.1.34 instance on AWS RDS. Instance specs are as follows: Instance Class: db.t2.large Storage: 100GiB gp2 DB Size: 1.2 GiB I'm trying to create a mysqdump from an EC2 ...
1
vote
1answer
374 views

sh script for executing mysql script with entering pass [closed]

I'd like to execute a mysql script where user is asked to enter the password dynamically from the command line. If possible with a message Enter your $root password However it doesn't work as expected ...
3
votes
1answer
2k views

Data getting overwritten with same timestamp in InfluxDB

There are some data in a csv file and it is getting overwritten if the timestamp is similar, for example: ip,time,name 1.1.1.1,2018-08-31 11:12:32,python 1.2.1.2,2018-08-31 11:05:28,oracle 1.3.1.3,...
-1
votes
1answer
93 views

Risk of keep mysql data folder into linux cache

Is there a risk of doing: vmtouch -dl /mysql-data-folder On a production server with 192GB RAM and mysql data folder of 50GB. What is vmtouch? man vmtouch vmtouch opens every file provided on the ...
-2
votes
1answer
1k views

How to create a new database and collection using pymongo?

I want to create a database and collection using python script so that I used pymongo driver. But I am unable to create database. Steps I followed: from pymongo import MongoClient con = MongoClient('...