MariaDB package

[skelosParticipant]

Hello,
where I can fine MariaDB package for Cubox-i 4×4 architecture?

Thank you.

[skelosParticipant]

I get Develop image last Christmas… but I need mariadb package. Where I can download it? it appears not existing in http://download.geexbox.org/snapshots/geexbox-kodi-imx6-cuboxi/latest/binaries.cuboxi/packages/

thank you.

[Warped RudiModerator]

Missing in action… Try this for now.

[skelosParticipant]

?

root@geexbox:~# opkg update
Downloading http://download.geexbox.org/snapshots/geexbox-kodi-imx6-cuboxi/lates
t/binaries.cuboxi/packages/Packages.
Updated list of available packages in /var/lib/opkg/snapshots.
root@geexbox:~# opkg install mysql-server_5.5.43-1_armv7.opk
Installing mysql-server (5.5.43-1) on root.
Collected errors:
* opkg_install_pkg: Package mysql-server md5sum mismatch. Either the opkg or th
e package index are corrupt. Try ‘opkg update’.
* opkg_install_cmd: Cannot install package mysql-server.

I wrong something?

[Warped RudiModerator]

I just downloaded mysql-server_5.5.43-1_armv7.opk to my PC and the md5sum is fine (d712cb6734afb29bf7f331e1646246c5). Did you try ‘opkg update / install’ again?

[skelosParticipant]

I did again. Same error but I saw in packages folder there are same packages version.
I suppose they are same and I installed from here.

Try launching many times mysql I needed to download and install other additional libraries :

root@geexbox:~# mysql
mysql: error while loading shared libraries: libedit.so.0: cannot open shared object file: No such file or directory
root@geexbox:~# wget http://download.geexbox.org/SolidRun/geexbox-kodi-imx6-cuboxi/packages/libmysqlclient_5.5.43-1_armv7.opk
Connecting to download.geexbox.org (67.203.12.194:80)
libmysqlclient_5.5.4 100% |*******************************|   743k  0:00:00 ETA
root@geexbox:~# opkg install libmysqlclient_5.5.43-1_armv7.opk
Installing libmysqlclient (5.5.43-1) on root.
Configuring libmysqlclient.
root@geexbox:~# mysql
mysql: error while loading shared libraries: libedit.so.0: cannot open shared ob
ject file: No such file or directory
root@geexbox:~# wget http://download.geexbox.org/SolidRun/geexbox-kodi-imx6-cuboxi/packages/libedit_20150325-3.1-1_armv7.opk
Connecting to download.geexbox.org (67.203.12.194:80)
libedit_20150325-3.1 100% |*******************************| 66528   0:00:00 ETA
root@geexbox:~# opkg install libedit_20150325-3.1-1_armv7.opk
Installing libedit (20150325-3.1-1) on root.
Configuring libedit.
root@geexbox:~# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run
/mysqld/mysqld.sock' (2)

in this point I stopped. I don’t know what I can do…

I tried also to start mysqld :

root@geexbox:/var/lib# mysqld
mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
root@geexbox:/var/lib# opkg install libaio
Unknown package 'libaio'.
Collected errors:
 * opkg_install_cmd: Cannot install package libaio.

So, I definitively stopped…

[Warped RudiModerator]

Arrg! Use this libaio until we fix the dependencies…

BTW, http://download.geexbox.org/SolidRun/geexbox-kodi-imx6-cuboxi symlinks to the same files as http://download.geexbox.org/snapshots/geexbox-kodi-imx6-cuboxi/latest/binaries.cuboxi . The first link is for SolidRun’s Ignition installer.

Edit: After you have installed libaio, please remove the file /etc/mysql/conf.d/root-pass.cnf and reboot. Also run mysql_upgrade to get rid of the error messages related to ‘performance_table’.

[skelosParticipant]

Thank you Rudi,

I followed step by step your instructions but it appears not been working…

root@geexbox /srv/www/htdocs/webconsole$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
root@geexbox /srv/www/htdocs/webconsole$ mysqld
160216  8:24:55 [Note] mysqld (mysqld 5.5.43-MariaDB) starting as process 3660 ...
160216  8:24:55 [Warning] An old style --language or -lc-message-dir value with language specific part detected: /usr/share/mysql/english/
160216  8:24:55 [Warning] Use --lc-messages-dir without language specific part instead.
160216  8:24:55 InnoDB: The InnoDB memory heap is disabled
160216  8:24:55 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
160216  8:24:55 InnoDB: Compressed tables use zlib 1.2.8
160216  8:24:55 InnoDB: Using Linux native AIO
160216  8:24:55 InnoDB: Initializing buffer pool, size = 128.0M
160216  8:24:55 InnoDB: Completed initialization of buffer pool
160216  8:24:55 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 50037
160216  8:24:55  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1597945
160216  8:24:55  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 8
4 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
160216  8:24:56  InnoDB: Waiting for the background threads to start
160216  8:24:57 Percona XtraDB (http://www.percona.com) 5.5.42-MariaDB-37.1 started; log sequence number 1597945
160216  8:24:57 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
160216  8:24:57 [Note] Server socket created on IP: '127.0.0.1'.
160216  8:24:57 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
root@geexbox /srv/www/htdocs/webconsole$ mysql_upgrade
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
FATAL ERROR: Upgrade failed
root@geexbox /srv/www/htdocs/webconsole$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2

It appears mysql doesn’t start cause ERROR 2002 (HY000) error. I will search it online for know if I miss a setup value…

[Warped RudiModerator]

There were some problems with the initial setup/bootstrap of MariaDB. I think the easiest way to get a working copy is:

1.) Use ‘opkg’ to remove the packages mysql-server and mysql-client
2.) Manually delete all mysql directories (/etc/mysql /usr/lib/mysql /usr/share/mysql)
3.) Download the updated mysql-* packages from here
4.) Install new mysql-client and mysql-server packages (in that order)
5.) After reboot, the server should be started automatically (check with ‘systemctl status mysqld -l’)
and ‘mysql’ should be able to connect without asking for a password.

This, of course, is a fresh install killing all existing data.

[skelosParticipant]

Wonterfull!
it works!

root@geexbox:~# systemctl status mysqld -l
    mysqld.service - MySQL database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor pres
et: enabled)
   Active: active (running) since Wed 2016-02-17 13:42:22 GMT; 15min ago
 Main PID: 915 (mysqld_safe)
   CGroup: /system.slice/mysqld.service
                Ç 915 /bin/sh /usr/bin/mysqld_safe
                Ç1319 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql -
-plugin-dir=/usr/lib/mysql/plugin --user=root --pid-file=/var/run/mysqld/mysqld.
pid --socket=/var/run/mysqld/mysqld.sock --port=3306
                Ç1320 logger -t mysqld -p daemon.error
Feb 17 13:42:28 geexbox mysqld[1320]: InnoDB: Doublewrite buffer created
Feb 17 13:42:29 geexbox mysqld[1320]: InnoDB: 127 rollback segment(s) active.
Feb 17 13:42:29 geexbox mysqld[1320]: InnoDB: Creating foreign key constraint sy
stem tables
Feb 17 13:42:29 geexbox mysqld[1320]: InnoDB: Foreign key constraint system tabl
es created
Feb 17 13:42:29 geexbox mysqld[1320]: 160217 13:42:29  InnoDB: Waiting for the b
ackground threads to start
Feb 17 13:42:31 geexbox mysqld[1320]: 160217 13:42:31 Percona XtraDB (http://www
.percona.com) 5.5.42-MariaDB-37.1 started; log sequence number 0
Feb 17 13:42:31 geexbox mysqld[1320]: 160217 13:42:31 [Note] Server socket creat
ed on IP: '127.0.0.1'.
Feb 17 13:42:31 geexbox mysqld[1320]: 160217 13:42:31 [Note] Event Scheduler: Lo
aded 0 events
Feb 17 13:42:31 geexbox mysqld[1320]: 160217 13:42:31 [Note] /usr/sbin/mysqld: r
eady for connections.
Feb 17 13:42:31 geexbox mysqld[1320]: Version: '5.5.43-MariaDB'  socket: '/var/r
un/mysqld/mysqld.sock'  port: 3306  Source distribution
root@geexbox:~# mysql
Welcome to the MariaDB monitor.  Commands end with ; or g.
Your MariaDB connection id is 2
Server version: 5.5.43-MariaDB Source distribution
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
MariaDB [(none)]> exit
Bye
root@geexbox:~#

[Warped RudiModerator]

Good. There will be an update to 5.5.48 in two days or so…

[skelosParticipant]

Just form ask… I installed phpMyadmin forma interact with mariaDB but login doesnt work.. Il dure cedential are OK because i tested IT from commamd line.

[Warped RudiModerator]

Tried it and it doesn’t work here either. No idea why, but I have the feeling that it’s more related to php or phpmyadmin itself than to mariadb. Maybe @tomlohave can have a look when he returns from vacation.

[skelosParticipant]

I googled a little bit andò found thishttp://serverfault.com/questions/583797/cant-login-to-remote-mariadb-server-with-phpmyadmin-but-works-in-shell

Do you think may Be the same for us?: This solution is applyable?

[skelosParticipant]

I think to found solution:In config.inc.php
only changed
$cfg[‘Servers’][$i][‘host’] = ‘localhost’;
in
$cfg[‘Servers’][$i][‘host’] = ‘127.0.0.1’;

Please let me know if this work also for you.

[Author]

Posts