titansking

Hi,

I am new to Mambo and i am using Mambo 4.5 [1.0.7]

My mysql server is running on port 3316 rather than the default 3306. is there anyway i can make mambo query mysql database on port 3316 rather than port 3306.

thanks in advance

regards
victor

Gayle

just add the port to the end of the host in the configuration.php.

e.g. mysql.domain.com:3316

__________________
"Unix gives you just enough rope to hang yourself -- and then a couple of more feet, just to be sure" --- Eric Allman

titansking

Sorry it doesnt work. My Core Mambo works fine with this. But when i install components and modules, it doent go thru. They just cant recognize the new port number.

Thanks in Advance

mmx

Could it be done programmically using something like:

<?php ini_set("mysql.default_port", "3316"); ?>

or via .htaccess using something like:

php_value mysql.default_port 3316

titansking

Sorry guys none of the options mentioned above work for me. Is there any other way to tell mambo to connect to the mysql server on a specific port eg 3316 rather than the default one running at 3306.

Pls Help

Thanks in advance

mmx

Get into admin and go to System > System Info, then copy the information on screen and paste it in a message within this thread.

titansking

Here is the System Info

PHP built On: Linux daffy.perf.redhat.com 2.4.18-11smp #1 SMP Thu Aug 15 06:41:59 EDT 2002 i686 i686 i386 GNU/Linux
Database Version: 3.23.54
PHP Version: 4.2.2
Web Server: Apache/2.0.40 (Red Hat Linux)
WebServer to PHP interface: apache2filter
Mambo Open Source Version: 4.5 Stable-1.0.7 [Sinatra] 07/04/2004 13:20 GMT
User Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Relevent PHP Settings: Safe Mode: OFF
Open basedir: none
Display Errors: ON
Short Open Tags: ON
File Uploads: ON
Magic Quotes: ON
Register Globals: ON
Output Buffering: OFF
Session save path: /tmp
Session auto start: 0
XML enabled: Yes
Zlib enabled: Yes
Disabled Functions: none
WYSIWYG Editor: htmlarea2

Configuration File: <?php
$mosConfig_offline = '0';
$mosConfig_host = 'xxxxxx'
$mosConfig_user = 'xxxxxx'
$mosConfig_password = 'xxxxxx'
$mosConfig_db = 'xxxxxx'
$mosConfig_dbprefix = 'mos_';
$mosConfig_lang = 'english';
$mosConfig_absolute_path = '/var/www/linux';
$mosConfig_live_site = 'http://www.linux.biz';
$mosConfig_sitename = 'Welcome : Linux';
$mosConfig_shownoauth = '0';
$mosConfig_emailpass = '1';
$mosConfig_offline_message = 'This site is down for maintenance.
Please check back again soon.';
$mosConfig_error_message = 'This site is temporarily unavailable.
Please notify the System Administrator';
$mosConfig_UseBanner = '1';
$mosConfig_debug = '0';
$mosConfig_lifetime = '900';
$mosConfig_MetaDesc = 'Mambo Open Source - the dynamic portal engine and content management system';
$mosConfig_MetaKeys = 'mambo, mambo open source, Mambo, Mambo Open Source';
$mosConfig_locale = 'en_GB';
$mosConfig_offset = '0';
$mosConfig_hideAuthor = '0';
$mosConfig_hideCreateDate = '0';
$mosConfig_hideModifyDate = '0';
$mosConfig_hidePdf = '0';
$mosConfig_hidePrint = '0';
$mosConfig_hideEmail = '0';
$mosConfig_enable_log_items = '0';
$mosConfig_enable_log_searches = '0';
$mosConfig_sef = '0';
$mosConfig_vote = '0';
$mosConfig_gzip = '0';
$mosConfig_multipage_toc = '0';
$mosConfig_allowUserRegistration = '1';
$mosConfig_link_titles = '0';
$mosConfig_error_reporting = -1;
$mosConfig_editor = 'htmlarea2';
setlocale (LC_TIME, $mosConfig_locale);
?>

mmx

According the the PHP Manual, either of the two methods I suggested should work. See the following url:

http://us4.php.net/ini_set

Try to use the second method again with 3316 enclosed in quotations ( "3316" ).

titansking

can u tell me the exact syntax which i can just copy and paste in my .htaccess file.

Thanks for your patience

titansking

Currently my .htaccess is something like this

ErrorDocument 404 http://www.linux.biz/index.php?option=com_404
php_value mysql.default_port 3316