Smatool adventures on Synology DSM 5.0

79 views
Skip to first unread message

Koen Roggemans

unread,
Aug 16, 2014, 2:26:13 PM8/16/14
to sma-bl...@googlegroups.com
As stated in a previous post, the upgrade to MariaDB made my system stop working. The reason is a missing libmysqlclient.so.15

I solved it by removing MariaDB and returning back to MySQL5

ipkg update 
ipkg install mysql 

set mysql root password
/opt/etc/init.d/S70mysqld stop 
/opt/bin/mysqld_safe --skip-grant-tables 

open a new terminal window
/opt/bin/mysql -u root 
mysql> use mysql; 
mysql> update user set Password=PASSWORD('newpassword') where 
User='root'; 
mysql> exit 
/opt/etc/init.d/S70mysqld stop 
rm -f ~/.mysql_history 
/opt/etc/init.d/S70mysqld start 

Then the usual installation sequence for smatool.

Mario Schmidt

unread,
Aug 16, 2014, 2:31:59 PM8/16/14
to sma-bluetooth
Hi,
i solved it by adding the following to my startup script:

if [ ! -L /tmp/mysql.sock ]; then
  ln -s /run/mysqld/mysqld.sock /tmp/mysql.sock
fi

Now the old client finds the socket and connects to the new DB on DSM5. The mysql Library is in /opt for my smatool setup.

Greetings

Mario


--
You received this message because you are subscribed to the Google Groups "sma-bluetooth" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sma-bluetoot...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--
It's never to late to have a good childhood.

Koen Roggemans

unread,
Aug 20, 2014, 1:48:50 PM8/20/14
to sma-bl...@googlegroups.com
I stored my compiled script smatool in /root and forgot to make a backup of it when upgrading to DSM 5.0. The root folder was empty after the upgrade, so I had to recompile. That didn't work with MariaDB
Reply all
Reply to author
Forward
0 new messages