Installing CMSMS on MySQL with non standard port

[mvines]

Hopefully a simple one,  I just didn't find it in any documentation.  I am trying to setup CMSMS with MySQL on non-standard port 3309.  Where do I tell the installer to use that port on step 3 of the installation? I have tried...

127.0.0.1:3309
127.0.0.1/3309
127.0.0.1 3309

and some others that really don't make sense.  All help is appreciated, thanks.

Using:
CMSMS 1.2.2
PHP 5.2.3 but will also use latest version of 4 on another site.
MySQL 5.0 but may have to use a version of 4 on another site.
Apache >2.0

Matthew Vines

[Pierre M.]

Hello Matthew,

what about keying the database host in the database host field and the database port in the database port field ?
Or haven't I understood your question ?
Or are you sure you have downloaded the official CMSms v 1.2.2 ?

Pierre M.

[calguy1000]

Hmmm, is the database on a non standard port, or the httpd server?

[savagekabbage]

I run WAMP on my development box, and run MySQL on port 3307. Usually specifying localhost:3307 does the trick for me

[mvines]

Thank you for your quick reply,

I am installing a (the?) multi lingual branch/modification from:

http://dev.cmsmadesimple.org/projects/multilang/

I downloaded the 'cmsms-mle-1.2.2.tar.gz' package, unzipped placed it in my development environement, and ran the installation page. All was well until step three, where there does not appear to be a field for the database port.  I failed to explain in enough detail in my previous post that I tried to enter the port information in with the host data on that field, but that of course did not work.  I can submit a screen shot if you would like.  Could this be a minor bug in this edition of CMSMS? 

I did dig around in the code a bit, and while it appears that the underlying data array for this step of the installation does have a key for the port, there is no field on the web form, also the ADOConnection (I'm pulling that name from my memory, but it is something close to that) class's Connect, PConnect, and TConnect (again from memory) member functions all fail to send port information when connecting. 

If you do not support this version of CMSMS, can you recommend a way to provide multi-lingual content within a version that you do support.  If I read correctly these features are planned for the 2.0 stable benchmark but are not active in the primary development branch right now.

Once again, all help is appreciated.  Feel free to point me to the documentation.  I'm never too lazy to RTFM. 

Matthew Vines

[mvines]

I run WAMP on my development box, and run MySQL on port 3307. Usually specifying localhost:3307 does the trick for me

I have also tried the same variations listed above with localhost, but thank you for the suggestion.

If it is relevant, I am running Windows XP Pro in my development environment.

Matthew Vines

[savagekabbage]

I run WAMP on my development box, and run MySQL on port 3307. Usually specifying localhost:3307 does the trick for me

I have also tried the same variations listed above with localhost, but thank you for the suggestion.

If it is relevant, I am running Windows XP Pro in my development environment.

Matthew Vines

Strange... I just tried the MLE edition for the first time and it worked like a charm. In step 3, for the Database Host Address, make sure you just have localhost:PORT.

My config.php file looks like this:

Code: Select all

#This is your database connection information.  Name of the server,
#username, password and a database with proper permissions should
#all be setup before CMS Made Simple is installed.
$config['dbms'] = 'mysql';
$config['db_hostname'] = 'localhost:3307';
$config['db_username'] = 'root';
$config['db_password'] = '';
$config['db_name'] = 'db_name';	

[mvines]

I'll give it another try.  It is possible I am missing something else.

Thanks again, I will report back with my results.

Matthew Vines