HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Developers' Forum (http://www.howtoforge.com/forums/forumdisplay.php?f=33)
-   -   sys_userid field (http://www.howtoforge.com/forums/showthread.php?t=57835)

devalentino 5th July 2012 14:24

sys_userid field
 
Hi

I write module for drupal, which works with IPSConf 3 SOAP API.
I try to get user's sites with function client_get_sites_by_user.

at first I receive user data:
PHP Code:

$i3Client $client->client_get($sessionId$clientId); 

here is $i3Client var_dump:
Code:

array (size=72)
  'client_id' => string '2' (length=1)
  'sys_userid' => string '1' (length=1)
  'sys_groupid' => string '1' (length=1)
  'sys_perm_user' => string 'riud' (length=4)
  'sys_perm_group' => string 'riud' (length=4)
  'sys_perm_other' => string '' (length=0)
  'company_name' => string '' (length=0)
  'company_id' => string '' (length=0)
  'contact_name' => string 'Protog Client 1' (length=15)
  'customer_no' => string '' (length=0)
  'vat_id' => string '' (length=0)
  'street' => string '' (length=0)
  'zip' => string '' (length=0)
  'city' => string '' (length=0)
  'state' => string '' (length=0)
  'country' => string 'UA' (length=2)
  'telephone' => string '' (length=0)
  'mobile' => string '' (length=0)
  'fax' => string '' (length=0)
  'email' => string '' (length=0)
  'internet' => string '' (length=0)
  'icq' => string '' (length=0)
  'notes' => string '' (length=0)
  'default_mailserver' => string '0' (length=1)
  'limit_maildomain' => string '0' (length=1)
  'limit_mailbox' => string '0' (length=1)
  'limit_mailalias' => string '0' (length=1)
  'limit_mailaliasdomain' => string '0' (length=1)
  'limit_mailforward' => string '0' (length=1)
  'limit_mailcatchall' => string '0' (length=1)
  'limit_mailrouting' => string '0' (length=1)
  'limit_mailfilter' => string '0' (length=1)
  'limit_fetchmail' => string '0' (length=1)
  'limit_mailquota' => string '0' (length=1)
  'limit_spamfilter_wblist' => string '0' (length=1)
  'limit_spamfilter_user' => string '0' (length=1)
  'limit_spamfilter_policy' => string '0' (length=1)
  'default_webserver' => string '0' (length=1)
  'limit_web_ip' => null
  'limit_web_domain' => string '0' (length=1)
  'limit_web_quota' => string '0' (length=1)
  'web_php_options' => string 'no,fast-cgi,cgi,mod,suphp' (length=25)
  'limit_web_subdomain' => string '0' (length=1)
  'limit_web_aliasdomain' => string '0' (length=1)
  'limit_ftp_user' => string '0' (length=1)
  'limit_shell_user' => string '0' (length=1)
  'ssh_chroot' => string 'no,jailkit,ssh-chroot' (length=21)
  'limit_webdav_user' => string '0' (length=1)
  'default_dnsserver' => string '0' (length=1)
  'limit_dns_zone' => string '0' (length=1)
  'limit_dns_slave_zone' => string '0' (length=1)
  'limit_dns_record' => string '0' (length=1)
  'default_dbserver' => string '0' (length=1)
  'limit_database' => string '0' (length=1)
  'limit_cron' => string '0' (length=1)
  'limit_cron_type' => string '' (length=0)
  'limit_cron_frequency' => string '0' (length=1)
  'limit_traffic_quota' => string '0' (length=1)
  'limit_client' => string '0' (length=1)
  'limit_mailmailinglist' => string '0' (length=1)
  'limit_openvz_vm' => string '0' (length=1)
  'limit_openvz_vm_template_id' => string '0' (length=1)
  'parent_client_id' => string '0' (length=1)
  'username' => string 'pclient1' (length=8)
  'password' => string '$1$9aHgTWaB$YkoOqK93E8hJmjTTB/TrA.' (length=34)
  'language' => string 'fi' (length=2)
  'usertheme' => string 'default_no_navimg' (length=17)
  'template_master' => string '0' (length=1)
  'template_additional' => string '' (length=0)
  'created_at' => string '1341391516' (length=10)
  'id_rsa' => string '-----BEGIN RSA PRIVATE KEY-----
MIIEpQIBAAKCAQEAvvKYFoNmovv86oAFUDg1MgxdmPFz3Xch69pO21gJu4xVuAGD
ooZOURxX0qAxAD90QWDvOTgr50U4jiax9jpe57NCOukgQHvldQmBELC8Gb/YV91M
8S8SUgUbSbCHbZnGNmp1RS2IAQ+C4WHB/ZYiujjmUEVIY3ll3WtazrpvkFohaKw0
pGPyGa26d6hfEaL0mR+F9zVabaZWNkugSstW3p+QqaldE3qQU5RQUU3yvZD7gRuD
LiVLLkhw1iHJUgg8juMVM8KOIAyc8q8hYIOhUj7LlFQXnpKtudxZn1Ir6pjz4oc5
YiSnDU4910+CWvaNEwua1gu+882cXO/RUl6kVwIDAQABAoIBAQCykhrrSv1sRK40
+358k+Qjpu7NPlj17xiZAfMnLAEGFOqBB2F8V4/cSN5Uypyot67YCXgPEdn1EYYf
Yk6hj9r7Ymf4wdX4mCVxO28pF'... (length=1679)
  'ssh_rsa' => string 'ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQC+8pgWg2ai+/zqgAVQODUyDF2Y8XPddyHr2k7bWAm7jFW4AYOihk5RHFfSoDEAP3RBYO85OCvnRTiOJrH2Ol7ns0I66SBAe+V1CYEQsLwZv9hX3UzxLxJSBRtJsIdtmcY2anVFLYgBD4LhYcH9liK6OOZQRUhjeWXda1rOum+QWiForDSkY/IZrbp3qF8RovSZH4X3NVptplY2S6BKy1ben5CpqV0TepBTlFBRTfK9kPuBG4MuJUsuSHDWIclSCDyO4xUzwo4gDJzyryFgg6FSPsuUVBeekq253FmfUivqmPPihzliJKcNTj3XT4Ja9o0TC5rWC77zzZxc79FSXqRX pclient1-rsa-key-1341391516
' (length=409)

then I try to receive user's sites:
PHP Code:

$sites $client->client_get_sites_by_user(
            
$sessionId
            
$i3Client["sys_userid"], 
            
$i3Client["sys_groupid"]); 

here is $sites var_dump:
Code:

array (size=1)
  0 =>
    array (size=4)
      'domain' => string 'test1.net' (length=9)
      'domain_id' => string '1' (length=1)
      'document_root' => string '/var/www/clients/client1/web1' (length=29)
      'active' => string 'y' (length=1)

| connected to server and saw client table:
Code:

mysql> select client_id, sys_userid, sys_groupid, username from client;
+-----------+------------+-------------+----------+
| client_id | sys_userid | sys_groupid | username |
+-----------+------------+-------------+----------+
|        1 |          1 |          1 | test1    |
|        2 |          1 |          1 | pclient1 |
|        3 |          1 |          1 | 1111    |
|        4 |          1 |          1 | test2    |
|        5 |          1 |          1 | test3    |
+-----------+------------+-------------+----------+

all users has same sys_userid and sys_groupid values, so API returns me data for first user (test1), but I asked data for second user (pclient1)

Alse I tried to set client_id instead of sys_userid, but thats not correct. Table with sites (web_domain) has strange values:
Code:

mysql> select client_id, sys_userid, sys_groupid, username from client;
+-----------+------------+-------------+----------+
| client_id | sys_userid | sys_groupid | username |
+-----------+------------+-------------+----------+
|        1 |          1 |          1 | test1    |
|        2 |          1 |          1 | pclient1 |
|        3 |          1 |          1 | 1111    |
|        4 |          1 |          1 | test2    |
|        5 |          1 |          1 | test3    |
+-----------+------------+-------------+----------+

Can anybody help? How can I receive correct sys_userid?

till 5th July 2012 17:38

The sys_userid is the user that created the record, it is not necessarrily the owner of the record. If you wnat to get the owner, then use the sys_groupid.

Your querys can not work as you used the sys_groupid and sys_userid of the client record. The client record is always owned by the administartor of the server.

Example:

Code:

$groupid = client_get_groupid($session_id, $client_id);
$sites = sites_web_domain_get($session_id, array("sys_groupid" => $groupid) );



All times are GMT +2. The time now is 00:18.

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