- discuss - lists.mariadb.org

[Maria-discuss] help - i'm not finding one sql function
by Roberto Spadim 20 Mar '14

20 Mar '14

hi guys, i'm not finding a function to return how many character i have, for example: "banana" i want a function that return 2 "n" characters, example: substr_count("banana","n") => 2 sorry it a begginners question, but i didn't found it in mysql/mariadb manual -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle

7 21

[Maria-discuss] New Question: mariaDB_client-1-0-0_win64 in Visual Studio 2012
by AskMonty KB 18 Mar '14

18 Mar '14

Hello, A new question has been asked in "Client libraries" by olivierf77: -------------------------------- Hello, I have installed MariaDB 5.6 , and its works perfectly. Thanks to all the MariaDB team. I also installed (by *.msi) mariaDB_client-1-0-0_win64 in c:\L\SQLClient\mariadb_client-1.0.0-win64\ + added paths as follow in project properties: INCLUDE DIRECTORIES = C:\L\SQLClient\mariadb_client-1.0.0-win64\mariadbclient\include;$(IncludePath) LIBRARY DIRECTORIES = C:\L\SQLClient\mariadb_client-1.0.0-win64\lib;$(LibraryPath) However, when trying to use it even with the most simple programs, compilation is OK, **BUT** linking fails: --- my minimal c++ program (c++ console under Visual Studio 2012 --- #include "stdafx.h" #include <mysql.h> int _tmain(int argc, _TCHAR* argv[]) { MYSQL *my; my = mysql_init(NULL); } -- end of program -- BUILDING PROJETS -> following error msg: 1>------ Build started: Project: cppconMariaDB02, Configuration: Debug Win32 ------ 1>cppconMariaDB02.obj : error LNK2019: unresolved external symbol _mysql_init@4 referenced in function _wmain 1>c:\users\olivier\documents\visual studio 2012\Projects\cppconMariaDB02\Debug\cppconMariaDB02.exe : fatal error LNK1120: 1 unresolved externals ========== Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped ========== Every mysql function gets the same "unresolved external symbol" error, even though I believe I did specify the path to the directory containing the 3 files "libmariadb.dll, libmariadb.lib & mariadbclient.lib", which I even tried (for testing purposes only, and with no better results) to copy into windows/system32. I have spent a lot of time on this issue, with no success. I did see that this question was asked several times on several programming sites, but it never gets any answer. As additional info, here is my directory for the c mariadb_client client: Directory of c:\L\SQLClient\mariadb_client-1.0.0-win64 <DIR> .. docs examples html lib libmysql mariadbclient mysql_config unittest zlib I hope that the above information (and question) is clear and complete, but not over verbose, and that someone in your team will have a few seconds to answer my query, even though the answer may be trivial (at least for him). And once again, many thanks for a very nice product. Sincerely yours Olivier, Paris, France PS And hello to Michael 'Monty' Widenus, whom I met in Paris six months ago. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb_client-1-0-0_win64-in-visual-studio-2012/

1 0

[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 18 Mar '14

18 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