Ubuntu is a desktop and server operating system based on Debian GNU/Linux. Note that http://askubuntu.com is specifically dedicated to Ubuntu questions.

learn more… | top users | synonyms

1
vote
1answer
452 views

How can I be sure if MongoDB is doing the balance?

I have the following structure: Two Ubuntu 14.04.2, both with MongoDB v3.0.4 instaled. Both in the same LAN. I want to make them work as a cluster. In the first one, that I call "MC1", I run the ...
2
votes
1answer
350 views

Not able to install PostgreSQL 9.4 on Ubuntu

When I try to install PostgreSQL 9.4.+ on Ubuntu, it is installing version 9.3.9. I have used the following command: sudo apt-get install postgresql postgresql-contrib Then I have tried with sudo ...
3
votes
1answer
667 views

current_timestamp default column value working in Windows but not in Linux

This MySql query runs fine in Windows: CREATE TABLE `posts`.`table` ( `idTable` INT NOT NULL AUTO_INCREMENT, `Column1` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`idTable`)); In ...
3
votes
0answers
105 views

Recovering data from postgresql xlog

I lost a lot of data in my postgresql database and do not have a dump file to restore backup from, but I heard that in /var/lib/postgresql/9.4/main there are pg_xlog and pg_clog and that those ...
0
votes
1answer
22 views

MySql DB from Ubuntu to RHEL

I would like to migrate my Mysql databases from Ubuntu to RHEL..what is the best way to proceed? I'm on community edition. I will be moving to entreprise edition of MySql on RHEL.
0
votes
1answer
1k views

MongoDB eats 100% CPU when idle

I am running in OpenVZ container with Ubuntu 14.04 LTS. MongoDB version: db version v3.0.4 git version: 0481c958daeb2969800511e7475dc66986fa9ed5 I use clean installation like described here - ...
0
votes
1answer
151 views

Why do the queries slow down after a few minutes, when trying to build a DB?

First - I am a complete newb to DBA. Please be gentle. (And I am fairly new to python as well.) Oh, and I have no idea how to change any MySQL settings or the like, so all the MySQL DB settings are ...
1
vote
1answer
42 views

Moving postresql 9.1 database - live

This question has probably been asked and answered before, and if so, I would appreciate if that could be pointed out to me. I have googled this point quite a bit, but I want to be very sure as to ...
1
vote
2answers
171 views

cannot access my DB server on ubuntu

server OS: Ubuntu 14.04 MYSQL Server version: 5.5.43-0ubuntu The output of: select User, host from user is: db % db localhost In my /etc/mysql/my.cnf, I made sure that bind-address is ...
1
vote
1answer
229 views

sqlplus not connecting to Oracle XE 11g

I installed Oracle XE 11g on my Ubuntu in vmware fusion. The oracle installation is all went fine but I am not able to connect the oracle database using sqlplus. I am getting this exception: $ ...
1
vote
1answer
424 views

postgresql won't install dependencies

Please help me figure out why postgresql isn't playing nice with updating. I can't find anything on SO or Google that remedies this problem. This is a production server and a distribution reinstall ...
1
vote
1answer
292 views

mongodb 3.0.3 Ubuntu 14.04.2 AWS m3.medium Upstart PID mismatch

(Cross posted from stackoverflow, seems like this belongs here but 10gen link to stackoverflow explicitly from their site...) Is it possible to run mongod via upstart and keep track of the PID ...
1
vote
1answer
125 views

Install PostgreSQL using source code or using apt-get?

I want to install PostgreSQL on a server that runs Ubuntu 14.04.2 LTS. I understand that I have two options: 1) Install PostgreSQL using the source code distribution e.g., ...
1
vote
1answer
959 views

How to handle user with no password in postgresql

I installed postgresql but it's asking me for passwords that I never had and never entered. There is a postgres ubuntu user and a database user named moodle. Neither of these were created with a ...
2
votes
2answers
7k views

MongoDB service not working after upgrade to Ubuntu 15.04

I have recently upgraded my Ubuntu from 14.10 to 15.04. All features seems to be working fine except MongoDB. It is not controllable from service as we do normally in Ubuntu. sudo service mongodb ...
1
vote
0answers
313 views

Can I export a PostgreSQL database from Heroku and Import as a PostGIS database in Digital Ocean?

Disclaimer: This may be a dumb question. This is honestly way over my head... one of the pitfalls of using Heroku for too long. I have a PostgreSQL database on Heroku. Now I'm migrating to Digital ...
1
vote
1answer
351 views

How do you grant permissions to a MySQL user using a shell script with variables?

I'm trying to create a provisioning script for Scotch Box (Vagrant) that will populate a database with seed content when I fire up the server. When I name the actual user, database, password, and ...
-1
votes
1answer
75 views

Switching from Oracle database to Ubuntu [closed]

I need support please. I am the CEO of a Life Assurance company. We are currently building our own core application under the leadership of my Head of ISD. We are using Oracle for our database and ...
1
vote
2answers
418 views

MySQL on Ubuntu consuming almost all RAM

I've been having an issue with MySQL crashing randomly, apparently as a result of not having enough available memory (as discussed here: ...
0
votes
1answer
252 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. ...
2
votes
1answer
485 views

Postgres 9.4.1 on Ubuntu 14.04.2 LTS fails to install properly

I'm trying to install PostgreSQL 9.4.1 on Ubuntu 14.04.2. I'm using the packages from apt.postgresql.org. The package installs but it fails running pg_createcluster. If I run manually, I get: ...
1
vote
1answer
274 views

How can I remove references to tables after removing .frm files?

So I had a bunch of csv files in my /var/lib/mysql/imports directory for importing into mysql tables I had created. To clean up the folder I deleted all the files in the directory (incorrectly ...
0
votes
0answers
553 views

Mongodb 3.0.1 in ubuntu starts but status, stop or restart show 'mongo stop/waiting'

I am relatively new to Mongo and have installed 3.0.1 on a Digital Ocean droplet (Ubuntu 14.04 LTS). The database starts without problems but I am unable to 'sudo service mongod [stop/restart/status]' ...
2
votes
1answer
388 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 ...
1
vote
1answer
243 views

Slow database drop in mysql

Just installed a new 24 core server and it is noticeably slower when doing truncates and drops. Example: $ mysql -u root lmcdental_test2 Reading table information for completion of table and column ...
0
votes
1answer
95 views

how to check and list all the files related to mongodb in ubuntu? I am looking for config files, password informations for mongodb [closed]

I installed the mongodb package in ubuntu using apt following the instructions on http://docs.mongodb.org/manual/tutorial/install-mongodb-on-ubuntu/. I know that binaries are in /usr/bin/, and so on. ...
1
vote
2answers
245 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
2answers
510 views

what is the password to user mongodb when mongodb is installed in ubuntu?

When I installed mongodb in ubuntu, user mongodb and group mongodb are created in /etc/passwd and /etc/group. But I have no idea of the password to these user and group. I have to run mongod as root ...
0
votes
0answers
35 views

How do I alter my role to be a superuser?

I'm working my way through the steps in this slide to configure Postgresql & PostGIS. I configured my user role as directed on this slide. Note, the new role should not be a superuser. That ...
1
vote
2answers
135 views

How to Permanently solve MySQL error 2002 (HY000)

I have a problem on my cloud server with 2GB of RAM and 40GB Hard Disk that's hosting a Wordpress website that receives around 1000-2000 hits a day. My problem is that MySQL is always crashing and my ...
0
votes
1answer
132 views

Why MySQL imports only one record for each table?

Code shows some info: $ cat /etc/*-release | grep VERSION 6:VERSION="12.04.5 LTS, Precise Pangolin" $ mysql --version mysql Ver 14.14 Distrib 5.5.40, for debian-linux-gnu (x86_64) using readline ...
1
vote
1answer
75 views

postgresql: accept subdomain wildcards?

I want to accept all db connections from servers with domain mydomain.com so that all subdomains like tiger.mydomain.com, venus.mydomain.com will have access to the postgresql server. I've read that ...
0
votes
1answer
452 views

odbc connection from windows machine to mysql server running on ubuntu?

I was able to install mysql server on an ubuntu machine and set up a test data base, created a user and granted that user access to the database. I also changed the binding address to the IP of the ...
1
vote
0answers
241 views

Are A or D series VMs better for deploying PostgreSQL on Azure?

In Azure there are VMs that have local storage either as spinning disk (A-series) or SSD (D-series). Considering this space is wiped on reboot... Is there a benefit to choosing the SSD option for ...
0
votes
1answer
239 views

ubuntu - Pm2 mysql high cpu usage [closed]

Not sure what is going on here but would love some help if any can. I am running on digital ocean 1GB ram ubuntu server a node.js application that is is launched with pm2 and that uses a mysql ...
1
vote
4answers
5k views

How can I export just the structure of a MySQL database?

I use Ubuntu 14.10 and PhpMyAdmin. I have a 'big' MySQL database, the size is 900MB. I need just the structure of this database, to use it on my local machine. How can I export the structure only?
0
votes
1answer
291 views

After upgrade from 9.1 to 9.3, commands still point to 9.1

Upgraded from 9.1 to 9.3 on my Ubuntu 12.04 server. Everything worked great but running commands like 'createdb' still runs them from the 9.1 path. /usr/lib/postgresql/9.1/bin/createdb: unrecognized ...
0
votes
1answer
2k views

Error: /var/lib/postgresql/9.3/main is not accessible or does not exist

I have a PostgreSQL db that was running on my server. I tried to do a db_dump and got a weird error message. I eventually thought I would just restart PostgreSQL. However its now stopped and won't ...
2
votes
1answer
1k views

Warnings while running AutoMysqlBackup

I am using Automysqlbackup.sh file to take MySql backups on Ubuntu.I have only 1 database. But when i run this script then it generates several Warnings (plus a error mail) like below Errors reported ...
0
votes
1answer
563 views

Upgrading MariaDB Galera cluster from 5.5 to 10.0 - rolling upgrade possible?

I've had a good search around and cannot find much on the topic. We want to upgrade our live MariaDB 5.5 Galera cluster to the MariaDB 10.0 branch, ideally without any downtime. We installed ...
4
votes
1answer
3k views

Difference between mongod and mongodb upstart jobs

I just noticed that there are two possible ways to start mongodb: service mongodb start (uses /etc/mongod.conf) service mongod start (uses /etc/mongodb.conf) Can someone tell me what's the ...
2
votes
1answer
78 views

MySQL Memory & max_connections Performance Tuning

So, our site runs WordPress and in the past few days we have been getting tons of spam comments etc. I believe that we are becoming the victims of some kind of bot army that has been crashing our ...
1
vote
1answer
878 views

Postgresql connection refused

I'm trying to remotely connect to my postgresql database. I have two virtual machines set up both running ubuntu 14.04. I am trying to connect to the second vm using the first vm using psql -h ...
0
votes
1answer
5k views

oracle 11gR2 installation on ubuntu 14.04 LTS

I have installed oracle 11gR2 on ubuntu 14.04 LTS. On terminal I wrote following to start oracle: sudo service oracle-xe start on pressing enter, got following output : " Starting Oracle Net ...
3
votes
1answer
1k views

Problems installing Postgis extension on Ubuntu 14.04

I have Ubuntu 14.04 with Postgres 9.3 and I'm trying to install Postgis extension. One of the most recommended and straightforward ways I found is very simple: sudo apt-get install postgresql-contrib ...
2
votes
2answers
1k views

starting pgbouncer on startup

I installed pgbouncer and configured it and it starts only via using this command pgbouncer /etc/pgbouncer/pgbouncer.ini however using service pgbouncer start it dose not start. I then set up ...
6
votes
2answers
10k views

Redis takes up all the Memory and Crashes

A redis server v2.8.4 is running on a Ubuntu 14.04 VPS with 8 GB RAM and 16 GB swap space (on SSDs). However htop shows that redis alone is taking up 22.4 G of memory! redis-server eventually crashed ...
1
vote
2answers
11k views

How do I allow remote mysql access to all users?

I have setup a mysql server on unbuntu. The server hosts websites for my various clients. Hence, I want all of them(and any new clients) to have remote access to the mysql server. How do I configure ...
3
votes
1answer
263 views

Very large btree index with few rows (openstreetmap gis data)

I tried to import a subset of open street map data to a Postgres database using the standard tool (osm2pgsql). I then tried to rebuild the indices on the table using plain sql (dropping them, then ...
0
votes
0answers
183 views

MySQL 5.5, Xubuntu 14.04 - INSERT and UPDATE bottleneck

DBAs: I have been developing and maintaining plugins for Moodle for the last ~2 years, and have recently decided to try using my local desktop again, rather than my institutions ESX VMs, as a ...