BlackBerry Forums Support Community

hayabusa · 12-10-2007, 02:44 PM

that page does however hook to the adlookup.asp page that Grimlin created so if you don't have that added cool feature let me know and I can send that to you as well. This will allow for the ldap search to happen

SoUnCool · 12-10-2007, 04:01 PM

thanks i got your asp page, yes i already have adlookup, will try these this weekend and see how it goes,

schu2u · 12-10-2007, 11:07 PM

I have downloaded the latest code and gone through the set up process.
I am able to run admin.asp to configure the config.xml. However whenever I go to http://localhost/berrystats/index.xml it times out.

Also (and may be cause for issue above) I have the BES DB, BESMgmt, running within a SQL instance - how do I accomidate this? I went with SQLSERVER\Instance but again am timing out. I build an odbc connection on the same server using the instance name, SQL port, and SQL id\password and can connect ok which leads me to think it has to do with how the app is handling the SQL instance.

MSXML 4.0 SP2 is installed. The Web server is x64 (does that matter?)
Any tips?

Grimlin · 03-19-2008, 02:23 PM

Anyone heard from QC_Metal? His download link appears to be 404. I had someone PM me looking for his version of berrystats.

qc_metal · 03-19-2008, 02:42 PM

I'm trying to work out some billing issues on the website...

Hopefully it will be back up this evening or tomorrow morning.

Sorry about this everyone.

Oh - and some good news: We are evaluating BB Server here at my new(-ish) job. Sooooo...that means I should be able to resume work on BerryStats for ASP again!

Grimlin · 03-20-2008, 08:26 AM

Quote:

Originally Posted by qc_metal

Oh - and some good news: We are evaluating BB Server here at my new(-ish) job. Sooooo...that means I should be able to resume work on BerryStats for ASP again!

That is great news!

qc_metal · 03-20-2008, 09:13 AM

Website is back up...! Sorry about the troubles everyone!

sahellis · 03-24-2008, 02:39 PM

I hope someone can help me.
I have no idea what I'm doing and know nothing about SQL and very little about ASP.
This is the error I'm getitng when I try to browse (through the computer management console) any page but the admin.asp page, it works fine.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
Microsoft][ODBE SQL ServerDriver][SQL Server]Login
failed for user 'berrystats'.
/BerryStats/lite.asp, line 24

Again the admin.asp opens fine but I guess the user that I made called berrystats is not getting access.

If I try to browse the index.asp it just times out

Thanks

If I browse the serverstatus.asp it works also.

Grimlin · 03-25-2008, 07:02 AM

Quote:

Originally Posted by sahellis

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
Microsoft][ODBE SQL ServerDriver][SQL Server]Login
failed for user 'berrystats'.
/BerryStats/lite.asp, line 24

Sounds like you have not setup the user on your SQL Server. You also need to make sure that your SQL Server or MSDE instance is set for SQL Auth (and Windows Auth). I believe there is information about this in the install instructions, but there is definitely a post in this thread about it as well. Do a little search on this thread and you will turn up your answer.

qc_metal · 03-25-2008, 08:11 AM

Side note - I'm looking for all modifications or updates made to the ASP version, as I would like to start working on this a little bit.

If you have updated files, please post them in the thread on my messageboard, and I will start to compile them together: Viewing a thread - BerryStats ASP (BlackBerry statistics web GUI)

sahellis · 03-25-2008, 08:15 AM

Quote:

Originally Posted by Grimlin

Sounds like you have not setup the user on your SQL Server. You also need to make sure that your SQL Server or MSDE instance is set for SQL Auth (and Windows Auth). I believe there is information about this in the install instructions, but there is definitely a post in this thread about it as well. Do a little search on this thread and you will turn up your answer.

Here are my database users. Is this not correct. I followed the directions exactly as written.
I searched this thread all day yesterday with no luck.

Grimlin · 03-25-2008, 11:08 AM

Quote:

Originally Posted by sahellis

Here are my database users. Is this not correct. I followed the directions exactly as written.
I searched this thread all day yesterday with no luck.

What happens when you create an ODBC connection to it from a PC and use the same ID and password?

Frank Castle · 03-25-2008, 11:37 AM

QC - Great to see you back, I'd love to have a lite version of BerryStats that will display on Blackberry. I frequently use it to query if someone is on the BES and what their status is etc.

qc_metal · 03-25-2008, 04:41 PM

Quote:

Originally Posted by jletendre

QC - Great to see you back, I'd love to have a lite version of BerryStats that will display on Blackberry. I frequently use it to query if someone is on the BES and what their status is etc.

Already in the works...

- -

I'm going to try to set lite.asp up so that it automatically detects if it is trying to render a page for the mobile browser. If so, you will navigate differently (no hidden tables, etc.). As a matter of fact, I'm going to get away from tables if possible.

I have already done some work with the pie charts - getting away from using the MS Office-based charts and using ampie (and others). The new charts are much cooler and are flash based. Alas, they won't be rendered on the BlackBerry, but, really, we're talking about doing some basic stuff on the BB itself, not reporting.

The only problem I'm going to have working on this is I won't be able to test queries that return a lot of results or anything that requires multiple servers. Soooo, I may need everyone's help with that.

sahellis · 03-25-2008, 11:58 PM

Quote:

Originally Posted by Grimlin

What happens when you create an ODBC connection to it from a PC and use the same ID and password?

Successful connection. The funny thing is it took 3 tried. The first 2 came back with errors. I deleted it and tried again. The third time it hooked up with no errors, and now everytime after there are no errors.

I just realised that the serverstatus.asp page doesn't actually work. It doesn't show State or Startup mode but is shows todays date and time.

Do I need to setup the BESuserAdminClient Tool, because I am not.

sahellis · 03-26-2008, 12:20 AM

The problem was my password.
It had a ; in it and I guess you can't do that.

Grimlin · 03-26-2008, 07:22 AM

Quote:

Originally Posted by sahellis

Do I need to setup the BESuserAdminClient Tool, because I am not.

Only if you want to change things on the BES. (set passwords, etc.)

qc_metal · 03-26-2008, 07:46 AM

The serverstatus page validates via WMI to pull the server stats, etc. - so I suspect that there is some code in there that can't handle the ";". I'll put that on the bug list

sahellis · 03-26-2008, 08:00 AM

The ; was in the password on the database user 'berrystats' once I changed it and removed the ; everything but the serverstatus.asp page is working. Not really a big deal for me because I don't know how much I will use that page anyway.

Thanks for all your help.

chrisb009 · 03-26-2008, 10:29 AM

My assumption (without setting BerryStats up) is that someone who is granted privileges within BES (such as help desk) to perform administration duties can administer devices without authenticating as besadmin....and instead authenticate as themselves....as long as the tools are installed. Is this correct?

If this is correct.....has anyone used the tools and BerryStats across domains...and if they have was there any authentication issues across the domains?

BlackBerry Forums Support Community

BerryStats for NonAdmins