Want more timely Centmin Mod News Updates?
Become a Member

Pre-install noob questions (CMM and VPS)

Discussion in 'Install & Upgrades or Pre-Install Questions' started by sepulchre, Dec 24, 2014.

  1. eva2000

    eva2000 Administrator Staff Member

    42,284
    9,554
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,714
    Local Time:
    7:18 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    does your namechanged.com (hostname for server in virtual.conf server_name) have a valid DNS entry for it ? i.e. if you had hostname.domain.com you need to have valid domain name DNS entry for it with your DNS name servers.

    does it work with ip address of server ?
    Code:
    https://ipaddressofserver/22076_mysqladmin874
     
    • Like Like x 1
  2. sepulchre

    sepulchre Member

    156
    22
    18
    Dec 22, 2014
    Ratings:
    +27
    Local Time:
    10:18 AM
    Your are the best, sir!

    I dont know what you mean with a valid DNS entry. This install I didnt touch anything, so it is easier to exclude other possibilities. I just did what I listed 1 message ago.

    And now with this:
    Code:
    https://ipaddressofserver/22076_mysqladmin874
    It works!!!!!!


    Your getting started guide step 1: 1. Setup the default server hostname Nginx vhost.
    This I skipped because there you explain how to change the server hostname but I didnt want to change it and leave it like I have it. So that was the mistake? Should I go through step 1 or what?
    You say there:
    And mine returned the correct one I told my host. So I skipped step 1.


    I am so sorry that I have noob problems, really. Maybe I could have thought by myself to try out the ip instead of the server name. Thanks.
     
    • Like Like x 1
  3. eva2000

    eva2000 Administrator Staff Member

    42,284
    9,554
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,714
    Local Time:
    7:18 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    yeah just need to add an DNS A record for hostname in server_name in virtual.conf for main hostname which is similar to Getting Started Guide Step 3. Will update step 1 with a note

    edit: updated Getting Started Guide for this note here.
     
    Last edited: Dec 31, 2014
  4. sepulchre

    sepulchre Member

    156
    22
    18
    Dec 22, 2014
    Ratings:
    +27
    Local Time:
    10:18 AM
    So from what I understand, I must add to the virtual.conf file this:
    server_name hostname.newdomain.com

    I use CloudFlare as DNS, so add there a Type A DNS, and point in my domain registrar (namecheap) to the nameservers of CloudFlare, right?

    Because if this is all, in my first install everything was like this. And it didnt work. At the moment, still it doesnt work (but I must say that my registrar points at the moment to my old server, I changed it back today for accessing my forum). It is strange.

    And thanks for the note.
     
  5. eva2000

    eva2000 Administrator Staff Member

    42,284
    9,554
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,714
    Local Time:
    7:18 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    yes virtual.conf entry and yes correct that is what you have to do
     
  6. sepulchre

    sepulchre Member

    156
    22
    18
    Dec 22, 2014
    Ratings:
    +27
    Local Time:
    10:18 AM
    Can you check and tell me if these steps are correct and in correct order for restoring my forum?

    1. Move stuff to /home/nginx/domains/mydomain.com/public
    2. Give folders data and internal_data full rights 777.
    3. Create a user in myphpadmin with full rights.
    4. Create a database in myphpadmin.
    5. Link the database to the created user.
    6. Import/restore your old database to this newly created database.
    7. Edit config.php file of Xenforo, which looks like this:
    Code:
    <?php
    
    $config['db']['host'] = 'localhost';
    $config['db']['port'] = '3306';
    $config['db']['username'] = 'database_username';
    $config['db']['password'] = 'database_username_password';
    $config['db']['dbname'] = 'database_name';
    $config['debug'] = false;
    // $config['enableListeners'] = false;
    
    $config['superAdmins'] = '1';
    So, is this correct? And Also is the port number correct? How do I know which port number?

    I did this and I am getting an "unexpected database error" all the time.
     
  7. eva2000

    eva2000 Administrator Staff Member

    42,284
    9,554
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,714
    Local Time:
    7:18 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    All steps are correct and port for mysql is always 3306 default.

    Using phpmyadmin could of have corrupted or done incomplete backup and/or restore ... only reliable way is mysqldump/mysql backup/restore via SSH
     
    • Like Like x 1
  8. sepulchre

    sepulchre Member

    156
    22
    18
    Dec 22, 2014
    Ratings:
    +27
    Local Time:
    10:18 AM
    Man, thank you soo much. I figured out everything now.
    I even dont use phpmyadmin, instead of I use your mysqladmin_shell.sh

    I was just confused about this database, msql stuff, but now I figured it out. My forum is almost working, just one problem with nginx is left, see this thread. Wow, I am finally so happy. Thank you sooo much!
     
    • Like Like x 1
  9. sepulchre

    sepulchre Member

    156
    22
    18
    Dec 22, 2014
    Ratings:
    +27
    Local Time:
    10:18 AM
    Hey,
    me again. That worked a while ago but now I have a problem.

    I have to install myphpadmin (want to check some database tables), just I can't get it to work. It installs but I can't connect to it at all.
    I assume that the installation is not correct. I get this:

    First, why does it try to acess the demodomain directory, which I deleted from the server, instead of my working domain directory?
    Second, why does it try to access to the localhost_ssl file which I don't have it at all?
    The rest of the phpmyadmin log file looks normal. I get my access details and so on. But I can't access it as I said.
     
  10. eva2000

    eva2000 Administrator Staff Member

    42,284
    9,554
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,714
    Local Time:
    7:18 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    post contents of your /usr/local/nginx/conf/conf.d/virtual.conf and their included include .conf files in pastebin or gist so can see what's going on

    phpmyadmin addon installer should of created an install log at /root/centminlogs/centminmod_phpmyadmin_install_${DT}.log where DT is the date timestamp numeric numbers. You can use Pastebin.com or Gists to share a version of the contents of the install or error messages and post the link here or contact me via private message with the link. You can use the uninstaller script to remove the phpmyadmin installation if needed or if you want to try reinstalls.
     
  11. sepulchre

    sepulchre Member

    156
    22
    18
    Dec 22, 2014
    Ratings:
    +27
    Local Time:
    10:18 AM
    I hope this is what you asked for. Put every .conf file I have and the install log for phpmyadmin.

    demodomain.com.conf
     
  12. sepulchre

    sepulchre Member

    156
    22
    18
    Dec 22, 2014
    Ratings:
    +27
    Local Time:
    10:18 AM
    Did you have time to check this?
     
  13. eva2000

    eva2000 Administrator Staff Member

    42,284
    9,554
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,714
    Local Time:
    7:18 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    pretty busy with client work right now but quick check of the provided config files, they look okay to me so can't see why that would happen other than you still having the /usr/local/nginx/conf/conf.d/demodomain.com.conf in place and not removing it as it would reference the deleted directories you removed for /home/nginx/domains/demodomain.com/*
     
    • Like Like x 1
  14. sepulchre

    sepulchre Member

    156
    22
    18
    Dec 22, 2014
    Ratings:
    +27
    Local Time:
    10:18 AM
    Yeah, I forgot to delete it. But I didn't want to remove it after you asked for the conf files. Because maybe that could be the problem. I will delete it now.
    And I really appreciate your helping. I still can't figure it out that you helping some noobs like me while handling big daddy stuff with big clients.

    One question. Could it be te problem that I used your mysqladmin_shell script for creating a database and restoring my files? Maybe the server sees somehow a problem to install phpmyadmin over that? I don't know. I am a helpless noob who runs a VPS server thanks to you.
    But it is just a software, it makes no sense.
    Hmm, maybe because I run DNS through Cloudflare and it doesn't accept my ip address?
    I still don't know why it doesn't accept server.mydomain.com. We figured out that replacing it with my ip address it works but normally it also should work with that way. I don't know. I will try again installing it. Maybe deleting that conf file will help.

    But maybe you can tell me, after you have finished your work and have time, why I get these errors from above.
    Maybe something to do with:
    wget --no-check-certificate https://github.com/centminmod/phpmyadmin/raw/master/phpmyadmin.sh
    So it installs a newest version for that I need ssl-certificate?
     
  15. sepulchre

    sepulchre Member

    156
    22
    18
    Dec 22, 2014
    Ratings:
    +27
    Local Time:
    10:18 AM
    ...
    ...
    boom I am in. deleting demodomain.conf solved it.
    I am speechless. Sorry for stealing your time. I will slap myself for this.
     
    • Like Like x 1
  16. eva2000

    eva2000 Administrator Staff Member

    42,284
    9,554
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,714
    Local Time:
    7:18 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    heh glad to see you fixed it finally :)
     
    • Like Like x 1