I am relatively new to Linux and to Edison, so please forgive me if I sound silly.
For a project I'm working on, I need to configure an Edison as a MySQL server. Unfortunately, it doesn't look like SQLite will work since, for the purposes of my project, I need a server that can support concurrency well. I have considered MariaDB, Percona, and FirebirdSQL, and have run into the following problems that I was hoping someone could help me out with.
If anyone could point me in the right direction, either by advising on one of the above issues or pointing me in a new direction entirely, I would greatly appreciate it.
I was able to install mariadb by doing the following:
Using the latest release, uname -a: Linux edison 3.10.17-poky-edison+ # 2 SMP PREEMPT Mon Mar 14 15:26:16 PDT 2016 i686 GNU/Linux
You should have the following content in the /etc/opkg/base-feeds.conf and /etc/opkg/iotkit.conf:
root@edison:~# cat /etc/opkg/base-feeds.conf
src/gz all http://repo.opkg.net/edison/repo/all http://repo.opkg.net/edison/repo/all
src/gz edison http://repo.opkg.net/edison/repo/edison http://repo.opkg.net/edison/repo/edison
src/gz core2-32 http://repo.opkg.net/edison/repo/core2-32 http://repo.opkg.net/edison/repo/core2-32
root@edison:~# cat /etc/opkg/iotkit.conf
src/gz all-iotkit http://iotdk.intel.com/repos/3.0/iotdk/all http://iotdk.intel.com/repos/3.0/iotdk/all
src/gz edison-iotkit http://iotdk.intel.com/repos/3.0/iotdk/edison http://iotdk.intel.com/repos/3.0/iotdk/edison
src/gz core2-32-iotkit http://iotdk.intel.com/repos/3.0/iotdk/core2-32 http://iotdk.intel.com/repos/3.0/iotdk/core2-32
src iotkit http://iotdk.intel.com/repos/3.0/intelgalactic/opkg/i586/ http://iotdk.intel.com/repos/3.0/intelgalactic/opkg/i586/
root@edison:~# opkg update
root@edison:~# opkg install mariadb
Let me know if by doing this you are able to install it too.
Thanks so much for your help. I followed your steps and unfortunately I'm still not able to install it.
When I try to install, I get the same error as always:
opkg install mariadb
Unknown package 'mariadb'.
* opkg_install_cmd: Cannot install package mariadb.
Any more ideas?
As a quick and dirty solution you can download the package (and dependencies... yes, that might be inconvenient) manually, e.g. the main mariadb package is here: http://repo.opkg.net/edison/repo/core2-32/mariadb_5.5.43-r0_core2-32.ipk http://repo.opkg.net/edison/repo/core2-32/mariadb_5.5.43-r0_core2-32.ipk
It looks like you either don't have repos configured properly or you have networking problems - please post contents of those files Charlie has shown + full output of "opkg update" command.
Contents of base-feeds.conf:
src edison http://repo.opkg.net/edison/repo/edison
src core2-32 http://repo.opkg.net/edison/repo/core2-32
Contents of iotkit.conf:
src all-iotkit http://iotdk.intel.com/repos/3.0/iotdk/all
src edison-iotkit http://iotdk.intel.com/repos/3.0/iotdk/edison
src core2-32-iotkit http://iotdk.intel.com/repos/3.0/iotdk/core2-32
I changed all occurrences of "src/gz" to "src" according to another one of your posts after I got the "invalid gzip magic" error.
The output of opkg update is:
root@edison:~# opkg update
Updated list of available packages in /var/lib/opkg/all.
Updated list of available packages in /var/lib/opkg/edison.
Updated list of available packages in /var/lib/opkg/core2-32.
Updated list of available packages in /var/lib/opkg/all-iotkit.
Updated list of available packages in /var/lib/opkg/edison-iotkit.
Updated list of available packages in /var/lib/opkg/core2-32-iotkit.
Updated list of available packages in /var/lib/opkg/iotkit.
Thank you again for your help!
Okay, that looks pretty much ok to me, so now if you run "opkg list |grep mariadb", what do you get?
On my board I get this and that means it should be able to find and install that package just fine:
root@edison1:~# opkg list |grep mariadb
mariadb - 5.5.43-r0 - A robust, scalable, and reliable SQL server A robust, scalable, and
mariadb-client - 5.5.43-r0 - A robust, scalable, and reliable SQL server A robust, scalable, and
mariadb-dbg - 5.5.43-r0 - A robust, scalable, and reliable SQL server - Debugging files A robust,
mariadb-leftovers - 5.5.43-r0 - A robust, scalable, and reliable SQL server unpackaged and probably
unneeded files for mariadb
mariadb-server - 5.5.43-r0 - A robust, scalable, and reliable SQL server A robust, scalable, and
I would like to know if you try running the command suggested for AlexT above (opkg list |grep mariadb), let us know if you have been able to install mariadb.