epg2vdr - error locale mysqlepglv.so

vinkler · May 30, 2015 at 10:27 AM

My locale:

Display Spoiler

Code

vinkler@desktop:/$ locale
LANG=pl_PL.UTF-8
LANGUAGE=pl_PL
LC_CTYPE="pl_PL.UTF-8"
LC_NUMERIC="pl_PL.UTF-8"
LC_TIME="pl_PL.UTF-8"
LC_COLLATE="pl_PL.UTF-8"
LC_MONETARY="pl_PL.UTF-8"
LC_MESSAGES="pl_PL.UTF-8"
LC_PAPER="pl_PL.UTF-8"
LC_NAME="pl_PL.UTF-8"
LC_ADDRESS="pl_PL.UTF-8"
LC_TELEPHONE="pl_PL.UTF-8"
LC_MEASUREMENT="pl_PL.UTF-8"
LC_IDENTIFICATION="pl_PL.UTF-8"
LC_ALL=

Display More

Install vdr2epg:

Code

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

Display More

How to solve the problem?

CKone · May 30, 2015 at 1:18 PM

afaik this is a workaround because this function is not native UTF8 but converted.

Please take a look at:

Code

if (!ws->iconv_init)
    {
        if ((ws->ic = iconv_open("ISO8859-15", "UTF-8")) == (iconv_t)-1)
        {
           print("%s", "failed to initialize iconv '%m'");
           return 0;
        }


        ws->iconv_init = 1;
    }

Display More

in epgd/epglv/src/epglvbase.c

Christian

vinkler · May 30, 2015 at 2:42 PM

Hi,
So, how to install the plugin epg2vdr?
This error generates another error when running:

Code

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!

Display More

I read this thread, but my locale is pl_PL.utf-8

epg2vdr - error locale mysqlepglv.so

Participate now!

Users Viewing This Thread