Home · Links · Contact Us
Home arrow Forums
Home
Features
FAQ
Screen Shots
Modules
Themes
Demos
Documentation
Forums
Contact Us
Download
Purchase
Quotes

" ... I want to tell you that your thyme product is functional and valuable beyond words. I cannot imagine why any portal would be without it. It is the cornerstone of our new project ..."

" ... Thanks for such a complete project, its making my job much easier. ..."

" ... I have now deployed 4 different calendars and our users love them ... "

" ... Easy to install and use and a great look/design. ..."

" ... This has to be the easiest to use program I think I've had to deal with at all this year. ..."


  FAQFAQ    SearchSearch  RegisterRegister   Log inLog in 
Generic MySQL Authentication - no errors, no users

 
Post new topic   Reply to topic     Forum Index -> Web site integration
View previous topic :: View next topic  
Author Message
pkbarbiedoll



Joined: 12 Sep 2008
Posts: 15

PostPosted: Fri Sep 12, 2008 5:26 pm    Post subject: Generic MySQL Authentication - no errors, no users Reply with quote

Hi, I edited auth.php with settings from my server, and uploaded the auth-mysql folder to the modules/ subfolder. The auth-mysql folder is readable by the webserver.

I am unable to log in with my specified admin account. Actually, the only way I can log in is to enter the previous thyme admin/pass combo.

Here are the auth settings, critical data changed obviously:

Quote:
$_cal_auth_sql['db_name'] = 'db';
$_cal_auth_sql['db_user'] = 'dbuser';
$_cal_auth_sql['db_pass'] = 'dbpassword';

$_cal_auth_sql['db_host'] = 'localhost';
$_cal_auth_sql['db_port'] = '3306';

$_cal_auth_sql['table'] = 'myusertable'; # name of table containing users

$_cal_auth_sql['userid'] = 'user_id'; # unique id # of user
$_cal_auth_sql['username'] = 'username'; # login username
$_cal_auth_sql['email'] = 'user_email'; # e-mail address
$_cal_auth_sql['pass'] = 'password'; # password field
$_cal_auth_sql['name'] = array('user_name_first','user_name_last'); # user's common name.
$_cal_auth_sql['name_key'] = 1;

$_cal_auth_sql['admin'] = 'superduperuser';
$_cal_auth_sql['append_query'] = 'active = 1';
$_cal_auth_sql['auth_func'] = 'SHA1';

$_cal_auth_sql['debug'] = 1;


What am I doing wrong?
Back to top
View user's profile Send private message
pkbarbiedoll



Joined: 12 Sep 2008
Posts: 15

PostPosted: Fri Sep 12, 2008 5:32 pm    Post subject: Reply with quote

Nevermind - I uploaded auth.php to the wrong folder. Once I copied to the /modules/auth folder I was able to log in with my existing user table data (and all the users are populated).

Everything is working nicely now - thanks. Smile
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Web site integration All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
© 2005 eXtrovert software unless otherwise noted. All rights reserved.
Portions © 2004 Ben Brown. All rights reserved.
Trademarks are property of their respective owners.