Simple Blog .NET

NEW POST: Creating users and e-mail notifications

paulkolo — Wed, 19 Mar 2008 11:29:15 GMT

Hey there

These may be stupid questions, but how do I create new users in Simple Blog.NET.
I've installed it i.e. ran the SQL scripts, web-pages in virtual directory, connection string admin etc.
But I don't see an option on the interface to create users. I'd also like it if the users can receive email
notifications on a new post etc. Is that possible with Simple Blog.NET. Maybe I thought that I'm missing
some web-pages? Here are the pages I have:

Archive.aspx
Article.aspx
Default.aspx
Default.master
Downloads.aspx
GetFile.aspx
Login.aspx

Source code checked in

rrife — Sun, 21 Oct 2007 02:19:54 GMT

Source code checked in

rrife — Sat, 20 Oct 2007 04:15:40 GMT

Source code checked in

rrife — Sat, 20 Oct 2007 03:59:04 GMT

Source code checked in

rrife — Sat, 20 Oct 2007 03:45:44 GMT

Source code checked in

rrife — Sat, 20 Oct 2007 03:43:43 GMT

UPDATED WIKI: Home

rrife — Fri, 20 Apr 2007 00:10:33 GMT

4/19/2007 Changes
I've made dozens of fixes and correctted some problems I was having with TFS. The new code has support for photo galleries, static pages, pinned articles, etc. A new official release should be available soon.

11/05/2006 Changes
I've checked in more changes that address some bug fixes and missing functionality that is required to make the site operate that I ran into these issues while setting up ryanandkimberly.com.

SQL 2000 Support
If you're going to run SBN on a SQL 2000 database, you'll need to rename sys.objects to sysobjects and "objectid = OBJECTID" to "id = OBJECT_ID" in the change scripts and stored procedures.

10/22/2006 Changes
I checked in a huge set of changes, including several database changes. The code includes numerous fixes and several security enhancments to prevent people from posting spam in your blogs. Things include: optional user registration, software autoposter prevention, maximum login attempts, ip address blocking and several GUI enhancements. If you're updating an existing database you'll need to make sure you publish your existing blog entries before they'll reappear on your site.

Changes
I made several changes recently and you'll need to make sure to run the change scripts and the new stored procedures (not the ones in the V2 folder) regardless if you have an old database or if you just created a new one from the create scripts.

Simple Blog .Net (SBN)
SBN is simple to setup, simple to use blogging application build on top of the .Net 2.0 framework and SQL 2005 (although it'll work in 2000).

Release 2 is available at http://www.infinityball.net, it has some issues (nothing major) that I'm working on right now and I should have a stable release on CodePlex soon. Or you can just download Change Set 3222 or higher.

Requirements
-SQL Server 2005 (2000 works too)
-Web server capable of running ASP.Net 2.0 code
-Privledges to setup the database and web site

Installation
Installation is pretty easy. First you need to download the latest source code or grab one of the releases (shouldn't make a big difference unless you're already running an old version of SBN). Both the release and source contain a folder called "SimpleBlogData", inside that folder is a "Create Scripts" folder. This contains the sql script that will build the initial database or upgrade your current DB to the latest version. In SQL Server, create a new, empty database (i.e. SimpleBlog), then run the create script on the that database. This will setup the tables and stored procedures you need to run SBN. Depending on your SQL Server security setup you'll most likely have to create a SQL user that can access the DB and you may have to give that user execute permissions on the stored procedures. Once that is done, you'll need to copy the contents of the "SimpleBlogWeb" folder that came with the source or release to the server where you'll be hosting SBN. Next you'll need to modify the web.config file found in the root of the SBN web site you're creating. Modify the ConnectionString property and SMTPServer properties to match the settings for your web site. Once that is done you should be able to visit your SBN web site and you will be prompted to setup the admin user. After that the site should be fully operational.

Lost Admin Password
If you lost your admin password, the only way to recover it is to modify the sbusers table in the database. To reset the password, find your admin user account in sbusers and modify the password field to be "admin". The word "admin" is a reserved word that will not require or be encrypted to login, this will allow you to login with the password 'admin' and change it to something more secure through the settings page.

Planned Features

AJAX enabled image gallery
Enhanced settings page
SimpleNav control will be database driven
Toolbar navigation control
Themes
RSS support (available in the latest build and currently being tested at http://www.infinityball.net/rss.aspx
Rich text editor for article entry
Article and comment ranking system

Sites Using SBN
http://www.infinityball.net
http://www.ryanandkimberly.com
http://www.jdhsreunion.com

UPDATED WIKI: Home

rrife — Fri, 20 Apr 2007 00:09:17 GMT

4/19/2007 Changes
I've made dozens of fixes and correctted some problems I was having with TFS. The new code has support for photo galleries, static pages, pinned articles, etc.

11/05/2006 Changes
I've checked in more changes that address some bug fixes and missing functionality that is required to make the site operate that I ran into these issues while setting up ryanandkimberly.com.

SQL 2000 Support
If you're going to run SBN on a SQL 2000 database, you'll need to rename sys.objects to sysobjects and "objectid = OBJECTID" to "id = OBJECT_ID" in the change scripts and stored procedures.

10/22/2006 Changes
I checked in a huge set of changes, including several database changes. The code includes numerous fixes and several security enhancments to prevent people from posting spam in your blogs. Things include: optional user registration, software autoposter prevention, maximum login attempts, ip address blocking and several GUI enhancements. If you're updating an existing database you'll need to make sure you publish your existing blog entries before they'll reappear on your site.

Changes
I made several changes recently and you'll need to make sure to run the change scripts and the new stored procedures (not the ones in the V2 folder) regardless if you have an old database or if you just created a new one from the create scripts.

Simple Blog .Net (SBN)
SBN is simple to setup, simple to use blogging application build on top of the .Net 2.0 framework and SQL 2005 (although it'll work in 2000).

Release 2 is available at http://www.infinityball.net, it has some issues (nothing major) that I'm working on right now and I should have a stable release on CodePlex soon. Or you can just download Change Set 3222 or higher.

Requirements
-SQL Server 2005 (2000 works too)
-Web server capable of running ASP.Net 2.0 code
-Privledges to setup the database and web site

Installation
Installation is pretty easy. First you need to download the latest source code or grab one of the releases (shouldn't make a big difference unless you're already running an old version of SBN). Both the release and source contain a folder called "SimpleBlogData", inside that folder is a "Create Scripts" folder. This contains the sql script that will build the initial database or upgrade your current DB to the latest version. In SQL Server, create a new, empty database (i.e. SimpleBlog), then run the create script on the that database. This will setup the tables and stored procedures you need to run SBN. Depending on your SQL Server security setup you'll most likely have to create a SQL user that can access the DB and you may have to give that user execute permissions on the stored procedures. Once that is done, you'll need to copy the contents of the "SimpleBlogWeb" folder that came with the source or release to the server where you'll be hosting SBN. Next you'll need to modify the web.config file found in the root of the SBN web site you're creating. Modify the ConnectionString property and SMTPServer properties to match the settings for your web site. Once that is done you should be able to visit your SBN web site and you will be prompted to setup the admin user. After that the site should be fully operational.

Lost Admin Password
If you lost your admin password, the only way to recover it is to modify the sbusers table in the database. To reset the password, find your admin user account in sbusers and modify the password field to be "admin". The word "admin" is a reserved word that will not require or be encrypted to login, this will allow you to login with the password 'admin' and change it to something more secure through the settings page.

Planned Features

AJAX enabled image gallery
Enhanced settings page
SimpleNav control will be database driven
Toolbar navigation control
Themes
RSS support (available in the latest build and currently being tested at http://www.infinityball.net/rss.aspx
Rich text editor for article entry
Article and comment ranking system

Sites Using SBN
http://www.infinityball.net
http://www.ryanandkimberly.com
http://www.jdhsreunion.com

Source code checked in

rrife — Sat, 14 Apr 2007 17:26:07 GMT

Source code checked in

rrife — Sat, 14 Apr 2007 16:34:47 GMT

Source code checked in

rrife — Sat, 14 Apr 2007 16:30:26 GMT

Source code checked in

rrife — Sat, 14 Apr 2007 16:29:27 GMT

Source code checked in

rrife — Sat, 14 Apr 2007 16:28:15 GMT

Source code checked in

rrife — Sat, 14 Apr 2007 16:23:55 GMT

Source code checked in

rrife — Thu, 12 Apr 2007 21:56:41 GMT

Source code checked in

rrife — Thu, 12 Apr 2007 21:48:45 GMT

Source code checked in

rrife — Thu, 12 Apr 2007 21:46:01 GMT

Source code checked in

rrife — Thu, 12 Apr 2007 21:13:07 GMT

Source code checked in

rrife — Thu, 12 Apr 2007 21:03:09 GMT

Source code checked in

rrife — Thu, 12 Apr 2007 20:33:30 GMT