- discuss - lists.mariadb.org

[Maria-discuss] New Question: zip or msi
by AskMonty KB 28 Jun '13

28 Jun '13

Hello, A new question has been asked in "What is in the different MariaDB releases?" by Swirl: -------------------------------- Why is the "zip" that much bigger than the "msi"? Does it contain more info/code/tools or whatever? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/zip-or-msi/

2 1

[Maria-discuss] New Question: Changing location of database
by AskMonty KB 28 Jun '13

28 Jun '13

Hello, A new question has been asked in "MariaDB community" by mdavies5: -------------------------------- Using 5.5.31 on Linux Mint. By default datadir is /var/lib/mysql. Like most users I do not want my data on my boot drive so I moved it to a different physical drive which is always mounted. I then stopped server, reset the basedir in my.cnf and restarted. No problem. After a reboot the log shows multiple errors "Table xxx doesn't exist" although it does. In Mysql workbench the tables are listed in the schema tree but any attempt to access causes workbench to abort. I also tried deleting all data, recreate the schema folders and then the scripts to create the tables and routines and data. Again ok until a reboot. The only thing I haven't tried is dropping the schemas and recreating them in workbench. Relevant data: The new data drive is NTFS. The error messages include: [ERROR] Cannot find or open table pword/pword from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database? or, the table contains indexes that this version of the engine doesn't support. Would appreciate any suggestions. -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/changing-location-of-database/

1 0

[Maria-discuss] New Question: LINQ in C#
by AskMonty KB 27 Jun '13

27 Jun '13

Hello, A new question has been asked in "Using MariaDB" by JDoggieIII: -------------------------------- Hi, I am attempting to replace the database in an application with MariaDB. This application is written in C# and previously accessed the database (mostly inserts) with LINQ. When I attempt to insert (other transactions have the same type of issue) I get the error message: "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '[t0].[Id], [t0].[BirthYear], [t0].[FirstName], [t0].[Gender], [t0].[LastName], [' at line 1" The table in MariaDB is setup the same as it was in MS SQL. Any thoughts on this subject would be most appreciated. I could go back and remove all use of LINQ and write SQL by hand (which is how I would have implemented it in the first place due to LINQ being the bane of my existence), but if I can get it to work as is it will save a great deal of time, and therefore money. Thanks, Jeremy -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/linq-in-c/

1 0

[Maria-discuss] New Question: installation and license
by AskMonty KB 25 Jun '13

25 Jun '13

Hello, A new question has been asked in "Getting Started" by JDoggieIII: -------------------------------- Hi, we want to use MariaDB on several machines, one of which contains MS SQL 2008 R2 (which we don't want to use). Does MariaDB play nice on the same server as MS SQL 2008 R2? Also, is there a license somewhere, I can't locate one. Thanks, Jeremy -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/installation-and-license/

1 0

[Maria-discuss] Silencing "Unsafe statement written to the binary log" log warnings
by Vincent Pelletier 25 Jun '13

25 Jun '13

Hi. We get 500k such lines per day: 130517 0:00:02 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted. Statement: UPDATE [...] Is there a way to silence them ? Intuitively, I would expect a companion option to innodb_locks_unsafe_for_binlog, but couldn't find one in the documentation. The queries triggering those warnings are harmless in our case because the update is rolled back at application level on restart (which necessarily happens in case of disaster recovery involving restoring incremental backups). If you want more details to understand what we are doing - shouldn't be needed for this discussion: The table involved is used as a shared task queue. The update happens when a process wants to process a bunch of tasks, up to a limit. Once a task is over, it is deleted by its primary key. So any task assigned to a worker's identifier upon worker startup can be safely assumed to have to be processed, and is released by that worker (effectively rolling back UPDATE's action). This only represents 2MB gzipped, so we can live with it if we must, but it causes undesired noise which may hide real issues. Regards, -- Vincent Pelletier ERP5 - open source ERP/CRM for flexible enterprises

3 3

[Maria-discuss] New Question: Issue with symlinked database directories loading under windows
by AskMonty KB 25 Jun '13

25 Jun '13

Hello, A new question has been asked in "Using MariaDB" by scottharman: -------------------------------- Hi all, I'm having trouble getting symlinked databases to work under 5.5.31 of MariaDB Currently the databases are held on a different drive, and I've tried both Symlinks and Junctions under windows to get them working under MariaDB Both methods work equally well under MySQL 5.5.31, and I've enabled symlink support in my.ini for Mariadb Any thoughts on why it wouldn't be working? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/issue-with-symlinked-database-directories-loading…

1 0

[Maria-discuss] New Question: Downloading MariaDB and starting the installation procedure
by AskMonty KB 23 Jun '13

23 Jun '13

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by tsperry: -------------------------------- I've downloaded the package several times but the installation feature won't start. What am I doing wrong? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/downloading-mariadb-and-starting-the-installation…

1 0

[Maria-discuss] New Question: Downloading MariaDB and starting the installation procedure
by AskMonty KB 23 Jun '13

23 Jun '13

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by tsperry: -------------------------------- I've downloaded the package several times but the installation feature won't start. What am I doing wrong? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/getting-installing-and-upgrading-mariadb-download…

1 0

[Maria-discuss] New Question: Windows Authentication on AD
by AskMonty KB 20 Jun '13

20 Jun '13

Hello, A new question has been asked in "Plugins" by nobi: -------------------------------- Hi all, I have a question concerning the authentication plugin interface in MariaDB. We would use MariaDB on a Windows OS and want to authenticate the users against Active Directory. Additionally the users, who have logged in to Windows, should be able to connect from client programs to the server based on the token information in their environment without specifying an additional password (Single-Sign-On functionallity). MySQL sells this function in the commercial MySQL Enterprise version http://www.mysql.com/products/enterprise/security.html I have seen articles about authentication with PAM in the linux environment but found nothing about authentication issues in Windows world. Does there exist something that can be used? Best regards, nobi -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/windows-authentication-on-ad/

1 0

[Maria-discuss] New Question: MariaDB SSL connection issues
by AskMonty KB 19 Jun '13

19 Jun '13

Hello, A new question has been asked in "Getting Started" by bacterie: -------------------------------- Hi, After switching from Mysql to MariaDB ( Server version: 5.5.31-MariaDB-1~squeeze-log ) we lost the ability to connect via SSL to the server. We were using self signed certificates generated via the method described here and they worked well before the switch to MariaDB : http://dev.mysql.com/doc/refman/5.5/en/creating-ssl-certs.html We get the following error messages when trying to connect on the same machine having bot the client and the server. mysql -v -u user -p database --ssl-ca /etc/mysql/newcerts/ca-cert.pem --ssl-cert /etc/mysql/newcerts/client-cert.pem --ssl-key /etc/mysql/newcerts/client-key.pem Enter password: ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1) Any hint is appreciated. Thanks. -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/mariadb-ssl-connection-issues/

1 0