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.
- I followed Alex T's tutorial and updated my package repo. Based on some forum posts, I've seen that some people have had success running opkg install mariadb, but my Edison does not find that package.
- I tried installing MariaDB and Percona by compiling from source, but my Edison's root directory is not large enough to fit them, even though I'm running a clean install.
- I tried installing FireBirdSQL but I get a bunch of errors that I can't figure out, including one missing dependency that I also can't seem to find (tommath).
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.