sql / swiglib doesnt find lib

sql / swiglib doesnt find lib

[Michael Eidenbenz]

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//

Thanks!
___________________________________________________________________________________
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
___________________________________________________________________________________

Re: sql / swiglib doesnt find lib

[Hans Hagen]

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
___________________________________________________________________________________

Re: sql / swiglib doesnt find lib

[Michael Eidenbenz]

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 <pragma@wxs.nl> 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
> ___________________________________________________________________________________

___________________________________________________________________________________
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
___________________________________________________________________________________

Re: sql / swiglib doesnt find lib

[Hans Hagen]

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
___________________________________________________________________________________

Re: sql / swiglib doesnt find lib

[Michael Eidenbenz]

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 <pragma@wxs.nl> 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
> ___________________________________________________________________________________

___________________________________________________________________________________
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
___________________________________________________________________________________