[SoUnCool]

Hello guys, just wondering , if anyone added enterprise service policy feature, We use this to white list device PIN so that only provisioned devices by IT can be activated on our BES, Would love to see a feature on berrystats where I can add device PIN to white list

[SoUnCool]

Just discovered a bug , We have two users, UserA and UserB , UserA is leaving the firm, his account is being disabled, exchange team change his email address and assign this email address to UserB as UserB's secondary smtp address

now if using berrystats I delete UserA it will ONLY remove UserB from BES , not UserA

here is output of user delete function

BlackBerry(R) Enterprise Server User Administration Tool Version 4.1.6.5
Copyright (c) Research In Motion, Ltd. 1997-2008. All rights reserved.
Modification date: Jul 31 2008

besuseradminclient.exe -delete -u -hard -f -b BES -SQLUSER xxxxx -SQLPASS xxxxx

[13:12:08] BESUserAdmin::main - Log Start
[13:12:09] BESUserAdmin::DoDeleteUser - (UserA@xxx.zz) Preparing to delete user...
[13:12:09] BESUserAdmin::DoDeleteUser - (UserA@xxx.zz) User deleted.
[13:12:09] BESUserAdmin::main - Log End


here is code from berrystats

ElseIf strAction = "deleteuser" then
strEmailAddress = request.querystring("user")
strBESServer = request.querystring("besserver")
strCmd = BESUSERADMINEXE & " -delete -u " _
& chr(34) & strEmailAddress & chr(34) & " -hard -f -b " & strBESServer & _
" -p " & BESADMINPWD


Deleting user from BES management console does not reproduce this issue

[vjkumar]

Originally Posted by thejollyboys

Just installed berry stats and all works great all user admin functions seem to be fine.

The only issue I have is when a user browsers to the web site who is not in the Admins group in AD, I'm using LDAP, then it says "Youare not authorised to access BerryStats"

Confirmed all the speelings of groups is fine and users are members of groups. Self Servcie is enabled and group is set to Domain Admins.

Hope some body can help.

Thanks.

Andy.

DId you changed anything in logon.asp? can u give us the screensht of your configuration page as well?

[vjkumar]

Originally Posted by SoUnCool

Just discovered a bug , We have two users, UserA and UserB , UserA is leaving the firm, his account is being disabled, exchange team change his email address and assign this email address to UserB as UserB's secondary smtp address

now if using berrystats I delete UserA it will ONLY remove UserB from BES , not UserA

here is output of user delete function

BlackBerry(R) Enterprise Server User Administration Tool Version 4.1.6.5
Copyright (c) Research In Motion, Ltd. 1997-2008. All rights reserved.
Modification date: Jul 31 2008

besuseradminclient.exe -delete -u -hard -f -b BES -SQLUSER xxxxx -SQLPASS xxxxx

[13:12:08] BESUserAdmin::main - Log Start
[13:12:09] BESUserAdmin::DoDeleteUser - (UserA@xxx.zz) Preparing to delete user...
[13:12:09] BESUserAdmin::DoDeleteUser - (UserA@xxx.zz) User deleted.
[13:12:09] BESUserAdmin::main - Log End


here is code from berrystats

ElseIf strAction = "deleteuser" then
strEmailAddress = request.querystring("user")
strBESServer = request.querystring("besserver")
strCmd = BESUSERADMINEXE & " -delete -u " _
& chr(34) & strEmailAddress & chr(34) & " -hard -f -b " & strBESServer & _
" -p " & BESADMINPWD


Deleting user from BES management console does not reproduce this issue

what is the primary address of UserB? ? can you confirm that? BES always retrieve Primary SMTP address of user and nor secondary

[SoUnCool]

Originally Posted by vjkumar

what is the primary address of UserB? ? can you confirm that? BES always retrieve Primary SMTP address of user and nor secondary

we change userB email address to userB2 @ xxx.zz and add the origional email address to userA as secondary smtp address

and yes Berrystat always delete only UserA , and I do select UserB from berry stats and in the wuery it shows userB , but Always delete UserA

this does not happen in BB manager

[thejollyboys]

Originally Posted by vjkumar

DId you changed anything in logon.asp? can u give us the screensht of your configuration page as well?

Nothing changed in the Login.asp page.

Screen shot attached.

[vjkumar]

Originally Posted by thejollyboys

Nothing changed in the Login.asp page.

Screen shot attached.

Enable debug mode and check. Create security group and add some members into it. wait for about 15-20 minutes and ask them to login again.

[vjkumar]

Originally Posted by SoUnCool

we change userB email address to userB2 @ xxx.zz and add the origional email address to userA as secondary smtp address

and yes Berrystat always delete only UserA , and I do select UserB from berry stats and in the wuery it shows userB , but Always delete UserA

this does not happen in BB manager

Ok. Once you select UserB in berrystats, what is the email address tied to the account? was it userB or userA? The way BB manager works is different from user admin service. User admin service rely on the input. If the UserB email add in Berrystats shown as , for sure it will remove and not . When the command runs, it will get the email address from email address field and execute -delete -servername BES. This is just my guess

[SoUnCool]

Originally Posted by vjkumar

Ok. Once you select UserB in berrystats, what is the email address tied to the account? was it userB or userA? The way BB manager works is different from user admin service. User admin service rely on the input. If the UserB email add in Berrystats shown as , for sure it will remove and not . When the command runs, it will get the email address from email address field and execute -delete -servername BES. This is just my guess

let me explain littlie more,
UserA , primary smtp
UserB , primary smtp

now userB is leaving the firm, we change primary smtp of USERB to

and add a SECONDARY SMTP to userA , that is

when i run berry stat command, it shows that he is removing userB ( )

this address is not a primary address , is there a way around this function of useradmin service ?

[thejollyboys]

Originally Posted by vjkumar

Enable debug mode and check. Create security group and add some members into it. wait for about 15-20 minutes and ask them to login again.

Ok, if I add another group to AD, "berrystats selfservice" and add a user in the group it works ok.

We have 2500 users so adding all of them to the group would take some time. I tried to add Domain users to the group but that does not work.

Any ideas please? Thanks for your help so far.

Andy

[vjkumar]

Originally Posted by thejollyboys

Ok, if I add another group to AD, "berrystats selfservice" and add a user in the group it works ok.

We have 2500 users so adding all of them to the group would take some time. I tried to add Domain users to the group but that does not work.

Any ideas please? Thanks for your help so far.

Andy

Hi,

I am using Berrystats v0,57 which doesn't require seperate group for non-admin to login to Berrystats and fully customized.

You may try adding the domain user group in this way into berrystats configuration page:

domain\Domain users

It might help you. Let me know if you succeeded. If not, i can share a script that will help you to add members into DL in bulk. Just get the email address of your users. The script will add them into your berrystats user group.

[vjkumar]

Originally Posted by SoUnCool

let me explain littlie more,
UserA , primary smtp
UserB , primary smtp

now userB is leaving the firm, we change primary smtp of USERB to

and add a SECONDARY SMTP to userA , that is

when i run berry stat command, it shows that he is removing userB ( )

this address is not a primary address , is there a way around this function of useradmin service ?

I will simulate this with my dummy account and get back to you.

[SoUnCool]

Originally Posted by vjkumar

I will simulate this with my dummy account and get back to you.

thank you

[Passmos]

Hi All,

Has anyone got Berrystats working with the BES5 client tools for bes5? The command line is exactly the same and it runs from the box, however everytime I run it from within berry stats I get :


java.lang.NoClassDefFoundError: com/rim/bes/brk/besuseradmin/BESUserAdminMain
Exception in thread "main"

Anyone had any experience or know how to fix this error?

Thanks

[dlavingia]

I am trying to setup berrystats and having a bad experience with it.

Everytime I try to run the SQL statement I get a parse error saying incorrect syntax near "GO" from event source .net sqlclient data provider.

This is SQL Manangement Studio on a MSDE install.

How do I get this loaded properly?

[dlavingia]

some further errors I found from the query

Msg 208, Level 16, State 1, Procedure BerryStats, Line 3
Invalid object name 'dbo.ServerConfig'.
Msg 208, Level 16, State 1, Procedure BerryStats, Line 3
Invalid object name 'dbo.UserConfig'.
Msg 208, Level 16, State 1, Procedure BerryStats, Line 3
Invalid object name 'dbo.GroupConfig'.
Msg 208, Level 16, State 1, Procedure BerryStats, Line 3
Invalid object name 'dbo.UserStats'.
Msg 208, Level 16, State 1, Procedure BerryStats, Line 3
Invalid object name 'dbo.SyncDeviceMgmtSummary'.

[pietje]

I am a beginner but also would like to install Berrystats, because the administrationtools for the BES Server are all DOS based tools, i would like to use a GUID tool.

I have a BES Server Windows 2003 installed with connection to a Exchange 2003 server.
BES Pro software 5 installed, with a local SQL installation together with BES installed.

Now i read the for the Berrystats the BES user admin tool must be installed for Berrystats to work.
I want to use Berrystat on a different pc with Windows 7 not the BES server.

What i don't understand at this moment is what installations and how to install do i need for Berrystats? on the BES server or on the PC where i install BES admin user administration tool.
When i try to install the user administration tool he asks for a DNS name and a SSL keystore password.

So i have a lot of questions off where to begin to eventually use Berrystats...

[pietje]

I have followed the install documentation for Berrystats. Starting with the setup IIS for the webpage. Problem there is that after the configuration according to the document i cannot display \\besserver\berrystats\setup.asp
The page cannot be displayed...

What am i doiing wrong?

[hayabusa]

Originally Posted by Passmos

Hi All,

Has anyone got Berrystats working with the BES5 client tools for bes5? The command line is exactly the same and it runs from the box, however everytime I run it from within berry stats I get :


java.lang.NoClassDefFoundError: com/rim/bes/brk/besuseradmin/BESUserAdminMain
Exception in thread "main"

Anyone had any experience or know how to fix this error?

Thanks

The besuseradminclient tool is different for BES 5.0. The switches are different and the besuseradminclient has to login to the BAS server to pass the changes to the database. The global.asp and besuseradminclient.asp page will need to be re-coded to complensate for this.

[hayabusa]

Originally Posted by Grimlin

I haven't seen BES 5.0 yet. My hope is that there are fields of flowers and green grass and we don't need BerryStats with 5.0.

...but if we do, it is just a database. We reverse-engineered the last one and then they gave up and published a full schema. If needed, history will repeat itself.

If you want to use Berrystats with BES 5.0 you will need to partiallly re-code the besuseradminclient.asp, global.asp, and config.xml. You will need to create additional fields and varibles for the BAS stuff. In BES 5.0 you have to login to the BAS server to run any code. So your code will go besuseradminclient >basuser>baspw>authentication>basuserout>BesmgmtDB . The basic theory is now the besuseradminclient uses the bas userid to login to the BAS service then the bas service makes the changes to the DB on behalf of besuseradminclient. The other thing to note here is that RIM changed the installation location of the besuseradminclient so when invoking the besuseradminclient.exe validate it's in the correct directory.