Questions tagged [debian]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
194 views

MySQL listens at port 3306 even after changing it

I changed MySQL default port from 3306 to 12929 in my.cnf in both client and mysqld sections on Debian. After that I restarted MySQL service. Then I ran netstat -tln and saw that MySQL is still ...
3
votes
3answers
7k views

how to safely stop mysqldump?

I (well, my cron script) tried killall mysqldump and that didn't end very well - mysql server stopped accepting connections after a while. It was Debian Jessie machine with mysql 5.5.55-0+deb8u1. ...
0
votes
0answers
389 views

Using Ubuntu, `ogrinfo` fails to open an mdb file

Whenever I try to open a sample-mdb file, I'm getting ogrinfo Campaign_Template.mdb ERROR 1: PGeo: MDB Tools driver not found! Warning 1: Unable to install MDB driver for ODBC, MDB access may not ...
1
vote
0answers
2k views

pg_createcluster - Error: cluster configuration already exists

Wow! I seem to be stuck in the 9th level of pg wrapper command hell... On Debian, have been trying to delete cluster 'main' (in order to recreate using appropriate locales and other options...) ...
0
votes
1answer
1k views

PostgreSQL pg_ctlcluster won't work

today I was reconfiguring some stuff on a PostgreSQL 9.4 install on a Debian 8. After being done I typed # pg_ctcluster 9.4 main restart as usual, but this time it wouldn't start back up. The error ...
5
votes
1answer
19k views

Command not found: pg_ctl on Ubuntu

PostgreSQL 9.4.8 Ubuntu 16.04 64 bit I just want an explanation of what is happening here. Why is this command not found? Nothing else. malikarumi@Tetuoan2:/usr/lib/postgresql/9.4/bin$ pg_ctl stop -...
13
votes
1answer
49k views

PgAdmin 4 installation on Debian/Ubuntu [closed]

PgAdmin 4 1.0 has been just released, but on the download page for Linux there is only a link to a yum installer. Anybody knows if there are plans to create a deb installer? Or if there is already ...
2
votes
0answers
545 views

Try to create cluster PostgreSQL Debian

I try to create a cluster with log in folder using PostgreSQL on Debian 8 First I create db folder, and mark postgres as owner. Then I create logs folder, and and logs/log file. Try to create ...
1
vote
0answers
261 views

Londiste PostgreSQL replication over slow connection

I've got a setup with a single master and two branches. Unfortunately, the network connection to the master is over a 3G wireless network. It's not terribly slow, but the latency is pretty high. ...
0
votes
1answer
1k views

MySQL won't start, no log ins /var/logs/mysql*

MySQL sudently stop working, when start manually mysqld with `mysqld`` command: # mysqld 160805 11:34:10 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and ...
0
votes
2answers
2k views

ORACLE12 - Connect Via SqlPlus

I have a local installation of Oracle Before i can connect directly via SqlPlus but now when i try to connect i have this error : ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory ...
2
votes
3answers
11k views

using tnsnames.ora and sqlplus client without installing oracle 11g server on linux client [closed]

I want to create a connection to remote Oracle server using SQLplus client and tnsnames.ora without installing Oracle 11g server on the Linux client. I used debian and bash script to generate reports ...
0
votes
0answers
502 views

Cannot Start MongoDB

I cannot start MongoDB on Debian(Jessie 8.4 Stable). I generated the keyfile and added the path to the key file to the configuration and uncommented the "auth=true" but when I try to start the service ...
1
vote
2answers
48 views

Cannot execute inserts querys after upgrade to mysql 5.7

I have Debian 8 (Jessie) server and i followed this procedure to upgrade from mysql 5.5 to mysql 5.7 https://dev.mysql.com/doc/refman/5.7/en/linux-installation-debian.html Now, any script in the ...
0
votes
1answer
50 views

Install MongoDB on Debian

I tried to install MongoDB using this command: apt-get install mongodb=3.0.1 But the version 3.0.1 was not found. How can I install it?
1
vote
0answers
466 views

floating point exception in isql with mariadb

I have this problem in my Debian server : $ isql -v asterisk-connector [1] 13397 floating point exception isql -v asterisk-connector I already checked logs / google and got nothing Distributor ...
3
votes
1answer
2k views

What are the minimal MySQL grants for the debian-sys-maint user?

What are the minimal privileges that debian-sys-maint@localhost needs for the mysql service to work correctly? This answer on ServerFault suggests granting RELOAD only, but this is incorrect, as it ...
0
votes
0answers
30 views

Debian Server failover setup [duplicate]

I need to set up two servers with failover capability (Active - Passive model) sharing a common DB (Postgres)running over NAS. Could you please suggest me some workaround for the same ?
1
vote
1answer
620 views

MySQL: Reducing amount of open files

So, I currently have a problem with my mySQL server opening far too many file handles. This requires me to restart to server each day, as otherwise, I get the infamous "errno 24, too many open ...
0
votes
1answer
452 views

What to do when MySQL is not generating any logs at all on Debian?

The problem I'm having is that MySQL (5.5.46-0+deb7u1) is not generating log files. This on Debian Wheezy. The my.cfg file has been updated according to the required config for logging ALL queries (...
0
votes
0answers
252 views

Is my system configuration restricting me to psql:i386?

When I try to run psql on 64 bit sid I get this error message: /usr/lib/postgresql/9.4/bin/psql: symbol lookup error: /usr/lib/postgresql/9.4/bin/psql: undefined symbol: PQconninfo I needed to run ...
4
votes
1answer
7k views

Subtract time difference between two columns in a table

Problem: How can I subtract the TIMEDIFF between two sensors (sensor 1 and sensor 2 in the example below) and return the the value in mili seconds? How do I get with the resolution of milliseconds? ...
4
votes
6answers
139k views

“Table doesn't exist in engine” after moving tables from one VPS to another

I have two VPS's running right now. One, which I will refer to as the "old" server, runs on Debian 7 and gives this output for mysql --version: mysql Ver 14.14 Distrib 5.5.44, for debian-linux-gnu (...
2
votes
1answer
1k views

How to determine if pg_dumpall is still running

Environment: Postgres 8.4 Debian Squeeze LTS Recently we switched from a backup solution around hot_backups to using pg_dumpall. This solution used a pid file as long as the hot_backup was running,...
4
votes
6answers
57k views

Problem with new MySQL Workbench connection

I'm working on Debian 8 and wanted to create database using MySQL Workbench. I did everything in this tutorial, but when I created a new MySQL Connection, the program returned: Failed to Connect ...
2
votes
1answer
1k views

Neo4j service won't start with an imported database on Debian

I've been playing around with neo4j recently on my Debian 7.8 install. It's awesome! Today I imported around 100000 nodes and 75000 relationships using neo4j-import tool. I stopped the neo4j service ...
18
votes
2answers
47k views

How to reinitialise /var/lib/mysql files?

Due to a mishap I deleted the entire /var/lib/mysql directory. Since the database did not contain anything important, I do not want to go through the hassle of restoring it from an old backup, but ...
1
vote
1answer
674 views

Why SELECT is so slow

I have the following table CREATE TABLE words ( id bigint(20) NOT NULL, `text` int(11) NOT NULL, w1 int(11) NOT NULL, w2 int(11) NOT NULL, w3 int(11) NOT NULL, w4 int(11) NOT NULL, ...
8
votes
1answer
4k views

Postgres privileges: psql \dp - what is about the plus-sign

I used psql-command "\dp" to find out the given grants. Versions on test-server: PostgreSQL 9.1.15 on armv7l-unknown-linux-gnueabi, compiled by gcc (Debian 4.6.3-14) 4.6.3, 32-bit Out of the ...
1
vote
1answer
264 views

mongodb wont read config file using upstart

The problem started where mongo wouldn't start because of low disk space. So I enabled the small files directive in the config file. Now it starts if I run: /usr/bin/mongod --config /etc/mongod.conf ...
1
vote
1answer
147 views

Installed Percona-Toolkit, but no sign of xtrabackup

I've installed Percona-Toolkit on my Debian (Wheezy) test Server, using dpkg -i percona-toolkit.deb apt-get install --fix-missing -f dpkg -i percona-toolkit.deb However, there is no sign of ...
1
vote
0answers
6k views

mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect [duplicate]

I am troubleshooting a backup script (bash), and I have limited working knowledge of the current configuration since the last 3 predecessors did not leave any documentation. I do know that my server ...
1
vote
1answer
451 views

mysql multi-source replication to single slave from Debian repo's?

I've been experimenting with mysql 5.7's feature to backup multiple sources to a single slave, but have legacy db's on source servers where I'm not sure if upgrading to 5.7 will break things, and also ...
1
vote
0answers
1k views

debian sudo service mongod status shows failed but mongo is working

I started a replica set with three servers with default port and used a different data directory. But when i did sudo service mongod stop. it said failed. so i went into mongo shell and did a shutdown ...
46
votes
7answers
109k views

Disable MySQL binary logging with log_bin variable

Default MySQL config file /etc/mysql/my.cnf installed by some debian package using APT often set log_bin variable, so binlog are enabled: log_bin = /var/log/mysql/mysql-bin.log When I want to ...
0
votes
0answers
2k views

Mongodb is taking up 7GB of hard drive space on VM, how do I fix?

I am running Debian on a VM. I installed mongodb and it is taking up A LOT of space. It is really slowing me down in college, with work and projects ... etc. I have a disk usage analyzer and I've ...
0
votes
1answer
5k views

Setup mySQL in a chroot in Debian Wheezy

Sounds like a simple question, but the documentation is rare about what mySQL needs to run inside a chroot. I think I'm almost there, but I'm running into a permission problem that I can't solve, and ...
1
vote
1answer
2k views

Dedicated mysql server slow response [closed]

I have server in Kimsufi with 2gb RAM but my server is very slow , with simple hosting in ovh it responds quickly ... With pingdom.com test i have for server: 10 sec and simple hosting: 2sec is ...
1
vote
0answers
1k views

What to do with unused RAM on a MySQL database server?

For years I have been running dedicated servers with more or less limited ressources, resulting in unsatisfying performance of the web application (Drupal). Tools like Matthew Montgomery's MySQL ...

1
2