[luatex] LuaTeX and MySQL

[Ulrich Voosholz]

Hello erverybody!

I want to produce reports with LuaLaTex und MySql. But neither LuaLaTeX  
nor LuaTeX are able to load the required module "luasql.mysql" on my  
system. Lua itself does:

   ulvo at knox:~$ lua -e 'require "luasql.mysql"'
   ulvo at knox:~$

The connection to mysql works without problems. The following code

   \directlua{require("luasql.mysql")}
   \end

returns:

   This is LuaTeX, Version beta-0.60.2-2010071218 (TeX Live 2010) (rev 3736)
    restricted \write18 enabled.
   (./plainluatex.tex
   ! LuaTeX error <\directlua >:1: module 'luasql.mysql' not found:
	no field package.preload['luasql.mysql']
	[kpse lua searcher] file not found: 'luasql.mysql'
	[kpse C searcher] file not found: 'luasql.mysql'
	[kpse All-in-one searcher] file not found: 'luasql'
   stack traceback:
	[C]: in function 'require'
	<\directlua >:1: in main chunk.
   l.1 \directlua{require("luasql.mysql")}


I have already searched but cannot get a hint how to handle this. I have  
tried
the following code:

   \directlua{print(package.cpath)}
   \end

which gave

    ./plainluatex.tex./?.so;/usr/local/lib/lua/5.1/?.so;/usr/local/lib/lua/5.1/loadall.so

   ulvo at knox:~$ lua -e 'print(package.cpath)'

returned

    ./?.so;/usr/local/lib/lua/5.1/?.so;/usr/lib/lua/5.1/?.so;/usr/local/lib/lua/5.1/loadall.so

Therefore I tried

    \directlua{package.cpath="./plainluatex.tex./?.so;/usr/local/lib/lua/5.1/?.so;/usr/lib/lua/5.1/?.so;/usr/local/lib/lua/5.1/loadall.so"
    require "luasql.mysql"}
    \end

but the error was the same as shown above.

Does anybody have any idea or workaround?

My system is Ubuntu 10.4 LTS with Texlive 2010.

Thank you

Ulrich Voosholz

==============================
www: www.tanztraeume.de