[Glass] System performOnServer: - LDAP - MySQL

[BrunoBB]

Hi All,

I was able to connect to LDAP and MySQL using System performOnServer:.
You have to install ldapsearch and mysql command in the same machine
GemStone is.

LDAP 1 (with authentication):
System performOnServer: 
'ldapsearch -x -D "cn=admin.myApp,C=UY" -H ldap://10.245.50.147 -b
"ou=users,cn=myApp-test,C=UY" -w ldappassword'.

-D is the connection name for -w ldappassword 
-H is the ip address 
-b is the start route of the search in LDAP

This answer a string with all LDAP users under -b option, in this case
"ou=users,cn=myApp-test,C=UY".

LDAP 2:
System performOnServer: 
'ldapcompare -x -D "cn=admin.myApp,C=UY" -H ldap://10.245.50.147 
"uid=myUserID,ou=usuarios,cn=myApp-test,C=UY" -w ldappassword
userpassword:myPwdInLdapServer'.

Answer True if the password in LDAP server of user "myUserID" is equal to
myPwdInLdapServer otherwise answer false.

MySQL1:
System performOnServer:  
'mysql -h 10.215.152.125 -u root -pMySQLPasswordForRoot -e "show databases"'
.

Answer a string with all databases name

MySQL2:
System performOnServer:
 'mysql -h 10.215.152.125 -u root -pMySQLPasswordForRoot -e "select xml from
orbeon.orbeon_form_definition where form=''denuncias''" '

Answer the correct data from MySQL.

The only problem is that the amount of space memory to get the result string
is limited. If the sql sentence answer a big string the an error arise that
Temp memory is short.

Error message in Jade:
Fatal GemStone Error
VM temporary object memory is full, old space overflow

Regards,
Bruno



--
View this message in context: http://forum.world.st/System-performOnServer-LDAP-MySQL-tp4723981.html
Sent from the GLASS mailing list archive at Nabble.com.