Group Office Scalability!

[lightningfullmoon]

Hi all,

I am amazing to see the groupoffice after successfully install. Its a wonder full work.
I'm very eger to write a code like the GO code.

My Doubt is, Let me know the scalability of GO...
For example... how much of userbase is handel by the GO or its depend on the mysql,php etc...
Is it good for more then 80k user base?

Pls. tell me...

Note: one more doupt... where and which place the acl and acl_item table will work and incorprate in the GO system

Thanks & Regards
Rumesh

[Intermesh]

I don't know about 80.000 users. I guess you need major hardware for that. I do know of installations with 3.000 users.


The ACL is used everywhere through GO. It's used to secure items such as addressbooks, calendar, projects etc. Everywhere you can manage permissions an ACL id is used.

[lightningfullmoon]

Thanks for your reply....

I need some suggestions and clarification...

My concern is suppose to i set hardware completely... is GO will handle 80K users, (only Calender, Tasks and Fileshare.

What are entries will added in acl and acl_items table?. Because, upto i know, the most of the table will have single entries or few entries for a user, except the acl and acl_itmes, it have all the rights and other things for a user..... How many entries added in acl and acl_itmes for a single user.
eg: user have 1 share file, and 1 un shared file, 1 clander entry, and 1 task entry.

In mysql, suppose i have 80k user the acl and acl_items will have huge data.. I heard about the partition in mysql myisam engine... is it best to solve this type of problem? suggest me.

Note: I am not yet clear in the flow of code and with table structre. if you explain it, it will help for me... i search in pdf documents... it had't it.

Regards,
Rumesh

[Intermesh]

Each shared folder will have one ACL entry.
Each calendar will have 2 acl entries

If a user shares a calendar or file with 2 users acl_items will have 2 entries

etc.

[lightningfullmoon]

Hi friend,

Thanks for you reply....

Shall i ask some other doubts reg. GO in developer aspects (particularly in code flow)?

awaiting for your reply...



Regards
Rumesh

[Intermesh]

Of course, just post them here.

[lightningfullmoon]

Hi,

Once again me...

My doubts are...

1) What are the tables affected when i add a user and file we access?
2) If i using my table eg:user_master instead of users. What are the changes i do in the file? i add most of the columns in users to the user_master except the personal information fields and authcode?
3) If i have already a users table in my system? i want to implement GO, ie. i want to set those users to access the GO, what are the thing i do? ie. for eg. adding acl values for users?
4) Mainly, i am confusing in acl id... bcoz the modules table have the acl id, also the users table also having acl id. is it unique or not, i need explanation on what the value added in acl and acl_items when user or group are added, and how the id we get?
5) Could you explain the flow of GO from login to user addition, calender addition, file share in relate to coding files and database?
6) for what purpose we have local folder?
7) Is acl is relate to group? how groups are handling?

I need your help to solve my problem.



Regards
Rumesh

[Intermesh]

you ask a lot of questions. I'll try to explain the ACL system.

If you want permissions on an object. you call $GO_SECURITY->get_new_acl();
This returns an unique ACL id stored in acl_items. You can store this at a calendar for example to control read_permissions. If you want user with ID=1 to have read permissions then a row with user_id=1 and the acl id is inserted in the table acl. If you want a group with id =1 in to have read permissions a row with group_id=1 and the acl id is inserted in table acl.

If you want GO to authenticate to another user table take a look at the classes/base/*.auth.class.inc files. rewrite the authentication functions to use your table and call it yourtable.auth.class.inc.

[lightningfullmoon]

Hi,

Thanks for your reply...

May i know, for what purpose and where it call the PHP_AUTH_USER and PHP_AUTH_PASSWORD is used... i saw it in authenticat function.


Regards
Rumesh

[Intermesh]

It's not used anymore. It was used for HTTP authentication with PHP.

[lightningfullmoon]

Hi,

Thanks for your replay....

Is our GO application is suitable for Shared Host service (ie. multiple domain). In little brief on myquestion is...

I have host. It had 10 domains. That's it is a shared hosting...
I provide GO to all the domain and its members. The GO for the all the domain members is in comman place, ie. files and database are common... user of each domain can access it.
My question is, shall we set the features (email,files.. etc) by domain wise and also shall we give the admin rights for one member in each domain... also shall we restrict access of one domain members to other domain members in our GO and shall we set the resource, other feature for particular domain...

I think, this is new perspective view for GO implamentation...

If possible, where and which file and db tables we modify?
If not, could you suggest the soultion for this problem?

Regards
Rumesh

[Intermesh]

You have to setup a different GO and database for each domain.

[lightningfullmoon]

Hi,

Thanks for your reply...

May i know...by which file we call to get the list of users and groups for setting write or read permission?

Next one is not in our GO.
Any clue on maximum number of Database can mysql application can handle (if we set perfect hardware).? for eg. 400 Database of our GO for each domain in single server...



Thanks
Rumesh

[Intermesh]

The amount is not relevant in my opinion. The activity and the amount of simultaneous connections is.

[lightningfullmoon]

Hi,

Thanks for your reply....

May i know...by which file we call to get the list of users and groups for setting write or read permission?

ie.. the page we call for give write or read permission for users or groups



Regards
Rumesh