System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

0
votes
1answer
16 views

Name [ ] is not bound in this Context. Unable to find [jdbc] Tomcat Issues

I just created a fresh Oracle Linux 7 VM with Tomcat 7 and Java 8_40. I've created several servers with Apache and Tomcat before, but never connecting to databases before. SELinux and firewalld are ...
-3
votes
0answers
25 views

How to write access command with credentials? [on hold]

We had a third party company setup servers and built services for us years ago. But the relationship is strained now and basically they won't reply any email to us. We could find some legal help but ...
0
votes
0answers
25 views

Database Server froze - High IO - how do I find out whats the reason? (Pics)

got a db server(KVM) running mariadb 10.1, runs fine since months, only servers 2 databases (drupal). Last night it went tits up. Here 2 screenshots from zabbix I checked the logs, they show ...
1
vote
1answer
14 views

Do I need to restart SUSE when upgrade glibc?

I plan to upgrade glibc version (HAVE to install by rpm command) on 30 SUSE machines, all the machine are using for running test on Jenkins. Could someone tell me the reboot is needed in this case?
0
votes
1answer
33 views

Exchange 2013 - 0kb EDB File after ISCSI Drop

I am unsure if anyone will be able to help me out. I have a 0kb EDB file after an ISCSI failure. I cannot run "eseutil" on the file as I get the error: Extensible Storage Engine Utilities ...
1
vote
0answers
20 views

Correct Azure VM firewall settings for Azure SQL Database v12

One of the recommendations when a client runs on an Azure VM and needs to connect with your Azure SQL Database v12 is to: Ensure that the port ranges of 11000-11999 and 14000-14999 on your Azure ...
1
vote
1answer
20 views

MySQL Error Code: 1017 permission denied

I have downloaded the German version of the Northwind sample database. I moved the folder to /var/lib/mysql and set the rights to drwxr-x---. Here is an output of /var/lib/mysql drwxr-x--- 2 mysql ...
-1
votes
1answer
35 views

Use Google Drive for live DB backup? [closed]

I am currently trying to define my backup strategy for my AWS EC2 server. I already use Google Drive to backup my apache root folder. This also automatically doubles as a deployment strategy since the ...
2
votes
1answer
25 views

Back up a database nightly

Question: Is it possible to automate the process of coping a full database every night into the development database on the same server? Software: Windows Server, SQL, SQL Server Management Studio, ...
0
votes
0answers
24 views

MariaDB query cache not being used with prepared statements

We are seeing a problem with our MariaDB setup where our queries executed as prepared statements are not being cached, however, queries executed locally through mysql command (i.e. text protocol) do ...
0
votes
0answers
9 views

Telling how big an oracle DB dump will be when imported

I have an oracle DB dump file that is 30GB and i would like to build a filesystem to support its size once imported - is there a tool/method i can use to tell how big it will be post import ? Thanks ...
0
votes
0answers
17 views

Linking fail2ban with a RDBMS

I would like to maintain a highly dynamic RDBMS table that will be insert/update/deleted from from multiple hosts (a kind of global blacklist for all my servers). The table would have a couple basic ...
-2
votes
1answer
35 views

best configuration for database server [duplicate]

Okay I have a VPS (DO 512 MB) and AWS RDS free tier . I wanna get the maximum performance , please help me cause I'm a little confused . I run a nginx server on the VPS and it can handle 1K ...
0
votes
0answers
20 views

Get the most out of VPS and AWS [duplicate]

I have a static website running on shared hosting and doing good (not slow) And having a bandwidth of about 3Gb / month and I'm adding 2 other dynamic website with database and php scripting(I assume ...
0
votes
1answer
44 views

How can I securely access a Rackspace Cloud Database in AWS?

Rackspace limits access for Cloud Databases to their ServiceNet. How can I securely and efficiently connect to a database instance there from AWS (over the public internet)?
1
vote
1answer
36 views

Unable to restore postgresql data dump for Django app hosted on Azure VM

I am trying to restore a postgres data dump for a Django app of mine. The data dump was extracted from Heroku, and pg_restore is being run on an Azure VM with Linux on it. There are around 40 tables ...
0
votes
1answer
27 views

How to change MySQL user permission temporarily (Per Connection)

I do not know if it is possible at all or not. What I want is that, when a certain connection is established, the user not be able to modify data with that connection. This is the scenario: ...
3
votes
1answer
29 views

Connect server A to database on server B and forward remote database port on server A

Edited: I'm quite new to all this admin stuff though! So: Whats the best way to connect a port on server A to the database on server B. The reason i want to do this: I want to connect server A to a ...
0
votes
0answers
29 views

Wordpress showing article title, but content is showing blank

I recovered from a disaster situation on the server, database is not affected. My wordpress files were old, from previous version (maybe 4.3). When I recovered those file and setup nginx with it, I ...
1
vote
0answers
15 views

CouchDB Authentication and Security

i used this link to install CouchDB on virtual machine http://depth-first.com/articles/2010/01/28/pubcouch-install-couchdb-on-ubuntu-karmic-from-source/ everything goes fine, after that i tried to ...
-1
votes
1answer
49 views

All MySQL databases appear to have disappeared

I'm running CentOS 6.7 with MySQL 5.1.73 and it appears as if all of the MySQL databases have disappeared within the past hour. MySQL starts up without any issues, however when running show ...
0
votes
0answers
4 views

How do I resynchronize a Bacula catalog?

I tried performing a Bacula upgrade, but found there were issues with our architecture. Our team tried powering through the upgrade testing backups, but eventually decided to do a downgrade and ...
1
vote
1answer
53 views

What is the best practice for deploying dev database to live system?

My developers in a project want to have the dev db on dev server synced with live db on live servers, which I think is a bad idea. Despite that, what is the best way to deploy a codebase+db to live? ...
0
votes
1answer
36 views

VSFTPD setup on Centos new virtual user cant connect

I have a vsftpd server configured on centos. Old users that are listed in logins.txt can login via wb browser. Problem is that when I create a new user I can't login 530 bad login error. Steps taken ...
0
votes
0answers
12 views

Merge and transactional SQL replication…database empty (SQL 2005)

Firstly, let me just say that I'm a novice at SQL in general and this might be an easy fix for someone reading, but I've been unable to find anything that would explain or help my issue online. If ...
1
vote
1answer
32 views

Our app lags “randomly” due to Disk I/O issues?

We have made an app that requires hundreds of images downloaded for each user every day. Our basic server setup is as follows: Loadbalancer -> Nginx -> Databaseserver However, our app "randomly" ...
-1
votes
4answers
127 views

How to mysqldump last 10 rows for EVERY TABLE in a database?

I have seen a lot of articles about "how to mysqldump last 'n' rows from a table in a database". For example: mysqldump --user=superman --password=batman --host=gothamcity.rds.com --where="1=1 ...
0
votes
1answer
246 views

DBD: Can't load driver file apr_dbd_mysql.so

I am using Apache 2 on a virtual machine running a LAMP stack (mysql version 5.6). When I try to restart the server I am getting this error; DBD: Can't load driver file apr_dbd_mysql.so I have made ...
1
vote
1answer
27 views

Postgresql calculate kernel share memory?

We are running PGSQL 9.2 and following are hardware specs OS: CentOS7 64bit CPU: 24 Memory: 32GB Disk: SSD I want to calculate shmmax/shmall values then what would be the good way? I google it and ...
1
vote
0answers
10 views

Sql Partitionning a table time by time [closed]

I try to do a partioning into a SQL table with Microsoft SQL Server Management Studio. I want to do this partition all night at 23h. For example i put all lines with a 0(on the column) on my ...
-3
votes
1answer
56 views

Can't login into phpmyadmin but password is correct

I'm trying to login into my phpmyadmin but it keeps redirecting me back to the login page. My username password should still be correct becuase my website is still functioning and I can even login to ...
1
vote
2answers
26 views

Using NAS Server as a Database Server, a good option?

Introdution: I have six dedicaded servers with localhost dababases, additional I have rented a NAS server (NFS HA Hybrid) mounted in each dedicaded server under /mnt directory, I want to use this as a ...
0
votes
2answers
273 views

Can't load driver file apr_dbd_mysql.so when restarting Apache

I have an Apache 2.2 version running on a Centos 7.1 machine running a LAMP stack (MySql version 5.6). Apache has been configured to enable the DBD modules, and running a DUMP_MODULES using httpd ...
0
votes
1answer
17 views

Lock a specific mysql database in shared mysql database

I am trying to migrate a database from one cluster to another cluster. In order to avoid any data loss during the migration, I am trying to lock my database with the WRITE operations. But the lock ...
0
votes
0answers
21 views

DNS: check client IP in database, reply different if ip exists in a DB

I'm trying to setup a DNS server that looks for the client IP in a DB, and returns a static IP as result if the client is in fact in the DB. There might be thousands or a couple million of records ...
2
votes
1answer
76 views

Thought about using my server hardware effectively

I will receive my new server hardware in some days, and of course I am already planning on how to use it the most effective way. My current thoughts are about scaling the web and database server on a ...
-1
votes
1answer
25 views

Distributed (serverless) Database System [closed]

I've currently a setup where 10 database clients access one (Postgres)-SQL server on the same network. The applications have a very low db footprint. They do load a few tables upon startup and do ...
2
votes
1answer
48 views

Empty space in MySql database

Forgive me if I'm not using the appropriate vocabulary. I'm planning on implementing a MySQL database with a PHP front end so I can enter work order details and files (screengrabs, ZIPs, etc.) into ...
1
vote
0answers
31 views

Sybase heavy Disk I/O issue

I have a Sybase 15 server that is constantly reading from the hard disk. I noticed that the sqlsrvr.exe is the culprit which is the main database engine. This is a pretty utilized server that is ...
-2
votes
1answer
34 views

Share the database with another person in same network [closed]

I am a newbie to the database topic. I need to create a database and share the database to another person in my office so the other person can also create/delete tables in the same database. I created ...
2
votes
0answers
23 views

ZFS Backup vs. ZFS Data Folders for Services

So I recently set up my own little server here at home. I got my main system set up on an SSD and a ZFS pool of larger HDDs for data storage. Now the question I was asking myself was if for services ...
0
votes
0answers
9 views

Oracle 9i - Data Guard - how to completely resync existing stanby?

Thank's to another SF user, I've managed to recover the control file needed to start a target data guard database in standby mode. So I have an active primary running in ALM keeping only the last 14 ...
0
votes
1answer
17 views

Oracle 9i - Data guard target DB - lost control files, can I recreate from primary database?

I'm dealing with a problem whereby a I have a database that is managed using data guard using Redo Apply, so redo logs are copied to the target database, applied and kept in sync ready for fail over. ...
0
votes
2answers
135 views

Importing database in LDAP creates error

I have exported my database using the following function slapcat > ldif While I am importing database in other LDAP server it creates error. I am using the following function slapadd -l ldif. ...
1
vote
2answers
95 views

Sharing SSH port tunnel with local network

I've successfully created a SSH tunnel to our cloud postgresql server on a local linux server, with this command: ssh -N -f -L 5431:localhost:xxxx mycloudserver.com (where xxxx is remote port) ...
0
votes
0answers
69 views

sql-php-sqlyog: Access denied for user .. unable to connect to database

I browsed around all other answers provided for this same issue. But didnt find a solution. So I thought to ask mine here. I am not very good with sql. But this is the first time I am facing this ...
1
vote
1answer
44 views

MongoDB on RHEL vs. Ubuntu [closed]

I'm looking to install MongoDB on an Amazon EC2 instance, to me AMI doesn't matter much... but maybe it should. While searching online for how-to's, I've only found thorough guides for installing ...
0
votes
1answer
14 views

Remote data service: speed concern

I would like to provide an online service that consists of the following: A proprietary database Queries to the database that not only ask for data, but more importantly sophisticated calculations ...
1
vote
0answers
51 views

Securing communication over LAN in VPS provider

I'm curious about best practice when connecting from app to DB in a cloud provider. A quick rundown of our setup. We have 4 servers all on the same provider, in the same region running as VPS. ...
0
votes
1answer
34 views

PostgreSQL : Strange Sudden Data type AND select schema issue

Here is my problem : Actually I am using postgresql 9.4 and postGIS extension. I am creating a database, and adding new tables with no problems... with geometry data types... until now... Now, I ...