3 Jan 2005 12:10

### HELP!

Hi can anyone help me,

I am new to sql and php

I have a windows 2003 server, mysql 4.1.8 and php4.3.10 installed,

I have followed the install instructions to the best of my abilities.

But I am getting a lot of error

Can someone send me a copy of their config.inc.php file so I can see how to configure it.

Thanks

Matthew

4 Jan 2005 16:03

Hi all

I have MRBS running on my solaris 9 and mysql.......

I'm trying to logon as admin using my imap-server as authentication......
But there is absolutely no nothin' happening......I have used imap-auth
in other programs with positive outcome......

Any ideas ?

Best Regards

Gert Espersen
Aalborg Universitet
Det Teknisk Naturvidenskabelige Basisår
Strandvejen 12-14
9000 Aalborg
Tlf:96359739
ge <at> tnb.aau.dk


2 Jan 2005 05:35

### HELP!

Hi can anyone help me,

I am new to sql and php

I have a windows 2003 server, mysql 4.1.8 and php4.3.10 installed,

I have followed the install instructions to the best of my abilities.

When I try to view the index.php in IE on a client computer, I get the following error “Parse error: parse error in c:\inetpub\wwwroot\web\config.inc.php on line 24”

I have included the following attachments: my config.inc.php

And screen dump of  mysqladmin server info page

I have created a user called mrbs and password is mrbs, I have gave it all rights over the mrbs table

Thanks

Matthew

Attachment (config.inc.php): application/octet-stream, 15 KiB
4 Jan 2005 22:54

### Re: HELP!

Hi,

There are quotes missing around the user names and password string.
Try:

$db_login = "mrbs"; # Database login password:$db_password = "mrbs";
(Assuming you have created a MySQL account called "mrbs", with the associated password being "mrbs".)
The default MySQL account you're using (as shown in the image) seems to be:

$db_login = "root"; # Database login password:$db_password = "";
----- Original Message -----
From: Matthew
Sent: Sunday 02 January 2005 05:35
Subject: [MRBS-general] HELP!

Hi can anyone help me,

I am new to sql and php

I have a windows 2003 server, mysql 4.1.8 and php4.3.10 installed,

I have followed the install instructions to the best of my abilities.

When I try to view the index.php in IE on a client computer, I get the following error “Parse error: parse error in c:\inetpub\wwwroot\web\config.inc.php on line 24”

I have included the following attachments: my config.inc.php

And screen dump of  mysqladmin server info page

I have created a user called mrbs and password is mrbs, I have gave it all rights over the mrbs table

Thanks

Matthew

5 Jan 2005 20:43

### connection problem

I am currently using a current version of mrbs with MySQL ver 4.1 and
the latest php on a windows XP box.  I am having connection propblems.
I have created the database mrbs and gave this command

GRANT ALL PRIVILEGES ON mrbs.* TO 'mrbsuser' <at> 'localhost' IDENTIFIED BY
'mrbs';

The config.inc.php file has the following:

###################
# Database settings
###################
# Which database system: "pgsql"=PostgreSQL, "mysql"=MySQL
$dbsys = "MySQL"; # Hostname of database server. For pgsql, can use "" instead of localhost # to use Unix Domain Sockets instead of TCP/IP.$db_host = "localhost";
# Database name:
$db_database = "mrbs"; # Database login user name:$db_login = "mrbsuser";
$db_password = "mrbs"; # Prefix for table names. This will allow multiple installations where only # one database is available$db_tbl_prefix = "mrbs_";
# Uncomment this to NOT use PHP persistent (pooled) database

connections:
# $db_nopersist = 1; and when I try to connect via a web page I get the following error: Fatal error: Call to undefined function mysql_pconnect() in c:\Inetpub\wwwroot\cal\mysql.inc on line 224 Where am I going wrong? Thanks, Rene ================================ Rene Paquin, MCSE Library Network Administrator Wilfrid Laurier University Waterloo, Ontario, Canada (519)884-0710 x3795 rpaquin <at> wlu.ca **********************************************  6 Jan 2005 13:46 ### Re: connection problem Rene Paquin wrote: > I am currently using a current version of mrbs with MySQL ver 4.1 and > the latest php on a windows XP box. I am having connection propblems. > I have created the database mrbs and gave this command > [snip] > > and when I try to connect via a web page I get the following error: > > Fatal error: Call to undefined function mysql_pconnect() in > c:\Inetpub\wwwroot\cal\mysql.inc on line 224 You've not got the MySQL PHP extension installed/enabled. John. -- -- John Beranek To generalise is to be an idiot. http://redux.org.uk/ -- William Blake  6 Jan 2005 14:12 ### Re: connection problem John Beranek wrote: > Rene Paquin wrote: > >> I am currently using a current version of mrbs with MySQL ver 4.1 and >> the latest php on a windows XP box. I am having connection propblems. >> I have created the database mrbs and gave this command >> > [snip] > >> >> and when I try to connect via a web page I get the following error: >> >> Fatal error: Call to undefined function mysql_pconnect() in >> c:\Inetpub\wwwroot\cal\mysql.inc on line 224 > > > You've not got the MySQL PHP extension installed/enabled. Oh, and you're going to come across problems trying to use MySQL 4.1 with PHP on Windows. I tried this and it appears the mysql extension in PHP only supports MySQL <= 4.0.x. John. -- -- John Beranek To generalise is to be an idiot. http://redux.org.uk/ -- William Blake  6 Jan 2005 14:55 ### Re: connection problem Thanks for the heads up. I have rolled back to earlier versions of both and it is now working fine. ================================ Rene Paquin, MCSE Library Network Administrator Wilfrid Laurier University Waterloo, Ontario, Canada (519)884-0710 x3795 rpaquin <at> wlu.ca ********************************************** >>> John Beranek <john <at> redux.org.uk> 1/6/2005 8:12:28 AM >>> John Beranek wrote: > Rene Paquin wrote: > >> I am currently using a current version of mrbs with MySQL ver 4.1 and >> the latest php on a windows XP box. I am having connection propblems. >> I have created the database mrbs and gave this command >> > [snip] > >> >> and when I try to connect via a web page I get the following error: >> >> Fatal error: Call to undefined function mysql_pconnect() in >> c:\Inetpub\wwwroot\cal\mysql.inc on line 224 > > > You've not got the MySQL PHP extension installed/enabled. Oh, and you're going to come across problems trying to use MySQL 4.1 with PHP on Windows. I tried this and it appears the mysql extension in PHP only supports MySQL <= 4.0.x. John. -- -- John Beranek To generalise is to be an idiot. http://redux.org.uk/ -- William Blake ------------------------------------------------------- The SF.Net email is sponsored by: Beat the post-holiday blues Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek. It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt  7 Jan 2005 20:41 ### ldap problem I am almost there. I ahve the calendar working fine and the emailpart of it is also working fine. The last step, and this is where it is not working, is authentication. I am trying to setup ldap authentication and using the values that my campus IT people gave me but whenever I try and log in and authenticate I get a blank white page (the url in the adress field is going to the admin.php page..... is this correct?) Anyway here is my config file with the ldap values that was given to me as the correct ones for this environment. <?php #$Id: config.inc.php,v 1.39.2.2 2004/11/19 22:23:12 gwalker Exp $########################################################################### # MRBS Configuration File # Configure this file for your site. # You shouldn't have to modify anything outside this file. ########################################################################### ################### # Database settings ################### # Which database system: "pgsql"=PostgreSQL, "mysql"=MySQL$dbsys = "MySQL";
# Hostname of database server. For pgsql, can use "" instead of
localhost
# to use Unix Domain Sockets instead of TCP/IP.
$db_host = "localhost"; # Database name:$db_database = "mrbs";
$db_login = "mrbsuser"; # Database login password:$db_password = "****";
# Prefix for table names.  This will allow multiple installations where
only
# one database is available
$db_tbl_prefix = "mrbs_"; # Uncomment this to NOT use PHP persistent (pooled) database connections: #$db_nopersist = 1;

################################
# Site identification information
#################################
$mrbs_admin = "Your Administrator";$mrbs_admin_email = "rpaquin <at> wlu.ca";

# This is the text displayed in the upper left corner of every page.
Either
# type the name of your organization, or you can put your logo like this
:
# $mrbs_company = "<a href=http://www.your_organisation.com/> # <img src=your_logo.gif border=0></a>";$mrbs_company = "WLU Library";

# This is to fix URL problems when using a proxy in the environment.
# If links inside MRBS appear broken, then specify here the URL of
# your MRBS root directory, as seen by the users. For example:
# $url_base = "http://webtools.uab.ericsson.se/oam"; # It is also recommended that you set this if you intend to use email # notifications, to ensure that the correct URL is displayed in the # notification.$url_base = "";

###################
# Calendar settings
###################
# Note: Be careful to avoid specify options that displays blocks
overlaping
# the next day, since it is not properly handled.

# This setting controls whether to use "clock" based intervals (FALSE
and
# the default) or user defined periods (TRUE).  If user-defined periods
# are used then $resolution,$morningstarts, $eveningends, #$eveningends_minutes and $twentyfourhour_format are ignored.$enable_periods = FALSE;

# Resolution - what blocks can be booked, in seconds.
# Default is half an hour: 1800 seconds.
$resolution = 10800; # Start and end of day, NOTE: These are integer hours only, 0-23, and # morningstarts must be < eveningends. See also eveningends_minutes.$morningstarts = 8;
$eveningends = 24; # Minutes to add to$morningstarts to get to the real start of the day.
# Be sure to consider the value of $eveningends_minutes if you change # this, so that you do not cause a day to finish before the start of # the last period. For example if resolution=3600 (1 hour) # morningstarts = 8 and morningstarts_minutes = 30 then for the last # period to start at say 4:30pm you would need to set eveningends = 16 # and eveningends_minutes = 30$morningstarts_minutes = 30;

# Minutes to add to $eveningends hours to get the real end of the day. # Examples: To get the last slot on the calendar to be 16:30-17:00, set # eveningends=16 and eveningends_minutes=30. To get a full 24 hour display # with 15-minute steps, set morningstarts=0; eveningends=23; # eveningends_minutes=45; and resolution=900.$eveningends_minutes = 0;

# Define the name or description for your periods in chronological order
# For example:
# $periods[] = "Period&nbsp;1" #$periods[] = "Period&nbsp;2"
# ...
# or

# ...
# &nbsp; is used to ensure that the name or description is not wrapped
# when the browser determines the column widths to use in day and week
# views

#$periods[] = "Period&nbsp;1"; #$periods[] = "Period&nbsp;2";
#$periods[] = "08:30&nbsp;-&nbsp;011:29" #$periods[] = "11:30&nbsp;-&nbsp;14:29"
#$periods[] = "14:30&nbsp;-&nbsp;17:29" #$periods[] = "17:30&nbsp;-&nbsp;20:29"
#$periods[] = "20:30&nbsp;-&nbsp;23:29" # Start of week: 0 for Sunday, 1 for Monday, etc.$weekstarts = 0;

# Trailer date format: 0 to show dates as "Jul 10", 1 for "10 Jul"
$dateformat = 0; # Time format in pages. 0 to show dates in 12 hour format, 1 to show them # in 24 hour format$twentyfourhour_format = 0;

########################
# Miscellaneous settings
########################

# Maximum repeating entrys (max needed +1):
$max_rep_entrys = 0 +1; # Default report span in days:$default_report_days = 60;

# Results per page for searching:
$search["count"] = 20; # Page refresh time (in seconds). Set to 0 to disable$refresh_rate = 0;

# should areas be shown as a list or a drop-down select box?
$area_list_format = "list"; #$area_list_format = "select";

# Entries in monthly view can be shown as start/end slot, brief
description or
# both. Set to "description" for brief description, "slot" for time slot
and
# "both" for both. Default is "both", but 6 entries per day are shown
# of 12.
$monthly_view_entries_details = "both"; # To view weeks in the bottom (trailer.inc) as week numbers (42) instead of # 'first day of the week' (13 Oct), set this to TRUE$view_week_number = TRUE;

# To display times on right side in day and week view, set to TRUE;
$times_right_side = FALSE; # Control the active cursor in day/week/month views.$javascript_cursor = true; # Change to false if clients have old
browsers
# incompatible with JavaScript.
$show_plus_link = true; # Change to true to always show the (+) link as in # MRBS 1.1.$highlight_method = "hybrid"; # One of "bgcolor", "class", "hybrid".

# Define default starting view (month, week or day)
# Default is day
$default_view = "day"; # Define default room to start with (used by index.php) # Room numbers can be determined by looking at the Edit or Delete URL for a # room on the admin page. # Default is 0$default_room = 0;

###############################################
# Authentication settings - read AUTHENTICATION
###############################################
$auth["session"] = "php"; # How to get and keep the user ID. One of # "http" "php" "cookie" "ip" "host" "nt" "omni".$auth["type"] = "ldap"; # How to validate the user/password. One of
"none"
# "config" "db" "pop3" "imap" "ldap" "nis"
"nw" "ext".

# The list of administrators (can modify other peoples settings)
$auth["admin"][] = "127.0.0.1"; # localhost IP address. Useful with IP sessions.$auth["admin"][] = "administrator"; # A user name from the user list.
Useful
#with most other session schemes.
$auth["admin"][] = "rpaquin"; #$auth["admin"][] = "10.0.0.2";
#$auth["admin"][] = "10.0.0.3"; # 'auth_config' user database # Format:$auth["user"]["name"] = "******";
$auth["user"]["administrator"] = "*****;$auth["user"]["rpaquin"] = "*****";
#$auth["user"]["bob"] = "b"; # 'session_http' configuration settings$auth["realm"]  = "mrbs";

# 'auth_ext' configuration settings
$auth["prog"] = "";$auth["params"] = "";

# 'auth_ldap' configuration settings
# Where is the LDAP server
$ldap_host = "192.54.242.44"; # LDAP base distinguish name # See AUTHENTICATION for details of how check against multiple base dn's$ldap_base_dn = "o=wlu";
# Attribute within the base dn that contains the username
$ldap_user_attrib = "uid"; # 'auth_ldap' extra configuration for ldap configuration of who can use # the system # If it's set, the$ldap_filter will be combined with the value of
# $ldap_user_attrib like this: # (&($ldap_user_attrib=username)($ldap_filter)) # After binding to check the password, this check is used to see that # they are a valid user of mrbs. #$ldap_user_filter = "mrbsuser=y";

# 'auth_imap' configuration settings
# See AUTHENTICATION for details of how check against multiple servers
# Where is the IMAP server
$imap_host = "imap-server-name"; # The IMAP server port$imap_port = "143";

# 'auth_pop3' configuration settings
# See AUTHENTICATION for details of how check against multiple servers
# Where is the POP3 server
$pop3_host = "pop3-server-name"; # The POP3 server port$pop3_port = "110";

###############################################
# Email settings
###############################################

# Set to TRUE if you want to be notified when entries are booked.
Default is
# FALSE

# Set to TRUE if you want AREA ADMIN to be notified when entries are
booked.
# Default is FALSE. Area admin emails are set in room_area admin page.

# Set to TRUE if you want ROOM ADMIN to be notified when entries are
booked.
# Default is FALSE. Room admin emails are set in room_area admin page.

# Set to TRUE if you want ADMIN to be notified when entries are deleted.
Email
settings,
# as well as to booker if MAIL_BOOKER is TRUE (see below).

# Set to TRUE if you want to be notified on every change (i.e, on new
entries)
# but also each time they are edited. Default is FALSE (only new
entries)

# Set to TRUE is you want to show entry details in email, otherwise only
a
# link to view_entry is provided. Irrelevant for deleted entries.
Default is
# FALSE.
define ("MAIL_DETAILS", TRUE);

# Set to TRUE if you want BOOKER to receive a copy of his entries as
well any
# changes (depends of MAIL_ADMIN_ALL, see below). Default is FALSE. To
know
# how to set mrbs to send emails to users/bookers, see INSTALL.
define ("MAIL_BOOKER", FALSE);

# If MAIL_BOOKER is set to TRUE (see above) and you use an
authentication
# scheme other than 'auth_db', you need to provide the mail domain that
will
# be appended to the username to produce a valid email address (ie.
# " <at> domain.com").
define ("MAIL_DOMAIN", '');

# If you use MAIL_DOMAIN above and username returned by mrbs contains
extra
# strings appended like domain name ('username.domain'), you need to
provide
# this extra string here so that it will be removed from the username.

# Set the name of the Backend used to transport your mails. Either
"mail",
# "smtp" or "sendmail". Default is 'mail'. See INSTALL for more details.

#*******************
# Sendmail settings

# Set the path of the Sendmail program (only used with "sendmail"
backend).
# Default is "/usr/bin/sendmail"
define ("SENDMAIL_PATH", "/usr/bin/sendmail");

# Set additional Sendmail parameters (only used with "sendmail"
backend).
# (example "-t -i"). Default is ""
define ("SENDMAIL_ARGS", '');

#*******************
# SMTP settings

# Set smtp server to connect. Default is 'localhost' (only used with
"smtp"
# backend).
define ("SMTP_HOST", "192.54.242.16");

# Set smtp port to connect. Default is '25' (only used with "smtp"
backend).
define ("SMTP_PORT", 25);

# Set whether or not to use SMTP authentication. Default is 'FALSE'
define ("SMTP_AUTH", FALSE);

# Set the username to use for SMTP authentication. Default is ""

# Set the password to use for SMTP authentication. Default is ""

#****************************
# Miscellaneous settings

# Set the language used for emails (choose an available lang.* file).
# Default is 'en'.

# Set the email address of the From field. Default is $mrbs_admin_email define ("MAIL_FROM",$mrbs_admin_email);

# Set the recipient email. Default is $mrbs_admin_email. You can define # more than one recipient like this "john <at> doe.com,scott <at> tiger.com" define ("MAIL_RECIPIENTS",$mrbs_admin_email);

# Set email address of the Carbon Copy field. Default is ''. You can
define
# more than one recipient (see MAIL_RECIPIENTS)
define ("MAIL_CC", '');

# Set the content of the Subject field for added/changed entries.
$mail["subject"] = "Entry added/changed for$mrbs_company MRBS";

# Set the content of the Subject field for deleted fields.
$mail["subject_delete"] = "Entry deleted for$mrbs_company MRBS";

# Set the content of the message when a new entry is booked. What you
type
# here will be added at the top of the message body.
$mail["new_entry"] = "A new entry has been booked, here are the details:"; # Set the content of the message when an entry is modified. What you type # here will be added at the top of the message body.$mail["changed_entry"] = "An entry has been modified, here are the
details:";

# Set the content of the message when an entry is deleted. What you type
# here will be added at the top of the message body.
$mail["deleted_entry"] = "An entry has been deleted, here are the details:"; ########## # Language ########## # Set this to 1 to use UTF-8 in all pages and in the database, otherwise # text gets enterered in the database in different encodings, dependent # on the users' language$unicode_encoding = 0;

# Set this to a different language specifier to default to different
# language tokens. This must equate to a lang.* file in MRBS.
# e.g. use "fr" to use the translations in "lang.fr" as the default
# translations
$default_language_tokens = "en"; # Set this to 1 to disable the automatic language changing MRBS performs # based on the user's browser language settings. It will ensure that # the language displayed is always the value of$default_language_tokens,
# as specified above
$disable_automatic_language_changing = 0; # Set this to a valid locale (for the OS you run the MRBS server on) # if you want to override the automatic locale determination MRBS # performs$override_locale = "";

# faq file language selection. IF not set, use the default english file.
# IF your language faq file is available, set $faqfilelang to match the # end of the file name, including the underscore (ie. for site_faq_fr.html # use "_fr"$faqfilelang = "";

# This next require must be done after the definitions above, as the
definitions
# are used in the included file
require_once "language.inc";

#############
# Entry Types
#############
# This array maps entry type codes (letters A through J) into
descriptions.
# Each type has a color (see TD.x classes in the style sheet mrbs.css).
#    A=Pink  B=Blue-green  C=Peach  D=Yellow      E=Light blue
#    F=Tan   G=Red         H=Aqua   I=Light green J=Gray
# The value for each type is a short (one word is best) description of
the
# type. The values must be escaped for HTML output ("R&amp;D").
# Please leave I and E alone for compatibility.
# If a type's entry is unset or empty, that type is not defined; it will
not
# be shown in the day view color-key, and not offered in the type
selector
# for new or edited entries.

# $typel["A"] = "A"; #$typel["B"] = "B";
# $typel["C"] = "C"; #$typel["D"] = "D";
$typel["E"] = get_vocab("external"); #$typel["F"] = "F";
# $typel["G"] = "G"; #$typel["H"] = "H";
$typel["I"] = get_vocab("internal"); #$typel["J"] = "J";

##########################################
# PHP System Configuration - internal use, do not change
##########################################
# Disable magic quoting on database returns:
set_magic_quotes_runtime(0);

# Make sure notice errors are not reported, they can break mrbs code:
error_reporting (E_ALL ^ E_NOTICE);

# These variables specify the names of the tables in the database
# These should not need to be changed.  Please change $db_tbl_prefix # in the database section above.$tbl_area   = $db_tbl_prefix . "area";$tbl_entry  = $db_tbl_prefix . "entry";$tbl_repeat = $db_tbl_prefix . "repeat";$tbl_room   = $db_tbl_prefix . "room";$tbl_users  = $db_tbl_prefix . "users"; # MRBS developers, make sure to update this string before each release:$mrbs_version = "MRBS 1.2.1";

?>

================================
Rene Paquin, MCSE
Wilfrid Laurier University
(519)884-0710 x3795
rpaquin <at> wlu.ca
**********************************************


7 Jan 2005 22:58

### Re: ldap problem

Rene Paquin wrote:
> I am almost there.  I ahve the calendar working fine and the emailpart
> of it is also working fine.  The last step, and this is where it is not
> working, is authentication.  I am trying to setup ldap authentication
> and using the values that my campus IT people gave me but whenever I try
> and log in and authenticate I get a blank white page (the url in the
> adress field is going to the admin.php page.....  is this correct?)
> Anyway here is my config file with the ldap values that was given to me
> as the correct ones for this environment.

Your config doesn't scream any problems at me...

One problem with the pluggable authentication system at the moment is
the inability of an authentication scheme to pass back any error
message, so generally any problem with authentication is harder to track
down.

However, you could try putting some debug in auth_ldap.inc.

Wherever you see a "return 0" in the authValidateUser try putting
something like:

echo "Error 1\n";
exit;

in front of the return statement.

In this way you'll at least find which part of the ldap authentication
is failing...

Good luck,

John.

--

--
John Beranek                         To generalise is to be an idiot.
http://redux.org.uk/                                 -- William Blake



Gmane