Installing MySQL

[idata]

Hello all,

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.

Thank you!

[idata]

Hi,

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/LinuxYou 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/allsrc/gz edison http://repo.opkg.net/edison/repo/edison http://repo.opkg.net/edison/repo/edisonsrc/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/allsrc/gz edison-iotkit http://iotdk.intel.com/repos/3.0/iotdk/edison http://iotdk.intel.com/repos/3.0/iotdk/edisonsrc/gz core2-32-iotkit http://iotdk.intel.com/repos/3.0/iotdk/core2-32 http://iotdk.intel.com/repos/3.0/iotdk/core2-32src 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.

Kind regards,

Charlie

[idata]

Hi Charlie,

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'.

Collected errors:

* opkg_install_cmd: Cannot install package mariadb.

Any more ideas?

-Daniel

[AT9]

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.

[idata]

Contents of base-feeds.conf:

src all http://repo.opkg.net/edison/repo/all

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

src iotkit http://iotdk.intel.com/repos/3.0/intelgalactic/opkg/i586

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

Downloading http://repo.opkg.net/edison/repo/all/Packages.

Updated list of available packages in /var/lib/opkg/all.

Downloading http://repo.opkg.net/edison/repo/edison/Packages.

Updated list of available packages in /var/lib/opkg/edison.

Downloading http://repo.opkg.net/edison/repo/core2-32/Packages.

Updated list of available packages in /var/lib/opkg/core2-32.

Downloading http://iotdk.intel.com/repos/3.0/iotdk/all/Packages.

Updated list of available packages in /var/lib/opkg/all-iotkit.

Downloading http://iotdk.intel.com/repos/3.0/iotdk/edison/Packages.

Updated list of available packages in /var/lib/opkg/edison-iotkit.

Downloading http://iotdk.intel.com/repos/3.0/iotdk/core2-32/Packages.

Updated list of available packages in /var/lib/opkg/core2-32-iotkit.

Downloading http://iotdk.intel.com/repos/3.0/intelgalactic/opkg/i586//Packages.

Updated list of available packages in /var/lib/opkg/iotkit.

Thank you again for your help!

[AT9]

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

[idata]

Hi Daniel,

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.Regards,Charlie