Posts by vinkler

sudo /usr/local/bin/epgd -n -p /usr/local/lib/epgd/plugins -t
14:34:54,329  Set locale to 'pl_PL.UTF-8'
14:34:54,329  detected UTF-8
14:34:54,329  Loading uuid from '/etc/epgd/uuid' succeeded [71D3CEA7-6940-47D2-AE4B-BA29E31830FF]
14:34:54,329  Loading plugin: /usr/local/lib/epgd/plugins/libepgd-epgdata.so
14:34:54,330  Read 26 option from /etc/epgd/epgd.conf
14:34:54,333  Info: Stylesheet '/etc/epgd/epgdata-utf-8.xsl' loaded
14:34:54,334  SQL client character now 'utf8'
14:34:54,373  State now 'init'
14:34:54,415  SQL-Error in 'select epglv('123', '123')' - Can't initialize function 'epglv'; EPGLV() failed to change locale (1123) 
14:34:54,415  SQL-Error in 'select epglvr('123', '123')' - Can't initialize function 'epglvr'; EPGLV() failed to change locale (1123) 
14:34:54,415  Error: Missing functions epglv/epglvr, please install first!

cd /usr/local/src$
sudo git clone git://projects.vdr-developer.org/vdr-epg-daemon.git
sudo ln -s vdr-plugin-tvguide epgd
cd epgd/epglv/
sudo make && sudo make install


mysql -u root -p
mysql> DROP FUNCTION IF EXISTS epglv;
Query OK, 0 rows affected, 1 warning (0,00 sec)


mysql> DROP FUNCTION IF EXISTS epglvr;
Query OK, 0 rows affected, 1 warning (0,00 sec)


mysql> CREATE FUNCTION epglv RETURNS INT SONAME 'mysqlepglv.so';
Query OK, 0 rows affected (0,00 sec)


mysql> CREATE FUNCTION epglvr RETURNS INT SONAME 'mysqlepglv.so';
Query OK, 0 rows affected (0,00 sec)


mysql> SELECT * FROM mysql.func;
+--------+-----+---------------+----------+
| name   | ret | dl            | type     |
+--------+-----+---------------+----------+
| epglv  |   2 | mysqlepglv.so | function |
| epglvr |   2 | mysqlepglv.so | function |
+--------+-----+---------------+----------+
2 rows in set (0,00 sec)


mysql> select epglv('123' , '123');
ERROR 1123 (HY000): Can't initialize function 'epglv'; EPGLV() failed to change locale


mysql> select epglv('€uro', 'Euro');
ERROR 1123 (HY000): Can't initialize function 'epglv'; EPGLV() failed to change locale