mysql API error

[v8rik]

Hi all,

the problem discussed in this thread

http://www.directadmin.com/forum/showthread.php?threadid=258&perpage=20&pagenumber=5

is unresolved.

it is not possible to generate a mysql database for a user through the DA API described in

http://www.directadmin.com/api.html#create


generating the database from the control panel is not a problem. using CMD_DB in stead of CMD_API_DATABASES in the API does not help. I cannot verify if version 1.22 and 1.23 differ.

it generates an error in the directadmin error log:

2004:12:01-17:11:04: *** Segmentation fault *** getlock(./data/users/raq2da/reseller.allocation) : finished : User: xxxx : 213.247.60.140 : /CMD_DB : action=create&name=db4&domain=xxxxx.com&user=u4&passwd=xxxxxxx&passwd2=xxxxxxx : (null)

This is the reseller.allocation file

more /usr/local/directadmin/data/users/raq2da/reseller.allocation
bandwidth=15240
domainptr=0
ftp=243
mysql=51
nemailf=395
nemailml=360
nemailr=385
nemails=357
nsubdomains=0
nusers=0
quota=3130
vdomains=29


Compiled for Redhat 9.0
Server Version 1.23.0

thanks in advance for your reply

 

[mike_p]

Not surprisingly, I would like to find an answer to this too! Currently don't have time to go too deep myself so I've had to put my development of some script on hold.

Apparently the commands work on some systems but not on others.

I have a suspicion that it may be related to the mysql client libraries. What version of mysql are you using and which mysql client libraries libraries do you have installed?

ie if on an RPM system run the following command:

rpm -qa|grep -i mysql

 

[v8rik]

Hi Mike,

glad to have you on board on this one.

rpm -qa|grep -i mysql

yields

MySQL-client-4.0.17-0
MySQL-devel-4.0.17-0
MySQL-server-4.0.17-0

 

[mike_p]

I don't know whether this will help, but try loading the Dynamic client libraries as well. If you try it, let me know how you get on.

( http://downloads.mysql.com/archives.php?p=mysql-4.0&v=4.0.17 )

 

[justadollar]

I would really like to know a solution to this problem!

 

[v8rik]

I have included the dynamic libraries


rpm -qa|grep -i mysql
MySQL-client-4.0.17-0
MySQL-devel-4.0.17-0
MySQL-server-4.0.17-0
MySQL-shared-compat-4.0.17-0


but no improvement....

both /CMD_DB and /CMD_API_DATABASES continue to result in segmentation faults

more suggestions?

 

[v8rik]

this problem appears to be solved in the next update to 1.234

http://www.directadmin.com/features.php?id=467

will wait and see

 

[v8rik]

yes, the problem is solved, generating a mysql database now runs smoothly through the API

DirectAdmin 1.23.4

thanks DA people