oren levin | 1 Sep 20:14 2007
Picon

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
Peter Moulding | 3 Sep 01:09 2007
Picon
Picon

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
John Beranek | 3 Sep 12:58 2007
Picon

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/
John Beranek | 3 Sep 13:00 2007
Picon

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/
oren levin | 6 Sep 15:21 2007
Picon

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
Cooper, Mike | 6 Sep 21:19 2007

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
John Beranek | 7 Sep 14:15 2007
Picon

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/
John Beranek | 7 Sep 14:50 2007
Picon
Picon

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/
oren levin | 9 Sep 10:25 2007
Picon

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
oren levin | 9 Sep 10:46 2007
Picon

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

Gmane