August 2013 - discuss - lists.mariadb.org

[Maria-discuss] New Question: MariaDB on AIX: am I the first to try to compile?
by AskMonty KB 26 Aug '13

26 Aug '13

Hello, A new question has been asked in "Development" by mamfelt: -------------------------------- Since the current owner of mysql is no longer interested in creating/distributing for and IBM platforms - and, as a joomla user I am accustomed to using mysql as backend I am hoping to package and use mariadb on AIX. So, anyone else who has any (successful) experience with compiling mariadb for/on AIX? If yes, what OS level did you use, and compiler? I am trying with OS 5.3TL7 and AIX 6.1TL7. I will prefer to have it work on AIX 5.3 as that should support AIX 6.1 - but at this point I am just looking for a better starting point. Thanks for reply/comments! -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/mariadb-on-aix-am-i-the-first-to-try-to-compile/

1 0

[Maria-discuss] Idea about a socket betwwen plugins and mysql clients
by Roberto Spadim 26 Aug '13

26 Aug '13

Hi guys, i put a very big and well explained plugin interface for client-plugin comunication using mysql protocol could anyone give comments, ideas or talking if it should be done / or at least some points why it shouldn't? the mdev is at: https://mariadb.atlassian.net/browse/MDEV-4921 thanks! -- Roberto Spadim

1 0

[Maria-discuss] New Question: Hibernate Reverse Engineering wizard with MariaDB
by AskMonty KB 22 Aug '13

22 Aug '13

Hello, A new question has been asked in "MariaDB Documentation" by JohnD: -------------------------------- (Sorry, couldn't find a good place for this query - perhaps there ought to be a folder "MariaDB and ORMs"?) I'm trying to use the Hibernate Reverse Engineering wizard with MariaDB. It's just a very simple example, but I am stuck. I don't see any errors, but it doesn't work as described. Here's what I've got so far: * Windows 7 x64, Eclipse Juno, MariaDB v5.5.3, Hibernate v4.2.3 * I've got an example with Hibernate running using annotations and the same instance of MariaDB, no problem * Now I want to create the classes from the tables, so I'm trying to use the reverse engineering wizard. * I've set up a simple DB and a couple of tables * I've set up a hibernate.cfg.xml file using the same values as my working annotation example * Now I use the wizard (in Eclipse) to "New/Hibernate Reverse Engineering File (reveng.xml)" ** First page ok, second page "Configure Table filters" is where I'm stuck ** I select the correct Console configuration (generated as part of creating the config file) and then press the "Refresh" button ** At this point I should see my two tables in the "Database schema:" column. But it's empty. ** I briefly see "Pending..." - then nothing. ** I can't see any errors. So, how to move forwards? Can I turn on some logging? Where is the error? What logs to check? The Eclipse console window shows a bunch of stuff, all info, no errors and the last three lines are like this: * 2013-08-22 11:34:38,189 DEBUG Worker-33 org.hibernate.connection.DriverManagerConnectionProvider - opening new JDBC connection * 2013-08-22 11:34:38,198 DEBUG Worker-33 org.hibernate.connection.DriverManagerConnectionProvider - created connection to: jdbc:mysql://localhost:3306/omthibernate, Isolation Level: 4 * 2013-08-22 11:34:38,199 INFO Worker-33 org.hibernate.connection.DriverManagerConnectionProvider - cleaning up connection pool: jdbc:mysql://localhost:3306/omthibernate In case it helps, here is the hibernate config (I've tried a lot of variations): {{{ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory name="xxx"> <property name="hibernate.connection.driver_class">org.mariadb.jdbc.Driver</property> <property name="hibernate.connection.password">password</property> <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/omthibernate</property> <property name="hibernate.connection.username">user</property> <property name="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> </session-factory> </hibernate-configuration> }}} -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/hibernate-reverse-engineering-wizard-with-mariadb/

1 0

[Maria-discuss] More secure Kill command
by Roberto Spadim 21 Aug '13

21 Aug '13

hi guys, i hit a problem in this exact second... some programs are running and i want to kill only one big query well i executed kill 17143 ok.. but when i execute this command, the query was done, and starting a second query... in other words... i killed the wrong query could we add a hash information to kill, to make it more secure and precise? for example... kill 17143 md5 "123456789......." where md5 = id + start time of query + others informations to make it relative unique maybe it exists and i don't know... any other idea how to solve this? thanks -- Roberto Spadim

5 19

[Maria-discuss] NoSQL at mysql client
by Roberto Spadim 19 Aug '13

19 Aug '13

Hi guys, i was reading some time ago about memcache (i use it for a long time ~5years or more) and the handler socket plugin Why we don't implement it at mariadb client? instead of a second library to add nosql, why not implement a built in lib? for example... (pseudo functions...) mysql_connect ... (connect to database and have permission handling...) mysql_select_db ... select the schema being used mysql_query ... execute a query command (SQL QUERIES) mysql_fetch ... get a row mysql_num_rows .. get number of rows now the nosql... mariadb_handler_socket_openindex( handler socket parameters ) mariadb_handler_socket_query mariadb_handler_socket_fetch mariadb_handler_socket_close mariadb_memcache_get mariadb_memcache_set ... this make mariadb a sql/nonsql database with a single user/permission schema, and a nice language set (SQL, handler socket, memcache, redis, drizzle, hadoop, mongodb or others...) in this case we can use the mysql protocol, but instead of sending a QUERY command, we send a "MARIADB" command, and a new parameter telling what mariadb command it is, this can be used with mysql/mariadb/percona, when used with others database probably the database will report a wrong command message but we can contact mysql to reserve a command id to "others uses", and have compatibility with any mysql fork... but the point is... instead of many connections (3-> mariadb, handler socket write, handler socket read, or 2 -> mariadb, memcached) we have only one 1-> mariadb comments are wellcome, any idea why not implement this instead of many different protocol libs? -- Roberto Spadim

2 4

Re: [Maria-discuss] doubt about aria log files
by Roberto Spadim 18 Aug '13

18 Aug '13

well just to document this thread mail list i found the answer , (thanks federico) https://kb.askmonty.org/en/aria-faq/ aria_log_file_size - *Description:* Limit for Aria transaction log size - *Commandline:* --aria-log-file-size=# - *Scope:* Global - *Dynamic:* Yes - *Data Type:* numeric - *Default Value:* 1073741824

1 0

[Maria-discuss] doubt about aria log files
by Roberto Spadim 17 Aug '13

17 Aug '13

hi guys, i have a very big aria log file how could i change it to don't get sooo big? how could i reduce it size? could i delete it? [adm@agra1 sensors]# ls -l total 383008 drwxrwxrwx 2 mysql mysql 4096 Nov 1 2012 1000_sensors drwxrwxrwx 2 mysql mysql 4096 Nov 1 2012 1000_sensors_log -rw-rw---- 1 mysql mysql 362815488 Ago 17 12:19 aria_log.00000024 -rw-rw---- 1 mysql mysql 52 Ago 17 12:17 aria_log_control -rw-rw---- 1 mysql mysql 18874368 Jun 9 2012 ibdata1 -rw-rw---- 1 mysql mysql 5242880 Jun 9 2012 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 Jun 9 2012 ib_logfile1 -rwxrwxrwx 1 mysql mysql 13 Dez 27 2010 mysql_upgrade_info -rw-rw---- 1 mysql mysql 4 Dez 8 2012 pbxt-lock ... [adm@agra1 sensors]# du -S 26328352 ./1000_sensors_log 1052 ./1000_sensors 388236 . -- Roberto Spadim

1 0

[Maria-discuss] new kind of plugin
by Roberto Spadim 17 Aug '13

17 Aug '13

Hi guys, I was thinking about a new kind of plugin, a field type plugin... i think it's a relative interesting idea... about sintax: ALTER TABLE table ADD field PLUGIN("plugin_name","version","field_type","parameters") NOT NULL/NULL DEFAULT 'something' AUTOINCREMENT, etc.. an example... ALTER TABLE table ADD field PLUGIN("crypt","1","somecrypto","size=255") NOT NULL DEFAULT 'something' internally (to storage engine) this kind of data will be saved as blob (for example), and to client side it will be a blob too when i use: insert into table(field) values ("some text"); and select * from table i will get "some text" but internally (at filesystem) the value is save as a crypto of "some text" --- other idea is compress ADD field PLUGIN("crypt","1","compress","size=255") NOT NULL DEFAULT 'something' internally it will be saved as varchar(255), when i execute insert it will compress the value and when i select it will uncompress the value the parameters for this new field type is: PLUGIN(plugin name, plugin version, plugin field name, parameters) plugin name is the plugin name... plugin version is important to execute alter table, or when using diferent kind of plugin versions we could know what version is being used and execute a automatic alter table for example... plugin field is the type of field in this plugin parameters are parameters for plugin values another idea is a enum with external table... ADD field PLUGIN("external_enum",'1','enum','table=database.table,id=field_id,value=field_value') it will execute a SELECT internally to table "database.table" and return the id/value of that table id is a bigint/int/mediumint/smallint/tinyint value (like enum index) and value is a string value (varchar,char,longtext,text) to storage engine will be used a bigint, for user it will be used as a enum() field ------ thre's more examples with interesting things, like expand opengis, or add others kind of field types, but the main idea is create a plugin interface for field types what you say guys? bye =) -- Roberto Spadim

3 5

[Maria-discuss] MariaDB 10.0.4 Alpha Now Available
by Daniel Bartholomew 16 Aug '13

16 Aug '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.4. This is an Alpha release. It includes new features and bug fixes. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.4 Alpha - Release Notes: https://kb.askmonty.org/en/mariadb-1004-release-notes - Changelog: https://kb.askmonty.org/en/mariadb-1004-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.4 About MariaDB 10.0: https://kb.askmonty.org/en/what-is-mariadb-100 APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf (my.ini on Windows) file! See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to MariaDB, please see our "contributing" and "donations" pages. We also have merchandise available in a cafepress store. - https://kb.askmonty.org/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] PHP 5.3 and mariadb 5.5.32 pam auth problem.
by Rafał Radecki 16 Aug '13

16 Aug '13

Hi All. I have: - one devel application server with php53-mysql-5.3.27-1 MariaDB-compat-5.5.32-1.x86_64 MariaDB-common-5.5.32-1.x86_64 MariaDB-shared-5.5.32-1.x86_64 MariaDB-client-5.5.32-1.x86_64 - one devel database server with MariaDB-compat-5.5.30-1.x86_64 MariaDB-server-5.5.30-1.x86_64 MariaDB-common-5.5.30-1.x86_64 MariaDB-shared-5.5.30-1.x86_64 MariaDB-client-5.5.30-1.x86_64 When I try to make a connection from devel to database server with php mysql_connect function then when I am using: - user with local authentication: connection is ok; - user with pam/ldap authentication I get error "Client does not support authentication protocol requested by server; consider upgrading MariaDB client error 1251" When I use mysql command on application server I can connect to the database server with both users, so only php does not work. Have you got similar issues? Any clues anout how to solve the problem? Best regards, Rafal Radecki.

2 1