Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Remote Log ViewerRemote Log Viewer
Previous
 
Next
New Post
7/15/2007 8:24 AM
 

Hello

With time I have been creating several sites in Dotnetnuke for clients, friends and the own ones… At this moment I administer several web sites and i try to maintain a minimum control of the eventlog to find errors and to improve the performance of Dotnetnuke in all these sites.

Since the Event Log is available Only for users HOST'S I find with the problem to remember the different passwords to access like Host in each one from the sites that I administer. For that reason I have created this utility in the form of 2 modules for Dotnetnuke:

The SGW_Servidores module or “Servers Module” allows to store encrypted in the data base the different values necessary to connect to the database. (Basically they are the connection strings). 

On the other hand the SGW_RemoteViewer module is a duplicate of the event log viewer original module of dotnetnuke with the exception of which in the layers Controller, Dataprovider and SQLDataprovider I have added to each one of the functions a new parameter (byval Connection as string) that passage until executing the procedure in the corresponding server.

At the moment for visualizing the list of events a server can be selected via dropdownlist.

The final result is: two modules SGW_Servidores and Sgw_Remotelogviewer that can be added to any installation of Dotnetnuke and allow to visualize log of any site remote dotnetnuke …

At this moment I use this system successfully in one dotnetnuke local. In this way from a single screen I can see the Log of different Web sites. I want to share with you this software who I believe that it can be useful, I offer in source code form both and modules in form of installable modules standard in www.javieranto.com 

What do you think about this?

 
New Post
7/16/2007 9:44 AM
 

I think this is a very good idea and something that can help a majority of site admins.

I personally use sites with secure db channels so for me to use something like this from a local installation I would still need to open the secure channels to the db's first, but in a lot of ways I think my situation is a bit unusual.


-Mitchel Sellers
Microsoft MVP, ASPInsider, DNN MVP
CEO/Director of Development - IowaComputerGurus Inc.
LinkedIn Profile

Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Performance Tips, DNN Consulting Quotes, and DNN Technical Support Services
 
New Post
7/18/2007 6:12 AM
 

Hello Mitchell and thanks for your comments

For me this module is very useful but i'm a doubt about my way of working in this module...

Really I'm connecting one installation of DNN in my computer local with one server SQL Server in Internet.

I'm passing the credentials of SQL Server from my computer at home over Internet... Do you think that this is "Dangerous"?... Are the connection string passing in plain text over Internet?

 
New Post
7/18/2007 8:50 AM
 

Well, yes in a way it is "dangerous" becuase you are 100%  correct that the connection string is sent unencrypted over the internet.

A potential better LONG term solution would be to build a web service into each DNN installation that you can remotely connect to and retreive the data.  Michael Washington's IWeb Module (http://iweb.adefwebserver.com) I think would suit the needs very well as you can implement security on the requests etc. 


-Mitchel Sellers
Microsoft MVP, ASPInsider, DNN MVP
CEO/Director of Development - IowaComputerGurus Inc.
LinkedIn Profile

Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Performance Tips, DNN Consulting Quotes, and DNN Technical Support Services
 
New Post
7/18/2007 12:36 PM
 

Hello Mitchell

me imagined it… I'm agree with you in which the long term solution is to use web services for query the database.

Thank you very much for the link, I am going to watch it with more detail as soon as it has a little free time…

 

 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Remote Log ViewerRemote Log Viewer


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out