Database is an organized collection of data.

learn more… | top users | synonyms

1
vote
2answers
182 views

Simulate PostgreSQL query timeout

I would like to test the behaviour of a program which executes queries to a PostgreSQL server in case of a query timeout. How could I simulate that?
1
vote
2answers
391 views

delete redis keys that have been inactive for 30 days

I've installed a web app called scrumblr which uses redis as a database. What I am attempting to do is delete all keys that have been inactive for 30 days, or have not been accessed in 30 days. I ...
-1
votes
2answers
36 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.
1
vote
1answer
238 views

How to determine which Berkeley DB version is used for RPM's database?

I am attempting to read and write the RPM database located in /var/lib/rpm under CentOS 5, and eventually other system types (CentOS 6, RHEL, etc.) The problem is that I don't know what version of ...
1
vote
1answer
2k views

How do I run a service with numactl

I need to do something like this to run MongoDB $numactl --interleave=all /usr/bin/mongod --config /etc/mongod.conf & What should I change to be able to run the mongo daemon with the options ...
1
vote
1answer
86 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
291 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("...
0
votes
1answer
323 views

Failed to open the bootstrap file in MySQL

After doing an installation of MySQL Ver. 5.7.10 for RH/Oracle Linux I get an error that during the initialization the bootstrap file was not found. I'm not sure where this may come from, as it is a ...
0
votes
1answer
18 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
1answer
30 views

Does mysql user exist in MySQL database system

I searched mysql.user table and did not find any user named as mysql. root is the default username. I am curious to know whether mysql user exist or not? If yes, what is the purpose of this user? ...
-1
votes
1answer
28 views

Physical Backup of Maria DB as a snapshot using LVM

I have a SQL database which I want to backup as a snapshot. I want to use LVM to do so, but I am not able to do it. Also my database is not stored in a LVM partition but its located in my /dev/sda2 ...
2
votes
0answers
158 views

VoIP dialer for SIP

I have some Java, so am biased in that direction, but not overly so. None of the Java suggestions: http://stackoverflow.com/questions/16471795/sip-client-for-java http://stackoverflow.com/questions/...
2
votes
0answers
586 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
44 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 ...
1
vote
0answers
99 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....
1
vote
0answers
1k views

How to set up Active Directory authentication on CentOS 6.5?

I have: 1. A CentOS machine to which I have SSH and STFP access. 2. The machine is on network where there is a MS SQL Server database and Windows shared drives. 3. All authentication seems to be with ...
1
vote
0answers
372 views

how to create a script to backup MySQL databases on separate files?

I need to create a script so to automate the backup process for my database server. Today there are 19 databases on the server and to prevent some schema is created and not contemplated by the script, ...
1
vote
0answers
145 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 ...
0
votes
0answers
9 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? ...
0
votes
0answers
23 views

Fastest way to perform Redis data migration?

I have several Redis 3.0 instances running in AOF persistence mode. Sometimes, I have to perform data migration from one instance to another. Data migration process currently goes like this: BGSAVE ...
0
votes
0answers
21 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
0answers
104 views

how to Install oracle 12 on Debian jessie server

I want to install Oracle version12 on a server Debian Jessie but I can't find any tutorial or the commands to follow. How can I install it?
0
votes
0answers
101 views

Shell script to check the ASM diskgroup space in oracle and send a mail

I am trying to write a shell script to monitor ASM instance in ORACLE and mail the respective people in mail list. I have written the following script. #/bin/sh #set -x USER=xxx PASS=yyy ...
0
votes
0answers
36 views

Installing Ubuntu and PostgreSQL database on different drives

I just received a new root server with the following drives: Disk /dev/sda: 480 Gb Disk /dev/sdb: 480 Gb Disk /dev/sdc: 240 Gb This one: https://www.hetzner.de/de/hosting/produkte_rootserver/...
0
votes
0answers
58 views

The curious case of high 5 min load average

Looking for some expert advice here. I'm a first time sys admin on my own server and I can't figure the bottle neck in my server. Linux CentOS 6 Apache 2.4 PHP 5.5 I've been receiving tons of high 5 ...
0
votes
0answers
19 views

How to monitor system, Database Query Values, and the Existance of Files?

I was looking through an old system today, and it had this monitoring software that could send out email alerts. It's very old, but it still seems interesting and useful. It allowed for monitoring ...
0
votes
0answers
86 views

“[unixODBC][Driver Manager]Data source name not found, and no default driver specified” When using Teradata ODBC Drivers

I am running a PHP script on a RedHat server using Teradatas ODBC drivers. <?php $conn = odbc_connect("Teradata", "username", "password"); $result = odbc_exec($conn, 'SELECT count(*) FROM table');...
0
votes
0answers
53 views

Is there a `find` command that uses a database, like `locate`?

locate is simple yet quick because it's database based. find offers much more options but it's slower because it actually browses the filesystem each time it's invoked. So.. find using a database ...
0
votes
0answers
866 views

upgrading Berkeley DB rpm in a Centos OS

I have a software which need 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....
0
votes
0answers
128 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 ...