A widely-used open-source operating system that is particularly popular on servers.

learn more… | top users | synonyms

3
votes
1answer
52 views

Sharing PostgreSQL database on one dual-boot machine without duplication (cross-platform)

I have PostgreSQL 9.4 installed on a dual-boot machine (both on Win 7 and Ubuntu 14.10). The two systems share a drive (NTFS-formated) which includes a PSQL database directory which was created under ...
0
votes
0answers
13 views

Can't auto-start db2 with db2iauto

Followed guide Auto-starting instances . [root@oktest-stage-db-1 ~]# db2greg -getinstrec instancename=db2inst1 | grep -i startatboot StartAtBoot = 1 [root@oktest-stage-db-1 ~]# ...
0
votes
1answer
18 views

Ubuntu broken need to recover mysql db

With a recent Ubuntu upgrade it has broken my system. I now only have access to the filesystem through a live CD. I had a MySQL database on the system with many objects and views I would hate to lose. ...
-1
votes
2answers
18 views

How can I create Data Base on phpMyAdmin?

I have a serious problem here. I am not able to create data bases as the option is not to be found on my phpMyAdmin, but it only shows 'No Privilege' in red font. I even tried to create data base ...
0
votes
1answer
19 views

MySQL table doesn't exist

What I did before the disaster was: vi /etc/my.cfg I added innodb_buffer_pool_size=4G innodb_buffer_pool_instance=2 innodb_read_io_threads=12 innodb_write_io_threads=12 innodb_io_capacity=300 ...
0
votes
3answers
41 views

MySQL Exporting a query to text file via Cron Job

I'm in the beginning stages of hacking together code that syncs two completely different pieces of software/webware. I'm looking for a way to run a SQL query and output the results to a text file. I'd ...
0
votes
1answer
19 views

Unable to get any type of connection using mysql on LAN

My question is rather simple, I have a Windows 7 machine that is hosting an Apache server and a MySQL server using the XAMPP control panel. Both of these have been installed as a service on the ...
1
vote
1answer
67 views

MongoDB installation Ubuntu 12.04 LTS errors

I need some help with my MongoDB installation on a clean, fresh Ubuntu 12.04 LTS server with no nonsense installed. I thought it would be a piece of cake, but I got some errors and the Ubuntu-forums ...
0
votes
1answer
42 views

How to restore database from /var/lib/mysql

I have a database folder from a crashed server called gain_wordpress. I'm trying to put that database on a new server but I'm not able to do it successfully. I don't have a .sql dump, all I have is ...
0
votes
1answer
15 views

How do i prevent executing os command in oracle 11g

I have Oracle 11g installed on a linux serveur and i'm looking for a way to prevent sysdba from executing system command through oracle(Using java for example).
0
votes
1answer
48 views

How to fix “TNS:listener does not currently know of SID given in connect descriptor” with DBVisualizer on Linux?

I am trying to connect with Oracle database from a server having Oracle client installed (RHEL Linux Environment). I installed DB Visualizer on client machine. But getting listner error on hitting ...
0
votes
1answer
18 views

Will 'sleeping' connections open files other than the socket in MySQL?

Recently, in our MySQL replication setup, the replication slave crashed due to 'too many open files' error. We brought it backup, but trying to figure out what caused the unexpected hike in the number ...
2
votes
1answer
79 views

Problems restoring backup from base backup + WAL with WAL-E

I'm trying to do nightly restores of the main database on a separate node. I want to do weekly full restores and nightly restores by consuming the latest WAL files. On the master I have wal_level = ...
0
votes
1answer
20 views

Setting MySQLDump to keep running in the background after session times out

I'm tryng to set up a new Slave DB by copying another Slave DB. Normally I would simply use MySQLDump to dump the Slave and create a .sql file, then import that into the new database. However, as our ...
0
votes
1answer
29 views

MySQL does not generating PID file

I upgraded my OS from redhat 2.6.3 to 2.6.5 after that when I restarted my MySQL server but it not started, error message is "150320 11:53:17 [ERROR] Error message file ...
0
votes
1answer
23 views

What limits the number of connections?

As per https://devcenter.heroku.com/articles/heroku-postgres-legacy-plans the connection limit is 500 As per https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server "Generally, PostgreSQL on ...
-1
votes
1answer
31 views

Server has antivirus. Do I need to enable external locking on MySQL?

From MySQL docs: If you only read tables with other programs, external locking is not required Assuming the bytes of MySQL files does not match viruses, the antivirus will not change the ...
0
votes
1answer
26 views

In mongodb, is “sh.getBalancerState() is false” the same as “sh.isBanlancerRunning is false”?

During upgrading config servers to use WiredTIger, I stopped balancer using sh.setBalancerState(false), and then I run sh.getBalancerState(). The output is false. Does this mean the balancer is not ...
0
votes
2answers
50 views

MongoDb Upgrade from 2.6 to 3.0 Issue [closed]

For some reasons I cannot install MongoDb 3.0 version. What am I missing?
-2
votes
1answer
53 views

any advantage or disadvantage to have mysql 5.6 on a linux server over on a window server [closed]

i am planning to decide to use mysql5.6 on a window server 2012 or a linux server. Can someone gives me some general advises between the two?
0
votes
0answers
16 views

Index creation issue with MySql and Linux

MySQL Server database is installed on RHEL5.5 and db version is 5.6.20 Community Server. In MySQL database we have a table and it has 11,144 records. I am altering the table and adding index to it. ...
0
votes
0answers
87 views

upgrading posgresql 9.0 to 9.4 with pg_upgrade on CentOS 6.6

I'm trying to upgrade a postgres v9.0 database to v9.4 with pg_upgrade on CentOS 6.6, but I keep hitting a wall. I am calling pg_upgrade thru a shell script as postgres, first exporting the needed ...
0
votes
0answers
27 views

Please help: kerberos authentication setup on postgresql

Requirement: Backend working with RHEL and postgresql and front-end working with windows,.net. please consider how the authentication method must be done. our main idea will be to have the ...
0
votes
2answers
41 views

mysql does not start: error 13 on bin file (permissions are set correctly)

I just renamed the hostname and rebooted the server and now mysql 5.6 wont start. (debian 7 + dotdeb) 150312 20:40:15 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql.mnt ...
1
vote
1answer
17 views

Requests to local CouchDB have 40ms latency

Requests to a CouchDB instance on the same machine have about 40ms latency when HTTP keepalive is used by the client, about 0-1ms latency when the client does not use keepalive. What causes this ...
0
votes
0answers
14 views

Getting warning ignoring option '--databases' due to invalid value 'testdatabase' in mysql while importing data

i am getting warning ignoring option '--databases' due to invalid value 'testdatabase' in mysql while importing sql data into a database.Its working fine when I do it on my local machine but same is ...
0
votes
1answer
23 views

Mongodb: Couldn't find mech GSSAPI

I am trying to understand how mongodb works with kerberos. To do that I have configured a kerberos server, just only for local. This is the configuration of my realm: this is the content of krb5.conf ...
0
votes
1answer
158 views

ORA-04031: unable to allocate 32 bytes of shared memory

I want to flush shared pool because of error like ORA-04031: unable to allocate 32 bytes of shared memory So I want to flush shared pool using alter system flush shared_pool; Connected as ...
1
vote
1answer
72 views

How much memory are used by perticular session during run time in MySQL 5.1 community version? [closed]

Is it possible to find out how much memory is used by particular session?A user was asked me how much memory is utilized by particular session running in MySQLl 5.1 community version server. Kindly ...
2
votes
0answers
30 views

How to reinstall a legacy DB2 Server 7.x for Linux?

We have to move our legacy database dump to a new Linux installation. I know DB2 7.x is out of support for over a decade, but is there a way to obtain a DB2 7.x Server installation media for Linux? ...
1
vote
0answers
34 views

Pass a URI as a pgAdmin parameter

I can connect to Heroku with psql passing a URI: $ psql postgres://user:password@ec2-54-243-xxx-xxx.compute-1.amazonaws.com:5432/d7xkxididkdi I want to do the same with pgAdmin: $ pgadmin3 -qc ...
0
votes
0answers
14 views

Metadata database on top of flat files

I have a bunch (millions) of flat files. I do sort them into subdirectories, but that doesn't really help searches. Is there some database software that could be fed metadata information and would ...
0
votes
0answers
37 views

Install specific older version of postgresql centos

I need to rebuild a production system with same version of installed packages. It's a Centos 5.11 and it was using this repo http://yum.pgsqlrpms.org/reporpms/8.3/pgdg-centos-8.3-6.noarch.rpm to ...
0
votes
0answers
289 views

MySQL workbench: Cannot Connect to Database Server (ssh)

General pointers would be appreciated -- it's likely I'm misunderstanding the mechanisms involved in a remote connection through ssh. I can use ssh to connect remotely, and then, through the CLI, ...
0
votes
1answer
27 views

Check mysql domain that is using resources

I have a webserver hosting about 300 websites and sometimes my CPU usage gets close to 100% and when I use "top" in my CENTOS to check who is using all CPU, I discover it's mysql. I would like then to ...
1
vote
1answer
73 views

Can I reduce MySQL memory usage, or do I need to add more RAM?

I have a VPS with 2.25GB of RAM. MySQL is using 1.4GB with only four users on my site right now. It seems to use this amount even when no users are online. The available memory of my server regularly ...
0
votes
0answers
27 views

password based ssh authentication with MySQL Workbench

I know that it's possible to configure SSH to use keys only, and to disable password based authentication. That being said, can I do the following from MySQL Workbench? I've tried more than a few ...
1
vote
1answer
105 views

ONLINE BACKUP is not performed from the CRON Job on LINUX server (manually it works)

I made a script which executes successfully online backup when it is run manually by the instance owner. Script is the following (two lines originally). #!/bin/bash /opt/ibm/db2/V9.7/bin/db2 ...
0
votes
1answer
139 views

Spool in Shell script not working for me

#!/bin/sh echo "Started at" `date +%Y/%m/%d" "%H:%M:%S` sqlplus -s ${ORA_LOGIN_SYSADM} <<EOF 2>&1 > /dev/null SET SERVEROUTPUT ON SET FEED OFF spool ech.txt create BEGIN ...
1
vote
1answer
144 views

How to start Sybase server

I have installed Sybase(Developer's Edition for ASE 16.0) on a linux machine. I have executed the setup.bin file, and installed it using GUI. After this, I tried connecting to the localhost server, by ...
4
votes
3answers
451 views

TNS-12541 Error

I have grid installed in my pc but the problem is LISTENER does not start automatically. I have to start listener manually and then only LISTENER get started. But before starting listener if you check ...
0
votes
1answer
389 views

How to set ADR Base directory correctly on OracleDB on Linux?

Installed Oracle Database on Linux based OS. Listener is ok. But Oracle is not. (I changed all angular brackets to vertical, because parser not shows angular brackets) ORA-48108: invalid value ...
0
votes
1answer
126 views

Cannot start MySQL service on linux RHEL when pointing datadir to mounted ecryptfs folder

I moved the data directory for MySQL to an ecryptfs encrypted folder. When I run service mysqld start as root, the service will not start. [Warning] Can't create test file ...
0
votes
2answers
854 views

mysql.sock not found on CentOS 7 machine

I am getting the following error when I try to log into mysql from the CentOS 7 terminal of the machine where mysql is installed: ERROR 2002 (HY000): Can't connect to local MySQL server through ...
0
votes
0answers
70 views

MongoDB mongoexport $or query returns zero records

I have the following cmd in bash termial mongoexport --db fscrap --collection Wall -q "{\$or : [{'insert_time' : {\$gte : new Date(1393624800000)} },{'comments.comment_time' : {\$gte : new ...
1
vote
3answers
108 views

Linux kernel parameters for oracle

I wonder what are the optimal Linux kernel parameters for oracle 11g db on 64-bit system. I didn't find any detailed, good or full recommendations or best practices for this issue. Just found one ...
1
vote
1answer
178 views

remove password requirement for user postgres

I understand that, upon installation, PostgreSQL has no password for its db root user (postgres): postgres=# select usename, passwd is null from pg_shadow; usename | ?column? ----------+---------- ...
0
votes
1answer
66 views

Similar hardware, Same DBconfiguration and Database but different status variables result between Windows and Linux server [closed]

I have two database servers - one is Windows - 2008 and another is RHEL5 with similar hardware configuration. Both OS are 64 bit. MySQL 5.1.58 community edition is installed on Windows servers while ...
0
votes
1answer
69 views

Mysqldump without slow query

Situation: I currently monitor an instance of MySQL for slow queries. We have a mysql user dedicated to backups which performs a mysqldump, but the mysqldump gets logged as a slow query. Question: ...
1
vote
2answers
3k views

Oracle Database 12c on Oracle Linux 7 - autostart, enabling connection as sysdba

I've installed 12c on Oracle Linux 7 for my development work, as per document Oracle Database Installation Guide 12c Release 1 for Linux (E41491-10). My previous experience with administering Oracle ...