Re: [NTG-context] 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  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
___

Re: [NTG-context] 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: [NTG-context] 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  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: [NTG-context] 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
___