Questions tagged [debian]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
81 views

Mariadb won't start (can't change dir, errcode 13: permission denied)

I moved my MariaDB database to /media/user/extdrive1/mysql, updated the conf files, and changed chown for the drive to 7777 for user mysql.mysql. Despite all this, sudo systemctl start mysqld fails, ...
0
votes
1answer
77 views

How to use 'mysql -uroot -pXXXX' on Debain 9.8?

My apologies for this lame question. Debian 9.8 changed some things and mysql is broke but I can't seem to fix it. I installed MySQL on Debian 9.8, which now installs MariaDB 10.1. After install I ...
0
votes
1answer
903 views

Access denied for user 'root'@'localhost' What proces is causing this?

I got this connections constantly in logs, how to trace what app is trying to connect? root@localhost is allowed to connect and working for some apps. I think there is some app without changed ...
1
vote
0answers
21 views

MySQL not starting when shut down with mysqladmin

MySQL server 5.5 fails to start when I use the mysqladmin shutdown command to stop the server. The only option to start MySQL server is to reboot the machine. Is there is any option so that I can ...
-1
votes
1answer
92 views

Is mysql using some kind of auto repair due to “check table” warnings?

Today i noticed a "strange" behaviour of MySQL when using "CHECK TABLE" on a crashed table. First i got a warning like "Size of datafile is: * ... Should be: *" but i could still "insert into / select ...
1
vote
1answer
95 views

MySQL perfomance

I have 2 main tables on the server. They have the same structure, but hold different data. Table #1: 214 million rows, size 40GB (25gb indexes) Table #2: 26 million rows, size 5.5GB (3.5gb indexes) ...
2
votes
1answer
307 views

Repmgr: Error to promote Standby Cluster to Master Cluster in failover

I maked the configuration of the failover system based in Repmgr, but i don't haved success to promote the Standby Cluster to Master Cluster in case of failover. Following my configurations, this ...
-4
votes
1answer
279 views

PSQL copy-paste tab-completion and inserting errant parenthesis

Note, I use tabs. Frequently, when I write answers on this site, I write them in vim with the assistance of vim-surround, especially when I'm migrating a fixed-width table/grid to a DDL. Here is an ...
1
vote
0answers
131 views

Best way forward for setting up Debian 9 / MariaDB (10.1.26-0+deb9u1) with root user Adminer access

I have a new Debian 9 LAMP server (includes MariaDB v10.1.26 rather than MySQL). I note that in this build, the debian-sys-maint user no longer exists. Instead a unix_socket is used to grant root user ...
7
votes
3answers
11k views

Install SQL Server on Debian

I want to install SQL Server on Linux. From MS site I read that Red Hat, SUSE, and Ubuntu are supported but I want to use it under Debian. Since Ubuntu is based on Debian, is there a chance to succeed ...
1
vote
1answer
542 views

“sudo -u postgres psql postgres” does not ask for password

I've taken over a system using postgres. When logging in, if I use ... sudo -u postgres psql postgres ...it does NOT ask for a password. However, if I do ... psql -U postgres -h localhost postgres ...
1
vote
2answers
228 views

How do I get the remote hostname of the server?

Can I use the hostname of the server in a PostgreSQL SELECT statement? The following may be close but apparently does not quite work: \set x \! hostname select :x; This is for PostgreSQL 9.6 on ...
0
votes
1answer
785 views

Firebird2.5-superclassic on Ubuntu 16.04 LTS

I installed firebird2.5-superclassic using sudo apt-get install firebird2.5-superclassic and then ran sudo dpkg-reconfigure firebird2.5-superclassic and set the password per https://firebirdsql.org/...
1
vote
2answers
225 views

What administration utilities does Ubuntu and Debian package with PostgreSQL?

I see that there are a lot of tools authored by Ubuntu and Debian for PostgreSQL? Does any one have a list of them, or the build-differences?
0
votes
1answer
70 views

Restore MySQL DB from files

I own a raspberry pi 1 running raspbian jessie (SYS_A). Two weeks ago I performed an update of the system (aptitude update && aptitude upgrade, not aptitude dist-upgrade, since I know it ...
3
votes
2answers
4k views

MySql/MariaDB cannot change default datadir on Debian 9.1 server

I have a problem to move the default datadir of Maria DB to another partition, it appears to be very common but i tried everything I can without luck. Mysql is installed as Mariadb 10.1.26 with the ...
0
votes
1answer
406 views

Unable to start the mongo services on debian server

Mongo DB keep on crashing automatically and all database and collection remove automatically.This is happening randomly and when I check mongod.log I can see it's automatically dropped. Today I got ...
0
votes
0answers
142 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 ...
1
vote
3answers
4k 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
281 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
1k 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
594 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 ...
3
votes
1answer
10k 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 -...
12
votes
1answer
44k 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
481 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
239 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
535 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
1k 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
7k 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
458 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
42 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
47 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
398 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
1k 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
28 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
374 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 files" ...
0
votes
1answer
77 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
198 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
5k 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? ...
3
votes
5answers
93k 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
621 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,...
3
votes
4answers
26k 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 ...
10
votes
2answers
22k 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
309 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, ...
3
votes
1answer
2k 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
255 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
94 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
1k 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
433 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 ...