Community
cancel
Showing results for 
Search instead for 
Did you mean: 
idata
Community Manager
1,414 Views

Installing MySQL

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!

Tags (1)
0 Kudos
6 Replies
idata
Community Manager
75 Views

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

Kind regards,

 

Charlie

 

idata
Community Manager
75 Views

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
Honored Contributor II
75 Views

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
Community Manager
75 Views

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
Honored Contributor II
75 Views

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
Community Manager
75 Views

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
Reply