Forums

Subscribe via email Subscribe via email
Subscribe via rss
Guest
or Ask a Question
Add a reply View Replies (7) →
StilleVande
StilleVande
Offline
Issue

remote connectivity and my.ini location for MariaDB 5.5 / ClearOS 7

Resolved
0 votes
I would like to store an intranet gameservers database on my ClearOS Gateway. I have a couple questions.

1) Where is the cnf file that contains the "bind-address=127.0.0.1" entry? I need to make the database so that it can accept connections from within my intranet.

2) I also need to add a few lines to the my.ini, but I can seem to find the production my.ini. Anyone happen to know the location of it?

Thank you!
In MariaDB Database Server
Sunday, November 29 2015, 04:48 PM

Location [ View Larger Map ]

http://maps.googleapis.com/maps/api/staticmap?center=32.7481845,-96.47193119999997&language=en&maptype=roadmap&zoom=5&size=450x300&sensor=true&markers=color:red|label:S|32.7481845,-96.47193119999997
Subscribe via email
Share this post:
Responses (7)

  • Accepted Answer

    Nick Howitt
    Nick Howitt
    Offline
    Monday, November 30 2015, 07:07 PM - #Permalink
    Resolved
    0 votes
    Wow! That's a bit different now! Lots more apps show up including MariaDB.

    Thanks, Ben.
    The reply is currently minimized Show

  • Accepted Answer

    Ben Chambers
    Ben Chambers
    Offline
    Monday, November 30 2015, 05:43 PM - #Permalink
    Resolved
    0 votes
    Ah yes...that's the issue (very early beta)...this would actually be fixed when we move to 7.2 in a few weeks...we did not have the handler in place during the beta for minor upgrades.

    To fix your issue, Nick, just run:

    
cp /etc/clearos/edition.d/community-7.1.conf /etc/product
    
rm -rf /var/clearos/framework/cache/*


    B.
    The reply is currently minimized Show

  • Accepted Answer

    Nick Howitt
    Nick Howitt
    Offline
    Monday, November 30 2015, 05:33 PM - #Permalink
    Resolved
    0 votes
    Hi Ben,

    10700:

    software_id = 10700
    
name = ClearOS Community
    
jws_nodes = 1
    
jws_prefix = cos6-ws
    
jws_domain = clearsdn.com
    
jws_realm = ws
    
jws_version = 1.1


    [edit]
    I can't edit my post to attach the the same picture as yours, but from the Community Edition and no app showing :(
    [/edit]
    The reply is currently minimized Show

  • Accepted Answer

    Ben Chambers
    Ben Chambers
    Offline
    Monday, November 30 2015, 04:01 PM - #Permalink
    Resolved
    0 votes
    @Nick...doesn't sound right...it's coming up in my business edition, and I just checked a Community and Home Edition too...shows up in Marketplace OK.

    What is the 'software_id' field in /etc/product....perhaps it's some issue from an earlier beta???

    B.
    Attachments:
    The reply is currently minimized Show

  • Accepted Answer

    Nick Howitt
    Nick Howitt
    Offline
    Sunday, November 29 2015, 09:50 PM - #Permalink
    Resolved
    0 votes
    Ben Chambers wrote:

    Hi,

    It's call MariaDB in the Marketplace, but can also be installed vi CLI:
    yum -y install app-mariadb


    You can make changes to the default configuration in /etc/my.cnf

    B
    That is what I thought, but it does not show up in my marketplace - installed or not. I tried hunting it down via the cli but it looks like I missed it. The webconfig is definitely ClearOS7 and it does not show in my marketplace. My VM is up to date.
    The reply is currently minimized Show

  • Accepted Answer

    Ben Chambers
    Ben Chambers
    Offline
    Sunday, November 29 2015, 08:43 PM - #Permalink
    Resolved
    0 votes
    Hi,

    It's call MariaDB in the Marketplace, but can also be installed vi CLI:
    yum -y install app-mariadb


    You can make changes to the default configuration in /etc/my.cnf

    B
    The reply is currently minimized Show

  • Accepted Answer

    Nick Howitt
    Nick Howitt
    Offline
    Sunday, November 29 2015, 07:57 PM - #Permalink
    Resolved
    0 votes
    hmm.... I can't even find the equivalent of the ClearOS6 app-mysql so I don't know what the app is called. It looks like the configuration file /etc/my.cnf is still used.

    .... and deleting your duplicate post.
    The reply is currently minimized Show
Your Reply