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 offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,395
Thanks: 833
Thanked 5,490 Times in 4,322 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 offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,395
Thanks: 833
Thanked 5,490 Times in 4,322 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
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 05:29.


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