System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

0
votes
1answer
434 views

Is weblogic 10.3.6 data source connection pool maximum capacity per domain or server?

My WLS server is connecting to an Oracle DB that has a maximum concurrent connection limit of 3. I have created a data source in WebLogic and set the "Maximum Capacity" value to 3. Is this value ...
0
votes
3answers
147 views

Amazon Linux EC2 Webserver / MYSQL Upgrade – Traffic causing error establishing a database connection

To give you a little background, I currently have a website that allows users to upload photos. The website was initially on a GoDaddy shared server, but recent surges in traffic have forced me to ...
1
vote
0answers
61 views

Tell proftp to allow connections only to the users that have permissions in PostgreSQL

I'm trying to set up an ftp server for the first time (under Debian Squeeze) and after searching through Google, I decided to use proftp. NOTE: I have a PostgreSQL server running in the same machine ...
1
vote
2answers
130 views

mysql fails every day at the same time and when many requests occurs

I am some problems with my mysql database. I configured a server with the database and other services (apache, php) and put run multiple applications. There are two problems. The first: Every day ...
1
vote
2answers
142 views

Indepedent pairs of RAID 1 is superior to RAID 10

I am rather new to databases. I was reading up on RAID Storage and it seems that the consensus is that RAID 10 is RAID 10 is best is terms of performance and redundancy However at the end ...
-1
votes
1answer
40 views

CISCO router GUI management

Is there any simple solution to connect to routers database with GUI? I mean is it even possible to find an application which could do the configuration without the need to push commands? Thank you ...
5
votes
4answers
418 views

Is MySQL required on both the database server and the webserver? why?

Is MySQL required on both the MySQL database server and the web server that it is connecting to? If it is required on both the web server and database server, please explain why this is. Moreover, if ...
1
vote
1answer
116 views

Choosing the right database/storage engine for iptables ulogd

I'm looking for some help choosing a database backend for a iptables ulogd setup. We are going to swap out our current proprietary firewall solution with iptables and one of the requirements is to ...
1
vote
1answer
246 views

How do I change the config_file location of a postgresql database for “service postgresql start”?

I had a PostgreSQL 9.1 db that I just upgraded to 9.3 using /usr/lib/postgresql/9.3/bin/pg_upgrade -b /usr/lib/postgresql/9.1/bin -B /usr/lib/postgresql/9.3/bin -d /var/lib/postgresql/9.1/main/ -D ...
2
votes
1answer
54 views

Alternatives to oracle flashback database/table functionality

Does anyone know of an open source tool or similar that covers the same functionality as the Oracle EE built-in flashback database and flashback table features? I'm considering going from Oracle EE ...
0
votes
1answer
108 views

Which db managment software can copy from one sqlite3 table to another for fields which are common in both?

We are looking for db management software which can copy from one sqlite3 table to another for fields which are common to both tables. For example, if table A has column name and address. Table B has ...
0
votes
1answer
19 views

OpenBase server database connection troubleshoot?

I am troubleshooting a workstation/server instance in which an application hangs while interacting with our Windows 2003 Server OpenBase-hosted database. In short, the application will go into "Not ...
0
votes
1answer
547 views

Migrate to AWS from Linode

Migration to another server is not easy when we have a large database. We want to move our database in Linode to amazon RDS database, i tried to pg_dump and pg_restore and it succeeds but it consume a ...
1
vote
1answer
70 views

Does converting a disk from basic to dynamic require a reboot?

I'm finding conflicting info on converting a disk from basic to dynamic and have a few questions. Will it require a reboot? The server with the disk in question is hosting SQL Server 2008 R2, and ...
1
vote
2answers
462 views

Can remote queries cause locks?

We have a SQL Server 2005 (SERVER-A) server that holds the database for an application that has been locking a lot lately. We suspect that the problem are transaction locks, so we decided to capture ...
1
vote
2answers
4k views

Server crashed, some MySQL databases are broken. Trying to recover with InnoDB recovery, but ibdata1 seems corrupt

I've a problem. Some days ago my root server crashes after a power outage. I realised that the MySQL server won't start. In the logs I find out that an error occured with InnoDB's ibdata1. I've ...
0
votes
1answer
95 views

How can I change the Postgres data_directory folder location?

I use Ubuntu 12.04, postgresql 9,1 postgis 1.5. I want to change database location. I use instruction http://www.whiteboardcoder.com/2012/04/change-postgres-datadirectory-folder.html The only ...
2
votes
1answer
94 views

Protect a public-facing PostgreSQL server against abuse

I have a Postgres database containing public information that I'd like to expose to the internet, for anyone to use. What steps can I take to prevent: Excessively expensive queries that could hog ...
-5
votes
1answer
55 views

Ticketing server database security [closed]

I want to setup a ticketing system which will show the seats available instantly. However, for security, I do not want to open my database in internet. I want to setup a server which has public IP and ...
0
votes
1answer
2k views

sql error “Service Broker needs to access the master key in the Database ”xxx" Master Key has to exist

I am pretty new to SQL and administration of databases and still learning. We receive one SQL error for quiete a long time, which has as far as we know no effect on our application. So we put that to ...
0
votes
2answers
85 views

Possible to take a backup of SQL Server 2012 DB and restore on 2008?

I want to take a backup of SQL 2012 and restore on 2008, is that possible ? I have this options which I can't change on DB. Thank you
0
votes
1answer
145 views

Several Server Errors (No database connect, can't create TCP/IP socket etc

My server stops taking requests on my website today. It works for some time, but then the server just stops working and throws several errors: 500 Internal Server Error Warning: mysql_connect(): ...
0
votes
2answers
59 views

Ubuntu 10.04 database connection problems

I'm having some problems with a legacy program I'm starting back up. We had an image of this server, and the setup is Ubuntu 10.04, 5gb partition for mysql database, and 100gb filesystem. My issue ...
0
votes
1answer
54 views

MySQL Replication fix after server shutdown/start

Server1 is Master Server2 is Slave Both are in our AWS testing env and we stop them once done with our work. When start again, Master rotates/creates new binary log file but slave keep looking for ...
0
votes
0answers
94 views

In Linux, what's the best way to delegate administration responsibilities, like for Apache, a database, or some other application?

In Linux, what's the best way to delegate administration responsibilities for Apache and other "applications"? File permissions? Sudo? A mix of both? Something else? At work we have two tiers of ...
0
votes
1answer
242 views

MySQL Creating a Database CentOS (6 - 64bit) Error 1064 (42000)

When ever I type in : GRANT ALL PRIVILEGES minecraft.* TO 'minecraftu'@'%' IDENTIFIED BY '********'; It gives me an error of : ERROR 1064 (42000): You have an error in your SQL syntax; check the ...
-2
votes
1answer
57 views

Adding and Removing MySQL Databases via CentOS 6 - 64 bit

I have a VPS, and am having troubles with MySQL. I think I have created a database, but got lost. I need to know how to: Add a database, with the username, name of the database, and password. ...
0
votes
1answer
212 views

Rails application keeps timing out when attempting to connect to Postgresql DB

I'm hosting a postgresql database on a small windows azure Ubuntu 13.04 VM with a default postgresql.conf. I have a Rails application running on a medium windows azure Ubuntu 13.04 VM. When accessing ...
0
votes
1answer
580 views

Users database empty after Samba3 to Samba4 migration on different servers

I have to migrate a Samba 3 to a new Samba 4 server. My problem is that the database on the samba 3 server seems a bit empty. The secrets.dtb file is only 20K whereas the “pbedit -L |wc -l”command ...
-2
votes
1answer
77 views

Is There any way to change Active Directory Users Database Source?

I need Active Directory Use My Own Custom Database (or shell or ...) for Authentication Users. Is there any extention or something like this to change User Passwords Database of active directory? I ...
0
votes
2answers
380 views

Connect to MySQL EC2 Instance outside of VPC

I have a VPC setup with a few EC2 instances inside. I'm attempting to connect to a MySQL database on an EC2 instance outside the VPC, with no luck. I have the security groups on the VPC EC2 ...
1
vote
1answer
234 views

Cannot Connect to MsSql2008 R2 Database Engine, While Connecting to Other Services

I have installed MsSQL 2008 R2 on my computer as I have installed always before. But unfortunately this time, I cannot connect to Database Engine while I can easily connect to the other services like ...
0
votes
2answers
56 views

Recommended Setup

I have been running into issue with my MSSQL Database setup with speed. Here is my scenario. About 100M Rows Average: 1k Updates Per Second Hard Drives: RAID 10 SSD MDF --Active Time: 0 Log ...
1
vote
0answers
227 views

Changing Cassandra Tokens on 1.2.1 From 4 to 256

We initially started our cluster using one datacenter, one rack, and the Simple replication strategy. We have keyspaces with several hundred gigabytes of data. When we changed the tokens in the ...
0
votes
1answer
353 views

how to copy sql server database on same server

I've got a SQL Server 2008 and want to make a copy of a database so I've got a 2nd Version of the database for testing on the same server. The database copy wizard is not able to copy the database, ...
0
votes
1answer
35 views

Mysql Db replication

I have the following setup: 3 servers, B1, B2, B3. A database from B1 is being replicated to B2. B1 is master and B2 is slave. Now, I want an another database from B2 to be replicated to B3. I need ...
0
votes
1answer
43 views

Confusing MySql Error

I am trying to install an application on CentOS, and see this error in my apache log. If any can help me understand what exactly is the case, I can try to work on a solution for the error. This is ...
-2
votes
1answer
66 views

Transfer database from Red Hat Linux to WAMMP [closed]

I've currently got a MySQL 5.X database on a server running Red Hat Linux 4 (from memory), which I currently shell into with Putty. I now need to replicate the server in WAMP for offline debugging, ...
0
votes
1answer
33 views

Amazon RDS - Create a Security Group NOT in Virginia? [closed]

It seems as though the management console only allows security groups to be created while in the "Virginia" selection. Is there a way to create a security group for an Oregon (or other)-based ...
0
votes
2answers
128 views

Will re-installing phpmyadmin will have any effect on my Databases?

I am quiete new and somehow I crashed my phpmyadmin website, it can't be displayed without errors after changing the port of it once. So does it has any effect on my databases when I reinstall my ...
2
votes
1answer
1k views

Database (MySQL) and SSD lifetime - “lot” of writes to DB

In company where I work we started using SSD for our internal 3 GB MySQL database Difference in perfomance is HUGE, which is great. What I am worried about is lifetime of SSD Writes to DB are ...
1
vote
1answer
491 views

Large lag on mysql replication (Relay_Log_Pos and Exec_Master_Log_Pos does not increase)

Today my two slave's (one mysql 5.1 and second MariaDB 5.5, master is mysql 5.1) started lagging. Similar situation are quite often with lags rises to even 10000 seconds, because slaves have worse ...
0
votes
1answer
192 views

Exchange database doesn't decrease its space after remove-storemailbox [closed]

I need to free some space in the exchange's volume. I proceed with some mailbox deletion also with "remove-storemailbox" for softdeleted mailboxes. However the database size doesn't decrease. May I ...
0
votes
2answers
142 views

Connecting to SQL Server from Python Django

I have a Django site running on a Linux based server. My partner has SQL Server running on a IIS Windows server behind a Cisco router. We are looking for a secure way for the Django site to connect to ...
-1
votes
1answer
32 views

Why is SQL Server seperate from the roles in Windows Server 2008 Server Manager?

I have an instance of Windows Server 2008 running on my machine. Within the OS there is a useful application called Server Manager, where I can manage several roles for my machine (such as web server, ...
1
vote
0answers
67 views

Legacy BSD PTYs instead of /dev/pts?

I'm trying to use an old database that only accepts connections from legacy BSD style pseudo-terminals /dev/ttyp's or /dev/tty's. It does not recognise /dev/pts/9 style PTYs. Connections via SSH. I ...
0
votes
1answer
133 views

Securing database server with IPTables

I have my app (WordPress) and database (MySQL) on separate servers; they are connected on a private network provided by the hosting service provider, and I've taken all the preliminary steps (that I ...
0
votes
1answer
321 views

SSH Tunnel or OpenVPN to securely connect app and database servers?

I have my app (a PHP forum) and database on separate servers, and want to make sure that the connection between them is secure. I've taken all the preliminary steps that I've come to know of, and am ...
6
votes
3answers
191 views

Protocol choice for Machine-to-Machine communication - level:n00b

I am building a monitoring system for an irrigation pump and the connected pipeline. So far I have completed the sensor network. Everything connects to a micro-controller board (actually 4 Teensy 3.0 ...
-1
votes
2answers
51 views

Database based Mail Server [closed]

I have a single case problem, it relates to selecting the correct mail server. A group wants to create their own business PHP website, where the public can read articles, news etc. and the staff can ...