# Gacl and sql.inc ignore port settings

**URL:** <https://community.open-emr.org/t/gacl-and-sql-inc-ignore-port-settings/6190>\
**Category:** OpenEMR Development\
**Created:** [July 2, 2013, 6:10am UTC](https://community.open-emr.org/t/gacl-and-sql-inc-ignore-port-settings/6190 "2013-07-02T06:10:48Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [July 2, 2013, 6:10am UTC](https://community.open-emr.org/t/gacl-and-sql-inc-ignore-port-settings/6190/1 "2013-07-02T06:10:48Z")

</div>

**[yehster](https://sourceforge.net/u/yehster/)** wrote on [Tuesday, July 02, 2013](https://sourceforge.net/p/openemr/discussion/202506/thread/79db999a/#5f16):

Even though the setup script allows for specifying a port number other than the default of 3306 for the MySQL server, if you use something other than 3306, the port number doesn’t get applied in gacl or sql.inc or the calendar/config.php

I installed MariaDB on port 3307 so I could have MySQL still on 3306 and have discovered this problem.

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [July 2, 2013, 3:30pm UTC](https://community.open-emr.org/t/gacl-and-sql-inc-ignore-port-settings/6190/2 "2013-07-02T15:30:44Z")

</div>

**[yehster](https://sourceforge.net/u/yehster/)** wrote on [Tuesday, July 02, 2013](https://sourceforge.net/p/openemr/discussion/202506/thread/79db999a/#ef04):

I think the correct way to handle this is actually to ignore/remove the port option/field and specify it in the hostname instead.

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [July 2, 2013, 7:48pm UTC](https://community.open-emr.org/t/gacl-and-sql-inc-ignore-port-settings/6190/3 "2013-07-02T19:48:41Z")

</div>

**[yehster](https://sourceforge.net/u/yehster/)** wrote on [Tuesday, July 02, 2013](https://sourceforge.net/p/openemr/discussion/202506/thread/79db999a/#e920):

> <https://github.com/yehster/openemr/commit/2f253d98295b62b9c240886c15e3d02abf494495>

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [July 3, 2013, 9:25am UTC](https://community.open-emr.org/t/gacl-and-sql-inc-ignore-port-settings/6190/4 "2013-07-03T09:25:51Z")

</div>

**[bradymiller](https://sourceforge.net/u/bradymiller/)** wrote on [Wednesday, July 03, 2013](https://sourceforge.net/p/openemr/discussion/202506/thread/79db999a/#e920/94ad):

At work and can’t view the code. But guessing you may break things for  
upgraders(usually best to never touch the SQL config file). Will look at it  
soon.  
On Jul 2, 2013 12:48 PM, “Kevin Yeh” [yehster@users.sf.net](mailto:yehster@users.sf.net) wrote:

> ## [Fix port settings in config files · yehster/openemr@2f253d9 · GitHub](https://github.com/yehster/openemr/commit/2f253d98295b62b9c240886c15e3d02abf494495)
> 
> ## gacl and sql.inc ignore port settings[https://sourceforge.net/p/openemr/discussion/202506/thread/79db999a/?limit=25#e920](https://sourceforge.net/p/openemr/discussion/202506/thread/79db999a/?limit=25#e920)
> 
> Sent from [sourceforge.net](http://sourceforge.net) because you indicated interest in  
> [OpenEMR / Discussion / Developers](https://sourceforge.net/p/openemr/discussion/202506/)
> 
> To unsubscribe from further messages, please visit  
> [SourceForge.net: Log In to SourceForge.net](https://sourceforge.net/auth/subscriptions/)

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [July 11, 2013, 3:33pm UTC](https://community.open-emr.org/t/gacl-and-sql-inc-ignore-port-settings/6190/5 "2013-07-11T15:33:23Z")

</div>

**[yehster](https://sourceforge.net/u/yehster/)** wrote on [Thursday, July 11, 2013](https://sourceforge.net/p/openemr/discussion/202506/thread/79db999a/#0368):

> <https://github.com/yehster/openemr/commit/575b8adb6e80a14a85562c0c4c0c04d9e453118d>

  
I pushed this to master. Decided to go the more conservative route and add the port information explicitly.
