General discussion of MRBS (Meeting Room Booking System)

oren levin | 1 Sep 2007 20:14

Re: Transfer MRBS to remote host

Thank you for the quick replay The hosting company (GoDaddy) DB configuration page writes the following options:

--------------------------------------------------------------------------------------------

ODBC 3.51:
DRIVER={MySQL ODBC 3.51 Driver}; SERVER=h41mysql33.secureserver.net; PORT=3306; DATABASE=mrbs1 USER=DB Username; PASSWORD='your password'; OPTION=0;

OLE DB, OleDbConnection (.NET):
Provider=MySQLProv; Data Source=h41mysql33.secureserver.net; Initial Catalog=mrbs1; User ID=DB Username; Password='your password';

Connector/Net 1.0 (.NET):
Server=h41mysql33.secureserver.net; Port=3306; Database=mrbs1; Uid=DB Username; Pwd='your password';

---------------------------------------------------------------------------------

I've modified the config.inc.PHP file in the following matter:

$db_host = "h41mysql33.secureserver.net";
$db_database = "mrbs1";
$db_login = "DB Username";
$db_password = 'DB Password';

I'm still getting "Fatal Error: Failed to connect to database"

1. Do I need to change something else in the file ? (tbl prefix or nopersist ?)
2. Is there other file that need to be modified ? (mysql.inc for example)

Important again to mention that this MRBS folder is working perfect on my local server

Thanks

Date: Thu, 30 Aug 2007 12:25:57 +1000
From: Peter.Moulding <at> its.mq.edu.au
To: mrbs-general <at> lists.sourceforge.net
Subject: Re: [MRBS-general] Transfer MRBS to remote host

Your hosting company should tell you how to connect to the database. They usually tell you the server, database name, user name, and user password. You set those in your config file.

Individual hosting companies have many varieties of configuration and, even within one company, they might have servers set up in different ways. They might have online pages with the details. if not, place a request in their online ticket system.

>>> oren levin <oren_l <at> hotmail.com> 8/29/2007 11:43 PM >>>

Hello

I have a working MRBS installed on our intranet IIS server, works perfect !

Now I'm trying to move it to an external hosting, I've opened an account on GODADDY which support MYsql an PHP

I moved via FTP the content of the working MRBS directory

Changed the $db_host = at the config.inc.php according to the hosting server parameters

And imported the MRBS tables to a new DB there

When trying to lunch the index.php page all I get is "Fatal Error: Failed to connect to database"

Does anyone know how to Implement the MRBS on a remote host ?

Thanks

See what you’re getting into…before you go there See it!

Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! Try it!

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/

_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general

headers

Peter Moulding | 3 Sep 2007 01:09

Re: Transfer MRBS to remote host

Hello Oren,
It looks like your ISP is hosting your site on Windows. They use ODBC
to connect to MySQL instead of the native MySQL drivers. I found only
one reference to ODBC and MRBS, where someone asks about ODBC and there
is no reply:
http://osdir.com/ml/calendars.meeting-room-booking-system.general/2003-12/msg00011.html

You could make a copy of mysql.inc as odbc.inc, change the code to use
odbc instead of mysql, then change
$dbsys = "mysql";
to
$dbsys = "odbc";

The ODBC code is similar to the MySQL code and also to the PostgreSQL
code in pgsql.inc. The MySQL functions have the connection as an
optional second parameter but the ODBC functions have them as a
compulsory first parameter similar to the PostgreSQL functions. You
might find the coding easier if you look atpgsql.inc in parallel to
mysql.inc.

You could try talking Godaddy into using native MySQL connectors, which
are just as easy to use as ODBC. I use both on Windows and both on
Linux. There is little difference except a slight speed advantage for
native MySQL drivers in some circumstances. ODBC wins when the database
is on a different operating system to the Web server.

You could ask Godaddy to move your site to a Linux server; they have
both. Moving you to Linux would not help unless the MySQL database was
also moved to Linux. It is easier to switch on the MySQL drivers in
Windows.

Peter

>>> oren levin <oren_l <at> hotmail.com> 9/2/2007 4:14 AM >>>

Thank you for the quick replay The hosting company (GoDaddy) DB
configuration page writes the following options:

--------------------------------------------------------------------------------------------
ODBC 3.51: DRIVER={MySQL ODBC 3.51 Driver};
SERVER=h41mysql33.secureserver.net; PORT=3306; DATABASE=mrbs1 USER=DB
Username; PASSWORD='your password'; OPTION=0;

OLE DB, OleDbConnection (.NET): Provider=MySQLProv; Data
Source=h41mysql33.secureserver.net; Initial Catalog=mrbs1; User ID=DB
Username; Password='your password'; 
Connector/Net 1.0 (.NET): Server=h41mysql33.secureserver.net;
Port=3306; Database=mrbs1; Uid=DB Username; Pwd='your password'; 
---------------------------------------------------------------------------------

I've modified the config.inc.PHP file in the following matter:

$db_host = "h41mysql33.secureserver.net";
$db_database = "mrbs1";
$db_login = "DB Username";
$db_password = 'DB Password';

I'm still getting "Fatal Error: Failed to connect to database"

1. Do I need to change something else in the file ? (tbl prefix or
nopersist ?)
2. Is there other file that need to be modified ?  (mysql.inc for
example)

Important again to mention that this MRBS folder is working perfect on
my local server

Thanks

Date: Thu, 30 Aug 2007 12:25:57 +1000
From: Peter.Moulding <at> its.mq.edu.au 
To: mrbs-general <at> lists.sourceforge.net 
Subject: Re: [MRBS-general] Transfer MRBS to remote host

Your hosting company should tell you how to connect to the database.
They usually tell you the server, database name, user name, and user
password. You set those in your config file.
Individual hosting companies have many varieties of configuration and,
even within one company, they might have servers set up in different
ways. They might have online pages with the details. if not, place a
request in their online ticket system.

>>> oren levin <oren_l <at> hotmail.com> 8/29/2007 11:43 PM >>>
Hello
I have a working MRBS installed on our intranet IIS server, works
perfect !
Now I'm trying to move it to an external hosting, I've opened an
account on GODADDY which support MYsql an PHP
I moved via FTP the content of the working MRBS directory
Changed the $db_host =  at the config.inc.php according to the hosting
server parameters
And imported the MRBS tables to a new DB there

When trying to lunch the index.php page all I get is "Fatal Error:
Failed to connect to database"

Does anyone know how to Implement the MRBS on a remote host ?

Thanks

See what you’re getting into…before you go there See it! (
http://newlivehotmail.com/?ocid=TXT_TAGHM_migration_HM_viral_preview_0507
) 
Invite your mail contacts to join your friends list with Windows Live
Spaces. It's easy! Try it! (
http://spaces.live.com/spacesapi.aspx?wx_action=create&amp;wx_url=/friends.aspx&amp;mkt=en-us
) 

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general

headers

John Beranek | 3 Sep 2007 12:58

Re: Transfer MRBS to remote host

oren levin wrote:
> 
> Thank you for the quick replay The hosting company (GoDaddy) DB
> configuration page writes the following options:
>  
> *--------------------------------------------------------------------------------------------*
> 
>     * *ODBC 3.51: *
>     * *DRIVER={MySQL ODBC 3.51 Driver};
>       SERVER=h41mysql33.secureserver.net; PORT=3306; DATABASE=mrbs1
>       USER=DB Username; PASSWORD='your password'; OPTION=0; *
> 
>     * *OLE DB, OleDbConnection (.NET): *
>     * *Provider=MySQLProv; Data Source=h41mysql33.secureserver.net;
>       Initial Catalog=mrbs1; User ID=DB Username; Password='your
>       password'; *
> 
>     * *Connector/Net 1.0 (.NET): *
>     * *Server=h41mysql33.secureserver.net; Port=3306; Database=mrbs1;
>       Uid=DB Username; Pwd='your password'; *
> 
>     *---------------------------------------------------------------------------------*
>      
>     I've modified the config.inc.PHP file in the following matter:
>      
>     $db_host = "h41mysql33.secureserver.net";
>     $db_database = "mrbs1";
>     $db_login = "DB Username";
>     $db_password = 'DB Password';

I rather imagine your database username and password are not 'DB
Username' and 'DB Password'!!!

Did you not get given/choose more personal username and password?

>     I'm still getting "Fatal Error: Failed to connect to database"

I expect you've still got the connection details wrong.

>     1. Do I need to change something else in the file ? (tbl prefix or
>     nopersist ?)

No.

>     2. Is there other file that need to be modified ?  (mysql.inc for
>     example)

No.

John.

--

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

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/

headers

John Beranek | 3 Sep 2007 13:00

Re: Transfer MRBS to remote host

Peter Moulding wrote:
> Hello Oren,
> It looks like your ISP is hosting your site on Windows. They use ODBC
> to connect to MySQL instead of the native MySQL drivers.

No, Godaddy were just telling him how to use the MySQL ODBC connectors
to connect to his MySQL database. The ODBC connectors connect to MySQL
exactly how MRBS will, on port 3306.

So there is no need to make MRBS use ODBC.

John.

--

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

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/

headers

oren levin | 6 Sep 2007 15:21

Time table changes after importing

Hello

I've exported the mrbs content to an *.sql file and imported it to a different server (remotely)

The procedure was successful (with no errors) but all the time table has changed in 10 hours difference

Also when opening the main page (index.php) it's displaying a week before the current one.

What can cause this ?

Thanks

Explore the seven wonders of the world Learn more!

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/

_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general

headers

Cooper, Mike | 6 Sep 2007 21:19

Changing Building to two columns

We have a number of entries where you list buildings. So many that you can’t see the rooms to schedule unless you scroll down. Is there anyway to have the buildings display in two columns, There is plenty of room between the buildings on the month calendar to the right. Thank You

This e-mail message has been scanned by MailMarshal from Marshal Software, an email content filter.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/

_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general

headers

John Beranek | 7 Sep 2007 14:15

Re: Time table changes after importing

oren levin wrote:
> Hello I've exported the mrbs content to an *.sql file and imported it
> to a different server (remotely) The procedure was successful (with
> no errors) but all the time table has changed in 10 hours difference 
> Also when opening the main page (index.php) it's displaying a week 
> before the current one.

Did you by any chance move the installation to a server in a different
time zone?

If so, there are 2 possible fixes. One is to fool MRBS into thinking it
is still running in the old timezone, with something like:

putenv("TZ=America/New_York");

into your config.inc.php.

The other fix is to run an SQL query across your database to fix the
times. This would be something like I've posted here before, namely:

UPDATE mrbs_entry SET start_time=start_time+36000, end_time=end_time+36000;

UPDATE mrbs_repeat SET start_time=start_time+36000,
end_time=end_time+36000;

As for what the main page is showing, I don't know what could cause that
- it could still be to do with the server's time zone.

John.

--

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

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/

headers

John Beranek | 7 Sep 2007 14:50

CVS update: mrbs/web


Date:	Friday September 7, 2007  <at>  5:50
Author:	jberanek

Update of /cvsroot/mrbs/mrbs/web
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv8364/web

Modified Files:
      Tag: mrbs-1_2-branch
	edit_entry.php 
Log Message:
* Fix for SF tracker #1666299, as supplied by the reporter, 'northtommy'.
 Update of the room list as you change area in the edit entry screen 
 is now correct.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/

headers

oren levin | 9 Sep 2007 10:25

Re: Time table changes after importing

The time zone trick is working :)
Thanks

> Date: Fri, 7 Sep 2007 13:15:30 +0100
> From: john <at> redux.org.uk
> To: mrbs-general <at> lists.sourceforge.net
> Subject: Re: [MRBS-general] Time table changes after importing
>
> oren levin wrote:
> > Hello I've exported the mrbs content to an *.sql file and imported it
> > to a different server (remotely) The procedure was successful (with
> > no errors) but all the time table has changed in 10 hours difference
> > Also when opening the main page (index.php) it's displaying a week
> > before the current one.
>
> Did you by any chance move the installation to a server in a different
> time zone?
>
> If so, there are 2 possible fixes. One is to fool MRBS into thinking it
> is still running in the old timezone, with something like:
>
> putenv("TZ=America/New_York");
>
> into your config.inc.php.
>
> The other fix is to run an SQL query across your database to fix the
> times. This would be something like I've posted here before, namely:
>
> UPDATE mrbs_entry SET start_time=start_time+36000, end_time=end_time+36000;
>
> UPDATE mrbs_repeat SET start_time=start_time+36000,
> end_time=end_time+36000;
>
> As for what the main page is showing, I don't know what could cause that
> - it could still be to do with the server's time zone.
>
> John.
>
> --
> John Beranek To generalise is to be an idiot.
> http://redux.org.uk/ -- William Blake
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems? Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> mrbs-general mailing list
> mrbs-general <at> lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/mrbs-general

Can you find the hidden words? Take a break and play Seekadoo! Play now!

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general

headers

oren levin | 9 Sep 2007 10:46

Unicode problem on shared host

Hello.

I've transferred a working mrbs directory from my local IIS (windows) server to a remote unix server

So far all is working but there's an encoding problem with some of the text (meetings).

When reactivating the unicode function on config.inc.php I get an error regarding the lack of iconv module.

How do I solve or bypass it ?

Thanks

Kick back and relax with hot games and cool activities at the Messenger Café. Play now!

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general

13	June 2013
29	May 2013
23	April 2013
74	March 2013
58	February 2013
115	January 2013
89	December 2012
80	November 2012
142	October 2012
122	September 2012
98	August 2012
155	July 2012
73	June 2012
99	May 2012
125	April 2012
164	March 2012
56	February 2012
193	January 2012
124	December 2011
103	November 2011
174	October 2011
223	September 2011
156	August 2011
144	July 2011
91	June 2011
106	May 2011
85	April 2011
123	March 2011
130	February 2011
107	January 2011
220	December 2010
289	November 2010
236	October 2010
184	September 2010
143	August 2010
91	July 2010
116	June 2010
49	May 2010
172	April 2010
156	March 2010
54	February 2010
49	January 2010
123	December 2009
156	November 2009
165	October 2009
94	September 2009
104	August 2009
109	July 2009
53	June 2009
88	May 2009
85	April 2009
150	March 2009
133	February 2009
127	January 2009
88	December 2008
58	November 2008
82	October 2008
125	September 2008
70	August 2008
74	July 2008
22	June 2008
37	May 2008
60	April 2008
43	March 2008
40	February 2008
83	January 2008
27	December 2007
29	November 2007
112	October 2007
54	September 2007
93	August 2007
39	July 2007
41	June 2007
24	May 2007
23	April 2007
64	March 2007
55	February 2007
32	January 2007
6	December 2006
12	November 2006
32	October 2006
33	September 2006
16	August 2006
36	July 2006
15	June 2006
23	May 2006
28	April 2006
43	March 2006
100	February 2006
56	January 2006
34	December 2005
17	November 2005
16	October 2005
51	September 2005
64	August 2005
36	July 2005
41	June 2005
52	May 2005
27	April 2005
34	March 2005
32	February 2005
14	January 2005
41	December 2004
33	November 2004
45	October 2004
61	September 2004
47	August 2004
40	July 2004
58	June 2004
106	May 2004
156	April 2004
128	March 2004
57	February 2004
143	January 2004
103	December 2003
125	November 2003
99	October 2003
118	September 2003
47	August 2003
61	July 2003
46	June 2003
56	May 2003
94	April 2003
76	March 2003
19	February 2003
84	January 2003
21	December 2002
25	November 2002
42	October 2002
29	September 2002
29	August 2002
24	July 2002
39	June 2002
71	May 2002
29	April 2002
21	March 2002
16	February 2002
26	January 2002
20	December 2001
29	November 2001
28	October 2001
25	September 2001
22	August 2001
26	July 2001
7	June 2001
32	May 2001
24	April 2001
63	March 2001
132	February 2001
68	January 2001
13	December 2000
30	November 2000
9	October 2000
30	September 2000
19	August 2000
37	July 2000
56	June 2000
11	May 2000

Mon	Tue	Wed	Thu	Fri	Sat	Sun

					1	2
3	4	5	6	7	8	9
10	11	12	13	14	15	16
17	18	19	20	21	22	23
24	25	26	27	28	29	30