Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 27th April 2008, 18:06
AllanJ AllanJ is offline
Junior Member
 
Join Date: Mar 2007
Posts: 16
Thanks: 5
Thanked 6 Times in 2 Posts
Default 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
Reply With Quote
Sponsored Links
  #2  
Old 28th April 2008, 10:45
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,466
Thanks: 813
Thanked 5,253 Times in 4,119 Posts
Default

Which version of the remoting framework do you use?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 28th April 2008, 17:18
AllanJ AllanJ is offline
Junior Member
 
Join Date: Mar 2007
Posts: 16
Thanks: 5
Thanked 6 Times in 2 Posts
Default

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
Reply With Quote
  #4  
Old 28th April 2008, 17:26
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,466
Thanks: 813
Thanked 5,253 Times in 4,119 Posts
Default

ISPConfig removes the record because the user_email field contains unallowed characters. Set user email to: 'uwe' and not 'uwe@linuxbutikken.net'.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 28th April 2008, 18:37
AllanJ AllanJ is offline
Junior Member
 
Join Date: Mar 2007
Posts: 16
Thanks: 5
Thanked 6 Times in 2 Posts
Default

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
Reply With Quote
  #6  
Old 28th April 2008, 19:17
AllanJ AllanJ is offline
Junior Member
 
Join Date: Mar 2007
Posts: 16
Thanks: 5
Thanked 6 Times in 2 Posts
Default

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
Reply With Quote
  #7  
Old 28th April 2008, 19:59
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,466
Thanks: 813
Thanked 5,253 Times in 4,119 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #8  
Old 28th April 2008, 20:55
AllanJ AllanJ is offline
Junior Member
 
Join Date: Mar 2007
Posts: 16
Thanks: 5
Thanked 6 Times in 2 Posts
Default

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 ?
Reply With Quote
  #9  
Old 29th April 2008, 12:36
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,466
Thanks: 813
Thanked 5,253 Times in 4,119 Posts
Default

Please post the INSERT mysql statement from the mysql log that is used now.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #10  
Old 29th April 2008, 22:57
AllanJ AllanJ is offline
Junior Member
 
Join Date: Mar 2007
Posts: 16
Thanks: 5
Thanked 6 Times in 2 Posts
 
Default

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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ftplicity problems Ovidiu Server Operation 25 3rd December 2008 05:42
Bunch of user Maildirs disappeared catdude General 1 20th November 2007 09:55
Relay access denied brainz Installation/Configuration 27 8th March 2007 08:21
No user logins work the_billness Installation/Configuration 1 10th August 2006 17:34
Problem with the apache (I can't start ist) M.Behrens Installation/Configuration 11 31st March 2006 10:48


All times are GMT +2. The time now is 09:24.


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