- discuss - lists.mariadb.org

[Maria-discuss] Mariadb Java Driver useOldAliasMetadataBehavior and useColumnNamesInFindColumn
by Peter Mclarty 18 Mar '14

18 Mar '14

Hi Our context file presently has the useOldAliasMetadataBehavior=true in it to handle select count(*) as Bignumber type scenarios.( select as as b from table ) We tried using the mariadb driver as we have started the journey to using mariadb.5.5 and had a meltdown in our app (dev only thanks). I have done some research and it as i read it the mariadb code doesn't honour that parameter. I have done some research and one article stated With JDBC drivers version 4.0 and later you will eventually not get the aliasName As i haven't fully digested the JDBC 4.0 spec, barely scratched the surface am I right to conclude Maria and MySQL drivers will not eventually support this behavior and what is the approach to this using aliases or the selact a as b type scenario. Just point me to the pages is fine Any assistance appreciated Cheers -- *Peter McLarty* *Data Analyst DBA* Compare The Market -- Compare The Market is a brand and trading name of Compare The Market (Pty) Ltd (CTM). This email is for the intended addressee and is confidential and subject to copyright. If you are not the intended addressee, confidentiality has not been waived and any use, interference with, or disclosure of this email is unauthorised. If you are not the intended addressee please immediately notify CTM and then delete the email. CTM does not warrant that this email is error or virus free.

1 0

[Maria-discuss] New Question: pre-seeding databases from remote servers for multi-source replication
by AskMonty KB 17 Mar '14

17 Mar '14

Hello, A new question has been asked in "Backup, Restore and Import" by ivesstoddard: -------------------------------- I'm in the process of pre-seeding a mariadb 10.0.9 multi-source replica server with databases from remote 5.5 servers. I'm looking for the fastest and most stable way of doing this (preferably without using mysqldump). I'm curious if there is a way to import entire databases directly from block-level snapshots, similar to the transportable tablespaces (only on a database level instead of a table level, by copying .idb/.frm/etc. files directly to the target server). NOTE: Transportable tablespaces aren't yet available in 5.5 and also have to be done on a table-by-table basis. Some of the databases are large enough that running mysqldump & import will are impractical. Not only will this process take a considerable amount of time, but to do this in a way that is closest to a snapshot will require a separate server instance to ensure all transactions have been committed to the tablespaces. Is there anyone out there looking at multi-source replication who has a simple solution to this that i might be overlooking? Thank you. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/pre-seeding-databases-from-remote-servers-for-mult…

1 0

[Maria-discuss] MariaDB vs. MySQL error codes (1900+)
by Felipe Gasper 17 Mar '14

17 Mar '14

Hi everyone, I notice that MariaDB is using the 1900+ range for its own error codes; however, MySQL 5.7, at least, has a few errors in that range as well. Are error codes just going to be an area of increasing conflict between the two, or is there a plan to migrate MariaDB codes to a different numbering scheme? -Felipe Gasper Houston, TX

2 2

[Maria-discuss] Participation in GSOC 2014
by Ivoline Ngong 17 Mar '14

17 Mar '14

Hi, My name is Ngong Ivoline.I am a second year student reading Computer Engineering in the University of Buea (Cameroon in West Africa). I am very excited working with an open source organization as i will finally have the chance to share my ideas as well as learn from others. I love coding and i am proficient in Java ,C and mysql.I will like to not only test but improve my skills by taking part in a google summer of code 2014. One of my goals as an African woman is to encourage the growth of programming in my community, country and continent as a whole. I am interested in the project to statistically optimize mysql-test runs by running less tests. It will be great if i get some guidance on how to continue from here.Look forward to participating in this group. Cheers!! Ivoline.

2 1

[Maria-discuss] New Question: Reentrant mariadbclient on the horizon?
by AskMonty KB 14 Mar '14

14 Mar '14

Hello, A new question has been asked in "MariaDB community" by markcianfaglione: -------------------------------- I've written an test application that can be multi-threaded and I've done a bit of testing only to find that mariadbclient is not reentrant! (Oh the humanity!) I have got it to run using the reentrant library (libmysqlclient_r) for MySQL but there doesn't seem to be a similar library for mariadbclient. Is this even on the horizon? Mark -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/reentrant-mariadbclient-on-the-horizon/

2 1

[Maria-discuss] New Question: Question about testing
by AskMonty KB 14 Mar '14

14 Mar '14

Hello, A new question has been asked in "MariaDB FAQ" by openiduser40: -------------------------------- I'd like to run the test suite on MariaDB-5 + MariaDB-10 both. https://mariadb.com/kb/en/mysql-test-overview gives some information + fails to give enough. Suggest docs add a full example. Something like this... 1) create a database net1# mysql_create_database --dbname=mariadb_test --dbuser=mariadb --dbpass=mariadb /usr/bin/mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'CREATE DATABASE mariadb_test CHARACTER SET utf8 COLLATE utf8_general_ci' /usr/bin/mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'GRANT ALL PRIVILEGES ON mariadb_test.* to 'mariadb@localhost' IDENTIFIED BY "mariadb"; FLUSH PRIVILEGES;' 2) run a test The reason I ask about this is every test I run fails. lsof shows my socket is /var/run/mysqld/mysqld.sock + here are the failures. mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'SHOW DATABASES' | grep mariadb_test shows my database exists. These tests fail to connect to database... net1# mysqltest --verbose --protocol=socket --socket=/var/run/mysqld/mysqld.sock --database=name=mariadb_test --user=mariadb --password=mariadb mysqltest: Logging to ''. mysqltest: Results saved in ''. mysqltest: Connecting to server (null):3306 (socket /var/run/mysqld/mysqld.sock) as 'mariadb', connection 'default', attempt 0 ... mysqltest: Could not open connection 'default': 1044 Access denied for user 'mariadb'@'localhost' to database 'name=mariadb_test' not ok net1# mysqltest --verbose --host=localhost --database=name=mariadb_test --user=mariadb --password=mariadb mysqltest: Logging to ''. mysqltest: Results saved in ''. mysqltest: Connecting to server localhost:3306 (socket /var/run/mysqld/mysqld.sock) as 'mariadb', connection 'default', attempt 0 ... mysqltest: Could not open connection 'default': 1044 Access denied for user 'mariadb'@'localhost' to database 'name=mariadb_test' not ok net1# /usr/bin/mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'SELECT db,user,host FROM mysql.db WHERE db="mariadb_test"' +--------------+---------+-----------+ | db | user | host | +--------------+---------+-----------+ | mariadb_test | mariadb | localhost | +--------------+---------+-----------+ Obviously I'm missing something simple + having a complete example would help. Please update this question with all steps required to run mysqltest. Thanks. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/question-about-testing/

1 0

[Maria-discuss] New Question: JSON error
by AskMonty KB 14 Mar '14

14 Mar '14

Hello, A new question has been asked in "MariaDB community" by miroigov: -------------------------------- Hello, I installed MariaDB Manager on CentOS 6.5 and when i open in browser http://domain.com:8080/MariaDBManager/ it starts loading and then displays error : API did not return JSON for: GET http://localhost/consoleAPI/api/user HTTP 500 - Errors: HTTP/1.1 500 Internal Server Error - The API is unable to function because PHP JSON functions are not available I do not have experience with Tomcat and have no idea how to set json for php. I have php 5 install and json is working fine with default config /etc/php.ini -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/json-error/

1 0

[Maria-discuss] New Question: Permanent link to download last version of MariaDB
by AskMonty KB 12 Mar '14

12 Mar '14

Hello, A new question has been asked in "MariaDB FAQ" by francocorbelli: -------------------------------- I suggest to create permanent link to last version of a given series. Something like this https://downloads.mariadb.org/mariadb-5.5/mariadb-current-winx64.msi With best regards for a great project. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/permanent-link-to-download-last-version-of-mariadb/

1 0

[Maria-discuss] New Question: creating pivot table fails
by AskMonty KB 12 Mar '14

12 Mar '14

Hello, A new question has been asked in "CONNECT Table Types" by nobswolf: -------------------------------- I tried to create a pivot table based on an existing table "test1" and get an error. I am logged in and I can use "test1", so this error makes no sense to me. What I am doing wrong? Any hints? MariaDB [nav]> create table xsort engine=connect table_type=pivot tabname=test1; ERROR 1105 (HY000): (1045) Access denied for user 'root'@'localhost' (using password: NO) MariaDB [nav]> -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/creating-pivot-table-fails/

1 0

[Maria-discuss] postfixadmin and mariadb, want to add support for user 'groups'
by Tanstaafl 12 Mar '14

12 Mar '14

Hello all, We have a postfixadmin+mariadb sql database we have been using for many, many years (well, only recently migrated from mysql to mariadb, and it was totally transparent, so thanks for that!). This system is rock solid, and we have no desire to change it. We are in the process of setting up SOGo groupware, amd have run into a stumbling block. Not a show stopper, but it definitely put a heavy burden on me, as the SysAdmin. SOGo can Active Directory just fine for testing Group Memberships for purposes of applying ACLs (for shared calendars, contacts, etc)... We intentionally do not use SSO - we enforce very strong email passwords, but allow much weaker AD computer passwords - so email AUTH happens with our SQL DB. The problem is, SOGo does not have support for using 'Groups' for ACLs when using SQL for the AUTH backend. It also does not (yet) have support for different AUTH and USER DB backends. So, as things stand now, I'm going to have to manually add every single individual userid to every single resource they will need to have access too, rather than just doing this with groups. So, my first questions is, has anyone every come up with a decent schema that provides for managing user groups in the same way as AD groups that scales reasonably well? I'm very dangerous when it comes to this stuff, so can't even attempt this myself, but I have some options available to help get this done, especially if I can get some help/advice with getting started. One thing I do know is the SOGo guy had to create a 'View' to use, so whatever we end up using will have to work inside a View (probably displaying my ignorance to the world with that comment - is pretty much everything in an SQL DB compatible with 'Views'?)... I'd dearly appreciate any help anyone is willing to give... Thanks, Charles

3 5