Re: undiscribe

[Reindl Harald]

WTF

look at the "List-Unsubscribe:" header in every list message and say
thanks to fools using DMARC enabled domains on mailing-lists resulting
in list footers are removd everywhere

no mailing list unsubsribe on planet earth works that way spam every
subscriber, you got a welcome message as you subscribed with
instructions too, keep such informations for later usage

Am 02.12.18 um 15:43 schrieb 高强:
> |
> undiscribe

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Estimate mysqldump size

[Reindl Harald]

Am 28.11.18 um 10:00 schrieb Olivier:
> Is there a way that gives an estimate of the size of a mysqldump such a
> way that it would always be larger than the real size?
keep in mind that a dump has tons of sql statements not existing that
way in the data

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: How to get the MySQL Command-Line Tool to display Unicode properly?

[Reindl Harald]

Am 13.03.2018 um 22:59 schrieb Roger House:
In all respects except one, the treatment of Unicode works just fine. I 
can write Unicode to database tables, read it, display it, etc., with no 
problems. The exception is mysql, the MySQL Command-Line Tool. When I 
execute a SELECT statement to see rows in a table containing the Venus 
and Mars Unicode characters, here is what I see on the screen:


|| Venus | ♀ | | Mars | ♂ | |

What I should see in the right column are the standard glyphs for Venus 
and Mars.


Any ideas about how to get the MySQL Command-Line Tool to display 
Unicode properly?

what operating system
what terminal

all recent Linux systems have UTF8 as default

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: mysql_upgrade then mysqld. I feel very ID-10-T PEBKAC today

[Reindl Harald]

Am 23.02.2018 um 15:15 schrieb Bob Eby:

2018-02-23T14:02:33.962240Z 0 [ERROR] [MY-010735] Can't open the
mysql.plugin table. Please run mysql_upgrade to create it.

How do I run mysql_upgrade if the mysqld server won't start?


post the *full* errorlog and watch for invaluid config stuff

most likely start mysqld without grant-tables (CAUTION: every user with 
and without password works for that time from everywhere!) would break 
the loop so that "mysql_upgrade" suceeds and after that *mmedidiatly* 
start the sevrer again with permission system enabled


https://stackoverflow.com/questions/1708409/how-to-start-mysql-with-skip-grant-tables

https://ma.ttias.be/mysql-table-mysql-plugin-doesnt-exist-after-mysql-upgrade/




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: monitoring mysql performance

[Reindl Harald]

Am 02.11.2017 um 20:09 schrieb Miguel González:

  I have a VPS Web server (Apache 2.4/PHP 7.x + Varnish 4.1) running with
MySQL 5.6. I have 20 Gb of RAM. I serve Wordpress sites mainly all using
innodb.

  So I´m thinking of ways of improving MySQL performance and of course
for that, you need to measure.

  Currently I´m checking, there are no slow queries and read and writes
perform well. I have enabled slow queries logging but the truth is that
most queries logged are not slow, they are just slow when the web server
load is too high, so when you try to check those queries at other time,
there isn´t anything wrong with them


so what evidence do you have that it's the database server at all?

mysqltuner would be a good start for config hints in that case

but mostly the webserver load is high because wordpress, joomla and all 
that crap is terrible inefficient even with PHP7 and opcache enabled and 
so you need caching in the application - not query results, whole 
content parts like navigation and so on - parts of the page which don#t 
change every time and are shared between different pages


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: mysqld_multi

[Reindl Harald]

Am 01.06.2017 um 00:01 schrieb Matthew Black:

I DON'T RUN SYSTEMD, so that's not an option. At all. Why is that so hard to 
grasp?


then just clone the sysvinit script as i have done years ago before 
syetemd on dozens of machines without ever touch mysqld_multi - why is 
that so hard to grasp?



Where do I enter the command "create table database" when mysqld isn't running? 
It isn't possible to launch mysqld when there's no database directory or initialized 
database.


*that* was missing from the very begin but still RTFM
https://dev.mysql.com/doc/refman/5.7/en/mysql-install-db.html

in my google search field is nothing more than "mysql init database"

and guess what - when you have *somewhere* a running instance you can 
just shut it down, rsync the "mysql" folder from the datadir to the new 
instance and just fire it up - that's how i clone and init mysqld 
instances since 15 years, i explained that already



You fail to grasp my problem and your answers are completely unhelpful


you fail to describe your problem properly


they don't behave anything different if you have a single server


Really? With mysqld_multi, each mysqld daemon listens on a separate port. Each 
database instance gets its own environment that database administrators control 
WITHOUT INTERFERING with other database instances. In single-server 
environment, the server listens only on port 3306 and all databases run on that 
one port; it is not possible to shutdown individual databases, only ALL 
databases.


tell me something new - but there is no difference how you connect to a 
databaseserver - just host/port or host/socket - so what


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: mysqld_multi

[Reindl Harald]

Am 31.05.2017 um 17:48 schrieb Matthew Black:

# mysql -uroot -p --socket=/MySQLdb/cba/mysql.sock
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';
mysql> quit

I was simply seeking those three commands, but the reference manual did not 
provide a real-world example.


they don't behave anything different if you have a single server, 
mysqld_multi or just a dozen mysqld instances started directly with 
systemd and "Can anyone provide a simple example of how to edit 
/etc/my.cnf file and command line steps necessary for creating a new 
database running on, for example, port 3311" still is nosense besides a 
basic command like "create table database" where your problem was 
obviosuly connect to the instance at all


in my first response you got:
[harry@srv-rhsoft:~]$ mysql --help | grep port

well, find the socket option is similar

[harry@rh:~]$ mysql --help | grep socket
  -S, --socket=name   The socket file to use for connection.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: mysqld_multi

[Reindl Harald]

can't you just stop reply-all so that responses are going back to the 
list


Am 20.05.2017 um 12:01 schrieb Johan De Meersman:

He means a database, not a schema. Instance would have been clearer as 
terminology goes, admittedly, but in a MySQL context the two are identical.


database and instance are identical?

> I just installed MySQL Enterprise Edition 5.7 on RHEL 6.8 to
> replace an aging 5.1 system running on RHEL 5. We run
> mysqld_multi with multiple instances, each database on its
> own TCP Port 33xx. I'm having trouble creating a database
> on the new server in a multi environment.

i still have no idea what is the problem

* connect to the instance with "mysql -h 127.0.0.1 -P 3307 -u root -p"
* create database dbname


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: mysqld_multi

[Reindl Harald]

Am 19.05.2017 um 18:42 schrieb Matthew Black:

Sorry, but that is not the least bit helpful. We are not ready for RHEL 7, 
which is VERY different than prior versions. I don't really need the victim 
blaming for using an earlier RHEL release that is still fully supported and in 
widespread use.


your problem - we are using Fedora in production since 2008 and systemd 
was introduced that i even can't remember the sysvinit mess...



As for /etc/my.cnf, that's where one defines the port, database location, log 
file, port number, and user, so they don't have to be placed on the command 
line.


and how do you imagine hat to work for *multiple instances*


Your response does not explain the command line steps necessary for creating a 
new database.


becasue creating a database is absolutely basic stuff at all and if you 
mean the mysql database with users itself - well, i hvanet created one 
from scratch since 2003 because they are portable between 
windows/linux/osx and i just rsync the folder or a baisc install and 
that's it



-Original Message-
From: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Friday, May 19, 2017 9:27 AM
To: mysql@lists.mysql.com
Subject: Re: mysqld_multi



Am 19.05.2017 um 18:19 schrieb Matthew Black:

I just installed MySQL Enterprise Edition 5.7 on RHEL 6.8 to replace an aging 
5.1 system running on RHEL 5. We run mysqld_multi with multiple instances, each 
database on its own TCP Port 33xx. I'm having trouble creating a database on 
the new server in a multi environment.

Can anyone provide a simple example of how to edit /etc/my.cnf file and command 
line steps necessary for creating a new database running on, for example, port 
3311?


what has this to do with the my.cnf?
just connect to the correct instance and that's it

and probably get rid of RHEL6 because with systemd you don't need all
the crap around to start multiple instances, just a few lines in the
unit-file pointing to the correct config and mysqld_safe is also no needed

[harry@srv-rhsoft:~]$ mysql --help | grep port
-P, --port=#Port number to use for connection or 0 for
default to, in
--progress-reports  Get progress reports for long running commands (like
(Defaults to on; use --skip-progress-reports to
disable.)


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: mysqld_multi

[Reindl Harald]

Am 19.05.2017 um 18:19 schrieb Matthew Black:

I just installed MySQL Enterprise Edition 5.7 on RHEL 6.8 to replace an aging 
5.1 system running on RHEL 5. We run mysqld_multi with multiple instances, each 
database on its own TCP Port 33xx. I'm having trouble creating a database on 
the new server in a multi environment.

Can anyone provide a simple example of how to edit /etc/my.cnf file and command 
line steps necessary for creating a new database running on, for example, port 
3311?


what has this to do with the my.cnf?
just connect to the correct instance and that's it

and probably get rid of RHEL6 because with systemd you don't need all 
the crap around to start multiple instances, just a few lines in the 
unit-file pointing to the correct config and mysqld_safe is also no needed


[harry@srv-rhsoft:~]$ mysql --help | grep port
  -P, --port=#Port number to use for connection or 0 for 
default to, in

  --progress-reports  Get progress reports for long running commands (like
  (Defaults to on; use --skip-progress-reports to 
disable.)


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Ssd vs mix of ssd and spinning disk

[Reindl Harald]

Am 08.05.2017 um 19:53 schrieb Shain Miley:

Hello,
We have traditionally setup our mysql database servers with a mix of ssd and 
spinning disk drives.

We use the ssd drives (Raid-1) for the mysql tablespace data, and we use the 
spinning disks (15 sas in Raid-1) for the index data, etc.

I am wondering if going forward we should simply put all of the data on the ssd 
drives. Does anyone have any information on whether or not we would see any 
significant performance increase if we made this switch?

I have been thinking about using 4 ssd drives (Raid-10) going forward…and 
wondering if we should expect to see any improvement in the database 
performance.

Any thoughts?


http://www.tansi.org/hybrid/


CAUTION: only works for RAID1 - not for linux RAID10

if i only woul dhave knwen that 10 years ago i would have my setups with 
4 disks on two RAID1 with a RAID0 on top...


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: tcmalloc mysql 5.7.14

[Reindl Harald]

Am 08.05.2017 um 13:51 schrieb Machiel Richards:

We are having an issue with memory allocations on mysql 5.7.14 whereby
mysql is not releasing the memory that is being allocated during
mysqldump processes.

 This has been logged as a bug with mysql dev team however they do not
see this as a bug and suggested we test using another malloc library
such as tcmalloc.

However from what I can see, this is no longer included in mysql 5.7
and thus I am trying to find out if anyone can tell me how to enable /
install this and how to tell mysql to use this library.


does the oracle stuff not support "jemalloc" like MariaDB

MariaDB even suppports "-DWITH_JEMALLOC=system" because it's not the job 
of random software ship and build random library sources in their 
tarballs which usually don't get much attention in case of updates 
(others than system packages)


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Can not add foreign key constraints

[Reindl Harald]

Am 24.04.2017 um 16:18 schrieb David Mehler:

  I'm trying to add a table to an existing database. I'm wanting it to get
  one of it's fields from an already existing table. I've done this
  before in this database. This works:

  CREATE TABLE `virtual_users` (
`id` int(11) NOT NULL auto_increment,
`domain_id` int(11) NOT NULL,
`user` varchar(40) NOT NULL,
`password` varchar(128) NOT NULL,
`quota` bigint(20) NOT NULL DEFAULT 256,
`quota_messages` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE KEY `user` (`user`),
FOREIGN KEY (domain_id) REFERENCES virtual_domains(id) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

  This does not:

  CREATE TABLE IF NOT EXISTS `lastauth` (
  `user` varchar(40) NOT NULL,
  `remote_ip` varchar(18) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
  CURRENT_TIMESTAMP,
  PRIMARY KEY (`user`),
  FOREIGN KEY (user) REFERENCES virtual_users(user) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

  Can anyone spot the situation?


wouldn't it be cool if you post the errors you get from the start?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL server has gone away

[Reindl Harald]

Am 03.04.2017 um 21:22 schrieb Mahmood N:

well, who did set it that low?


ِDon't know. Maybe the previous admin hadn't used mysql for sending emails!!


on a proper server you have a local smtpd like postfix listening on 
127.0.0.1 and hence you can send thousands of messages within seconds 
from a web-application and your local relay queues messages and try to 
deliver them by default up to 5 days


when you use a remote smtpd directly froma php application your are 
doing all wrong - what when the smtpd is not reachable or got restarted 
in the middle of sending?


how to act on a 4xx temporary error?

anything which takes more then 30 seconds needs to be fixed proper and 
then the timeout would not have been a probkem at all



On Monday, April 3, 2017 11:37 PM, Reindl Harald
 wrote:

Am 03.04.2017 um 20:41 schrieb Mahmood N:

Good news!

I changed wait_timeout=30 to wait_timeout=600 and now the error
disappears... I don't know if long_query_time=1 has effect.


well, who did set it that low?

https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_wait_timeout

http://orbisius.com/howto/web-development/change-mysqls-wait_timeout-interactive_timeout-variables/



On Monday, April 3, 2017 10:32 PM, Mahmood N 
<mailto:nt_mahm...@yahoo.com>> wrote:

I tested with both 5 and 1 and see the log files are empty.

I am really confused about that error and it is taking more than 2 weeks
about that!


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL server has gone away

[Reindl Harald]

Am 03.04.2017 um 20:41 schrieb Mahmood N:

Good news!

I changed wait_timeout=30 to wait_timeout=600 and now the error
disappears... I don't know if long_query_time=1 has effect.


well, who did set it that low?

https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_wait_timeout

http://orbisius.com/howto/web-development/change-mysqls-wait_timeout-interactive_timeout-variables/


On Monday, April 3, 2017 10:32 PM, Mahmood N  wrote:
I tested with both 5 and 1 and see the log files are empty.

I am really confused about that error and it is taking more than 2 weeks
about that!


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL server has gone away

[Reindl Harald]

Am 03.04.2017 um 19:45 schrieb Mahmood N:

So I set long_query_time=5 and restarted the service. Test the email
page again. Still the logs are empty


WTF - you had it set to 5 seconds 2 hours ago
i am out here...

Am 03.04.2017 um 18:11 schrieb Mahmood N:
> The my.conf file contains
>
> log_error=/var/log/mysql/error.log
> slow_query_log=1
> slow_query_log_file=/var/log/mysql/error_slow.log
> max_connections=200
> max_user_connections=30
> wait_timeout=30
> interactive_timeout=50
> long_query_time=5
> character-set-client-handshake = FALSE
> thread_concurrency = 8
> query_cache_size = 16M
> thread_cache_size = 8
> max_allowed_packet = 8M

"long_query_time=5" is low when you talk about 5 seconds as i remember 
in previuos posts - given that a reasonable server should be able to 
handle hunredts to thousands of requests per second anything above 1 
second is a alert sign


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL server has gone away

[Reindl Harald]

Am 03.04.2017 um 19:26 schrieb Mahmood N:

given that a reasonable server should be able to
handle hunredts to thousands of requests per second anything above 1
second is a alert sign


Excuse me, do you mean higher values are better? I didn't understand. I
said in my posts that when I submit the email test, the refresh time for
that page is about 5 minutes.


if you think a moment you realize that lower values are better when 5 
seconds don't log any query and you have obvious slow queries



look also in phpinfo() for mysqlnd and mysql params containing "timeout"
and/or "max"


in /etc/php/7.0/apache2/php.ini I see

;mysqlnd.net_read_timeout = 31536000

Note that is comment


since when is phpinfo() - the *real* active configuration be it changed 
by some config snippet, vhost-configuration or even ini_set() - the same 
than a random file in /etc?


http://php.net/manual/en/function.phpinfo.php

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL server has gone away

[Reindl Harald]

Am 03.04.2017 um 18:11 schrieb Mahmood N:

The my.conf file contains

log_error=/var/log/mysql/error.log
slow_query_log=1
slow_query_log_file=/var/log/mysql/error_slow.log
max_connections=200
max_user_connections=30
wait_timeout=30
interactive_timeout=50
long_query_time=5
character-set-client-handshake = FALSE
thread_concurrency = 8
query_cache_size = 16M
thread_cache_size = 8
max_allowed_packet = 8M


"long_query_time=5" is low when you talk about 5 seconds as i remember 
in previuos posts - given that a reasonable server should be able to 
handle hunredts to thousands of requests per second anything above 1 
second is a alert sign



I restarted the mysql server (/etc/init.d/mysql restart on ubuntu) and
tested the email page one again. I again see that error message on the
browser, however, the log files are empty.


look also in phpinfo() for mysqlnd and mysql params containing "timeout" 
and/or "max"


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL server has gone away

[Reindl Harald]

Am 03.04.2017 um 17:52 schrieb Mahmood N:

Dear all,
Currently max_allowed_packet is set to 8M. That test email is simply a test 
email containing some basic information in the message body to assure that the 
email system works.
Thing that can help me is to put mysql in the debug mode in one terminal and at 
the same time, submit a test email from the browser. Then I can see what is 
going there in sql. This process is similar to sshd debug mode where I can turn 
on the ssh service in the debug mode and see what is what. Is there is any 
other option for debugging, please let me know.


The MySQL Error Log may  contain details explaining why mysqld was unable to 
stay running

If you are referring to /var/log/musql/error.log then I have to say it is empty!


Perhaps you could connect your mysql client, load the screen, then run show 
full processlist every second or so to see what queries are going on.

As I said, I know few things about mysql. Please let me know the steps to do 
that


https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: multiple domain names mapped to a single IP

[Reindl Harald]

Am 02.03.2017 um 16:41 schrieb Bruce Ferrell:

There are two ways to approach this:

1.) Turn off name resolution in MySQL and only do the ACL by IP. This is
probably best as name resolution can slow the database and cause
outright app failure if DNS fails for any reason.

2.) Make absolutely certain the names resolve correctly in DNS... Then
see point 1 above.


he is talking about *server* address not the client

that you always should use "skip-name-resolve" and never ever set 
permissions based on reverse-DNS because a) when DNS lags everything 
lags and b) it is easy for many people which control the PTR of their 
zone let it answer what ever yxou wanted to see for grant access


but again: pointing with several hostnames to the same IP has nothing to 
do with reverse-lookup at all (nowhere)


on the other hand it makes no sense at all in context of a 
database-server because it has no concept of vhosts at all



On 3/2/17 7:01 AM, Kaushal Shriyan wrote:

Is there any pros and cons to multiple domain names mapped to a single IP
work in MySQL client server setup like in case of httpd webserver
there is
a concept of VHost having multiple domain names mapped to a single IP?

For example :-

int-mysqldbserver1.example.com :- 192.168.0.11
int-mysqldbserver2.example.com :- 192.168.0.11

Will there be a issue when i point full qualified domain name in the
application which uses mysql client program since both domain names are
pointing to the same IP?

Any help will be highly appreciable.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: multiple domain names mapped to a single IP

[Reindl Harald]

Am 02.03.2017 um 16:01 schrieb Kaushal Shriyan:

Is there any pros and cons to multiple domain names mapped to a single IP
work in MySQL client server setup like in case of httpd webserver there is
a concept of VHost having multiple domain names mapped to a single IP?

For example :-

int-mysqldbserver1.example.com :- 192.168.0.11
int-mysqldbserver2.example.com :- 192.168.0.11

Will there be a issue when i point full qualified domain name in the
application which uses mysql client program since both domain names are
pointing to the same IP?

Any help will be highly appreciable


as long there are no tls certificates are verified which in that case 
should contain SAN for both names a client don't care anyways for names, 
it just connects to a IP address relsoved over whatever method 
(/etc/hosts, DNS, NSS)


how would a client which resolves "int-mysqldbserver1.example.com" even 
know that "int-mysqldbserver2.example.com" exists - it can't which 
answers the primary question


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Changing a field's data in every record

[Reindl Harald]

Am 20.02.2017 um 10:35 schrieb Lucio Chiappetti:

On Sat, 18 Feb 2017, debt wrote:


How does one "grab" the existing data and then change it? Can this
be done solely in MySQL


I am not sure to understand your question ... you usually manipulate
data inside mysql ... but here it seems to me you are not talking of
changing the data VALUE (UPDATE table SET column=new value WHERE ...)
but of changing the DATA TYPE (ALTER TABLE table CHANGE or ALTER TABLE
table MODIFY depending on whether ypou change the column name too) or
even of (just) changing the FORMAT in which a value is displayed ...


but what he needs is a "select field from bla; foreach($data as 
$row){str_replace('x', 'y'); update table" for every record and he would 
like to do it in pure sql



Is there a formula to change the format of the data in a single
field in every record of a table?  She has a "timestamp??? in a
text field formatted as 2017|02|16|04|58|42 and she wants to
convert it to a more human readable format like 2017-02-16 @
04:58:42


curious ... the default format for a time stamp is very similar to the
latter (except for you funny at-sign) :

mysql> select time from north33 limit 1;
+-+
| time|
+-+
| 2013-01-22 12:47:47 |
+-+


and what has this to do with a TEXTFILED CONTAINING STRINGS LIKE 
"2017|02|16|04|58|42" - you need to understand what you quote first 
before you can comment it...



and only if I cast it to an integer I get the other form

mysql> select time+0 from north33 limit 1;
++
| time+0 |
++
| 20130122124747 |
++


completly unreleated to the problem


Anyhow I advise you to read the mysql manual and in particular the
function chapter and the "time and date function" subchapter. E.g. here

https://dev.mysql.com/doc/refman/5.7/en/functions.html


problem is that you did not understand the problem of the OP at all and 
pointing blindly to the manual is useless


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Changing a field's data in every record

[Reindl Harald]

Am 19.02.2017 um 11:11 schrieb Peter Brawley:

On 2/18/2017 15:13, debt wrote:

I’ve been asked to post a question here for a friend.

Is there a formula to change the format of the data in a single
field in every record of a table?  She has a "timestamp” in a text
field formatted as 2017|02|16|04|58|42 and she wants to convert it to
a more human readable format like  2017-02-16 @ 04:58:42

How does one "grab" the existing data and then change it?


If it's a timestamp, it's saved as 2017-02-16 04:58:42, not as you
showed it, and there's no need to change it, indeed she couldn't.
Instead, in a query that retrieves the timestamp, use the mysql
date_format() function to format the timestamp as desired.


you missed the quotes around timestamp as well as "in a text field 
formatted" and so THERE IS a need to change it - please consider to read 
before answer


as i read the post i hoped someone will say it nicer in between: 
*nobody* right in his mind saves timestamps in a "human readable format" 
but as a unix timestamp or date with the correct field type


unix timestamps have the advantage that they can be also in PHP simple 
compared with <>, < and > because it#s just the seconds since 1970-01-0-1


since this is nothing but random text you just need to select the data, 
split them, chnage the filed type, write them back and replace the 
direct output with strftime()


http://php.net/manual/de/function.explode.php
http://php.net/manual/de/function.mktime.php
http://php.net/manual/de/function.strftime.php


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: rescue Inno tables from an abandoned data directory?

[Reindl Harald]

Am 03.12.2016 um 21:23 schrieb Martin Mueller:

In my case, I can reproduce Time machine backups of data directories at varying 
times. At one point I was able to replace the non-working installation with an 
earlier installation, but then it failed unpredictably.

Are the Inno tables on Time Machine useless, or can I rescue data from them?


backup of files like innodb while the daemons are running is in general 
problemtaic, not only for time mahine, also for LVM snapsots


hence we use for 10 years now replication slaves which are stopped, the 
datadir rsynced and the slave started again to avoid all that other 
stuff just for having a relieable and consistent snapshot


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Mysql 5.6, Centos 7 and errno: 24 - Too many open files - Again

[Reindl Harald]

Am 01.12.2016 um 08:26 schrieb Götz Reinicke - IT Koordinator:

it happend again and I can't fix it, may be someone has a working
solution and information on that:


surely -> man systemd

LimitNOFILE=infinity
LimitMEMLOCK=infinity
OOMScoreAdjust=-1000



I installed the most recent mysql 5.6 community on a server and do get a
lot of "errno: 24 - Too many open files".

There are suggestions to increase the open_files_limit, change/add that
to /etc/security/limits.conf and modify the systemd script by hand


/etc/security/limits.conf don't matter
/etc/systemd/system/servicename.service.d/ is your friend

https://www.freedesktop.org/software/systemd/man/systemd-system.conf.html

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Update to Percona CVE-2016-6662 Vulnerability Communication

[Reindl Harald]

Am 16.09.2016 um 00:21 schrieb Johan De Meersman:

- Original Message -

From: "Reindl Harald" 
Sent: Friday, 16 September, 2016 00:12:26

frankly - mysqld_safe needs to go away and life is beautiful without for
years here and yes taht worked for mysql too before switch to MariaDB

to say it clear: running *any* code as root for a service binding to a
port above 1024 is idiotic by definition


I agree, and I'm happy to say that the release notes for 8.0 mention that it 
has finally gone away. That doesn't change the fact, however, that there are 
countless installations out there that use it, which is whom I was targeting 
with that mail :-)

Is that service description you pasted the one that comes with the MariaDB 
package, or did you roll it yourself ?


my own one shipped by our internal rpm package

used it more or less identical from 2011 where Fedora switched to 
systemd, some security features got added over time (my side as well as 
implementation in systemd)




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Update to Percona CVE-2016-6662 Vulnerability Communication

[Reindl Harald]

Am 16.09.2016 um 00:05 schrieb Johan De Meersman:

This is probably of interest to many of you, and I've not seen it on the list 
yet.

Kenny Gryp's blog about the vulnerability is at 
https://www.percona.com/blog/2016/09/12/database-affected-cve-2016-6662/ .

For those who use it, there's an ansible playbook to patch the workaround into 
mysqld_safe at https://github.com/meersjo/ansible-mysql-cve-2016-6662 .


frankly - mysqld_safe needs to go away and life is beautiful without for 
years here and yes taht worked for mysql too before switch to MariaDB


to say it clear: running *any* code as root for a service binding to a 
port above 1024 is idiotic by definition

___

[root@srv-rhsoft:~]$ cat /usr/lib/systemd/system/mysqld.service
[Unit]
Description=MariaDB Database

[Service]
Type=simple
User=mysql
Group=mysql
ExecStart=/usr/libexec/mysqld --defaults-file=/etc/my.cnf 
--pid-file=/dev/null

ExecStartPost=/usr/libexec/mysqld-wait-ready $MAINPID
Environment="LANG=en_GB.UTF-8"
Restart=always
RestartSec=1
TimeoutSec=300
LimitNOFILE=infinity
LimitMEMLOCK=infinity
OOMScoreAdjust=-1000
TasksMax=2048

PrivateTmp=yes
PrivateDevices=yes
NoNewPrivileges=yes
CapabilityBoundingSet=~CAP_AUDIT_CONTROL CAP_AUDIT_WRITE 
CAP_DAC_OVERRIDE CAP_NET_ADMIN CAP_NET_BIND_SERVICE CAP_SETGID 
CAP_SETUID CAP_SYS_ADMIN CAP_SYS_BOOT CAP_SYS_MODULE CAP_SYS_PTRACE
SystemCallFilter=~acct modify_ldt add_key adjtimex clock_adjtime 
delete_module fanotify_init finit_module get_mempolicy init_module kcmp 
kexec_load keyctl lookup_dcookie mbind mount open_by_handle_at 
perf_event_open pivot_root process_vm_readv process_vm_writev ptrace 
request_key set_mempolicy swapoff swapon umount2 uselib vmsplice

RestrictAddressFamilies=AF_UNIX AF_LOCAL AF_INET AF_INET6
SystemCallArchitectures=x86-64

ReadOnlyDirectories=/etc
ReadOnlyDirectories=/usr
ReadOnlyDirectories=/var/lib
ReadWriteDirectories=/var/lib/mysql

InaccessibleDirectories=-/boot
InaccessibleDirectories=-/home
InaccessibleDirectories=-/root
InaccessibleDirectories=-/media
InaccessibleDirectories=-/run/user

[Install]
WantedBy=multi-user.target
___

[root@srv-rhsoft:~]$ cat /usr/libexec/mysqld-wait-ready
#!/usr/bin/bash

# Service file passes us the daemon's PID
daemon_pid="$1"

# Wait for the server to come up or for the mysqld process to disappear
ret=0
while /usr/bin/true; do
 RESPONSE=`/usr/bin/mysqladmin --defaults-file=/etc/my.cnf 
--socket=/var/lib/mysql/mysql.sock --user=UNKNOWN_MYSQL_USER ping 2>&1`

 mret=$?
 if [ $mret -eq 0 ]; then
  break
 fi
 # exit codes 1, 11 (EXIT_CANNOT_CONNECT_TO_SERVICE) are expected,
 # anything else suggests a configuration error
 if [ $mret -ne 1 -a $mret -ne 11 ]; then
  ret=1
  break
 fi
 # "Access denied" also means the server is alive
 echo "$RESPONSE" | grep -q "Access denied for user" && break

 # Check process still exists
 if ! /usr/bin/kill -0 $daemon_pid 2>/dev/null; then
  ret=1
  break
 fi
 usleep 10
done

exit $ret

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL Platform Migration

[Reindl Harald]

Am 13.09.2016 um 13:47 schrieb Ryan Coleman:

Right...

I don't like seeing people being shredded by a high strung personality because 
they simply don't understand things at your level, Reiny.


the message where you responded with "jackasses" was actually nice and 
you are hardly at the position call me "Reiny"



Be nice to people and I won't say anything. Be an ass and I will.


mind your own dirt - you are not in the position to play internet police

especially when *you* are the guy with wordings like "jackasses" and 
"Your proven track record of asshole first" and i assure you the next 
time you start the same game as 08/2015 with 70 mails within 3 days 
which deserved a special folder in my archive you will regret it deeply



On Sep 13, 2016, at 06:39, Reindl Harald  wrote:


Am 13.09.2016 um 12:13 schrieb Johan De Meersman:
- Original Message -

From: "Ryan Coleman" 
Subject: Re: MySQL Platform Migration

Because they want to be belittled by european jackasses online.


The thing is, while he has a bit of a rough edge, his technical advice is 
always solid. What has your contribution been, outside of insulting him, and 
for some reason, an entire continent?


this guy is just mentally ill and the next steps are:

* starting off-list mails (already happened)
* can't stand the repsone
* add a list-moderator to CC
* setup something in his MUA which send all read messages back
 to me (includig old ones from other lists he reads again)
* can't stand the response to that action
* forwards that responses to my boss
* after having enough of the game and reject his
 envelope asking for list-removal by pretending
 that my server sends bounces to all his list mails while
 in fact it only rejects private email

https://mail-archives.apache.org/mod_mbox/spamassassin-users/201608.mbox/%3cbb0c1584-f56a-4c1e-8b58-0d4b7d9a8...@cwis.biz%3E


the reason for that personal hate (statet on a different list) is that repsone from 
last year: https://marc.info/?l=mysql&m=144526386203911&w=4


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL Platform Migration

[Reindl Harald]

Am 13.09.2016 um 12:13 schrieb Johan De Meersman:

- Original Message -

From: "Ryan Coleman" 
Subject: Re: MySQL Platform Migration

Because they want to be belittled by european jackasses online.


The thing is, while he has a bit of a rough edge, his technical advice is 
always solid. What has your contribution been, outside of insulting him, and 
for some reason, an entire continent?


this guy is just mentally ill and the next steps are:

* starting off-list mails (already happened)
* can't stand the repsone
* add a list-moderator to CC
* setup something in his MUA which send all read messages back
  to me (includig old ones from other lists he reads again)
* can't stand the response to that action
* forwards that responses to my boss
* after having enough of the game and reject his
  envelope asking for list-removal by pretending
  that my server sends bounces to all his list mails while
  in fact it only rejects private email

https://mail-archives.apache.org/mod_mbox/spamassassin-users/201608.mbox/%3cbb0c1584-f56a-4c1e-8b58-0d4b7d9a8...@cwis.biz%3E


the reason for that personal hate (statet on a different list) is that 
repsone from last year: https://marc.info/?l=mysql&m=144526386203911&w=4


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL Platform Migration

[Reindl Harald]

Am 13.09.2016 um 12:09 schrieb Johan De Meersman:

- Original Message -

From: "Reindl Harald" 
Subject: Re: MySQL Platform Migration

why shouldn't it when the identical software is running?
it's just a bunch of files used by mysql


Little/big endianness, for one, although I seem to recall, and your later mail 
confirms, that that is not an issue for MySQL datafiles - and Mac has gone 
Intel years ago anyway.


we discussed this multiple times here


There's no issue in this case; but it's not always as simple as 'same software, 
same binary files'.


that's why you try things out - takes not longer than write 3 mails and 
since you don't touch the original data no risk involved



One thing that is worth looking at, however, is users with the IP/hostname of 
the old host in them - those may need to be changed if the related software is 
also moved.

Also, some Linux distributions do specific setup - Debian, for one, sets up a 
debian-sys-maint user that gets used for clean startup/shutdown/upgrade tasks. 
Both copying over the datafiles and importing a mysqldump from the old db will 
destroy that user entry, so it needs to be recreated manually afterwards. Other 
distributions may or may not have their own quirks.


as said copy it to the new machine and you are done - why do people
these days not just try out things, look if it works and when it don't
asking questions?


Eh. Sometimes it's comforting to get someone else's opinion before messing with 
production systems you're not an expert on


really?

when you *copy* the datadir on the target machine nobody eats your data 
on the old one away and hence you can try out how it behaves on the new 
machine without any risk


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL Platform Migration

[Reindl Harald]

Am 12.09.2016 um 15:06 schrieb Ryan Coleman:

Dear sir,

You do not realize that there aren’t always sys admins on these lists


how does that change the fact that it just works and it did work from 
day one as described long before i became a sysadmin and that it now 
works over 15 years from mysql3 to mariadb 10.1.x


and it's pretty logical that it works just because it's a *binary 
identical copy* where mysqld has no chance at all to know that it lived 
on a different machine first



Your proven track record of asshole first, kid gloves later drives people away.


MIND YOUR OWN BUSINESS


Your fight to change mailing lists is one which only you seem to share.


what fight?
what is the point in producing mail copies?


Goodnight.


to say it with your words: go away!


On Sep 12, 2016, at 7:27 AM, Reindl Harald  wrote:

first: get rid of "reply-all"o n mailing-lists, you break others "reply-list" 
button with the second copy which arrives usually faster the the list one

Am 12.09.2016 um 13:35 schrieb Harrie Robins:

It is bad practice to do so in my eyes (and yes that is an *opinion*).
When you advice people, instruct them to take the proven route, as
described in the mysql documentation


proven route?

proven is that you can *test* how it works out by
* hot rsync
* shut down the old server
* cold rsync
* start the old server
which is scriptable to minimize downtime

after that (while the old machine is still in production) you figure out what 
needs to get adopted in the configuration

then you test your software, prove that everything works fine

in the meantime you can test as often as you want the hot-cold-rsync to refresh 
the mysql databases from production - and *now you have proven* that everything 
works

since you have proven that successful you can write a final script which does 
the sync (over ssh with certificates) a last time, restart the old servers 
network servioce with a prepared network address and on the new server take 
over the old ip adress

and trust me: that way you minimize downtime, have a proven *by yourself* way 
to go which works, is tested and when correct done nobody notices that the 
machine and undrlying operating system changed

after doing that dozens of times for thousands of mysql databases i know what i 
am doing and call bad practice ways which take depending on database sizes 
hours and beware god something goes wrong with your dump


Second, mastering mysqldump should be golden standard for any DBA.
Telling someone that asks for guidance to simply copy around some files
is bad practice as you do not know the level of expertise involved.


the golden standard for any sysadmin is to know where his datafiles and 
configuration files are stored and how they work together - independent of the 
software type


Regards,
Harrie

On 12 September 2016 at 11:03, Reindl Harald mailto:h.rei...@thelounge.net>> wrote:



   Am 12.09.2016 um 10:48 schrieb Harrie Robins:

   Ok let's drop this. Simply copying files to migrate a server is
   not the
   approach to take (in my humble opinion)


   And why?

   When you start with "Get the same release-version of mysql running
   on the target platform" and dump/load what's the point in playing
   around with dump-files when you hava binary datafiles which can be
   used on the destination

   and no - i am not talking about theory

   i migrated a hosting-infrastructure with dozens of servers from OSX
   PPC to OSX Intel and later to Linux x86_64 with just rsync the
   mysql-datadir


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL Platform Migration

[Reindl Harald]

first: get rid of "reply-all"o n mailing-lists, you break others 
"reply-list" button with the second copy which arrives usually faster 
the the list one


Am 12.09.2016 um 13:35 schrieb Harrie Robins:

It is bad practice to do so in my eyes (and yes that is an *opinion*).
When you advice people, instruct them to take the proven route, as
described in the mysql documentation


proven route?

proven is that you can *test* how it works out by
 * hot rsync
 * shut down the old server
 * cold rsync
 * start the old server
which is scriptable to minimize downtime

after that (while the old machine is still in production) you figure out 
what needs to get adopted in the configuration


then you test your software, prove that everything works fine

in the meantime you can test as often as you want the hot-cold-rsync to 
refresh the mysql databases from production - and *now you have proven* 
that everything works


since you have proven that successful you can write a final script which 
does the sync (over ssh with certificates) a last time, restart the old 
servers network servioce with a prepared network address and on the new 
server take over the old ip adress


and trust me: that way you minimize downtime, have a proven *by 
yourself* way to go which works, is tested and when correct done nobody 
notices that the machine and undrlying operating system changed


after doing that dozens of times for thousands of mysql databases i know 
what i am doing and call bad practice ways which take depending on 
database sizes hours and beware god something goes wrong with your dump



Second, mastering mysqldump should be golden standard for any DBA.
Telling someone that asks for guidance to simply copy around some files
is bad practice as you do not know the level of expertise involved.


the golden standard for any sysadmin is to know where his datafiles and 
configuration files are stored and how they work together - independent 
of the software type



Regards,
Harrie

On 12 September 2016 at 11:03, Reindl Harald mailto:h.rei...@thelounge.net>> wrote:



Am 12.09.2016 um 10:48 schrieb Harrie Robins:

Ok let's drop this. Simply copying files to migrate a server is
not the
approach to take (in my humble opinion)


And why?

When you start with "Get the same release-version of mysql running
on the target platform" and dump/load what's the point in playing
around with dump-files when you hava binary datafiles which can be
used on the destination

and no - i am not talking about theory

i migrated a hosting-infrastructure with dozens of servers from OSX
PPC to OSX Intel and later to Linux x86_64 with just rsync the
mysql-datadir


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL Platform Migration

[Reindl Harald]

Am 12.09.2016 um 10:48 schrieb Harrie Robins:

Ok let's drop this. Simply copying files to migrate a server is not the
approach to take (in my humble opinion)


And why?

When you start with "Get the same release-version of mysql running on 
the target platform" and dump/load what's the point in playing around 
with dump-files when you hava binary datafiles which can be used on the 
destination


and no - i am not talking about theory

i migrated a hosting-infrastructure with dozens of servers from OSX PPC 
to OSX Intel and later to Linux x86_64 with just rsync the mysql-datadir


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL Platform Migration

[Reindl Harald]

Am 11.09.2016 um 20:27 schrieb Ryan Coleman:

Because they want to be belittled by european jackasses online.


if you insist in not get any mail from me just shut up when nobody asked 
you - mind your own business



On Sep 10, 2016, at 11:56 PM, Reindl Harald  wrote:



Am 11.09.2016 um 06:36 schrieb Suresh Rajagopal:

Is the mysql datafile compatible with different operation system ? I have not 
done this in the past.


why shouldn't it when the identical software is running?
it's just a bunch of files used by mysql

as said copy it to the new machine and you are done - why do people these days 
not just try out things, look if it works and when it don't asking questions?


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL Platform Migration

[Reindl Harald]

Am 11.09.2016 um 06:36 schrieb Suresh Rajagopal:

Is the mysql datafile compatible with different operation system ? I have not 
done this in the past.


why shouldn't it when the identical software is running?
it's just a bunch of files used by mysql

as said copy it to the new machine and you are done - why do people 
these days not just try out things, look if it works and when it don't 
asking questions?



- Original Message -----
From: Reindl Harald 
To: mysql@lists.mysql.com
Sent: Saturday, September 10, 2016 7:19 PM
Subject: Re: MySQL Platform Migration

Am 11.09.2016 um 00:26 schrieb Suresh Rajagopal:

Is there any documentation for migrating mysql 5.0 database from darwin to Linux


what do you need to migrate?

shutdown mysqld, copy the datadir to the new machine, start mysqld with
adopted configuration on the new machine - done

P.S:
don't cross-post on mysql and mariadb list


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL Platform Migration

[Reindl Harald]

Am 11.09.2016 um 00:26 schrieb Suresh Rajagopal:

Is there any documentation for migrating mysql 5.0 database from darwin to Linux


what do you need to migrate?

shutdown mysqld, copy the datadir to the new machine, stat mysqld with 
adopted configuration ion the new machine - done


P.S:
don't cross-post on mysql and mariadb list

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MacOS Server 5 problem after upgrade

[Reindl Harald]

Am 04.09.2016 um 16:17 schrieb Matthias Schmidt:

Am 04.09.2016 um 16:29 schrieb Reindl Harald :

Am 04.09.2016 um 08:40 schrieb Matthias Schmidt:

2016-09-04 15:25:19 85518 [ERROR] /usr/local/mysql/bin/mysqld: Can't 
create/write to file '/usr/local/mysql/data/mysqld.local.pid' (Errcode: 102 - 
Operation not supported on socket)
2016-09-04 15:25:19 85518 [ERROR] Can't start server: can't create PID file: 
Operation not supported on socket

the socket is created but then something goes wrong


that sounds like socket and pid are configured for the same location
what about "rm -f /usr/local/mysql/data/mysqld.local.pid" and show us your 
config



thanks, that did the trick and made it run, but now I just discovered that my 
databases are all gone …
Of course I have backups, but really no experience how to get the stuff back :(


just configure "datadir" to the correct location and get familar with 
mysql basics and your operating system


the content of datadir can be moved between differen toperating systems 
and usually even different mysql versions (given the ones of our 
mainserver was created on windows, moved to osx and finally moved to 
linux in mysql4 times while now running with maridab10.0)





signature.asc
Description: OpenPGP digital signature

Re: MacOS Server 5 problem after upgrade

[Reindl Harald]

Am 04.09.2016 um 08:40 schrieb Matthias Schmidt:

2016-09-04 15:25:19 85518 [ERROR] /usr/local/mysql/bin/mysqld: Can't 
create/write to file '/usr/local/mysql/data/mysqld.local.pid' (Errcode: 102 - 
Operation not supported on socket)
2016-09-04 15:25:19 85518 [ERROR] Can't start server: can't create PID file: 
Operation not supported on socket

the socket is created but then something goes wrong


that sounds like socket and pid are configured for the same location
what about "rm -f /usr/local/mysql/data/mysqld.local.pid" and show us 
your config





signature.asc
Description: OpenPGP digital signature

Re: parallel installations of mysql

[Reindl Harald]

Am 03.07.2016 um 04:47 schrieb Martin Mueller:

If port 3306 is taken, how is one supposed to know that 3307 is a good 
alternative? Why not 3317 or 3703


seriously?

when this is your point about bad documentation than you just don't have 
a point - there is no "good alternive". ist's only a question of is the 
port already used by another service (and since this is a local question 
it has no place in any docs) and "hm, if i start mysqld already with a 
low privileged user i need a port between 1024 and 65535


if all of your points are "i have no clue and the documentation noweher 
talks about macos" then just install a virtual machine which is for 
development setups in general a good solution (simlar environment as 
everywhere in production or mass hoster setups, snapshots, backup of the 
whole environment, cloneable)




signature.asc
Description: OpenPGP digital signature

Re: parallel installations of mysql

[Reindl Harald]

Am 03.07.2016 um 00:49 schrieb Martin Mueller:

After struggling for several hours with installing an alternate installation of 
MySQL, I’ve concluded that this may be beyond my feeble powers but also that 
the official instructions are not very good. They are written for system 
administrators who are doing work of this kind all the time. I’m a scholar who 
has a reasonably firm command of SQL code but doesn’t work much at the command 
line. So you could say “tough luck” or you could try to be a little more 
explicit in the official instructions.


no, it's just easy, create a startup unit which fires up mysqld with a 
different config file, how that works on your OS is beyond mysqld


mysql  590  0.0  3.2 350092 82972 ?Ssl  Jul02   0:03 
/usr/libexec/mysqld --defaults-file=/etc/my.cnf


mysql  596  0.2  7.5 888280 192620 ?   Ssl  Jul02   0:50 
/usr/libexec/mysqld --defaults-file=/etc/my-dbmail.cnf




signature.asc
Description: OpenPGP digital signature

Re: corrupt INNO table

[Reindl Harald]

Am 02.07.2016 um 16:49 schrieb Martin Mueller:

I run MySQL 5.6 on OS 10.11.  There is a table that appears to be corrupt: it 
does not respond to queries, and the command to drop it does not execute. The 
database seems to be OK in other respects. What can I do to get rid of the 
table? Would it be safe just to remove the two .frm and .ibd files from the 
database directory or is there other stuff that I need to worry about.


NO - you must not delete .idb files because innodb is not myisam and has 
a *global tablespace*


what about looking and posting logs?




signature.asc
Description: OpenPGP digital signature

Re: Precautions to not run out of disk space?

[Reindl Harald]

Am 21.06.2016 um 09:41 schrieb Götz Reinicke - IT Koordinator:

we recently had a software bug who wrote gigs of data to our database in
a loop and finally filled the whole system.

O.K. we could serverside use a separate partition/storage for the
database directory, but I was wondering is mysql has a feature/option to
set some sort of  "minimum disk free" than stop writing and wait for a
sysop to check?


well, it would stop after it can't write because disk full or quota 
reached - what else should it do?



Would be nice, as other software can do this already 


man quota




signature.asc
Description: OpenPGP digital signature

Re: slave to master

[Reindl Harald]

Am 29.04.2016 um 20:49 schrieb william drescher:

On 4/28/2016 5:20 PM, Thomas wrote:

Hi,

I have setup an master slave replication.
This works fine.
I have running an Apache webserver and some other programms accessing the
master.
Whats the standard pocedure if master fail?

I want to start up the programms on the slave by hand and then they are
accessing the mySQL slave. Can they write to the slave or do I have to
change
something before in the mysql slave configuration?

The simple answer is that you don't have to do anything.

At some point you will want to stop the slave so that it will not start
replicating when the master comes back up.


it won't

frankly crash the master and replication will break and stop after 
reboot in most cases - no way that it just starts again just because the 
master comes back later


hence you normally have "read-only" on your slaves to prevent breaking 
replication




signature.asc
Description: OpenPGP digital signature

Re: slave to master

[Reindl Harald]

Am 29.04.2016 um 22:22 schrieb Mahmoud Alshinhab:

I was think of it from the cloud prospective, as for example you can
guarantee that Amazon's Elastic Load Balancer won't be a single point of
failure, so I was thinking how can I use MariaDB MaxScale and in the
same time guarantee that it won't be a single point of failure.


why should max scale care *what* your mysql-client is?

anything which can talk to your mysql server will talk the same way to 
max scale, it acts like a ordinary mysql server from the view of any client



On Fri, Apr 29, 2016 at 5:34 PM, Reindl Harald mailto:h.rei...@thelounge.net>> wrote:



Am 29.04.2016 um 17:27 schrieb Mahmoud Alshinhab:

I also like the MariaDB Max scale that Reindl Harald Sent -Thanks-
However I don't know if it is possible to use 2 servers of the
max scale
with a load balancer in front of them or not.
I always try to avoid the Single Point of Failure


get rid of the idea that your "load-balancer" not a single point

in a sane environment there is no single point of failure because
max scale *is the load balancer* and typically runs on a HA cluster
where it never goes away (virtual machine on a cluster FS - as
example - VMware vSphere with two hosts and VMware HA enabled)

why do you want a load balancer in front of a load balancer and how
do you make sure that this load balancer is redundant and not a
single point of failure itself?

"https://mariadb.com/products/mariadb-maxscale/how-maxscale-works";
On Fri, Apr 29, 2016 at 5:20 PM, Mahmoud Alshinhab
mailto:mahmoud.alshin...@gmail.com>
<mailto:mahmoud.alshin...@gmail.com
<mailto:mahmoud.alshin...@gmail.com>>> wrote:

I quote this from the page[1]:


  Load balancing implementation


Random picking

When initializing a connection or after a failed connection, the
connector will attempt to connect to a host with a certain role
(slave/master). The connection is selected randomly among
the valid
hosts. Thereafter, all statements will run on that database
server
until the connection will be closed (or fails).

The load-balancing will includes a pooling mechanism.
Example: when
creating a pool of 60 connections, each one will use a
random host.
With 3 master hosts, the pool will have about 20 connections
to each
host.


Master/slave distributed load

For a cluster composed of masters and slaves on connection
initialization, there will be 2 underlying connections: one
with a
master host, another with a slave host. Only one connection
is used
at a time.
For a cluster composed of master hosts only, each connection has
only one underlying connection.
The load will be distributed due to the random distribution of
connections..


Master/slave connection selection

It’s the application that has to decide to use master or slave
connection (the master connection is set by default).
Switching the type of connection is done by using JDBC
connection.setReadOnly(boolean readOnly)


<http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#setReadOnly%28boolean%29>
method. Setting read-only to true will use the slave connection,
false, the master connection.

[1]


https://mariadb.com/kb/en/mariadb/failover-and-high-availability-with-mariadb-connector-j/

So I think it is not implemented yet. as "the application has to
decide to use master or slave connection (the master
connection is
set by default)."

--
Eng. Mahmoud Alshinhab
AWS Cloud Support Engineer
Fedora Ambassador
Wiki : https://fedoraproject.org/wiki/User:Tuxawy
mahmoud.alshin...@gmail.com
<mailto:mahmoud.alshin...@gmail.com>
<mailto:mahmoud.alshin...@gmail.com
<mailto:mahmoud.alshin...@gmail.com>>
tux...@fedoraproject.org <mailto:tux...@fedoraproject.org>
<mailto:tux...@fedoraproject.org <mailto:tux...@fedoraproject.org>>

On Fri, Apr 29, 2016 at 5:14 PM, Mahmoud Alshinhab
mailto:mahmoud.alshin...@gmail.com>
<mailto:mahmoud.alshin...@gmail.com
<mailto:mahmoud.alshin...@gmail.com>>>
wrote:

It was actually built for Amazon's Aurora, but it should
work
with any mysql-compatible protoco.

--
 

Re: slave to master

[Reindl Harald]

Am 29.04.2016 um 17:27 schrieb Mahmoud Alshinhab:

I also like the MariaDB Max scale that Reindl Harald Sent -Thanks-
However I don't know if it is possible to use 2 servers of the max scale
with a load balancer in front of them or not.
I always try to avoid the Single Point of Failure


get rid of the idea that your "load-balancer" not a single point

in a sane environment there is no single point of failure because max 
scale *is the load balancer* and typically runs on a HA cluster where it 
never goes away (virtual machine on a cluster FS - as example - VMware 
vSphere with two hosts and VMware HA enabled)


why do you want a load balancer in front of a load balancer and how do 
you make sure that this load balancer is redundant and not a single 
point of failure itself?



"https://mariadb.com/products/mariadb-maxscale/how-maxscale-works";
On Fri, Apr 29, 2016 at 5:20 PM, Mahmoud Alshinhab
mailto:mahmoud.alshin...@gmail.com>> wrote:

I quote this from the page[1]:


  Load balancing implementation


Random picking

When initializing a connection or after a failed connection, the
connector will attempt to connect to a host with a certain role
(slave/master). The connection is selected randomly among the valid
hosts. Thereafter, all statements will run on that database server
until the connection will be closed (or fails).

The load-balancing will includes a pooling mechanism. Example: when
creating a pool of 60 connections, each one will use a random host.
With 3 master hosts, the pool will have about 20 connections to each
host.


Master/slave distributed load

For a cluster composed of masters and slaves on connection
initialization, there will be 2 underlying connections: one with a
master host, another with a slave host. Only one connection is used
at a time.
For a cluster composed of master hosts only, each connection has
only one underlying connection.
The load will be distributed due to the random distribution of
connections..


Master/slave connection selection

It’s the application that has to decide to use master or slave
connection (the master connection is set by default).
Switching the type of connection is done by using JDBC
connection.setReadOnly(boolean readOnly)

<http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#setReadOnly%28boolean%29>
method. Setting read-only to true will use the slave connection,
false, the master connection.

[1]

https://mariadb.com/kb/en/mariadb/failover-and-high-availability-with-mariadb-connector-j/

So I think it is not implemented yet. as "the application has to
decide to use master or slave connection (the master connection is
set by default)."

--
Eng. Mahmoud Alshinhab
AWS Cloud Support Engineer
Fedora Ambassador
Wiki : https://fedoraproject.org/wiki/User:Tuxawy
mahmoud.alshin...@gmail.com <mailto:mahmoud.alshin...@gmail.com>
tux...@fedoraproject.org <mailto:tux...@fedoraproject.org>

On Fri, Apr 29, 2016 at 5:14 PM, Mahmoud Alshinhab
mailto:mahmoud.alshin...@gmail.com>>
wrote:

It was actually built for Amazon's Aurora, but it should work
with any mysql-compatible protoco.

--
Eng. Mahmoud Alshinhab
AWS Cloud Support Engineer
Fedora Ambassador
Wiki : https://fedoraproject.org/wiki/User:Tuxawy
mahmoud.alshin...@gmail.com <mailto:mahmoud.alshin...@gmail.com>
tux...@fedoraproject.org <mailto:tux...@fedoraproject.org>

On Fri, Apr 29, 2016 at 3:13 PM, Reindl Harald
mailto:h.rei...@thelounge.net>> wrote:


Am 29.04.2016 um 15:07 schrieb Johan De Meersman:

From: "Mahmoud Alshinhab"
mailto:mahmoud.alshin...@gmail.com>>
Subject: Re: slave to master


I think you should have a look at MariaDB Connector[1].


It provides Load balancing and failover as Failover
occurs when a connection to
a primary database server fails and the connector
will open up a connection to
another database server.


Hmm, I didn't know that they built that into it,
interesting. Does it require server features, or would
it work with any mysql-compatible protocol ?

Load balancing allows load (read and write) to be
distributed over multiple
servers.


Is read-write splitting also built-in, then?


here you go:
https://mariadb.com/de/products/mariadb-maxscale and forget
about "MariaDB Connector" whatever that is




signature.asc
Description: OpenPGP digital signature

Re: slave to master

[Reindl Harald]

Am 29.04.2016 um 17:20 schrieb Mahmoud Alshinhab:

Master/slave connection selection

It’s the application that has to decide to use master or slave
connection (the master connection is set by default).
Switching the type of connection is done by using JDBC
connection.setReadOnly(boolean readOnly)

method. Setting read-only to true will use the slave connection, false,
the master connection.

[1]
https://mariadb.com/kb/en/mariadb/failover-and-high-availability-with-mariadb-connector-j/

So I think it is not implemented yet. as "the application has to decide
to use master or slave connection (the master connection is set by
default)."


so what's the benfit to use it?

https://mariadb.com/products/mariadb-maxscale/database-scaling

* Replication aware dynamic routing
* Query load balancing
* Client to database connection multiplexing

https://mariadb.com/products/mariadb-maxscale/minimize-maintenance-downtime

Whether you need to take a database node of a cluster out of service for 
maintenance or add a database node back to cluster, MaxScale?s load 
balance routing and monitoring plugins will assure that database traffic 
is always routed to database nodes in service without impacting the 
applications.


https://mariadb.com/products/mariadb-maxscale

MariaDB MaxScale is designed to hide the database setup complexity from 
the application so that the app still believes it connects to a single 
database instance but actually it connects to MariaDB MaxScale which 
sits on top of a growing MariaDB or MySQL database farm.


The concept of a data-centric proxy isn?t new, but MariaDB MaxScale is 
different because it leverages the deep server and parser knowledge of 
MariaDB to ensure that queries are processed in the exactly the same way 
inside MariaDB server. This makes it faster, more efficient and more 
transparent than any other database proxy on the market.




signature.asc
Description: OpenPGP digital signature

Re: slave to master

[Reindl Harald]

Am 29.04.2016 um 15:07 schrieb Johan De Meersman:

From: "Mahmoud Alshinhab" 
Subject: Re: slave to master



I think you should have a look at MariaDB Connector[1].



It provides Load balancing and failover as Failover occurs when a connection to
a primary database server fails and the connector will open up a connection to
another database server.


Hmm, I didn't know that they built that into it, interesting. Does it require 
server features, or would it work with any mysql-compatible protocol ?


Load balancing allows load (read and write) to be distributed over multiple
servers.


Is read-write splitting also built-in, then?


here you go: https://mariadb.com/de/products/mariadb-maxscale and forget 
about "MariaDB Connector" whatever that is




signature.asc
Description: OpenPGP digital signature

Re: need help from the list admin

[Reindl Harald]

Am 01.04.2016 um 21:09 schrieb Lentes, Bernd:

- Am 1. Apr 2016 um 17:45 schrieb shawn l.green shawn.l.gr...@oracle.com:

You said, "This is done on the master, written in the log and then
replicated to the slave, "

The INSERT would not appear in the Binary log until after session 1
commits.


So the INSERT take care about the transaction (begin transaction ... COMMIT)
although it's a MyISAM table ?
Because i read MyISAM does not care about it:
http://stackoverflow.com/questions/8036005/myisam-engine-transaction-support


and hence you should not mix innodb and non-transactional tables, a 
MyISAM table is not and will never be part of a transaction




signature.asc
Description: OpenPGP digital signature

Re: need help from the list admin

[Reindl Harald]

Am 30.03.2016 um 19:26 schrieb Lentes, Bernd:

- On Mar 30, 2016, at 7:04 PM, Reindl Harald h.rei...@thelounge.net wrote:



So i should use the default (autocommit=1)?


no, you should what is appropriate for your application

if you don't care about inserts/updates triggered by let say a
webrequest are half written due a crash or restart use autocommit


Autocommit means that every statement is committed implicitly. Right ?
Commit works only in conjunction with InnoDB tables and transaction. That's 
what i understand.
I thought when i make e.g. an insert into a InnoDB table, and that insert is 
not done completely (due to a crash, restart, what ever)
it is rolled back automatically after the restart. Is that wrong ?


transactions are not about single queries, transactions are all about 
multiple queries when you want them all or nothing written


please do some homework and read https://en.wikipedia.org/wiki/ACID 
which is basic knowledge about databases


the crash safety of innodb has nothing to do with commits



signature.asc
Description: OpenPGP digital signature

Re: need help from the list admin

[Reindl Harald]

Am 30.03.2016 um 18:56 schrieb Lentes, Bernd:

- On Mar 28, 2016, at 9:53 PM, shawn l.green shawn.l.gr...@oracle.com wrote:

I read that the converting is not difficult. But has the code of our webapp to
be changed ? It's written in php and perl.
What i understand is that inserts/updates/deletions in InnoDB tables have to be
commited. Yes ?


No. The server's default is to have --autocommit=1, which means that
there is an implicit commit at the end of every command. You do not need
to state explicitly "COMMIT" every time you want this to happen.

In fact, disabling autocommit has gotten many new users into trouble
because they did not understand the behavior they changed.


So i should use the default (autocommit=1)?


no, you should what is appropriate for your application

if you don't care about inserts/updates triggered by let say a 
webrequest are half written due a crash or restart use autocommit


if you care that all or nothing is written use transactions
if you care that way don't mix non-transactional tables with innodb



signature.asc
Description: OpenPGP digital signature

Re: need help from the list admin

[Reindl Harald]

Am 28.03.2016 um 21:36 schrieb Lentes, Bernd:

- On Mar 27, 2016, at 2:49 PM, Reindl Harald h.rei...@thelounge.net wrote:


Am 27.03.2016 um 14:34 schrieb Lentes, Bernd:

You would be better served by first converting your MyISAM tables to
InnoDB to stop mixing storage engine behaviors (transactional and
non-transactional) within the scope of a single transaction. But if you
cannot convert them, using MIXED will be a good compromise.


Is this a big problem ? Something to take care of ? Currently we have a mix.
I will ask the girl who developed it why we have both kinds. I hope i can
convert


surely - when you have non-transactional tables involved in
updates/inserts you can go and forget using transactions at all since
interruption or rollback would not rollback already written changes in
MyISAM tables

transactions are all about consistency - impossible with a mix of InnoDB
and MyISAM tables


I read that the converting is not difficult. But has the code of our webapp to 
be changed ? It's written in php and perl.
What i understand is that inserts/updates/deletions in InnoDB tables have to be 
commited. Yes ?


first please stop place a space before "?" - it hurts :-)

NO - it only has to be commited if you START A TRANSACTION at the begin


This has to be done in the code ? Or can we use the system variable autocommit ?


if you are using automcommit you lose any purpose of having transactions


That means that everything is commited immediately ? Is this a good solution ?


if you don't care about consistency yes


What means "By default, client connections begin with autocommit set to 1" in 
the doc ?


that nobody is starting a transaction automatically because nobody can 
tell when it is finished automatically end hence you need to tell it the 
db server



That every client connection established via perl/php is started with 
autocommit=1 ?


surely


And when does the commit happen ? When the connection is closed ? Is that 
helpful ?


depends - maybe you should start to read what transactions in the 
database world are because than you can answer all of your questions 
above at your own




signature.asc
Description: OpenPGP digital signature

Re: need help from the list admin

[Reindl Harald]

Am 27.03.2016 um 14:34 schrieb Lentes, Bernd:

You would be better served by first converting your MyISAM tables to
InnoDB to stop mixing storage engine behaviors (transactional and
non-transactional) within the scope of a single transaction. But if you
cannot convert them, using MIXED will be a good compromise.


Is this a big problem ? Something to take care of ? Currently we have a mix.
I will ask the girl who developed it why we have both kinds. I hope i can 
convert


surely - when you have non-transactional tables involved in 
updates/inserts you can go and forget using transactions at all since 
interruption or rollback would not rollback already written changes in 
MyISAM tables


transactions are all about consistency - impossible with a mix of InnoDB 
and MyISAM tables




signature.asc
Description: OpenPGP digital signature

Re: does anyone else have problems sending mails to this list ?

[Reindl Harald]

Am 22.03.2016 um 02:05 schrieb Jan Steinman:

please refrain from answering when you have no clue how DNS blacklists are 
working and what about others are talking


Well, excuse me! Someone put on their bossy pants this morning!

A simple “That’s not what’s going on here” would have been much nicer


deserved by what when one is answering to a over days ongoing thread 
without read what's topic?




signature.asc
Description: OpenPGP digital signature

Re: does anyone else have problems sending mails to this list ?

[Reindl Harald]

Am 20.03.2016 um 20:22 schrieb Reindl Harald:



Am 20.03.2016 um 20:16 schrieb Jan Steinman:

From: Reindl Harald 
Date: 17 March 2016 at 06:27:22 PDT

Am 17.03.2016 um 14:06 schrieb Lentes, Bernd:

i still can't send my question to the ML. Our outgoing Mailer has a
new IP which is not listed
(http://mxtoolbox.com/SuperTool.aspx?action=blacklist%3a146.107.103.20&run=toolpage#),
our domain is not listed
(http://mxtoolbox.com/SuperTool.aspx?action=blacklist%3ahelmholtz-muenchen.de&run=toolpage#),
my E-Mail include neither any link nor an attachment, it's formatted
as plain-text but i still get it back:


at least not terrible good
senderscore.com LISTED 127.0.4.63


Uhm… the 127 Class A network is the “super local network,” used for
processes on the same physical machine.

You need to look at other Received: headers than the ones that start
with 127


please refrain from answering when you have no clue how DNS blacklists
are working and what about others are talking - thank you!

here is your homework for today:
https://en.wikipedia.org/wiki/DNSBL

BTW: one of my jobs is to build up spamfilters for hundrets of users
including maintain own local DNSBL/DNSWL services for scoring


if the wiki page is to long for you:
https://www.spamhaus.org/zen/

Return CodesData Source Contains
127.0.0.2   Direct UBE sources, spam operations & spam services
127.0.0.3   Direct snowshoe spam sources detected via automation
127.0.0.4-7 CBL (3rd party exploits such as proxies, trojans, etc.)
127.0.0.10-11 		End-user Non-MTA IP addresses set by ISP outbound mail 
policy




signature.asc
Description: OpenPGP digital signature

Re: does anyone else have problems sending mails to this list ?

[Reindl Harald]

Am 20.03.2016 um 20:16 schrieb Jan Steinman:

From: Reindl Harald 
Date: 17 March 2016 at 06:27:22 PDT

Am 17.03.2016 um 14:06 schrieb Lentes, Bernd:

i still can't send my question to the ML. Our outgoing Mailer has a new IP 
which is not listed
(http://mxtoolbox.com/SuperTool.aspx?action=blacklist%3a146.107.103.20&run=toolpage#),
 our domain is not listed
(http://mxtoolbox.com/SuperTool.aspx?action=blacklist%3ahelmholtz-muenchen.de&run=toolpage#),
 my E-Mail include neither any link nor an attachment, it's formatted as plain-text 
but i still get it back:


at least not terrible good
senderscore.com LISTED  127.0.4.63


Uhm… the 127 Class A network is the “super local network,” used for processes 
on the same physical machine.

You need to look at other Received: headers than the ones that start with 127


please refrain from answering when you have no clue how DNS blacklists 
are working and what about others are talking - thank you!


here is your homework for today:
https://en.wikipedia.org/wiki/DNSBL

BTW: one of my jobs is to build up spamfilters for hundrets of users 
including maintain own local DNSBL/DNSWL services for scoring




signature.asc
Description: OpenPGP digital signature

Re: need help from the list admin

[Reindl Harald]

Am 18.03.2016 um 14:56 schrieb Chris Knipe:

Blah blah blah...

Delivery to the following recipient failed permanently:

  mysql@lists.mysql.com

Technical details of permanent failure:
Your message was rejected by the server for the recipient domain
lists.mysql.com by lists-mx.mysql.com. [137.254.60.71].

The error that the other server returned was:
550 Currently Sending Spam See:
http://www.sorbs.net/lookup.shtml?5.200.22.158

Show me one site, where that IP is, or WAS ever blacklisted?


on sorbs as you quoated yourself, that only idiots block by 
"spam.dnsbl.sorbs.net" ann response 127.0.0.6 instead RBL scoring is a 
different story


51.192.85.209.in-addr.arpa name = mail-qg0-f51.google.com

Name:   51.192.85.209.spam.dnsbl.sorbs.net
Address: 127.0.0.6

Received-SPF: pass (savage.za.org: Sender is authorized to use
 'ckn...@savage.za.org' in 'mfrom' identity (mechanism
 'include:_spf.google.com' matched)) receiver=amysql-list-wsv01.oracle.com;
 identity=mailfrom; envelope-from="ckn...@savage.za.org";
 helo=mail-qg0-f51.google.com; client-ip=209.85.192.51




signature.asc
Description: OpenPGP digital signature

Re: need help from the list admin

[Reindl Harald]

Am 19.03.2016 um 15:23 schrieb Reindl Harald:



Am 19.03.2016 um 15:17 schrieb Lentes, Bernd:

one further question:
if some of my e-mails get through (like this one) and others don't, it
does not depend on theh reputation of our domain or mailserver ? Right ?
So the reason has to be that particular e-Mail?


both

a spamfilter is typically score based and combines a ton of rules, some
add points, some remove points and the decision is made of the summary

when you have a bad server reputation you start with a penalty, some
other rules hitting and a not well trained bayes makes the rest

"How do i have to provide the ip" in case of RBLs?
https://en.wikipedia.org/wiki/Reverse_DNS_lookup


and that your domain even don't provide a "~all" SPF policy if you can't 
or don't want a stricht "-all" makes things not better, typically a 
SPF_PASS gives benefits in spamfilter scorings


Received-SPF: none (helmholtz-muenchen.de: No applicable sender policy
 available) receiver=amysql-list-wsv01.oracle.com; identity=mailfrom;
 envelope-from="bernd.len...@helmholtz-muenchen.de";
 helo=mtaextp1.scidom.de; client-ip=146.107.103.20

[harry@srv-rhsoft:~]$ dig TXT helmholtz-muenchen.de @8.8.8.8
; <<>> DiG 9.10.3-P4-RedHat-9.10.3-12.P4.fc23 <<>> TXT 
helmholtz-muenchen.de @8.8.8.8

;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 25126
;; flags: qr rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 1

[harry@srv-rhsoft:~]$ dig TXT thelounge.net @8.8.8.8
;; ANSWER SECTION:
thelounge.net.  21599   IN  TXT 
"google-site-verification=XQcET0ij0uOdn8AvlL82t8FoGTthvfPKWRfNjSNTfaM"
thelounge.net.  21599   IN  TXT "v=spf1 a 
ip4:91.118.73.0/24 ip4:95.129.202.170 -all"




signature.asc
Description: OpenPGP digital signature

Re: need help from the list admin

[Reindl Harald]

Am 19.03.2016 um 15:17 schrieb Lentes, Bernd:

one further question:
if some of my e-mails get through (like this one) and others don't, it does not 
depend on theh reputation of our domain or mailserver ? Right ?
So the reason has to be that particular e-Mail?


both

a spamfilter is typically score based and combines a ton of rules, some 
add points, some remove points and the decision is made of the summary


when you have a bad server reputation you start with a penalty, some 
other rules hitting and a not well trained bayes makes the rest


"How do i have to provide the ip" in case of RBLs?
https://en.wikipedia.org/wiki/Reverse_DNS_lookup




signature.asc
Description: OpenPGP digital signature

Re: need help from the list admin

[Reindl Harald]

Am 19.03.2016 um 15:08 schrieb Lentes, Bernd:

Ok. I tried again:

pc53200:~ # nslookup 20.103.107.146.score.senderscore.com.
Server: 146.107.8.88
Address:146.107.8.88#53

Non-authoritative answer:
Name:   20.103.107.146.score.senderscore.com
Address: 127.0.4.62

My result is 127.0.4.62. How can i interpret this result?


simple - it's a reputation score
100 = perfect reputation - whitelist score
0 = no reputation, pure spammer

with 62 you make it through postscreen but end with 2.5 points penalty 
in SA and that you had 2 days ago "senderscore.com LISTED 127.0.4.63" 
and now got worser scores shows that your outgoing server sends spam 
(given that we have full reputation 100 there without any actve 
operation, even before i did know about the RBL/DNSWL)


anything below 127.0.4.70 should raise alerts
___

our postscreen-scoring:
score.senderscore.com=127.0.4.[0..20]*2
score.senderscore.com=127.0.4.[0..69]*2
score.senderscore.com=127.0.4.[90..100]*-1
___

our spamassassin scoring:

header   CUST_DNSBL_21 
eval:check_rbl('cust21-lastexternal','score.senderscore.com.','^127\.0\.4\.(1?[0-9]|20)$')

describe CUST_DNSBL_21 score.senderscore.com (senderscore.com High)
scoreCUST_DNSBL_21 1.5

header   CUST_DNSBL_25 
eval:check_rbl('cust25-lastexternal','score.senderscore.com.','^127\.0\.4\.(0?[0-6]?[0-9])$')

describe CUST_DNSBL_25 score.senderscore.com (senderscore.com Medium)
scoreCUST_DNSBL_25 1.0

header   CUST_DNSWL_2 
eval:check_rbl('cust35-lastexternal','score.senderscore.com.','^127\.0\.4\.(9[0-9]|100)$')

describe CUST_DNSWL_2 score.senderscore.com (Low Trust)
scoreCUST_DNSWL_2 -0.1



signature.asc
Description: OpenPGP digital signature

Re: need help from the list admin

[Reindl Harald]

Am 18.03.2016 um 15:25 schrieb Lentes, Bernd:


- Am 18. Mrz 2016 um 14:52 schrieb Johan De Meersman vegiv...@tuxera.be:


and yet, both of those messages made it through :-p

Stick your domain in http://mxtoolbox.com to see if there's any problems that
might be worth solving. If the mailserver classifies you as spam, that's
usually caused by something on your side :-)

- Original Message -

From: "Chris Knipe" 
To: "Lentes, Bernd" 
Cc: "MySql" 
Sent: Friday, 18 March, 2016 14:46:26
Subject: Re: need help from the list admin



Ditto.  I've pretty much given up on this list...




Neither our outgoing mailserver 
(http://mxtoolbox.com/SuperTool.aspx?action=blacklist%3a146.107.103.20&run=toolpage#)
 nor our domain
(http://mxtoolbox.com/SuperTool.aspx?action=blacklist%3ahelmholtz-muenchen.de&run=toolpage#)
 is listed there.
I checked that before i wrote the e-Mail. If you could help me to point out 
what's wrong on our side i could ask our mail admin to correct it.
Currently i don't have any idea


as i already told you offlist
senderscore.com  LISTED  127.0.4.67

this *is* a bad reputation

and more worse: you did not manage to get your server on any DNSWL

[harry@srv-rhsoft:~]$ nslookup 20.103.107.146.score.senderscore.com.
Server: 127.0.0.1
Address:127.0.0.1#53
Non-authoritative answer:
Name:   20.103.107.146.score.senderscore.com
Address: 127.0.4.67
_

compare with 91.118.73.15 (our outgoing server) which has there the best 
possible reputation (treated as whitelist) and is at the same time on 
the "list.dnswl.org" and "hostkarma.junkemailfilter" while one of both 
would possibly neutralize the BL listing in a scoring system


[harry@srv-rhsoft:~]$ nslookup 15.73.118.91.score.senderscore.com.
Server: 127.0.0.1
Address:127.0.0.1#53
Non-authoritative answer:
Name:   15.73.118.91.score.senderscore.com
Address: 127.0.4.100



signature.asc
Description: OpenPGP digital signature

Re: does anyone else have problems sending mails to this list ?

[Reindl Harald]

Am 17.03.2016 um 14:06 schrieb Lentes, Bernd:

i still can't send my question to the ML. Our outgoing Mailer has a new IP 
which is not listed
(http://mxtoolbox.com/SuperTool.aspx?action=blacklist%3a146.107.103.20&run=toolpage#),
 our domain is not listed
(http://mxtoolbox.com/SuperTool.aspx?action=blacklist%3ahelmholtz-muenchen.de&run=toolpage#),
 my E-Mail include neither any link nor an attachment, it's formatted as plain-text 
but i still get it back:


at least not terrible good
senderscore.com LISTED  127.0.4.63

would be 1.0 SpamAssasin points on our setup, not much but not a good 
sign, hence we use 50 DNSBL/DNSWL with different scores and it's worth 
to catch most spam while prevent false positives



"This is the mail system at host mtaextp1.scidom.de.

I'm sorry to have to inform you that your message could not
be delivered to one or more recipients. It's attached below.

For further assistance, please send mail to postmaster.

If you do so, please include this problem report. You can
delete your own text from the attached returned message.

The mail system

: host lists-mx.mysql.com[137.254.60.71] said: 552 spam
 score exceeded threshold (#5.6.1) (in reply to end of DATA command)"

Can anyone points out the error ?


not without the full message

try to send me the same mail (subject, content, attachments whatever) 
and i can bounce you back a SpamAssassin report




signature.asc
Description: OpenPGP digital signature

Re: does mysql alert about all the duplicates?

[Reindl Harald]

Am 16.03.2016 um 13:38 schrieb lejeczek:

hi everybody

just another beginner's question.
if I insert into table and there are duplicate primary keys - does mysql
alert about all the duplicates or just the first one and then
exits/abandon the rest of the insert without any alerts for potential
further duplicates?
And is this a user/config controlled behavior?


only the first because it makes no sense when you attempt to make 
100 inserts proceed the whole operation when in the second one a 
fatal error happens






signature.asc
Description: OpenPGP digital signature

Re: does anyone else have problems sending mails to this list ?

[Reindl Harald]

Am 09.03.2016 um 11:44 schrieb Lentes, Bernd:

i tried yesterday several times to send an e-Mail to this list. E-Mail is 
formatted as plain-text, has no links included and no attachment but is 
declined as spam. This is what is bounced:

: host lists-mx.mysql.com[137.254.60.71] said: 552 spam
 score exceeded threshold (#5.6.1) (in reply to end of DATA command)

Any ideas?


surely:

spam.dnsbl.sorbs.netLISTED  127.0.0.6
bl.spamcannibal.org LISTED  127.0.0.2

Received-SPF: none (helmholtz-muenchen.de: No applicable sender policy
 available) receiver=amysql-list-wsv01.oracle.com; identity=mailfrom;
 envelope-from="bernd.len...@helmholtz-muenchen.de";
 helo=mtaextp1.scidom.de; client-ip=146.107.3.105

PTR: mtaextp1.scidom.de
Country: DE (Germany)
ISP: Helmholtz Zentrum Muenchen




signature.asc
Description: OpenPGP digital signature

Re: can I just encrypt tables? what about the app?

[Reindl Harald]

Am 03.03.2016 um 16:40 schrieb lejeczek:

how to backup in a way that this in-database-encryption will be taken
advantage of?
does any of present backup solutions can do it?
many thanks


think once again what "transparent encryption" means

the most effective backup is anyways running slave connected to the 
master via TLS, stop the slave and rsync away the whole datadir because 
it is fast, efficient and scriptable (with ssh-keys even between networks)




signature.asc
Description: OpenPGP digital signature

Re: can I just encrypt tables? what about the app?

[Reindl Harald]

Am 29.02.2016 um 20:54 schrieb Gary Smith:

On 29/02/2016 19:50, Reindl Harald wrote:


cryptsetup/luks can achieve that way better


Only to a degree.


no - not only to a degree - when the question is "not store anything 
unencrypted on the disk" the is no degree, but or if



Once the disk is unencrypted, you've got access to the
filesystem. If you've got physical access to the machine, then anything
which gives you console access gives you (potentially) access to the
underlying database files. If you can get those, it's trivial to get
access to the dataset that they contain.

However, if TDE is employed, then you've got another significant
obstacle to overcome: The data is only encrypted (aiui) once it's in
memory. At this point, you're needing to do attacks on RAM to get access
to the data - and even then, you're unlikely to get 3 bars for a jackpot
payout of the whole database schema, assuming a decent sized database.


in theory

in reality you don't need to hack around in the RAM - mysqld needs to 
have access to key for operate with the data and so you need to find 
only that piece


the same for encryption on the application side before send data to the 
db-layer - see the start and subject of that thread how far people are 
away from understanding how and on what layer things are encrypted and 
what excatly is protected in which context


there is no "turn this on and you are safe" without deeper understanding



signature.asc
Description: OpenPGP digital signature

Re: can I just encrypt tables? what about the app?

[Reindl Harald]

Am 29.02.2016 um 20:30 schrieb shawn l.green:

Hi Reindl,

On 2/29/2016 2:16 PM, Reindl Harald wrote:



Am 29.02.2016 um 20:07 schrieb Jesper Wisborg Krogh:

Hi Lejeczek,

On 1/03/2016 00:31, lejeczek wrote:

hi everybody

a novice type of question - having a php + mysql, can one just encrypt
(internally in mysql) tables and php will be fine?
If not, would it be easy to re-code php to work with this new,
internal encryption?


Starting with MysQL 5.7.11, there is transparent data encryption (TDE)
for InnoDB tables. If you use that, it is as the name suggest
transparent for PHP. See also:
https://dev.mysql.com/doc/refman/5.7/en/innodb-tablespace-encryption.html



i still don't grok a usecase for such encryption because when a
webserver got compromised you have the same access as before, just
solwer with more overhead in general

what is the purpose of encryption on that layer?


Some process requirements state that some data should never be stored on
disk in plain text. This is one way to meet those requirements.


cryptsetup/luks can achieve that way better


Some data has been compromised not by cracking the primary database but
by breaking into a server containing backups of the data. This new
feature allows file-level backups (like those generated by MySQL
Enterprise Backup) to be secure.


well, somewhere must be the key to decrypt the data anyways, otherwise 
mysqld couldn't operate with the data - how do you protect that one 
without run in a chicken-egg problem


in the worst case it introduces the risk that some clueless guys become 
more careless "because my data is encrypted" somewhere else and don't 
grok what and what not is safe



What that feature achieves is that the data will be encrypted at rest,
not just in flight (using SSL).


see above


Clearly, this does not defeat an attacker who is able to compromise or
become an authenticated client who is normally allowed to read that
data. To fix that problem, you must employ application-level encryption
which encodes the data actually stored on the table. Clearly this last
type of encryption breaks the database server's ability to index the
data as the server would have no key to decrypt the content of the
fields to build any normal (clear-content) indexes on it. It would only
be able to index the encrypted (opaque) data. The clients would need to
code their queries with WHERE clauses looking for the exact encrypted
values they wanted to find


and even there you have the same problem: as long your application works 
with however encrypted data it needs to have they key somewhere and when 
i compromise your server i can read that key too




signature.asc
Description: OpenPGP digital signature

Re: can I just encrypt tables? what about the app?

[Reindl Harald]

Am 29.02.2016 um 20:07 schrieb Jesper Wisborg Krogh:

Hi Lejeczek,

On 1/03/2016 00:31, lejeczek wrote:

hi everybody

a novice type of question - having a php + mysql, can one just encrypt
(internally in mysql) tables and php will be fine?
If not, would it be easy to re-code php to work with this new,
internal encryption?


Starting with MysQL 5.7.11, there is transparent data encryption (TDE)
for InnoDB tables. If you use that, it is as the name suggest
transparent for PHP. See also:
https://dev.mysql.com/doc/refman/5.7/en/innodb-tablespace-encryption.html


i still don't grok a usecase for such encryption because when a 
webserver got compromised you have the same access as before, just 
solwer with more overhead in general


what is the purpose of encryption on that layer?




signature.asc
Description: OpenPGP digital signature

Re: Mysql devel

[Reindl Harald]

Am 23.02.2016 um 13:12 schrieb Larry Martell:

On Tue, Feb 23, 2016 at 7:07 AM, Larry Martell  wrote:

On Tue, Feb 23, 2016 at 6:16 AM, Reindl Harald  wrote:


Am 23.02.2016 um 04:47 schrieb Larry Martell:


I am trying to install the mysql devel libs (so I can build MySQLdb).
This is on RHEL 6. It's failing as shown below. Can anyone help with
this?


you are mixing remi and other repos


I did this:

# yum shell --enablerepo=remi

remove php-mysql
install php-mysqlnd
run


Followed by this:

yum install mysql-devel
/usr/local/bin/pip2.7 install MySQL-python

Now the MySQL server is down and will not come up. It fails with this:

Fatal error: mysql.user table is damaged. Please run mysql_upgrade

It was running 5.1 before and now it's running 5.7.

But how can I run mysql_upgrade if I can't start the server?


Actually it was running 5.5 before:

Server version: 5.5.44 MySQL Community Server (GPL) by Remi


all your problems are coming from careless mix repos and allow updates 
without considering the result and read how to deal with 3rd party repos 
from the very beginning


downgrade and re-consider how you are doing upgrades
5.5 to 5.7 and skip 5.6 entirely is a bad idea
make sure that you don't mix mysql-packages from different repos

and RTFM https://wiki.centos.org/de/AdditionalResources/Repositories/
Les RPM de Remi repository - (See http://rpms.famillecollet.com/) Remi 
Collet maintains latest version of MySQL and PHP (backports of fedora 
RPM). Suggest caution if using this repo due to replacement of core packages


Third Party Repositories
WARNING: These repositories are not provided nor supported by CentOS. 
The CentOS project has no control over these sites. Many have their own 
mailing lists, IRC channels, issue trackers, etc. for support issues 
with their packages.


NOTE: If you are considering using a 3rd Party Repository, then you 
should seriously consider how to prevent unintended 'updates' from these 
side archives from over-writing some core part of CentOS. One approach 
is to only enable these archives from time to time, and generally leave 
them disabled. See: man yum


Another approach is to use the exclude= and includepkgs= options on a 
per sub-archive basis, in the matching .conf file found in 
/etc/yum.repos.d/ See: man yum.conf


The yum Priorities plug-in can prevent a 3rd party repository from 
replacing base packages, or prevent base/updates from replacing a 3rd 
party package.




signature.asc
Description: OpenPGP digital signature

Re: Mysql devel

[Reindl Harald]

Am 23.02.2016 um 04:47 schrieb Larry Martell:

I am trying to install the mysql devel libs (so I can build MySQLdb).
This is on RHEL 6. It's failing as shown below. Can anyone help with
this?


you are mixing remi and other repos


Package mysql-community-devel.x86_64 0:5.7.11-1.el6 will be installed
for package: mysql-server-5.5.44-1.el6.remi.x86_64





signature.asc
Description: OpenPGP digital signature

Re: SAP Customers DB

[Reindl Harald]

Am 12.02.2016 um 16:23 schrieb MELISSA White:

Would you be interested in acquiring SAP Users contact information in excel 
sheet for unlimited marketing usage?


creep away spammer or your company domain ends in a Sender-Filter 
(envelope and To-headers) - who do you think you are that you are in the 
position offer "unlimited marketing usage" to 3rd parties?




signature.asc
Description: OpenPGP digital signature

Re: using alias in where clause

[Reindl Harald]

Am 26.01.2016 um 01:16 schrieb Larry Martell:

I know I cannot use an alias in a where clause, but I am trying to
figure out how to achieve what I need.

If I could have an alias in a where clause my sql would look like this:

SELECT IFNULL(f_tag_bottom,
 IFNULL(f_tag_bottom_major_axis,
  IFNULL(f_tag_bottom_minor_axis,
   IFNULL(f_tag_ch_x_bottom,
IFNULL(f_tag_ch_y_bottom, NULL) as ftag,
STDDEV(ch_x_top)
FROM data_cst
WHERE ftag = 'E-CD7'
GROUP BY wafer_id, lot_id

But I can't use ftag in the where clause. I can't put it in a having
clause, as that would exclude the already aggregated rows and I want
to filter then before the aggregation. Anyone have any idea how I can
do this?


why would you want to do that?
it would make the where clause not be able to use proper indexes



signature.asc
Description: OpenPGP digital signature

Re: commands out of sync, you can't run this command now'

[Reindl Harald]

Am 08.01.2016 um 10:14 schrieb Nitin Mehta:

Looks like some kind of locking mechanism in the application. Should not be a 
database issue.


no true - this is a native mysql error message!
honestly both of you should have used Google

http://dev.mysql.com/doc/refman/5.7/en/commands-out-of-sync.html

http://stackoverflow.com/questions/15798762/mysqli-commands-out-of-sync-you-cant-run-this-command-now


 On Friday, January 8, 2016 10:47 AM, geetanjali mehra 
 wrote:


  Hi all,

Suddenly I have started getting below error from our web site:

'commands out of sync, you can't run this command now'

This error is generated sometimes when opening a page ,and immediately
after refreshing the page, error gone.

Can you please help me to troubleshoot this issue, so that above error
disappears permanently? Is it a database issue or application side issue?




signature.asc
Description: OpenPGP digital signature

Re: Start mysqld 5.7.7 with new disk

[Reindl Harald]

Am 23.12.2015 um 14:11 schrieb Jørn Dahl-Stamnes:

I had to replace the datadisk where mysql had its innodb files.

But after I had added a new disk I'm not able to initialize mysql files any 
more:

# mysqld --initialize --user=mysql
2015-12-23T13:07:08.216472Z 0 [ERROR] Plugin 'InnoDB' init function returned 
error.
2015-12-23T13:07:08.216556Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE 
ENGINE failed.
2015-12-23T13:07:08.216577Z 0 [ERROR] Failed to initialize plugins.
2015-12-23T13:07:08.216595Z 0 [ERROR] Aborting

I have created the directories stored in my /etc/my.cnf and changed group and 
ownership to the
directories to mysql:mysql


man mysql_install_db

NAME
   mysql_install_db - initialize MariaDB data directory

SYNOPSIS
   mysql_install_db [options]

DESCRIPTION
   mysql_install_db initializes the MariaDB data directory and 
creates the system tables that it contains, if they do not exist.


   To invoke mysql_install_db, use the following syntax:

   shell> mysql_install_db [options]

   Because the MariaDB server, mysqld, needs to access the data 
directory when it runs later, you should either run mysql_install_db 
from the same account that will be used for running mysqld or run it
   as root and use the --user option to indicate the user name that 
mysqld will run as. It might be necessary to specify other options such 
as --basedir or --datadir if mysql_install_db does not use
   the correct locations for the installation directory or data 
directory. For example:


   shell> bin/mysql_install_db --user=mysql \
--basedir=/opt/mysql/mysql \
--datadir=/opt/mysql/mysql/data



signature.asc
Description: OpenPGP digital signature

Re: --initialize specified but the data directory has files in it. Aborting.

[Reindl Harald]

Am 13.11.2015 um 17:46 schrieb Axel Diehl:

what kind of OS do you have?


pretty sure Fedora/CentOS7 because "yum" and the package name, if i 
would be him i would just install mariadb which is the default mysql 
implementation these days on most linux distributions and hence the 
packages are better maintained



-Ursprüngliche Nachricht-
Von: jim Zhou [mailto:jim.jz.z...@gmail.com]
Gesendet: Freitag, 13. November 2015 17:12
An: mysql@lists.mysql.com
Betreff: --initialize specified but the data directory has files in it. 
Aborting.

Hi,

I did "yum install myswl-community-server" and "service mysqld start"
I got the error

Initializing MySQL database:  2015-11-13T15:54:01.203931Z 0 [Warning] Changed 
limits: max_open_files: 1024 (requested 5000) 2015-11-13T15:54:01.204205Z 0 
[Warning] Changed limits: table_open_cache:
431 (requested 2000)
2015-11-13T15:54:01.204397Z 0 [Warning] TIMESTAMP with implicit DEFAULT value 
is deprecated. Please use --explicit_defaults_for_timestamp server option (see 
documentation for more details).
2015-11-13T15:54:01.207712Z 0 [ERROR] --initialize specified but the data 
directory has files in it. Aborting.
2015-11-13T15:54:01.207751Z 0 [ERROR] Aborting

can someone help?




signature.asc
Description: OpenPGP digital signature

Re: --initialize specified but the data directory has files in it. Aborting.

[Reindl Harald]

Am 13.11.2015 um 17:37 schrieb jim Zhou:

I change socket=/tmp/mysql.sock in my.cnf file and I am still having the
same error.
ls -lha /var/lib/mysql the directory is not empty. those .pem files are
created by the service even I deleted them.


write a bugreport if they are really created by the service before 
mysql_install_db is called, in the meantime make sure the directory is 
empty and call "mysql_install_db" by hand without trying to start the 
service before


P.S.: don't reply offlist!


[root@deweyods1 pem]# ls -lha /var/lib/mysql
total 48K
drwxr-x--x.  2 mysql mysql 4.0K Nov 13 07:33 .
drwxr-xr-x. 44 root  root  4.0K Nov 12 15:12 ..
-rw---.  1 mysql mysql  255 Nov 13 08:27 .bash_history
-rw---.  1 mysql mysql 1.7K Nov 13 07:33 ca-key.pem
-rw-r--r--.  1 mysql mysql 1.1K Nov 13 07:33 ca.pem
-rw-r--r--.  1 mysql mysql 1.1K Nov 13 07:33 client-cert.pem
-rw---.  1 mysql mysql 1.7K Nov 13 07:33 client-key.pem
-rw---.  1 mysql mysql 1.7K Nov 13 07:33 private_key.pem
-rw-r--r--.  1 mysql mysql  451 Nov 13 07:33 public_key.pem
-rw-r--r--.  1 mysql mysql 1.1K Nov 13 07:33 server-cert.pem
-rw---.  1 mysql mysql 1.7K Nov 13 07:33 server-key.pem
-rw---.  1 mysql mysql  578 Nov 12 15:21 .viminfo




signature.asc
Description: OpenPGP digital signature

Re: --initialize specified but the data directory has files in it. Aborting.

[Reindl Harald]

Am 13.11.2015 um 17:12 schrieb jim Zhou:

I did "yum install myswl-community-server" and "service mysqld start"
I got the error

Initializing MySQL database:  2015-11-13T15:54:01.203931Z 0 [Warning]
Changed limits: max_open_files: 1024 (requested 5000)
2015-11-13T15:54:01.204205Z 0 [Warning] Changed limits: table_open_cache:
431 (requested 2000)
2015-11-13T15:54:01.204397Z 0 [Warning] TIMESTAMP with implicit DEFAULT
value is deprecated. Please use --explicit_defaults_for_timestamp server
option (see documentation for more details).
2015-11-13T15:54:01.207712Z 0 [ERROR] --initialize specified but the data
directory has files in it. Aborting.
2015-11-13T15:54:01.207751Z 0 [ERROR] Aborting


this is most likely because the socket file lives by default in 
"/var/lib/mysql" and maybe created too soon for the task


write a bugreport and in the meantime temporary configure mysqld with 
the socket file somewhere else like /tmp, make sure with "ls -lha 
/var/lib/mysql" that the directory is really empty




signature.asc
Description: OpenPGP digital signature

Re: a

[Reindl Harald]

what about stop that bullshit or at least purge the list after press 
reply-all?


Am 18.10.2015 um 22:52 schrieb bluethu...@gmail.com:

e

Sent from my iPhone


On Oct 18, 2015, at 4:12 PM, Daevid Vincent  wrote:

d


-Original Message-
From: ryan.esca...@gmail.com [mailto:ryan.esca...@gmail.com] On Behalf
Of Ryan Escarez
Sent: Friday, October 16, 2015 2:47 AM
To: Ryan Coleman
Cc: Dennis Ruiz; mysql-le...@lists.mysql.com
Subject: Re: a

c

On Fri, Oct 16, 2015 at 3:01 PM, Ryan Coleman 
wrote:


b


On Oct 15, 2015, at 10:07 PM, Dennis Ruiz  wrote:

a




signature.asc
Description: OpenPGP digital signature

Re: When to create a new database

[Reindl Harald]

Am 10.10.2015 um 16:28 schrieb Richard Reina:

If I were keeping tract of high school sports statistics and thus designed
the following tables:

sports, rules, statistical definitions

and

players, teams, games

Would it be a good or bad idea to put the first set of tables in a separate
database called "library" since they are used for reference and rarely
change? What would be the pros and cons of using two different databases?


it makes zero sense since you can use different users for the same 
database down to table and even column permissions


with default (crap) settings innodb anyways stores all in the same big 
file, and file_per_table is, well, per table




signature.asc
Description: OpenPGP digital signature

Re: mysql instance disk quota

[Reindl Harald]

Am 06.09.2015 um 12:01 schrieb Ken Peng:

How to set OS disk quota?


that's hardly a mysql question
http://lmgtfy.com/?q=linux+disk+quota


On 2015/9/6  17:52, Reindl Harald wrote:

set OS disk quota for them




signature.asc
Description: OpenPGP digital signature

Re: mysql instance disk quota

[Reindl Harald]

Am 06.09.2015 um 11:37 schrieb Ken Peng:

If disk quota is reached, an error can be threw out. we can accept this
policy. Thanks.


and damage will happen - jesus christ the worst thing for a database is 
"disk full", if you don't care just start the mysql instances as 
different users and set OS disk quota for them, but be prepared for data 
loss sooner or later



On 2015/9/6 17:28, Reindl Harald wrote:


Am 06.09.2015 um 11:08 schrieb Ken Peng:

We have some instances running in a hardware server, each instance has
different port.

For quota limits, we can adjust my.cnf to control each instance's memory
usage, also can use cgroups to set CPU quota.

But what's the general solution to setup the disk quota? For example, I
want each instance should use the storage no more than 50GB.


you can't

what do you expect how a database server should do if the disk quota is
reached? what about the global table space?





signature.asc
Description: OpenPGP digital signature

Re: mysql instance disk quota

[Reindl Harald]

Am 06.09.2015 um 11:08 schrieb Ken Peng:

We have some instances running in a hardware server, each instance has
different port.

For quota limits, we can adjust my.cnf to control each instance's memory
usage, also can use cgroups to set CPU quota.

But what's the general solution to setup the disk quota? For example, I
want each instance should use the storage no more than 50GB.


you can't

what do you expect how a database server should do if the disk quota is 
reached? what about the global table space?




signature.asc
Description: OpenPGP digital signature

Re: Free load balancing and sharding

[Reindl Harald]

Am 02.09.2015 um 09:55 schrieb S.Mohammad Emami Razavi:

I want to cluster MySQL to several servers and have no idea to start. Some
questions have stuck to my mind such as How to balance connections and How
to make mesh of shards and ...
Can you show me a way to do these tasks correctly?


https://mariadb.com/products/mariadb-maxscale




signature.asc
Description: OpenPGP digital signature

Re: moving inno tables

[Reindl Harald]

Am 20.08.2015 um 23:06 schrieb Martin Mueller:

I moved the data directory of a MySQL installation from one computer to
another. This works for MyISAM tables. Unfortunately I inadvertently
created some INNO tables, and it doesn't seem to work.

The show tables command accurately lists the following the tables from a
longer list

  pospairs   |
| purchas4   |

The ls -l command for the directory /usr/local/mysql/data/tcpcurrent shows
what I take to be all the required files for these two tables:

-rw-r-  1 _mysql  wheel   66152 Jul 28 15:53 pospairs.MYD
-rw-r-  1 _mysql  wheel   45056 Jul 28 15:53 pospairs.MYI
-rw-r-  1 _mysql  wheel8664 Jul 28 15:53 pospairs.frm
-rw-r-  1 _mysql  wheel   13792 Jul 28 15:53 purchas4.frm
-rw-r-  1 _mysql  wheel   385875968 Jul 28 15:54 purchas4.ibd

The permissions are identical, and the file sizes seem appropriate. But
the first ISAM file responds while for the INNO file the command


you CAN NOT move / copy innodb tables that way because of the global 
tablespace - you can only dump / import or rsync *the complete* datadir




signature.asc
Description: OpenPGP digital signature

Re: When to create a new user?

[Reindl Harald]

Am 19.08.2015 um 15:18 schrieb Jim:

On 8/19/2015 8:40 AM, Reindl Harald wrote:


Am 19.08.2015 um 14:29 schrieb Richard Reina:

I am writing a web application in perl that will create, edit, update
and
delete data from a MySQL database. I have written a perl module that
will
manage the connections (issue database handles ). As new users sign up
for
the application should each get their own MySQL username and password
or is
okay to execute their queries with the same (one generic) MySQL username
and password?


one generic for the application

since you normally never ever should connect as root to your application
it even don't have the permissions to add mysql-users

how would you even imagine working with a usertable on your applications
side which is for every user different - chicken/egg


One generic, non-admin user is what you'll find in most apps.

Some developers take the approach of creating several users based on
level of operation and least privilege, particularly for public facing
scripts.

So, for example, if the operation is to delete data, that might be one
user. Perhaps there is some very sensitive data in the environment and
you'll create a given user for accessing that data and no other user has
access to that data.

Each user is given no greater access than is required based on the
intent of that user.

Then the given script connects with the appropriate user here.

Of course, you should program against and have defenses for db-related
vulnerabilities like SQL-injection, but the thinking with the multiple
users is if you had a script that was vulnerable to some exploit, the
damage would be limited to the privileges of the mysql user used to
connect to your database. It's a bit harder to manage and requires some
more planning up front, but it adds to damage control in case of a db
related exploit. You'd make this call based on how sensitive and
important your data is and how much effort you are willing to put into
the planning and design.


yes, but what has this all to do with "As new users sign up for the 
application" and create a own mysql-user for each application user?




signature.asc
Description: OpenPGP digital signature

Re: When to create a new user?

[Reindl Harald]

Am 19.08.2015 um 14:29 schrieb Richard Reina:

I am writing a web application in perl that will create, edit, update and
delete data from a MySQL database. I have written a perl module that will
manage the connections (issue database handles ). As new users sign up for
the application should each get their own MySQL username and password or is
okay to execute their queries with the same (one generic) MySQL username
and password?


one generic for the application

since you normally never ever should connect as root to your application 
it even don't have the permissions to add mysql-users


how would you even imagine working with a usertable on your applications 
side which is for every user different - chicken/egg




signature.asc
Description: OpenPGP digital signature

Re: mysql Digest 12 Aug 2015 13:08:20 -0000 Issue 5317

[Reindl Harald]

Am 12.08.2015 um 16:49 schrieb Bob Eby:

converting from MyISAM to innodb would certainly pose problems, I
guess the main question would be is MyISAM functionality a strict
sub-set of innodb?

I'm not sure, but maybe someone else here knows better


no it is for sure not





signature.asc
Description: OpenPGP digital signature

Re: Changing storage engine in dump file.

[Reindl Harald]

Am 12.08.2015 um 15:07 schrieb geetanjali mehra:

I am in the process of creating a new slave. On my master, there is a mix
of innodb and myisam tables. I want all my tables to be created in innodb
on slave.

I have planned to change the value of storage engine from innodb to myisam
in dump file itself using sed .

Running that dump file on the slave will create all my tables with innodb.

Is there any implications in doing so. Is this approach correct? Will I
face any problem in syncing the slave?


if you are asking for trouble do so
otherwise replication is designed to be identical

how do you imagine that working if there is only a single "alter table" 
on the master? how do you imagine row-based replication working in such 
a setup while statement-based replication is unsafe in many cases?


sorry, but that sounds just crazy



signature.asc
Description: OpenPGP digital signature

Re: innodb log sequence problem

[Reindl Harald]

Am 05.08.2015 um 17:06 schrieb Csepregi Árpád:

150805 17:02:31  InnoDB: Page dump in ascii and hex (16384 bytes):
hex...
150805 17:02:31  InnoDB: Page checksum 1094951825, prior-to-4.0.14-form
checksum 1449969277
InnoDB: stored checksum 1467223489, prior-to-4.0.14-form stored checksum
87759728
InnoDB: Page lsn 1054562273 1692468334, low 4 bytes of lsn at page end
3304862103
InnoDB: Page number (if stored to page already) 544833488,
InnoDB: space id (if created with >= MySQL-4.1.1 and stored already)
960999566
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 7.
InnoDB: You may have to recover from a backup

Does anyone have any idea how to recover?


check hardware, especially memory and restore your backup!



signature.asc
Description: OpenPGP digital signature

Re: password problem

[Reindl Harald]

Am 31.07.2015 um 16:23 schrieb Martin Mueller:

Dear Mr Harald,

I've learned some things from your responses and even more from shawn
green's. You might learn a lot from him about patience and courtesy, which
make life on a technical forum a lot easier. You clearly know a lot about
technical stuff, but you're short on patience, and it would help you a lot
to practice a little courtesy and refrain from vulgar language.


well, i am developer and sysadmin, not a politican

my first response pointed again to the docs and quotet that:
>>> Resetting the Root Password: Generic Instructions
>>> Stop the MySQL server if necessary, then restart it
>>> with the --skip-grant-tables option

https://www.google.at/search?q=skip-grant-tables would have flooded you 
with informations


P.S.: on the right side of the docs page is a "Section Navigation" with 
a link 
https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-generic



On 7/31/15 9:12 AM, "Reindl Harald"  wrote:


Am 31.07.2015 um 15:40 schrieb shawn l.green:

1. Log on to your system as the Unix user that the MySQL server runs as
(for example, mysql).


Everything that executes on a Linux/Unix/Mac machine executes in the
context of some kind of user account (the system login). By default,
mysqld (the database server daemon) is installed to run under the host
machine user account 'mysql'. It can be changed if you want to change it
but that is the default. That is why 'mysql' was listed in the "for
example" section of that instruction


but this part of the docs is completly bullshit

a) on no sane system the user "mysql" has a password, hence
no login possible and typically it has also no shell
configured

b) for what reason "mysql -u root" and you are done with
skip-grant-tables (and skip-grant-tables is the only
relevant point)

why in the world should i need to logon as the user mysqld runs for
connect to mysqld? but anyways, "mysql -u mysql" would have worked also
as well as "mysql -u bullshit" because skip-grant-tables does what it
says, you can do anything you like to do




signature.asc
Description: OpenPGP digital signature

Re: password problem

[Reindl Harald]

Am 31.07.2015 um 15:40 schrieb shawn l.green:

1. Log on to your system as the Unix user that the MySQL server runs as
(for example, mysql).


Everything that executes on a Linux/Unix/Mac machine executes in the
context of some kind of user account (the system login). By default,
mysqld (the database server daemon) is installed to run under the host
machine user account 'mysql'. It can be changed if you want to change it
but that is the default. That is why 'mysql' was listed in the "for
example" section of that instruction


but this part of the docs is completly bullshit

a) on no sane system the user "mysql" has a password, hence
   no login possible and typically it has also no shell
   configured

b) for what reason "mysql -u root" and you are done with
   skip-grant-tables (and skip-grant-tables is the only
   relevant point)

why in the world should i need to logon as the user mysqld runs for 
connect to mysqld? but anyways, "mysql -u mysql" would have worked also 
as well as "mysql -u bullshit" because skip-grant-tables does what it 
says, you can do anything you like to do




signature.asc
Description: OpenPGP digital signature

Re: password problem

[Reindl Harald]

Am 31.07.2015 um 14:40 schrieb Martin Mueller:

Sorry  for the off-list reply. It was an oversight.

That said, the instructions for resetting a forgotten root password have a
section for Windows and a section for Unix. The Unix section begins as
follows:

1. Log on to your system as the Unix user that the MySQL server runs as
(for example, mysql).

But if I do this with the command 'mysql -u mysql I get the answer

Access denied for user 'mysql'@'localhost' (using password: NO)

I can do this as super user or normal, and I can try passwords from
earlier installations, but none of them work. So I am stopped dead in my
tracks, am I not?


what do you not understand in:

>> Resetting the Root Password: Generic Instructions
>> Stop the MySQL server if necessary, then restart it with the
>> --skip-grant-tables option

jesus christ, put "skip-grant-tables" in your "my.cnf", make sure the 
server is not reachable from outside and just type "myysql -u root" and 
don't forget remove "skip-grant-tables" after you defined a password you 
are knowing and restarting the server again



As for the datadir, the command "update db locate mysql" works on the Mac
and gives me info about a whole set of files in
/usr/local/mysql-5.1.73-osx10.6-x86_64. That's where I thought it was, and
I deleted a previous installation because I had moved the data I needed to
another machine.

I'm not a very experienced programmer and have trouble wrestling with the
command line. But I think I did my due diligence and didn't find any open
doors.


well, you have a bad mix

* missing knowledge
* a blackbox with a installer
* refusing to read more than the begin of docs


On 7/31/15 3:36 AM, "Reindl Harald"  wrote:


first: don't reply off-list, a answer on a mailing-list is no invitation
for private support!

Am 31.07.2015 um 02:34 schrieb Martin Mueller:

I read that section but was stopped in my tracks by

   "Log on to your system as the Unix user that the MySQL server runs as
(for example, mysql)"

Because I have no password for ANY thing.


read the f**ng
https://dev.mysql.com/doc/refman5.0/en/resetting-permissions.html
<https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html> -
unbelievebale that users these days need anything ready chewed and are
too lazy to click on a link and read more than 5 lines

Resetting the Root Password: Generic Instructions
Stop the MySQL server if necessary, then restart it with the
--skip-grant-tables option


I used the uninstall routine recommended by Rob Allen, in which you
remove
the directories /usr/local/mysql as well as /usr/local/mysql* and a lot
of
other library and etc files. So there is no trace of the old system on
my
machine. How come a routine installation of mysql then locks up the
application.


the datadir is *not* removed by any sane installer, dunno where it lives
on Apple machines since i banned them 5 years ago for good reasons

on a non-OSX i would just type "updatedb; locate mysql" als root


On 7/30/15, 19:22, "Reindl Harald"  wrote:


Am 31.07.2015 um 01:41 schrieb Martin Mueller:

I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I
cannot
run the mysql command because it challenges me for a password. But I
did
not set any password, either for the root, for mysql, or for myself
as a
user.

So the installation has somehow installed passwords about which I know
nothing or there is some error in the installation process.

There is a lot on the Web about resetting a forgotten password. But
the
assumption is always that you can get at the program via some other
password. But in this case every door is shut.

Does anybody recognize this problem? I've uninstalled and re-installed
the
program, but the results are always the same


* install and uninstall *never* removes the datadir
* users and permissions are in the DB "mysql"
* https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html




signature.asc
Description: OpenPGP digital signature

Re: password problem

[Reindl Harald]

Am 31.07.2015 um 14:45 schrieb Martin Mueller:

Data directory path mention in cnf is of old mysql.

Make a fresh data directory, configure it in configuration file and execute 
mysqlinstall_db,
I don't understand the sentence about the data directory path mention.  The 
my.cnf file is at /etc/my.cnf . It doesn't have any data directory path 
mention, but neither does the my.cnf file on a laptop, which works. So there 
seems to be nothing wrong with the location or content of the my.cnf file.


your current problem is that you have no clue where your mysql-datadir 
is *because* it's some random default, from the moment on you specify it


a) you know it - good for a million reasons
b) it is empty and you can start from scratch

or you seek the current one and make the folder empty and start with

mysql_install_db initializes the MySQL data directory and creates the 
system tables that it contains, if they do not exist.



On Fri, Jul 31, 2015 at 5:11 AM, Martin Mueller 
mailto:martinmuel...@northwestern.edu>> wrote:
I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot
run the mysql command because it challenges me for a password. But I did
not set any password, either for the root, for mysql, or for myself as a
user.

So the installation has somehow installed passwords about which I know
nothing or there is some error in the installation process.

There is a lot on the Web about resetting a forgotten password. But the
assumption is always that you can get at the program via some other
password. But in this case every door is shut.

Does anybody recognize this problem? I've uninstalled and re-installed the
program, but the results are always the same.


Martin Mueller
Professor emeritus of English and Classics
Northwestern University



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql




--
Thanks and Regards:

Nikhil Anand

+91 9650024197



--

Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / CISO / Software-Development
m: +43 (676) 40 221 40, p: +43 (1) 595 3999 33
icq: 154546673, http://www.thelounge.net/

http://www.thelounge.net/signature.asc.what.htm



signature.asc
Description: OpenPGP digital signature

Re: password problem

[Reindl Harald]

first: don't reply off-list, a answer on a mailing-list is no invitation 
for private support!


Am 31.07.2015 um 02:34 schrieb Martin Mueller:

I read that section but was stopped in my tracks by

  "Log on to your system as the Unix user that the MySQL server runs as
(for example, mysql)"

Because I have no password for ANY thing.


read the f**ng 
https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html - 
unbelievebale that users these days need anything ready chewed and are 
too lazy to click on a link and read more than 5 lines


Resetting the Root Password: Generic Instructions
Stop the MySQL server if necessary, then restart it with the 
--skip-grant-tables option



I used the uninstall routine recommended by Rob Allen, in which you remove
the directories /usr/local/mysql as well as /usr/local/mysql* and a lot of
other library and etc files. So there is no trace of the old system on my
machine. How come a routine installation of mysql then locks up the
application.


the datadir is *not* removed by any sane installer, dunno where it lives 
on Apple machines since i banned them 5 years ago for good reasons


on a non-OSX i would just type "updatedb; locate mysql" als root


On 7/30/15, 19:22, "Reindl Harald"  wrote:


Am 31.07.2015 um 01:41 schrieb Martin Mueller:

I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I
cannot
run the mysql command because it challenges me for a password. But I did
not set any password, either for the root, for mysql, or for myself as a
user.

So the installation has somehow installed passwords about which I know
nothing or there is some error in the installation process.

There is a lot on the Web about resetting a forgotten password. But the
assumption is always that you can get at the program via some other
password. But in this case every door is shut.

Does anybody recognize this problem? I've uninstalled and re-installed
the
program, but the results are always the same


* install and uninstall *never* removes the datadir
* users and permissions are in the DB "mysql"
* https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html




signature.asc
Description: OpenPGP digital signature

Re: password problem

[Reindl Harald]

Am 31.07.2015 um 01:41 schrieb Martin Mueller:

I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot
run the mysql command because it challenges me for a password. But I did
not set any password, either for the root, for mysql, or for myself as a
user.

So the installation has somehow installed passwords about which I know
nothing or there is some error in the installation process.

There is a lot on the Web about resetting a forgotten password. But the
assumption is always that you can get at the program via some other
password. But in this case every door is shut.

Does anybody recognize this problem? I've uninstalled and re-installed the
program, but the results are always the same


* install and uninstall *never* removes the datadir
* users and permissions are in the DB "mysql"
* https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html



signature.asc
Description: OpenPGP digital signature

Re: Unsubscribing my sql mailing list

[Reindl Harald]

why do you think we could do that for you and what do you think is that 
link in every mail for? YES i send this to the list hopefully to save a 
few of this "meh i can't handle my mail".


To unsubscribe:http://lists.mysql.com/mysql

Am 22.07.2015 um 18:08 schrieb Charles Turner:

Dear Sirs,

I'd like to unsubscribe my subscription to this mailing list.

Thank you so much.

Regards

Andrea Fanni




signature.asc
Description: OpenPGP digital signature

Re: can't start mariadb with client certs specified

[Reindl Harald]

Am 22.07.2015 um 16:24 schrieb Tim Dunphy:

Hi Reindl,

what about running mysql_upgrade *directly* after the major update
and *before* touch anything else?

That was precisely what happened. In setting up the new database
machine, puppet had installed version 5 of mariadb. Before even starting
up version of for the first time, I uninstalled the RPM's for that
version and installed version 10.0.20 from the mariadb repo.

However I was able to solve this problem my recreating the keys and
certs. I had setup master/slave replication using this tutorial:

https://www.howtoforge.com/how-to-set-up-mysql-database-replication-with-ssl-encryption-on-centos-5.4

I'm not sure what the problem is with the way the keys are generated in
this article that could have caused that last, rather long email. :)

So after I regenerated the keys and certs using this method:

   182  openssl genrsa -des3 -out db1.example.com.key 4096
   183  openssl rsa -in db1.example.com.key -out db1.example.com.key
   184  openssl req -new -key db1.example.com.key -out db1.jokefire.com.csr
   185  openssl x509 -req -days 3650 -in db1.example.com.csr -CA ca.crt
-CAkey ca.key -set_serial 01 -out db1.example.com.crt


you need the same certs and same CA on both sides


*Last_Error: Unable to load replication GTID slave state from
mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't exist*

 Last_IO_Errno: 0

 Last_IO_Error:

Last_SQL_Errno: 1146

* Last_SQL_Error: Unable to load replication GTID slave state from
mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't exist*

Any idea what that error means and how I can get rid of it?


hopefully you did run mysql_upgrade first on the slave as all docs in 
that context saying and after that on the master


however, i would just double-rsync (hot and than cold) the whole datadir 
to the not running slave and just start replication with that binary 
identical copies from scratch, doing that in case of any replication 
issues for many years now and if it's just for safety






signature.asc
Description: OpenPGP digital signature

Re: can't start mariadb with client certs specified

[Reindl Harald]

Am 22.07.2015 um 06:39 schrieb Tim Dunphy:

Hey guys,

I'm trying to setup multi master replication using SSL under MariaDB 10.20.
I've been able to specify my client certs on the second node (db2) with no
issue and start up the mysql service


what about running mysql_upgrade *directly* after the major update and 
*before* touch anything else?


150722  4:18:47 [ERROR] Column count of mysql.file_summary_by_event_name is
wrong. Expected 23, found 5. Created with MariaDB 50541, now running
100020. Please use mysql_upgrade to fix this error



signature.asc
Description: OpenPGP digital signature

Re: can't authenticate ssl user account

[Reindl Harald]

Am 21.07.2015 um 05:03 schrieb Tim Dunphy:

I see absolutely NO indication as to why the login for the 'slave2' user
(that requires SSL) is failing

So my questions are 1) how to I bump up the verbosity on the logs so I can
get an indication as to why this is failing? 2) what is the best way to
troubleshoot this?


you client configuration shows no indication for SSL, i see it in my.cnf 
only in the [mysqld] section and remember when you initrialize 
replication you need to specify it there too


i doubt there is anything to change the logging but since you *know* 
what that user requires that should really not be the problem - said 
from somebody using SSL for any mysql connection over TCP for years now 
(replication, php-applications, cli-client...)


CHANGE MASTER TO MASTER_HOST='masterip', MASTER_USER='user', 
MASTER_PASSWORD='password', MASTER_PORT=3306, MASTER_CONNECT_RETRY=3600, 
MASTER_SSL=1, MASTER_SSL_CA='/etc/mysqlssl/ca.crt', 
MASTER_SSL_CERT='/etc/mysqlssl/client.pem', 
MASTER_SSL_KEY='/etc/mysqlssl/client.pem'; START SLAVE;




signature.asc
Description: OpenPGP digital signature

Re: Unable to start mysql after power Failure

[Reindl Harald]

Am 04.07.2015 um 06:24 schrieb Jatin Davey:

We are trying to High Availability solution for our database. We have
our application running on a node-1 and the DB running on the shared
storage which is shared across node-1 & node-2. Whenever there is a
power Failure on node-1 , we start our application on node-2 but our
problem is that now after a failover onto node-2 the DB deamon on node-2
will fail to start.


did you see that lines of your log?

2015-07-03 16:04:03 17753 [Note] InnoDB: Retrying to lock the first data 
file
2015-07-03 16:04:04 17753 [ERROR] InnoDB: Unable to lock ./ibdata1, 
error: 11
2015-07-03 16:04:04 17753 [Note] InnoDB: Check that you do not already 
have another mysqld process using the same InnoDB data or log files.




signature.asc
Description: OpenPGP digital signature

Re: Sending a fax

[Reindl Harald]

Am 15.06.2015 um 19:24 schrieb Trianon 33:

Jim,

It's just a fax to email service I would like to test..


and WHY THE FUCK don't you call some buddy instead spam large, public 
mailing-lists? creep away!




signature.asc
Description: OpenPGP digital signature