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

0
votes
1answer
16 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
29 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
36 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 ...
0
votes
1answer
42 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., ...
0
votes
1answer
26 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 ...
0
votes
1answer
154 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
26 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
34 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
59 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 ...
0
votes
1answer
29 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
23 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
175 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
32 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
96 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]' ...
1
vote
1answer
158 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
2answers
44 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
38 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
65 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?
0
votes
0answers
42 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
22 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
55 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
0answers
20 views

MySQL by default autostarts on Ubuntu Linux?

I installed MySQL server on Ubuntu Linux 14.04 LTS following instructions at https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu. The console ...
0
votes
0answers
139 views

Galera: WSREP: gcs connect failed: Socket type not supported

I am having a problem when trying to start the 2nd and 3th nodes. The node number 1 has started ok with no problem: I use the same configuration file for galena.cnf and my.cnf : change the ...
0
votes
0answers
20 views

Should I install hadoop on a single node

I just bought a desktop computer with 16GB RAM and 1TB drive, i7-quad core. I will be partitioning off 800GB for Ubuntu so I can do some data science type tasks. Is there any advantage to installing ...
0
votes
1answer
51 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
36 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
179 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 ...
0
votes
0answers
131 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
104 views

ubuntu - Pm2 mysql high cpu usage

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
3answers
233 views

How i can export just structure of mysql database

I use ubuntu 14.10 Phpmyadmin I have ''big'' mysql database, 900mb, I need just structure of this database, how i can export just database structure/empty database without remove data or download ...
0
votes
1answer
167 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
718 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 ...
0
votes
0answers
62 views

MySQL performance_schema not working properly?

I have MySQL 5.6.19 community server running on my Ubuntu 14.04. Lately I have been trying to monitor MySQL server using performance_schema. Previously I used to do this by running SHOW FULL ...
2
votes
1answer
507 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
383 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 ...
1
vote
1answer
933 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 ...
0
votes
0answers
76 views

Pre requirements missing when installing oracle database 11g Ubuntu

I'm trying to install Oracle Database 11g on Ubuntu 14.04. At the middle of executing ./runInstaller I'm getting following message saying about missing prerequisites. This says make is missing but, ...
0
votes
0answers
44 views

mysqldump replace option - ubuntu / mediawiki

I know this is probably a silly question, but I'd like to be sure, rather than make assumptions. There's the option to use 'replace' in a mysqldump, which uses the 'REPLACE' rather than the 'INSERT' ...
1
vote
0answers
45 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
225 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
3k 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 ...
2
votes
1answer
488 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 ...
0
votes
2answers
507 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 ...
3
votes
2answers
3k 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 ...
0
votes
2answers
7k 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
152 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
126 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 ...
0
votes
1answer
2k views

Good configuration for 2gb (my.cnf) [duplicate]

I'm little newbie in configuring mysql and i seek a good configuration for mysql i have one site in ajax with many query and very slowly with VPS Iam in kimsufi 2gb i run only mysql in vps not apache ...
0
votes
0answers
35 views

Optimization mysql very slowly [duplicate]

Hello I have a server in kimsufi 2gb RAM and 500gb storage but the query with php mysql is very slowly I have change innodb buffer pool size to 500M but i have error too many connections, i add max ...
0
votes
0answers
54 views

Starting up postgres on Ubuntu for the first time

I've installed postgres on ubuntu, created a node and now I'm trying to start up that node as per the instructions: postgres --coordinator -D /usr/local/pgsql/data -p 1281 But I get the following ...