phpScheduleIt
May 24, 2013, 09:03:50 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: phpScheduleIt 2.4.2 has been released!
 
   Home   Help Login Register  
Pages: [1]
  Print  
Author Topic: Installation failed  (Read 469 times)
NicoBoots
Newbie
*

Karma: 0
Posts: 5


« on: August 18, 2012, 07:10:36 AM »

On my computer with Window 7 Home Premium I am running an Apache server and MySQL (XAMMP). To evaluate the usefulness of phpScheduleIt, I downloaded and unzipped the download into the the folder C:\XAMMP\htdocs, the root of the apache server. I have copied/pasted the config.dist.php file as config.php in de same config folder.  Using phpAdmin I imported the following files in a new MySql database (phpscheduleit2): database_schema/create-db.sql", database_schema/schema-utf8.sql, and database_schema/create-user.sql . Yhen I have changed the passwords of "admin" and "user" in the the user table into repectively admin and user.
To be sure I also made in the config file the following changes:

Database configuration
 */
$conf['settings']['database']['type'] = 'mysql';
$conf['settings']['database']['user'] = 'root';        // database user with permission to the phpScheduleIt database
$conf['settings']['database']['password'] = '';
$conf['settings']['database']['hostspec'] = 'localhost';        // ip, dns or named pipe
$conf['settings']['database']['name'] = 'phpscheduleit2';

where user 'root' has no password and all privileges.

When I start http://localhost/phpScheduleIt/Web/ I see the log-in page but when I enter one of the usernames (admin, user or root) and their passwords I get an "unknown error", and there the program ends.

I am at a loss how to proceed. Can someone help me with the installation?

Logged
NicoBoots
Newbie
*

Karma: 0
Posts: 5


« Reply #1 on: August 18, 2012, 09:06:19 AM »

By the way, why is there no decent manual/installation description supplied to help a newcomer to overcome the problems I've encountered.

Hello? Is there a moderator available to do this job?
Logged
jschendel
Newbie
*

Karma: 0
Posts: 20


« Reply #2 on: August 18, 2012, 09:18:16 AM »

I'm still a newbie, but I've used this program many times.
Seems to me you've followed the instructions to the letter; though I've always worked with a host and not installed locally. 
I can only suggest that you revert back to the original password for the admin and user accounts and try to change them from within the program.  Also, I'd go ahead and create a password for the database user and put that in the config file.  I also noticed you have:
Code:
$conf['settings']['database']['password'] = '';
and if you don't have a password wouldn't it be
Code:
$conf['settings']['database']['password'] = "'';
Like I said, newbie here, but that's what I'd try.  Responses are pretty slow around here, but Nick wil eventually get to you!
Logged
NicoBoots
Newbie
*

Karma: 0
Posts: 5


« Reply #3 on: August 20, 2012, 06:44:17 AM »

To be sure I did everything OK I've added to the MySql table phpSchedulIt2/Users a new user, password and email. I left a blank the salt-value for this user (this user has also all privileges for the whole MySql datebase).
Subsequently, I changed in config.php:
"$conf['settings']['admin.email'] = 'my-email-address';"

In config.php I changed the databse configuration as follows:
$conf['settings']['database']['type'] = 'mysql';
$conf['settings']['database']['user'] = 'new-user';        // database user with permission to the phpScheduleIt database
$conf['settings']['database']['password'] = 'new-user-password';
$conf['settings']['database']['hostspec'] = 'localhost';        // ip, dns or named pipe
$conf['settings']['database']['name'] = 'phpscheduleit2';


Going to localhost/phpSscheduleIt first I get the following message:
"Please update the $conf['settings']['script.url'] setting in your config file to be http://localhost/phpScheduleIt/Web
You will be redirected automatically in 20 seconds, but portions of phpScheduleIt will not function correctly."

In the config.php file we see:
"$conf['settings']['script.url'] = 'http://localhost/phpScheduleIt/Web';", thus as requested in this message

Then I am presented with the login screen. When I now enter the new-username and password, or new user-email and password, I get the message that "We could not match your username or password".

To be sure that there is a proper connection to the MYSql database I defined in Dreamweaver a new site phpScheduleIt and used Dreamweaver's wizard to connect to database phpScheduleIt2 (using the new-username and password), which it did. In the root of the new site a Connection folder was created which contained the file PHPScheduleIt.php. My conclusion the connection to the database is can be established.

What else can I do?
Logged
Nick
Administrator
Hero Member
*****

Karma: 15
Posts: 5419


WWW
« Reply #4 on: August 20, 2012, 12:47:16 PM »

You'll need to register a user through phpScheduleIt in order to log in. Manually adding data to the database will not work.

If you're still seeing errors, I'd suggest turning on logging. That should give you details as to what's going wrong.
Logged
NicoBoots
Newbie
*

Karma: 0
Posts: 5


« Reply #5 on: August 21, 2012, 04:37:14 AM »

How can I register a new user if I cannot even pass the login page? To overcome that obstacle I decided to add a new user directly in the database itself!
Logged
NicoBoots
Newbie
*

Karma: 0
Posts: 5


« Reply #6 on: August 21, 2012, 04:54:58 AM »

Nick,
I followed the instructions in the readme_installation file to turn on logging, thus I changed level value to ERROR. Next I have opened localhost/phpScheduleIt and entered in the login page all the three users and their passwords.
In c:\temp there are two files created: log_20120821 and sql_log_20120821, however both are empty! Apparently nothing has been registered.
Logged
Nick
Administrator
Hero Member
*****

Karma: 15
Posts: 5419


WWW
« Reply #7 on: August 21, 2012, 02:05:24 PM »

Quote
How can I register a new user if I cannot even pass the login page?

There is a link on the login page to create a new account. If you're not seeing that, then set $conf['settings']['allow.self.registration'] = 'true';
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2006-2007, Simple Machines Valid XHTML 1.0! Valid CSS!