[qc_metal]

I would try to run the BESUserAdminClient command directly on the BerryStats server and see if you produce the same results. If so, you will need to check the log file for the adminclient tool - this should be found in the same folder where your other log files are found (\BlackBerry Enterprise Server\Logs\ - by default)

If the command produces the same result, then you know that the problem is with either your configuration or how the client tool was set up. If not, then we need to take a look at the BerryStats command page...

Are you running Domino by chance?

[DavidAdams]

Hi Rob

I am getting the following from serverstatus.asp

An error occured during SQL processing. The actual error was: 3021-Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

Had this error briefly with a previous version but when i treid to repeat it the error went away, this time its a wee bit more persistent.

[jprknight]

Very nice...

Just needed to remove the top line from export.asp: <%Option Explicit%>

and now the export from classic is only the columns selected!! sweet!

[qc_metal]

Originally Posted by DavidAdams

Hi Rob

I am getting the following from serverstatus.asp

An error occured during SQL processing. The actual error was: 3021-Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

Had this error briefly with a previous version but when i treid to repeat it the error went away, this time its a wee bit more persistent.

In the serverstatus.asp page:

Around line 203 (search for "An error occured...") - insert the following line:

-Right below if err.number <> 0 then-

response.write SQL

Let me know what the query shows...if you have SQL Manager installed, try to run this query and see what it produces.

[DavidAdams]

Hi Rob

Added in the line, and now the query is working, i am seeing the server status page. Back to Alice in Wonderland methinks.

There's two blank results in the result, Mail Server Name and Admin Account Name.

[qc_metal]

Originally Posted by DavidAdams

Hi Rob

Added in the line, and now the query is working, i am seeing the server status page. Back to Alice in Wonderland methinks.

There's two blank results in the result, Mail Server Name and Admin Account Name.

That's OK - looks like you have nothing applied there. Probably should change that to a 'N/A' if no value is found...

Great news!

This is great - we're getting issues resolved right and left!

[StarDestroyer]

Originally Posted by qc_metal

I'm guessing those of you who had authentication issues had BerryStats installed on something OTHER than a DC?

That is correct.... I don't install anything on my DC's except the things required to make the network function (DNS, DHCP, RAS).

[StarDestroyer]

Sorry about the delayed response... was out of the office the end of last week and this slipped my mind over the weekend.

Originally Posted by qc_metal

This is the way in which FF doesn't like 'response.redirect' - I'm going to get this fixed, since the end goal here is to get it to run via all browsers.

I believe the correct JavaScript for that is to use:

document.location = 'new_url'

And if it's the server sending a redirect, a header with the following:

loaction: new_url

Not sure how to do that in .net though, I mainly use PHP and Pearl.

Originally Posted by qc_metal

Are you running via 4.5 mobile OS as well? I wonder if they changed how the browser handles some of the rendering details...I have 4.2, and it seems to be OK for me...like I said earlier, I'm going to have to bust out the simulator software!

No, I have 4.3.0.127 on a Pearl

Originally Posted by qc_metal

Brent and I have been collaborating on this bit, and I am redoing a portion of this code...essentially we are going to try and make it possible for transparent authentication via LDAP.

Cool beans... I'd help if I could, but like I said, my .net is next to nothing.

[qc_metal]

Originally Posted by StarDestroyer

That is correct.... I don't install anything on my DC's except the things required to make the network function (DNS, DHCP, RAS).

Yeah - not that I assumed people would only be running it on a DC, but the LDAP authentication issue occured only on systems when it wasn't installed on a DC.

We have it resolved now - - have you checked out .55? - - Heck, you might as well wait a little bit. .56 has self-service

[newaoao]

still errors:
Server: Msg 208, Level 16, State 1, Procedure BerryStats, Line 3
Invalid object name 'dbo.GroupConfig'.

Originally Posted by qc_metal

CREATE VIEW [dbo].[BerryStats]
AS
SELECT     dbo.ServerConfig.ServiceName AS Site, dbo.UserConfig.KeyGenPassword, dbo.UserConfig.DisplayName,
                      CASE dbo.UserStats.Status WHEN '0' THEN 'Initializing' WHEN '7' THEN 'No PIN' WHEN '8' THEN 'No Mailbox' WHEN '9' THEN 'Redirection disabled' WHEN
                       '10' THEN 'In cradle - no redirection' WHEN '12' THEN 'Running' ELSE CAST(dbo.UserStats.Status AS CHAR) END AS Status, dbo.UserConfig.PIN,
                      dbo.SyncDeviceMgmtSummary.ModelName, dbo.SyncDeviceMgmtSummary.HomeNetwork AS LastNetwork, dbo.UserStats.MsgsFailed AS Failed,
                      dbo.UserStats.MsgsPending AS Pending, dbo.UserStats.MsgsForwarded AS Rcvd, dbo.UserStats.MsgsSent AS Sent,
                      dbo.UserStats.MsgsExpired AS Expired, dbo.UserStats.MsgsFiltered AS Filtered, dbo.UserConfig.UserName as UserName, RTRIM(CONVERT(nchar(10), DATEDIFF(hh,
                      dbo.UserStats.LastFwdTime, GETUTCDATE()) / 24)) + ' Days ' + RTRIM(CONVERT(nchar(10), DATEDIFF(mi, dbo.UserStats.LastFwdTime, GETUTCDATE())
                      / 60 - DATEDIFF(hh, dbo.UserStats.LastFwdTime, GETUTCDATE()) / 24 * 24)) + ' Hrs' AS Inactive, DATEADD(hh, DATEDIFF(hh, GETUTCDATE(),
                      GETDATE()), dbo.UserStats.LastFwdTime) AS LastRcvd, DATEADD(hh, DATEDIFF(hh, GETUTCDATE(), GETDATE()), dbo.UserStats.LastSentTime)
                      AS LastSent, dbo.UserConfig.MailboxSMTPAddr AS SMTP, SUBSTRING(CAST(dbo.UserConfig.ServerDN AS varchar(100)), PATINDEX('%Servers/cn=%',
                      dbo.UserConfig.ServerDN) + 11, PATINDEX('%/cn=Microsoft%', dbo.UserConfig.ServerDN) - (PATINDEX('%Servers/cn=%', dbo.UserConfig.ServerDN)
                      + 11)) AS MailServer, dbo.SyncDeviceMgmtSummary.AppsVer, dbo.SyncDeviceMgmtSummary.PhoneNumber, dbo.SyncDeviceMgmtSummary.DCID,
                      dbo.SyncDeviceMgmtSummary.IMEI, dbo.SyncDeviceMgmtSummary.ITPolicyName, dbo.SyncDeviceMgmtSummary.FlashSize / 1048576 AS Memory,
                      DATEADD(hh, DATEDIFF(hh, GETUTCDATE(), GETDATE()), dbo.UserConfig.CreationTime) AS Creation, DATEADD(hh, DATEDIFF(hh, GETUTCDATE(),
                      GETDATE()), dbo.UserConfig.ActivationTime) AS Activation, DATEADD(hh, DATEDIFF(hh, GETUTCDATE(), GETDATE()), dbo.UserConfig.KeyDate)
                      AS KeyGen, DATEADD(hh, DATEDIFF(hh, GETUTCDATE(), GETDATE()), dbo.SyncDeviceMgmtSummary.HandheldConfigCheckTime) AS LastUpdate
FROM         dbo.ServerConfig INNER JOIN
                      dbo.UserConfig ON dbo.ServerConfig.Id = dbo.UserConfig.ServerConfigId LEFT OUTER JOIN
                      dbo.GroupConfig on dbo.UserConfig.GroupConfigID = dbo.GroupConfig.Id LEFT OUTER JOIN
                      dbo.UserStats ON dbo.UserConfig.Id = dbo.UserStats.UserConfigId LEFT OUTER JOIN
                      dbo.SyncDeviceMgmtSummary ON dbo.UserConfig.Id = dbo.SyncDeviceMgmtSummary.UserConfigId

GO

Does this view work for you? This was extracted directly from my DB server, and I have removed the GroupConfig field...

[StarDestroyer]

Originally Posted by qc_metal

We have it resolved now - - have you checked out .55? - - Heck, you might as well wait a little bit. .56 has self-service

I just installed .55 and LDAP auth works (once I used the domain_controller/dc=domain, dc=ext format). Looks good. We have a relatively small BB population (about 40) so it's not a huge ordeal to have IT deal with the relatively few issues that come up... I'll probably still update to it, though just 'cause I tend to do that.

I know it's not related to BerryStats, but any idea why the BES report my Pearl as a model unknown? I run OS 4.3.0.127 and have two other Pearls with that OS that are detected fine. The only difference I can think of is I updated their OS before activation and mine didn't update until after it was activated.

[qc_metal]

Originally Posted by newaoao

still errors:
Server: Msg 208, Level 16, State 1, Procedure BerryStats, Line 3
Invalid object name 'dbo.GroupConfig'.

Ahh... remove this line:

dbo.GroupConfig on dbo.UserConfig.GroupConfigID = dbo.GroupConfig.Id LEFT OUTER JOIN

[qc_metal]

Originally Posted by StarDestroyer

I just installed .55 and LDAP auth works (once I used the domain_controller/dc=domain, dc=ext format). Looks good. We have a relatively small BB population (about 40) so it's not a huge ordeal to have IT deal with the relatively few issues that come up... I'll probably still update to it, though just 'cause I tend to do that.

I know it's not related to BerryStats, but any idea why the BES report my Pearl as a model unknown? I run OS 4.3.0.127 and have two other Pearls with that OS that are detected fine. The only difference I can think of is I updated their OS before activation and mine didn't update until after it was activated.

That could be quite possible. I bet if you removed yourself from the BES and re-activate it will populate...don't quote me on that, tho'!

[jprknight]

This took me soo long to work out I wanted to post it. It took me forever to realise that the MAPI profile configuration under Start -> Blackberry Enterprise Server -> Edit MAPI Profile was the name of the mailbox, not the actual MAPI Profile Name. It can be found under:

HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows Messaging Subsystem

And perhaps usually, and in my case, was "BlackBerryServer".

Doh!!!!

[jprknight]

Sorry just realised I posted this without saying I am setting up the BESuseradminservice / BESuseradminservice client.

Originally Posted by jprknight

This took me soo long to work out I wanted to post it. It took me forever to realise that the MAPI profile configuration under Start -> Blackberry Enterprise Server -> Edit MAPI Profile was the name of the mailbox, not the actual MAPI Profile Name. It can be found under:

HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows Messaging Subsystem

And perhaps usually, and in my case, was "BlackBerryServer".

Doh!!!!

[qc_metal]

Originally Posted by jprknight

Sorry just realised I posted this without saying I am setting up the BESuseradminservice / BESuseradminservice client.

Jeremy, did you get your user lookup to work? Note that you must have email addresses specified in the AD user object in order for this to work...

For the rest of you, I've already discovered some small issues with .56 (mostly dealing with people browsing to the adduser.asp page even if they don't have this function assigned to their role).

Also, I've modified the adduser page so that if you -do- grant privileges to the self-service user to add a user, they can only add themselves. I have some other work to do - i.e. giving an option to the administrators to lock down the IT policy selection field so that a user can add themselves and have a pre-defined policy set.

[Ajlan]

Originally Posted by qc_metal

Jeremy, did you get your user lookup to work? Note that you must have email addresses specified in the AD user object in order for this to work...

For the rest of you, I've already discovered some small issues with .56 (mostly dealing with people browsing to the adduser.asp page even if they don't have this function assigned to their role).

Also, I've modified the adduser page so that if you -do- grant privileges to the self-service user to add a user, they can only add themselves. I have some other work to do - i.e. giving an option to the administrators to lock down the IT policy selection field so that a user can add themselves and have a pre-defined policy set.

I also have the same issue; logging in as a regular user which has a BB device already added and with the menu for a regular user, when choosing "My Blackberry" i get routed back to index.asp.

If I rem out the first rows in lite.asp it works great;
<%
if lcase(Session("LoggedOnSMTP")) <> Request.QueryString("SMTP") then
response.redirect "index.asp"
End If
%>

??

BTW Thanks for a great product

[qc_metal]

Yeah, I picked up on that today... -

...also, I've coded the pages so that a self-service user (if approved for adding a user) can only add themselves.

The next version will have the ability for admins to select whether to hide the IT-Policy and Server selection drop-downs (in addition to specifying the default values for them) on the self-service add user page...

Finally, I've noticed that when browsing from a BlackBerry, the menu options aren't quite what they should be. I will work on that.

[Ajlan]

Originally Posted by Ajlan

I'm configuring the "Find user", Show all users at startup to False and then using the query-users.asp.

It outputs the sql query on display but not the result.

Please, advice...

Originally Posted by qc_metal

Can you run the same query in SQL Manager Express?

Also, try to run a couple of the reports. Do you get anything back?

Found the issue; It was problem with the query column name LastNetwork.
In BES 4.0.x ver. the column name is "HomeNetwork".
In BES 4.1.x ver. the column name is "LastNetwork".

By changing in query-users.asp (from LastNetwork LIKE '%" & request.form("SearchForm") to HomeNetwork LIKE '%" & request.form("SearchForm") it worked like a charm.

[jprknight]

Originally Posted by Ajlan

Found the issue; It was problem with the query column name LastNetwork.
In BES 4.0.x ver. the column name is "HomeNetwork".
In BES 4.1.x ver. the column name is "LastNetwork".

By changing in query-users.asp (from LastNetwork LIKE '%" & request.form("SearchForm") to HomeNetwork LIKE '%" & request.form("SearchForm") it worked like a charm.

Thanks Ajlan, it was feed through to me via RD. Works a treat now!