Learn about Centmin Mod LEMP Stack today
Become a Member

New to Centminmod

Discussion in 'Introductions' started by jdan1457, Dec 20, 2016.

  1. jdan1457

    jdan1457 New Member

    15
    2
    3
    Dec 20, 2016
    Ratings:
    +2
    Local Time:
    7:24 AM
    1.11.13
    mariadb10
    Hello. I'm installing some tracking software called funnel flux. The requirements are:
    • Mysql 5.6+ or MariaDB 10.0+
    • PHP 5.6
    • The following PHP extensions (apart from ionCube Loader, the other ones are usually installed by default):
      • ionCube Loader 5.0+ (both for PHP Web and PHP CLI)
      • mcrypt
      • mbstring
      • json
      • hash
      • curl
      • mysqli
      • sockets
      • zip
      • xml
      • pdo_sqlite
      • sqlite3
    Make sure ONLY_FULL_GROUP_BY is disabled from sql_mode in your MySQL/MariaDB configuration file.

    Optional but highly recommended:
    • both memcached+redis and their respective PHP extensions
    • Zend Opcache PHP extension
    I installed the centminmod beta, everything went well. Then I used the install script for the software(which is for centos7) and when I get half way through, it asks me to create a db and user and password. When I do it says access denied user root@localhost. I tried typing a new user and password, didn't work. I tried using the same user and password that centmindmod created. Then I tried manually creating a new user and password in the .my.cnf but its the same result.

    Another question I have is how to ensure that ioncube is enabled for both web and cli?

    Last Question, how do i do this: "Make sure ONLY_FULL_GROUP_BY is disabled from sql_mode in your MySQL/MariaDB configuration file."

    Thanks

     
    Last edited: Dec 20, 2016
  2. eva2000

    eva2000 Administrator Staff Member

    54,935
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,812
    Local Time:
    9:24 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    welcome @jdan1457 to Centmin Mod Community :)

    You should now be able to post and ask your relevant questions in relevant forums ;)

    you can see which php extensions are installed via command in SSH
    Code (Text):
    php -m
    


    You do not touch mysql root user or /root/.my.cnf so if you can revert the password set in that file to the default set mysql root password as alot of centmin mysql related features assume working /root/.my.cnf. If you messed up mysql root user, you can reset mysql root user password in CentOS 7 via outlined method at MariaDB - How to reset MySQL root user password for CentOS 7 / MariaDB 10.1.19+ | Centmin Mod Community

    For creating mysql user/db you can use addons/mysqladmin_shell.sh addon outlined at mysqladmin_shell.sh Shell based Addon | Centmin Mod Community

    Ioncube as separate addon/ioncube.sh addon outlined at ioncube loader Addon [beta] | Centmin Mod Community

    not relevant in Centmin Mod MariaDB set ups as this is no set

    You might want to try the 123.09beta01 build as it will be next stable release and well has alot of improvements if you check 2nd post change log at Beta Branch - Centmin Mod .09 beta branch Testing

    Threads you might want to participate in ;)

    Threads & Info To Bookmark



    Threads to read, pages to bookmark and threads to watch/subscribe to get to know Centmin Mod would include:

    Centmin Mod Insights Forum



    The Centmin Mod Insights forums digs deeper into the inner workings of Centmin Mod so some useful threads in this forum include:

    Premium Membership


     
  3. eva2000

    eva2000 Administrator Staff Member

    54,935
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,812
    Local Time:
    9:24 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  4. jdan1457

    jdan1457 New Member

    15
    2
    3
    Dec 20, 2016
    Ratings:
    +2
    Local Time:
    7:24 AM
    1.11.13
    mariadb10
    Thx I appreciate the help.
     
  5. RB1

    RB1 Active Member

    292
    75
    28
    Nov 11, 2016
    California
    Ratings:
    +122
    Local Time:
    4:24 AM
    Nginx 1.21.x
    MariaDB 10.1.x
    Welcome! I'm about the make the switch to Funnel Flux myself :)
    I've heard nothing but great things. I really want to be able to deploy multiple servers and have it setup as somewhat of a "cloud" server. They don't support that yet.
     
  6. jdan1457

    jdan1457 New Member

    15
    2
    3
    Dec 20, 2016
    Ratings:
    +2
    Local Time:
    7:24 AM
    1.11.13
    mariadb10
    Ya I'm happy with the product myself. I was using it on vultr, where they (FF) have a setup script that made install super easy. But I wanted to run all my servers in one place (OVH).

    I ran the script on my new vps and it gave me an error saying that ioncube wasn't loaded, which I triple checked that it was installed and enabled.

    So after looking around online I found Centminmod, which seems to provide everything needed. Except now I get an error saying I don't have permission to create DB. I still haven't figured it out yet lol.
     
  7. RB1

    RB1 Active Member

    292
    75
    28
    Nov 11, 2016
    California
    Ratings:
    +122
    Local Time:
    4:24 AM
    Nginx 1.21.x
    MariaDB 10.1.x
    I'm really liking Linode at the moment...I have a $50 credit over at Vultr but I haven't taken the time to set a server up. Up until recently I had a VPS with WHM/cPanel installed so I never bothered using the command line. I'm slowly learning but I often still need to check on the forum when I have an issue although I can solve some things myself.

    As for ioncube, I'm fairly certain that it doesn't support the newest version of PHP 7 but that shouldn't matter because you're running 5.6 it looks like.

    For a while I was undecided on whether to use Funnel Flux or Voluum. I like the idea of owning all my data and not having it accessible by another company in the advertising industry (you never know what Voluum is doing with it), however Voluum would be great for running mobile traffic to numerous countries around the world due to their cloud servers everywhere. I think it would be great to boot up a few VPS servers in each continent I'm advertising to for the fastest lookup and redirect speeds, however, Funnel Flux doesn't support that yet.
     
  8. jdan1457

    jdan1457 New Member

    15
    2
    3
    Dec 20, 2016
    Ratings:
    +2
    Local Time:
    7:24 AM
    1.11.13
    mariadb10
    Ya Funnel Flux is pretty good. Lots of nice features. If your running lots of traffic on your campaigns then Voluum can get expensive. So FF can be cheaper in the long run for some people.

    Can anyone tell me why a .sh that works on vultr doesn't work on OVH?
     
  9. eva2000

    eva2000 Administrator Staff Member

    54,935
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,812
    Local Time:
    9:24 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    .sh meaning centmin.sh ? or you mean domain extension ?

    Centmin Mod should work tested on ovh dedicated and ovh public cloud vps fine if you use centos distro kernel not ovh custom kernel

    @ljseals though has issues with ovh vps too but he said he's using ovh custom kernel Newb- Fail Installation Job for nginx.service failed | Centmin Mod Community so maybe something changed on ovh vpses ?

    from install page Centmin Mod LEMP Stack Install Nginx on CentOS

    example for my OVH server with centos 7 distro kernel selected OVH - OVH Intel Core i7 4790K 32GB 2x240GB Samsung PM863 SSD Review | Centmin Mod Community

    might want to start your own thread in Install & Upgrades or Pre-Install Questions | Centmin Mod Community regarding OVH issues and might need troubleshooting info like at Newb- Fail Installation Job for nginx.service failed | Centmin Mod Community for your new thread
     
    Last edited: Dec 20, 2016
  10. jdan1457

    jdan1457 New Member

    15
    2
    3
    Dec 20, 2016
    Ratings:
    +2
    Local Time:
    7:24 AM
    1.11.13
    mariadb10
    I'm using the vps ssd range. I didn't notice the option to use different kernels. Is there a way to change it now?
     
  11. eva2000

    eva2000 Administrator Staff Member

    54,935
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,812
    Local Time:
    9:24 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+