Questions tagged [database]

Database is an organized collection of data.

Filter by
Sorted by
Tagged with
0
votes
1answer
42 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
21 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
42 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
146 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
83 views

[unixODBC][Driver Manager] Can't open lib when using pyodbc

UnixODBC Manager cant find the driver file to connect to the DB while using pyodbc. My system is running Ubuntu 18.04 and my configuration files and path are below: odbcinst -j output: unixODBC 2....
0
votes
0answers
14 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
10 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
17 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
51 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
74 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
58 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
32 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
144 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
95 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
53 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?...
2
votes
1answer
49 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
174 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
56 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
299 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
51 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
202 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
943 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
64 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
114 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
302 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 ...
0
votes
1answer
1k 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
79 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 ...
-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('...
-2
votes
1answer
296 views

CentOS : Is the port-5432 for me not accessible via internet?

We installed a new CentOS server for testing and the configuration was a bit different as compared to debian. I am unsure at this moment if the port-5432 is secure for us. If not, how can I secure ...
0
votes
0answers
172 views

Cron job fails: Could not retrieve file stat (script works when not run from cron)

I have a database backup script that works fine when I run it manually, but if I run it via cron it doesn't work and I get this in the log: Mar 11 11:58:02 ip-172-XX-Y-ZZ mysqldump: Could not ...
0
votes
2answers
937 views

SQLite3 Query storing IP address syntax error

I'm trying to run a sqlite3 query against a small DB to update a table. While the script is more complicated, for testing I set the following variables: DN=123 UP=123 downlocalip=10.1.2.3 ...
0
votes
1answer
857 views

DROP USER IF EXISTS syntax error in MySQL CLI

I use Ubuntu 16.04 with Bash and MySQL Ver 14.14 Distrib 5.7.21, for Linux (x86_64) using EditLine wrapper. I try to create a DB stack for a webapp (WordPress) directly from command line and I share ...
0
votes
1answer
16 views

How to measure daily number of metrics which is written to the single MongoDB instance?

Please suggest a commands to measure daily number of metrics which is written to the single MongoDB instance?
2
votes
1answer
110 views

Using a single command-line command, how would I search every text file in a database to find the 10 most used words?

This answered question explains how to search and sort a specific filename, but how would you accomplish this for an entire directory? I have 1 million text files I need to to search for the ten most ...
1
vote
0answers
102 views

Mysterious problem: Deleting massive amount of files doesn't free up disk space [duplicate]

I have a disk that is 100% used, 400 GB of 400 GB, however I have moved more than 44 GB of files from it, but no extra space got available, the usage is still 400GB of 400GB. Filesystem ...
-1
votes
1answer
395 views

Shortening of DB and WordPress instance creation script

How could I further shorten the following script who's purpose is to create a database && WordPress instance and then change permissions per the domain given and restart the server? ${domain} ...
0
votes
1answer
2k views

How to change adminer's default port?

My Adminer (Database management in a single PHP file) runs on a Debian Server, and I want to move my database management web login screen from port 80 to port 50001. How can I do it ?
2
votes
1answer
107 views

Is there any database solution that can do master-master replication by default on OpenBSD?

There are many "built-in" softwares for OpenBSD, ex.: NTP, LDAP, RADIUS, etc., see all (?): https://github.com/openbsd/src/blob/master/etc/rc.conf in the rc.conf file. The question: Currently, ...
-1
votes
1answer
1k views

Variable won't get expanded when INSIDE mysql shell

Before creating a new mysql user and DB, I did: read sps -s # Inputing and saving the sps (password) value. echo ${sps} # sps password value echoed. mysql -u root -p[PASSWORD] mysql>...
1
vote
1answer
111 views

Exporting and importing a mysqldump from within a mysql CLI heredocument

The following code drops a DB user and a DB instance by the name of test, if both exists, then creates an authorized, all privileged DB user and a DB instance with the same name (also test). mysql -u ...
0
votes
2answers
271 views

how to import customers to dolibarr

I have a rough and ready table as: mysql> mysql> show tables; +----------------------+ | Tables_in_businesses | +----------------------+ | 2017july | +----------------------+ 1 row ...
0
votes
2answers
31 views

Program to instantly host a mysql database from a dump file [closed]

I'm looking for a utility program which can take a dump of a mysql database and basically host a "fake" or minimal mysql server with that data for testing another program which requires it. Has ...
0
votes
1answer
2k views

Glassfish 4.1 on OpenJDK 8? (Netbeans)

Netbeans installed Glassfish, and shows Glassfish as running: Running the create-domain subcommand Using default port 4848 for Admin. Using default port 8080 for HTTP Instance. Using default port ...
0
votes
1answer
310 views

Clear OS-level cache

I have Red Hat Enterprise Linux 6 with Oracle 12c database. I am doing performance benchmarking but there seems to be an OS level cache causing only 1st time read to take significant time. How can I ...
3
votes
1answer
411 views

How can I calculate the average of multiple columns with the same value for the first two columns?

I have a file of about 13 million lines like: Lat Long air_temp sst wind_speed wave_height wave_period 65.3 7.3 4.3 8.8 7.7 4 8 61.6 1.3 -9.99 8.8 9.8 4 7 61.2 1.1 -9.99 8.8 7....
1
vote
2answers
155 views

Searchable database of Linux commands [duplicate]

Is there a searchable database of Linux commands? I'm new to the sport, and alot of information here assumes alot of knowledge I (and I'm sure many others) do not possess. However, I learn quickly, if ...
0
votes
1answer
451 views

PostgreSQL Remote Connection on NAS Synology DS216j

This is what I would like to achieve: I have postgreSQL database running on NAS Synology Diskstation DS216j connected to my router. I want to be able to connect and use the database from remote ...
25
votes
3answers
6k views

What kind of database do `updatedb` and `locate` use?

The locate program of findutils scans one or more databases of filenames and displays any matches. This can be used as a very fast find command if the file was present during the last file name ...
0
votes
1answer
75 views

Best way to migrate many SQL databases

So I'm switching VPSs, and have already done a backup of all the data files and moved them over. However I still need to move all the old databases over. I've been searching the internet for the best ...