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
0answers
6 views

Shared memory error while connecting to Oracle

I get this error message each time I try to connect to my Oracle XE local database under Ubuntu 15.10 : user@user-X220:/u01/app/oracle/product/11.2.0/xe/network/admin$ sqlplus SQL*Plus: Release ...
2
votes
2answers
448 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
1answer
111 views

PostgreSQL error moving data directory to home folder

I have a problem with the moving of my data directory of PostgreSQL. I found many different ways, but none worked. The most sensible way for me was: Stop PostgreSQL Copy data from old folder to new ...
0
votes
0answers
7 views

Is it mandate to turn off huge pages in Mysql 5.6

Folks, Is it required to turn off huge pages in Mysql 5.6 server under /sys/kernel/mm/transparent_hugepage/enabled -> To never? We have a heavy transactional database and calling the data segments ...
0
votes
3answers
276 views

lsnrctl is not working on Ubuntu 14.04

I have managed to install Oracle 11g on Ubuntu 14.04 through lots of pain. I managed to install it in the end but listener does not seem to be working and even responding any command. My ...
11
votes
3answers
31k views

How to make MySQL table name case insensitive in Ubuntu?

I am using Ubuntu 13.10 and MySQL 5.6 and I know database name and table name are case sensitive in Ubuntu (and some other *nix environments) by default. Now, I want to make MySQL work as case ...
0
votes
0answers
12 views

postgresql service fails to start after bad reboot

I have a postgresql 9.3 running on Ubuntu 14.04. For some reason, my fellow developer rebooted the server and since then postgresql service is failing to start. Also, the reboot didn't go smooth as it ...
1
vote
3answers
148 views

Trying to create PostGIS database

I am trying to create a spatially enabled PostGIS database by following the PostGIS documentation. In the short version, i executed, createdb yourdatabase createlang plpgsql yourdatabase But I did ...
3
votes
1answer
5k views

Mysql error 28 no space left on the device

I keep running in to the same problem with mysql with error code 28 which means there is not enough space left on the device. Now the weird part is that there is enough space, here are some tips i ...
0
votes
0answers
5 views

Ubuntu: How to soft-link to the latest version of PostgreSQL CLI tools [duplicate]

I have just upgraded my RDS PostgreSQL version from 9.3 to 9.5. In order to access the server, I need to upgrade the Ubuntu CLI tools as well. I have upgraded the tools using the apt.postgresql.org ...
0
votes
1answer
136 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 ...
0
votes
1answer
18 views

Incomplete installation with unsupported locale

I was installing postgresql on Ubuntu 12.04 (Digital Ocean droplet). The locale variables in my environment gets transported to the DO box. When postgres is installed via apt-get install postgresql, ...
1
vote
2answers
383 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: ...
1
vote
2answers
160 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
2answers
49 views

scaling options for mysql on linux vm (ubuntu) : how to scale when the RAID 0 is out of space

I was asked to give a scaling road map for our mysql database. Currently, I have a single mysql instance v5.6.28 running on an ubuntu VM on azure. It has a (software) RAID 0 disk made with two 1TBs. ...
1
vote
1answer
260 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 ...
1
vote
0answers
14 views

ERROR 1 (HY000): Can't create/write to file (Errcode: 13 - Permission denied)

I've been struggling for a couple of days with this now and have been trying to use this thread amongst other google searches to resolve it but can't seem to get it to work. When I run this SELECT ...
1
vote
1answer
69 views

Server warnings on MongoDB startup

I recently installed MongoDB on an AWS EC2 instance running Ubuntu. When I'm starting the MongoDB service, I get some warnings: $ mongo MongoDB shell version: 3.0.11 connecting to: test Server has ...
0
votes
0answers
44 views

How to do rolling upgrade MariaDB 10.0 -> 10.1 on ubuntu 14

I'm trying to figure out how to do a rolling upgrade of our galera cluster running on MariaDB on Ubuntu 14.04. In testing, the first node I upgraded started complaining about the timestamp column in ...
1
vote
4answers
4k 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
0answers
66 views

virtualbox ubuntu 14.04 MySQL access denied for user 'root'@'localhost'

I removed the mysql-server on the virtualbox ubuntu by running : sudo apt-get --purge remove mysql-server and re-installed it, but I still get Access denied with or without password when trying to ...
1
vote
1answer
43 views

My MySQL Server Died

Approximately 1 time per week my MySQL server is shutting down. This is what the log looks like: 2016-03-18 13:46:25 13166 [Warning] Buffered warning: Changed limits: max_open_files: 1024 ...
0
votes
1answer
40 views

NLS_LANG AL32UTF8/UTF8 for oracle database

I recently install a new database oracle on ubuntu using this tutorial. But a get an error oracle@ubuntu:/home/bruno$ echo $NLS_LANG /u01/app/oracle/product/11.2.0/xe/bin/nls_lang.sh ...
0
votes
0answers
79 views

How to fix: MySQL job failed to start

background: i installed mysql server on my ubuntu 14.04 aws ec2 server a few nights ago, configured it following guides from reputable sites, and populated it w/ ~80 million rows. a few times, I ...
0
votes
0answers
21 views

MySQL 5.5 client SSL connection only works when adding cipher list argument, why?

I set up the packaged MySQL server 5.5 and client on two Ubuntu VM. I configured the server to support SSL. I can connect to the server with the MySQL CLI tool between the VMs, but the connection is ...
0
votes
0answers
31 views

How to fix the MySQL 5.6 System.Security.Principal.WindowsIdentity.get_User () not implemented exception in Linux?

I would like to know if programmatic intervention is necessary to fix the following C# Runtime exception when running MySql 5.6 Connector.NET on Ubuntu Linux 15.10 instead of Windows 7. Error ...
2
votes
2answers
237 views

Filesystem tuning for PostgreSQL

I want to install PostgreSQL 9.x version in an Ubuntu 14.04 workstation and I'm looking for a recommendation on how to set it up in order to get a good read-write (50/50-balance) performance keep a ...
0
votes
0answers
30 views

MySQL [Warning] IP address could not be resolved

my Server runs good, i have mysql/mariadb + amavisd-new and postfix running but i have in my logs bunch of Feb 23 11:13:55 localhost mysqld[32633]: 160223 11:13:55 [Warning] IP address ...
11
votes
2answers
11k views

Preventing PostgreSQL from starting on boot in Ubuntu

I am using PostgreSQL 9.2 and it runs automatically when I start the system (Kubuntu). How can I avoid this? I need to start it manually, and I don't want it to start unattended because I need to ...
0
votes
0answers
35 views

Need help with corrupted MySQL database

I could use some step by step help on using innodb to hopefully recover a corrupted MySQL database. We are running moodle on a ubuntu server which uses the LAMP stack. The database has been corrupted ...
2
votes
0answers
203 views

MySQL 5.7 + Ubuntu 14.04 eating up my RAM

I've recently installed MySQL 5.7.11 in my Ubuntu 14.04.3 system following these instructions: http://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/ Being totally empty and not being called by any ...
0
votes
1answer
48 views

I would like to emulate the Microsoft SQL Server function GetSqlBinary() in MySQL version 5.6

I would like to emulate the Microsoft SQL Server function GetSqlBinary() in MySQL version 5.6. The C# namespace System.Data.SqlClient implements GetSqlBinary(), which is like fetching a blob.But the ...
0
votes
0answers
38 views

move a postgres cluster to another machine

I have a postgreSQL 8.3 cluster I should move onto a new machine which runs postgres 9.3 (Ubuntu 14.04) . First of all I copied my whole cluster and I pasted into ...
0
votes
3answers
51 views

Getting error while starting mysql by just typing in mysql terminal

I am getting an error while starting mysql, by just typing mysql in the terminal: The error is: amtz@amtz-VPCEA23EN:~$ mysql ERROR 1045 (28000): Access denied for user 'amtz'@'localhost' (using ...
0
votes
1answer
53 views

Could I set my InnoDB MySQL Server session state for SQL_SAFE_UPDATES and INNODB_FLUSH_LOG_AT_TRX_COMMIT?

Could I set my InnoDB MySQL Server session state for SQL_SAFE_UPDATES and INNODB_FLUSH_LOG_AT_TRX_COMMIT using MySQL Workbench's SQL Query window or MySQL Connection Navigator instead of in a c# ...
0
votes
1answer
538 views

Mysql can't write to filesystem

I need to output some queries as csv files. The directory is in the webroot and I want it to be writable by apache too, so I'm trying to add mysql to the www-data group (on Ubuntu). I thought this ...
0
votes
2answers
23 views

how to set mogodb in upstart service with authentication in mongodb way

I set username and password in MongoDB every time I have to run this command in terminal: sudo mongod --auth --port 27017 --dbpath /var/lib/mongodb As soon as I close terminal, MongoDB db also ...
1
vote
1answer
84 views

How to use SSL/TLS between server and client with Postgres?

I don't know much with it comes to security. I'm deploying a virtual machine with my database in a cloud service. I would like to encrypt all the communication between this server and any clients. How ...
2
votes
0answers
131 views

Server Doesn't Listen Error when connecting to PostgreSQL from Client

I have done a lot of research through the Google and have not been able to come up with a solution. I installed PostgreSQL 9.5 and PostGIS 2.1.8 On Ubunutu Server 14.04 and configured PostgreSQL as ...
0
votes
0answers
44 views

Configuring MySQL Cluster

I'm having trouble in configuring my data nodes. My setup is 1 management node, 1 SQL node and 2 data nodes. I'm running mysql-cluster-gpl-7.4.8-linux-glibc2.5-x86_64 on my cluster. My question is do ...
2
votes
1answer
83 views

Disk I/O Utilization at 95%

My disk I/O utilization is at 95% at my MySQL server. What are steps I could take to fix this? It is a Ubuntu VP with 16 GB Memory and 8 cores. Here is a screen-shot of the load:
5
votes
4answers
4k views

could not save history to file “/var/lib/postgresql/.psql_history”: No such file or directory

I'm following this tutorial to set up my postgresql db. http://inventtheweb.blogspot.ca/2012/05/install-postgresql-for-django.html After I finish running the CREATE DATABASE command and run \q I ...
1
vote
1answer
226 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 ...
1
vote
0answers
107 views

How to fix postgres stuck in recovery mode?

I have Jira and Confluence installed in a server. We didn't have any free disk space one day, and these services didn't started correctly, so after deleting some files we now have some free space ...
3
votes
4answers
4k views

pgpool replication not allowing md5 authentication

I have installed both pgpool and postgresql via apt. In pgpool.conf, I have made the changes necessary to use replication mode, as well as my two postgresql databases (currently all running on the ...
1
vote
1answer
216 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: $ ...
0
votes
0answers
29 views

Problems with MariaDB - won't resync nodes - Can we build a good diagnostic set of instructions?

I have a 3 node ubuntu server MariaDB cluster using rsync, which keeps coming un-synced. When it happens I try to add it back in, reboot, and try again, try again with bootstrap... Recently I've found ...
0
votes
1answer
54 views

postgresql.conf file found in both /usr/share/postgresql and /etc/postgresql/

While troubleshooting another issue I noticed that in my Ubuntu 14.04 system there are two postgresql directories containing a postgresql.conf file: /usr/share/postgresql /etc/postgresql/9.3/main/ ...
23
votes
3answers
61k views

List the database privileges using psql

I'm in the middle of a database server migration and I can't figure (after googling and searching here) how can I list the database privileges (or all the privileges across the server) on PostgreSQL ...
1
vote
0answers
28 views

MySQL using cpu after cancelling slow query

I had to cancel a very slow running query after it ran for a few days without completing on my ubuntu server. Since then mysql has been persistently running a process which is using 25-45% of the cpu ...