#maria Log v0.1

logs Catalogue

This page loads from the db, refresh as and when. It displays 24 hrs
For older data http://marialog.archivist.info/previous.php, logs go back to 2009-01-18
Some user stats
Table logs
date_time
user
message
2017-08-19 01:39:47
IgorK_
mgriffin: here are the results: https://bpaste.net/show/0e1911718916
2017-08-19 01:40:16
IgorK_
also the passwords are the same
2017-08-19 01:40:37
IgorK_
for user 'root'
2017-08-19 01:50:12
mgriffin
and in that session, SELECT user(), current_user()
2017-08-19 01:50:28
mgriffin
gives root@fordanwork, root@192.168.1.4
2017-08-19 01:50:28
mgriffin
?
2017-08-19 02:50:47
IgorK_
mgriffin: Nope. It gives root@192.168.1.2 and root@192.168.1.%
2017-08-19 02:51:00
mgriffin
IgorK_: so connecting differently
2017-08-19 02:51:17
mgriffin
again probably you want: drop user 'root'@'192.168.1.4';
2017-08-19 02:51:28
IgorK_
this is on the machine where the server is
2017-08-19 02:51:47
mgriffin
18:44 <mgriffin> use the client from that machine
2017-08-19 02:52:03
IgorK_
ok, let me try to drop it
2017-08-19 02:52:27
IgorK_
and i told you - i am using a connector/c there
2017-08-19 02:52:52
IgorK_
i don't any native clients installed on that machine
2017-08-19 02:53:34
mgriffin
yes but you can easily install the client
2017-08-19 02:54:26
IgorK_
ok, let me look where to get it and try installing it
2017-08-19 02:55:46
mgriffin
IgorK_: does the machine run linux?
2017-08-19 02:56:00
cslcm
Hello.. how can I go back to the old 10.1 behaviour of silently truncating input rather than generating an error?
2017-08-19 02:56:01
IgorK_
nope win 8
2017-08-19 02:56:12
IgorK_
server is on Linux
2017-08-19 02:57:23
mgriffin
cslcm: show session variables like 'sql_mode';
2017-08-19 02:58:19
cslcm
mgriffin: https://pastebin.com/raw/AKksRHLh
2017-08-19 02:58:56
mgriffin
cslcm: STRICT_TRANS_TABLES is fixing things for you
2017-08-19 02:59:33
mgriffin
cslcm: my_print_defaults --mysqld | grep mode
2017-08-19 02:59:36
IgorK_
ok on dev.mysql.com/downloads/ I should get "MySQL on Windows (Installer and Tools)" right?
2017-08-19 03:00:17
cslcm
mgriffin: no output
2017-08-19 03:00:25
IgorK_
or "MySQL Utilities"
2017-08-19 03:00:49
mgriffin
IgorK_: you can probably get the .zip and then the client is easily extracted https://downloads.mariadb.org/mariadb/5.5.57/#os_group=windows
2017-08-19 03:00:59
mgriffin
IgorK_: or workbench might do the trick
2017-08-19 03:02:22
cslcm
how do i disable STRICT_TRANS_TABLES?
2017-08-19 03:02:35
cslcm
sql_mode = ?
2017-08-19 03:04:00
mgriffin
cslcm: probably you want in [mysqld] of my.cnf:
2017-08-19 03:04:21
cslcm
sql_mode="ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" ?
2017-08-19 03:04:22
mgriffin
sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
2017-08-19 03:04:26
cslcm
cool
2017-08-19 03:04:27
cslcm
thanks
2017-08-19 03:04:33
mgriffin
https://mariadb.com/kb/en/mariadb/sql-mode/
2017-08-19 03:04:41
mgriffin
10.2 sets strict trans by default
2017-08-19 03:05:38
mgriffin
and you can "fix" (break) without a restart via SET GLOBAL (clients need to reconnect if they are a connection pool like java)
2017-08-19 03:05:49
mgriffin
but restart lets you test the change sticks
2017-08-19 03:06:09
cslcm
i just did a restart, screw the users. ;)
2017-08-19 03:06:21
cslcm
that mode is gone, thanks
2017-08-19 03:08:56
IgorK_
it going to be hard to cut'n'paste from Workbench, but I guess it will do...
2017-08-19 03:09:07
IgorK_
hold on downloading.........
2017-08-19 03:11:05
mgriffin
IgorK_: https://dev.mysql.com/doc/workbench/en/wb-sql-editor-query-panel.html
2017-08-19 03:48:30
IgorK_
mgriffin: I installed Workbench, but unfortunately "show grants\G" gave an error on "\G"
2017-08-19 03:50:03
IgorK_
running without "\G" produced bpaste.net/show/dfca6c307dbc
2017-08-19 03:51:39
IgorK_
running "SELECT user(), current_user() produces: https://bpaste.net/show/b2d14f189d76
2017-08-19 03:54:01
mgriffin
IgorK_: and "show grants;"
2017-08-19 03:54:46
mgriffin
oh you had that.
2017-08-19 03:54:55
mgriffin
anyway your grant is not what you say it is
2017-08-19 03:55:07
mgriffin
ALL PRIVILEGES ON `draft`.*
2017-08-19 03:55:21
mgriffin
22:26 <IgorK_> I successfully executed "GRANT ALL PRIVILEGES ON *.* TO 'root@192.168.1.4'@'%' IDENTIFIED BY PASSWORD '<my_pass>' WITH GRANT OPTION
2017-08-19 03:55:53
mgriffin
so, again, i think dropping that user makes sense. or grant it process.
2017-08-19 04:05:10
IgorK_
you mean 'root'@'192.168.1.4'?
2017-08-19 04:06:08
IgorK_
because the initial issue is - I got "need PROCESS privileges"
2017-08-19 04:06:33
IgorK_
and now user() and current_user() are different...
2017-08-19 12:19:17
j4g0
as a practice project I am planning to build a php application that for starters does two things: 1. make a (monthly) duty roster for all employees from a division at a workplace (while employees can be part of several divisions and work at several workplaces). I plan on building it so that a user would choose a month and a division and would get a html table for each employee with a row for every day of said month that
2017-08-19 12:19:17
j4g0
would state the start and end time and the workplace (as well as sum of actual work hours vs necessary work hours (e.g. overtime) - which wouldnt need to be stored in the db). 2. absence planning where the user would get division vise visual feedback of vacations, sick leaves, special leaves, compensatory time-offs. For that purpose I am currently trying to design a db that could not only do what has been described so
2017-08-19 12:19:20
j4g0
far, but could adapt to the needs of possible additional app functionality in the future. So far i have http://imgur.com/a/57gPC and i have a lot of questions, starting with the most basic one: is the depiction ok in general? i used dia and i hope it makes sense to read?
2017-08-19 12:23:16
uebera||
After the 10.1->10.2 upgrade of a cluster, the "wsrep_provider_options" is ignored (given that this in turn is also supposed to set "gmcast.listen_addr=tcp://188.68.55.29:4567", this is not funny as the default is 0.0.0.0). It's not documented in https://mariadb.com/kb/en/mariadb/upgrading-from-mariadb-101-to-mariadb-102/
2017-08-19 12:23:52
uebera||
Where are these options supposed to be set now?
2017-08-19 14:44:15
IgorK_
Hi, got another question
2017-08-19 14:44:42
IgorK_
I have a script which creates a database. I nade a script on Windows
2017-08-19 14:45:27
IgorK_
one of the tables I'm creating has a name of "abc<ALT>+225".
2017-08-19 14:45:51
IgorK_
it should be "abc"+greek letter "beta"
2017-08-19 14:46:16
IgorK_
or "abc"+German letter for interpreting "ss"
2017-08-19 14:46:56
IgorK_
I successfully build MS SQL Server DB and can read it without any issues from my software
2017-08-19 14:47:33
IgorK_
I also can successfully build and run my software against SQLIte on both Windows and Linux with this table
2017-08-19 14:48:34
IgorK_
Now here is the probloem - I build mySQL database on the server which runs on Linux and my program crashes when I run it on Windows trying to connect
2017-08-19 14:48:44
IgorK_
to mySQL server running on Linux
2017-08-19 14:49:40
IgorK_
upon examining I see that the table name for Windows has "abc\0d195\0d159"
2017-08-19 14:50:16
IgorK_
whereas for mySQL the table is read as "abc\0d-61\0d63"
2017-08-19 14:51:11
IgorK_
could someone please explain why there is a difference? and how to fix this?
2017-08-19 14:51:33
IgorK_
or maybe it is a bug in the mySQL/Connector?
2017-08-19 14:52:20
IgorK_
the database and table were both created with default options
2017-08-19 14:53:05
IgorK_
no encoding/collation option were supplied
2017-08-19 14:53:19
IgorK_
tia
2017-08-20 00:20:09
Xgc
IgorK_: Provide the SQL statements which produce the unexpected behavior or creates a table with an unexpected name.