Questions tagged [database]

Database is an organized collection of data.

43 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
1answer
18 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 ...
3
votes
0answers
259 views

VoIP dialer for SIP

I have some Java, so am biased in that direction, but not overly so. None of the Java suggestions: https://stackoverflow.com/questions/16471795/sip-client-for-java https://stackoverflow.com/...
2
votes
2answers
105 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 ...
2
votes
2answers
386 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
2
votes
1answer
639 views

OOM Killer keeps killing mysqld

I run a CentOS vps to host a few websites with cPanel/WHM but every now and then, my websites stop working because it can't establish a connection to the mysql database. Looking at the messages log, ...
2
votes
0answers
175 views

Migrating data from SCO OpenServer 5.0.6

I've been tasked to migrate data from an old HP NetServer LH3000 running SCO OpenServer 5.0.6 (circa 1998). I've had a good amount of experience dealing with Unix/Linux systems. However, this is ...
2
votes
1answer
197 views

Convert / import flat file with multiple records, one variable per line

I am searching for an efficient way using (UNIX) command line tools to read a flat file into a(ny) database, perhaps after first converting to an intermediate structured format, for example XML or csv....
2
votes
0answers
759 views

Automatically update MPD database upon external storage insertion

I have an Alix board in my living room running Voyage MPD edition and acting as jukebox. In order to play "guest" music, I would like that MPD automatically updates its database with the content of ...
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
60 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?...
1
vote
0answers
30 views

What's a good and free ER diagramming tool for Linux that is approachable via a web interface?

A web based ER diagramming tool. One that you can install on Linux and afterwards approach it via a web interface. Preferably Open source. Optional: connectivity with the database.
1
vote
0answers
20 views

Installer Oracle Server not allows to enter a value in the field

I set up a server for home testing on Virtual Box. I can't enter the letters in the field "email", only numbers, how do I fix it? Thanks for any help.
1
vote
0answers
25 views

Installing MySQL in CentOS without permissions

I need to install a MySQL that doesn't need root. The reason for this is that I'm a user in a cluster, so I don't want to mess other people work. Said that, is there a way to have a "portable" MySQL ...
1
vote
0answers
115 views

How to undertand the GPLI code, structure and database?

Where can I get the conception and database structure of the GLPI ? I didn't find any documentation in the Internet. "how to create a plugin in GPLI" in Github doesn't help me very much.
1
vote
0answers
420 views

Database client version mismatch in PhpMyAdmin

I use Ubuntu 14.04.1 Desktop and in PhpMy Admin I see this: Database client version: libmysql - 5.5.50 But when I do this in the terminal: mysql -V I get ver. 5.5.52 Also in Synaptic Package ...
1
vote
0answers
62 views

Send new login & logout logs to a database

I want to know how to send new login and logout logs to a database. I know that last command outputs the "lasts" login info. But, I found the following problems: How to filter to only get new logs? ...
1
vote
1answer
125 views

Changing redis filesystem writing behaviour

The filesystem usage of redis is peaking every 20 minutes at the moment on my server. Sometimes from 63.1% to over 90.9%! This causes my monitoring to send me alerts if its over a longer time-frame. ...
1
vote
1answer
2k views

Upgrading Berkeley DB rpm in a Centos OS

I have a software which needs Berkeley DB 4.5 or above. But in my CentOS 5.11 x86_64 Server I have: Package db4-4.3.29-10.el5_5.2.x86_64 already installed and latest version Package db4-4.3.29-10....
1
vote
1answer
586 views

syslog-ng ignores MSSQL database name

syslog-ng ignores the database defined in syslog-ng.conf and instead uses the default database of the user when logging to MSSQL destination. destination d_mssql { sql(type(mssql) host("...
1
vote
0answers
232 views

Installing rpm & dependencies

I am trying to install an rpm, namely the Oracle 10g database for CentOS 6 for testing an app. The problem is that the machine the OS is installed on does not have access to the internet and there ...
1
vote
1answer
151 views

Bash script to install website

First of all, excuse me if this is the wrong place to ask this question. I made a Bash script which installs a DirectAdmin backup into Apache. The steps are working but in the end I get a 500 error ...
0
votes
0answers
4 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
0answers
10 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
146 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 ...
0
votes
0answers
84 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: ...
0
votes
0answers
199 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
17 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....
0
votes
0answers
59 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 ...
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 ...
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,...
0
votes
0answers
184 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
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?
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
76 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 ...
0
votes
1answer
1k views

No space left on disk (PostgreSQL)

I was trying to write a 55GB SQL file to my database. It used to crash each time. I removed logs and did some cleaning to get the server running, but the transaction never used to complete. Latter, I ...
0
votes
2answers
440 views

stop scheduled cron jobs while database is creating

we have a multi cron jobs runing everyday on different hours. In sometime script is running too long and block database in time where we set up a new one. The problem is that, a new database is no ...
0
votes
1answer
189 views

Unable to start database in glassfish in CentOS7

Environment: VPS, CentOS7, glassfish3, server is running. Tried: both in root and glassfish user. a comamnd: "startNetworkServer" and sudo netstat -lntp | grep 1527 nothing happened so it seems port ...
0
votes
0answers
75 views

Performance of FS directory structures

Given a large (hundreds of thousands objects) fs-based database of uniquely identified objects with potentially a large number of long prefixes with many objects sharing the same prefix are treeish ...
0
votes
1answer
26 views

Transfer Schema and Rebuild Databse on Another Server

I have made a number of changes to the database schema on my development including the addition of new tables and changes to others. Is there an easy way to transfer this schema to the server, build ...
0
votes
0answers
199 views

Move Complete ORACLE from one system to another

I have 2 identical server with exact disk partitions (OS CENTOS 6.4 both ) [My college central oracle server]. Entire ORACLE HOME ( bin , control files, data files everything on oracle) is on 2nd ...
-1
votes
1answer
81 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 ...
-1
votes
2answers
314 views

Putting output into SQL table

I am trying to convert the output of ps awux into 11 fields with the headers eliminated and then importing that output into an existing table in SQL.