this doesnt work either. Do I haven't to install the luasql-mysql module? ...exp/tex/texmf-context/tex/context/base/mkiv/util-lib.lua:246: module 'luasql.mysql' not found: no field package.preload['luasql.mysql'] no file '/usr/local/share/lua/5.2/luasql/mysql.lua' no file '/usr/local/share/lua/5.2/luasql/mysql/init.lua' no file '/usr/local/lib/lua/5.2/luasql/mysql.lua' no file '/usr/local/lib/lua/5.2/luasql/mysql/init.lua' no file './luasql/mysql.lua' no file '/usr/local/lib/lua/5.2/luasql/mysql.so' no file '/usr/local/lib/lua/5.2/loadall.so' no file './luasql/mysql.so' no file '/usr/local/lib/lua/5.2/luasql.so' no file '/usr/local/lib/lua/5.2/loadall.so' no file './luasql.so' stack traceback: [C]: in function 'savedrequire' ...exp/tex/texmf-context/tex/context/base/mkiv/util-lib.lua:246: in function 'require' ...f-context/tex/context/base/mkiv/util-sql-imp-library.lua:74: in main chunk [C]: in function 'savedrequire' ...exp/tex/texmf-context/tex/context/base/mkiv/util-lib.lua:246: in function 'require' ...exp/tex/texmf-context/tex/context/base/mkiv/util-sql.lua:114: in function '__index' ...exp/tex/texmf-context/tex/context/base/mkiv/util-sql.lua:288: in function 'execute' [ctxlua]:19: in main chunk

On 02 Oct 2017, at 09:29, Hans Hagen wrote:

On 10/1/2017 11:47 PM, Michael Eidenbenz wrote:

...

Hello, I'm experimenting with the SQL interface in context. My testfile compiles with: utilities.sql.setmethod("client"), but I don't manage to setup the swiglib method. Following the instruction described in swiglib-mkiv.pdf, I compiled the mysql library for osx, and put it into: context/tex/texmf-osx-64/bin/lib/luatex/lua/swiglib/mysql/core.dylib But I get this error: swiglib > unknown: 'swiglib.mysql.core' my texmf.cnf has the line CLUAINPUTS = .;$SELFAUTOLOC/lib/{$progname,$engine,}/lua// and how about 'library' (using the normal sql library)

Hans

----------------------------------------------------------------- Hans Hagen | PRAGMA ADE Ridderstraat 27 | 8061 GH Hasselt | The Netherlands tel: 038 477 53 69 | www.pragma-ade.nl | www.pragma-pod.nl ----------------------------------------------------------------- ___________________________________________________________________________________ If your question is of interest to others as well, please add an entry to the Wiki!

maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context webpage : http://www.pragma-ade.nl / http://context.aanhet.net archive : https://bitbucket.org/phg/context-mirror/commits/ wiki : http://contextgarden.net ___________________________________________________________________________________

ffi does look better. but i cant test right now, because I have no access to my dbserver. what about swiglib method? I compiled and installed the library but luatex doesnt find it. is there a way to check the search path of luatex? thanks michael

On 02 Oct 2017, at 10:38, Hans Hagen wrote:

On 10/2/2017 10:26 AM, Michael Eidenbenz wrote:

...

this doesnt work either. Do I haven't to install the luasql-mysql module? ...exp/tex/texmf-context/tex/context/base/mkiv/util-lib.lua:246: module 'luasql.mysql' not found:

yes but another alternative that copuld work is installing th enormal mysql libraries and then use the 'ffi' method (works on on windows and linux)

Hans

----------------------------------------------------------------- Hans Hagen | PRAGMA ADE Ridderstraat 27 | 8061 GH Hasselt | The Netherlands tel: 038 477 53 69 | www.pragma-ade.nl | www.pragma-pod.nl ----------------------------------------------------------------- ___________________________________________________________________________________ If your question is of interest to others as well, please add an entry to the Wiki!

maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context webpage : http://www.pragma-ade.nl / http://context.aanhet.net archive : https://bitbucket.org/phg/context-mirror/commits/ wiki : http://contextgarden.net ___________________________________________________________________________________