UK WEB HOSTING FORUM FOR DISCUSSION ON WEB HOSTING SERVICE AND SUPPORT
LINUX HOSTING WINDOWS HOSTING PACKAGES SHOPPING CART OSCOMMERCE ZEN CART AGORA
ECOMMERCE HOSTING ASP MSSQL FRONTPAGE HOSTING PHP MYSQL HOSTING DISCUSSION FORUM
CPANEL RESELLER HOSTING DEDICATED SERVER VPS HOSTING PLESK VIRTUOZZO
Quick Search
Your forum announcement here!

  UK Web Hosting | Dedicated Server Windows and Linux VPS Forum > Web Hosting and Domains > MySQL Hosting

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-06-2007, 10:18
Junior Member
 
Join Date: May 2006
Posts: 12
Default sql passwords

hi,

i dont know much about MySQL Server but i can just get around phpmyadmin . i am trying to tackle a small problem i have. i created a forum for a club i run and when a user joins the password they enter gets encrypted as usual . the is another section on the website hosting that has a secure directory. if i want to add a user from the forum to that directory i thought i could get there password they originally put into the forum database and manually put it into the secure directory so they would have the same user name for both if they were able to avail of both.

at the moment i cant get the password decrypted and people have to use two logins one for the board and one for the secure directory.

any ideas how i could get around this ?

thanks
__________________
L1 was my nickname at school
Reply With Quote
  #2 (permalink)  
Old 06-06-2007, 20:18
247h's Avatar
Premium Member
 
Join Date: Nov 2006
Location: Buckingham UK
Posts: 261
Send a message via AIM to 247h Send a message via MSN to 247h Send a message via Yahoo to 247h
Default

You don't seem to be attracting any answers — my thoughts on this are that I don't understand enough of the detail of what you're using and the purpose of what you're trying to do? I presume this folder you're allowing them access to is a regular folder off of the domain root?

If so, even if you could extract an encrypted password from the forum database, how would this benefit either you or the user when it seems that (according to the tests I conducted) it will be encrypted differently in /.htpasswds/foldername (where passwords are stored for protected folders)?

I guess you mean that to login to the forum, or login to the folder, they use exactly the same username and password, but you're unable to create the folder permissions without them revealing their passwords to you? Or have I misunderstood you?
__________________
Gadge

Too many nice toys — too little time to play with 'em!

Last edited by 247h; 06-06-2007 at 20:21.
Reply With Quote
  #3 (permalink)  
Old 07-06-2007, 06:16
steppen's Avatar
Member
 
Join Date: May 2007
Location: Norway
Posts: 36
Send a message via MSN to steppen Send a message via Skype™ to steppen
Default

What platform are you at (Linux/Windows/other), and what forum software are you running (vBulletin/SMF/phpBB*/*nuke*/other)?
__________________
Stein

Last edited by steppen; 07-06-2007 at 06:19. Reason: simplified question
Reply With Quote
  #4 (permalink)  
Old 07-06-2007, 09:22
Junior Member
 
Join Date: May 2006
Posts: 12
Default

its hosted hon euk with linux and i have phpbb3
__________________
L1 was my nickname at school
Reply With Quote
  #5 (permalink)  
Old 07-06-2007, 11:15
WelshTom's Avatar
Moderator
 
Join Date: May 2007
Location: Newport, Wales
Posts: 870
Send a message via AIM to WelshTom Send a message via MSN to WelshTom Send a message via Yahoo to WelshTom
Default

All passwords in a phpBB3 database are encrypted using an MD5 hash.

It's virtually impossible to decrypt MD5 hashes, but you should be able to find out their passwords before it is encrypted into MD5 format.

You could fiddle with the registration and login files on phpBB3 for this.

Anyway, you shouldn't be using phpBB3 on a live environment since its only a release candidate, and has unfixed errors.
__________________
Thomas Williams

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Freephone: 0800 622 6352
Reply With Quote
  #6 (permalink)  
Old 07-06-2007, 11:58
eUKhost.com's Avatar
Chief Marketing Officer
 
Join Date: Sep 2005
Posts: 4,563
Send a message via AIM to eUKhost.com Send a message via MSN to eUKhost.com
Default

There's no need to decrypt those passwords.

simply share that database with another php script on which people will login first and once they get redirected on the forum then the forum will authenticate referral from successful login page only. one of our developers had implemented this functionality so I am quite sure that you can make it work.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
||
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
||
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Toll Free : 0808 262 0255 || MSN : mark @ eukhost.com || AIM : eukmark
A bunch of Sheep led by a Lion is better than a bunch of Lions led by a Sheep.
__________________________________________________

Great Opportunity :: Join our
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
for FREE and earn 20% commission on each referral.
Reply With Quote
  #7 (permalink)  
Old 07-06-2007, 13:40
DPS Computing's Avatar
Premium Member
 
Join Date: Apr 2007
Location: Manchester, United Kingdom
Posts: 4,951
Send a message via ICQ to DPS Computing Send a message via AIM to DPS Computing Send a message via MSN to DPS Computing Send a message via Yahoo to DPS Computing Send a message via Skype™ to DPS Computing
Default

Quote:
Originally Posted by eukhost.com View Post
There's no need to decrypt those passwords.

simply share that database with another php script on which people will login first and once they get redirected on the forum then the forum will authenticate referral from successful login page only. one of our developers had implemented this functionality so I am quite sure that you can make it work.
I was trying to think to answers for this question all yesterday and was looking for a complex one - sometimes the simpliest answers are the best and it has shown in this case.

Why did I not think about sharing the database!
__________________
David Smith
DPS Computing

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
- New site / new polls / new stories! With many more to follow!
NEW LAUNCH!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

NEW LAUNCH!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT. The time now is 19:23.

 

Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by Web Hosting 3.1.0
Copyright © 2001-2008, eUKhost.com. All rights reserved.

 
Site Map

VPS Hosting
VPS Hosting plans

Dedicated Server Hosting
Dedicated Server plans

Business Web Hosting
100% uptime Hosting

Cpanel Hosting
cPanel Shared Hosting

Reseller Hosting
Reseller Web Hosting

Windows Hosting
Windows Shared Hosting

Windows VPS

Windows VPS Hosting

Semi Dedicated Servers
Semi-Dedicated Hosting

Dedicated Server Mirroring
Dedicated Server Mirroring

Webhosting Knowledgebase
Frequently asked Questions

Web Hosting Blog
eUKhost Blog

Web Hosting Support
Support Helpdesk

UK Data Center
eUKhost Datacenter

Web Hosting Forum
eUKhost Forum

Support Tutorials
Online Flash Tutorials

Offsite Back-up Plans
Remote Backup Service

Customer Testimonials
eUK Customer Testimonials


knowledgebase articles

eUKhost.com Services

Pre-Sales Questions
Pre-sales FAQ's

Domain Names
Domain registration FAQ's

cPanel Hosting
cPanel Hosting FAQ's

Windows Web Hosting
Plesk Control Panel

Reseller Hosting
Reseller Hosting FAQ's

VPS Hosting
Virtual Private Server

Semi-Dedicated Servers
Semi-Dedicated FAQ's

Dedicated Servers
Dedicated Server Hosting


popular blog categories


Web Hosting
Website Hosting articles

UK Web Hosting
UK Hosting articles

Dedicated Server Hosting
Dedicated Server guidelines

VPS Hosting
VPS hosting articles

cPanel Hosting
cPanel Hosting articles

Linux Operating System
Linux Operating techniques

Windows Web Hosting
Windows plesk articles