HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=16)
-   -   creating user via remoting does not work (http://www.howtoforge.com/forums/showthread.php?t=22768)

AllanJ 27th April 2008 19:06

creating user via remoting does not work
 
Hi

I am trying to make an interface so that I can manage my ISPconfig server from an other server, and I hav no problems listing the webs and user etc, but when i tried to create a new user it fails. I can see in the mysql.log that the user i initially createrd but after some more mysql creating anf selcts it is then deleted again.
Is anyone using the remoting plugin, or can come with some help on this ?

Best regards
Allan Jacobsen

till 28th April 2008 11:45

Which version of the remoting framework do you use?

AllanJ 28th April 2008 18:18

I am running ISPConfig 2.2.23 and the remoting plugin 4.1beta on a debian etch server.
I just tried again from the example test.php script and the result is the same, you can see the mysql.log here:


62088 Init DB db_ispconfig
62088 Query INSERT INTO isp_isp_user (doctype_id,user_name,user_email,user_username,use r_passwort,user_speicher,user_mailquota,user_admin ) VALUES ('1014','Uwe Meier','uwe@linuxbutikken.net','web33_allan','sagi chnicht','10','10','0')
62088 Init DB db_ispconfig
62088 Query INSERT INTO isp_nodes ( userid, groupid, parent, type, doctype_id, status, icon, modul, doc_id, title
) VALUES (
4,
1,
'',
'a',
'1014',
'1',
'',
'',
53,
''
)
62088 Init DB db_ispconfig
62088 Query INSERT INTO isp_dep (userid, groupid, parent_doc_id, parent_doctype_id, parent_tree_id, child_doc_id, child_doctype_id, child_tree_id, status)
VALUES (
4,
1,
4,
'1013',
17,
53,
'1014',
182,
1)
62088 Init DB db_ispconfig
62088 Query SELECT * from doctype where doctype_id = '1014'
62088 Init DB db_ispconfig
62088 Query SELECT * from isp_server
62088 Init DB db_ispconfig
62088 Query select * from isp_isp_user where doc_id = '53'
62088 Init DB db_ispconfig
62088 Query SELECT count(doc_id) as doc_count from isp_isp_user where user_username = 'web33_allan'
62088 Init DB db_ispconfig
62088 Query UPDATE isp_isp_user SET user_passwort = '||||:xWnMZQ8qF9/8g' where doc_id = '53'
62088 Init DB db_ispconfig
62088 Query SELECT * from isp_isp_web, isp_dep where
isp_isp_web.doc_id = isp_dep.parent_doc_id and
isp_isp_web.doctype_id = isp_dep.parent_doctype_id and
isp_dep.child_doctype_id = 1014 and isp_dep.child_doc_id = 53
62088 Init DB db_ispconfig
62088 Query SELECT count(doc_id) as doc_count from isp_isp_user, isp_dep where
isp_isp_user.doc_id = isp_dep.child_doc_id and isp_isp_user.doctype_id = isp_dep.child_doctype_id and
isp_dep.parent_doctype_id = 1013 and isp_dep.parent_doc_id = 4 and isp_dep.child_doctype_id = 1014
62088 Init DB db_ispconfig
62088 Query SELECT * from isp_nodes where doc_id = 4 and doctype_id = 1013
62088 Init DB db_ispconfig
62088 Query SELECT * from isp_isp_reseller where reseller_group = 1
62088 Init DB db_ispconfig
62088 Query SELECT count(*) AS anzahl FROM isp_isp_user, isp_dep where
isp_isp_user.doc_id = isp_dep.child_doc_id and isp_isp_user.doctype_id = isp_dep.child_doctype_id and
isp_dep.parent_doctype_id = 1013 and isp_dep.parent_doc_id = 4 and
isp_dep.child_doctype_id = 1014 and isp_isp_user.user_email = 'uwe@linuxbutikken.net'
62088 Init DB db_ispconfig
62088 Query SELECT count(doc_id) as admin_count from isp_isp_user, isp_dep where
isp_isp_user.doc_id = isp_dep.child_doc_id and isp_isp_user.doctype_id = isp_dep.child_doctype_id and
isp_dep.parent_doctype_id = 1013 and isp_dep.parent_doc_id = 4 and isp_dep.child_doctype_id = 1014 and user_admin = '1'
62088 Init DB db_ispconfig
62088 Query DELETE from isp_isp_user where doc_id = '53'
62088 Init DB db_ispconfig
62088 Query DELETE from isp_nodes where doc_id = '53' and doctype_id = '1014'
62088 Quit

Best regards
Allan

till 28th April 2008 18:26

ISPConfig removes the record because the user_email field contains unallowed characters. Set user email to: 'uwe' and not 'uwe@linuxbutikken.net'.

AllanJ 28th April 2008 19:37

No, that is not the problem, I tried that yesterday, but i tried something else, and it turns out that I am not able to create a user with the normal ISPConfig webinterface.
To check this I have just installed a fresh copy of ISPconfig 2.2.23 and remoting beta4.1 on another server, and I am not able to create users with the normal webinterface. I dont know if the database can be corrupt, but I will try to clean the db_ispconfig and start over.

Best regards
Allan Jacobsen

AllanJ 28th April 2008 20:17

OK, this just gets worse, I deleted the database, /root/ispconfig and /home/admispconfig. Then I made a clean install, created a reseller, and logged in as that reseller. Then I made a client, and a website for that client, but when I try to create a user under that website it fails every time.
The errormessage is:

The following error occurred:



The selected diskspace exceeds site's limits.


Next >>


Is there an error in 2.2.23 or is it just me ?

Best regards
Allan Jacobsen

till 28th April 2008 20:59

Quote:

Is there an error in 2.2.23 or is it just me ?
there is no error in 2.2.3, you just set the limit wrong.

Please set the disk space limut of the user to a value that does not exceed the quota of the site. Be aware that if you set the limit of the user to -1 then the site must be set to -1 too, otherwise the users limit is larger then the site limt.

AllanJ 28th April 2008 21:55

OK, now things are clearing up a bit, all webinterfaces work, including on the testserver, where I am trying to get remoting to work, but remoting "user_add" still does not work, and I have removed the @domain part of the email.

"web_list" and "user_list" work fine with remoting, so it must be something specific with user_add.

Is there something else I can try to find the problem ?

till 29th April 2008 13:36

Please post the INSERT mysql statement from the mysql log that is used now.

AllanJ 29th April 2008 23:57

The start of the mysql log for a remoting "user_add" looks like this:

68251 Query INSERT INTO isp_isp_user (doctype_id,user_name,user_email,user_username,use r_passwort,user_speicher,user_mailquota,user_admin ) VALUES ('1014','Uwe Mer','uwe','web33_uwe','sagichnicht','0','1
68251 Init DB db_ispconfig
68251 Query INSERT INTO isp_nodes ( userid, groupid, parent, type, doctype_id, status, icon, modul, doc_id, titleM
) VALUES (M
4,M
1,M
'',M
'a',M
'1014',M
'1',M
'',M
'',M
68,M
''M
)
68251 Init DB db_ispconfig
68251 Query INSERT INTO isp_dep (userid, groupid, parent_doc_id, parent_doctype_id, parent_tree_id, child_doc_id, child_doctype_id, child_tree_id, status)M
VALUES (M
4,M
1,M
4,M
'1013',M
17,M
68,M
'1014',M
200,M
1)
68251 Init DB db_ispconfig
68251 Query SELECT * from doctype where doctype_id = '1014'
68251 Init DB db_ispconfig
68251 Query SELECT * from isp_server
68251 Init DB db_ispconfig
68251 Query select * from isp_isp_user where doc_id = '68'
68251 Init DB db_ispconfig
68251 Query SELECT count(doc_id) as doc_count from isp_isp_user where user_username = 'web33_uwe'
68251 Init DB db_ispconfig
68251 Query UPDATE isp_isp_user SET user_passwort = '||||:Xjd7M41I4c/eo' where doc_id = '68'


If I make a user with the webinterface the start of the mysql log is a bit different:

68245 Query INSERT INTO isp_isp_user (user_name, user_passwort, user_speicher, user_admin, user_shell) VALUES ('Jens Meier', 'test1234', '0', '0', '0')
68245 Init DB db_ispconfig
68245 Query INSERT INTO isp_nodes (title, doctype_id, doc_id, type, icon, userid, groupid, status) VALUES ('', '1014', '67', 'a', '', '1', '0', '1')
68245 Init DB db_ispconfig
68245 Query Select userid, groupid from isp_nodes where tree_id = '79'
68245 Init DB db_ispconfig
68245 Query select * from user_groups where groupid = '2' and userid = '1'
68245 Init DB db_ispconfig
68245 Query SELECT * from isp_nodes where tree_id = '79'
68245 Init DB db_ispconfig
68245 Query INSERT INTO isp_dep (userid,groupid,parent_doc_id,parent_doctype_id,pa rent_tree_id,child_doc_id,child_doctype_id,child_t ree_id) VALUES
('0','2','26','1013','79','67','1014','199')
68245 Init DB db_ispconfig
68245 Query SELECT * from sys_config
68245 Init DB db_ispconfig
68245 Query UPDATE isp_isp_user SET user_username = 'web33_jens', user_email = 'jens' where doc_id = 67
68245 Init DB db_ispconfig
68245 Query SELECT * from isp_server
68245 Init DB db_ispconfig
68245 Query select * from isp_isp_user where doc_id = '67'
68245 Init DB db_ispconfig
68245 Query SELECT count(doc_id) as doc_count from isp_isp_user where user_username = 'web33_jens'
68245 Init DB db_ispconfig
68245 Query UPDATE isp_isp_user SET user_passwort = '||||:]{AMOnrho.08c' where doc_id = '67'

so it would seem that the 2 operations take different paths in the code, but I have not dug that deep into ispconfig yet.

Best regards
Allan Jacobsen


All times are GMT +2. The time now is 19:40.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.