I can't send and receive emails

Discussion in 'General' started by mymmo73, Jun 4, 2019.

  1. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    That file exist, but if you want to see what it contains, use
    Code:
    more /usr/local/ispconfig/server/lib/config.inc.php
    or
    Code:
    less /usr/local/ispconfig/server/lib/config.inc.php
    Plus, a better way to verify a file exist is using ls command, like this
    Code:
    ls -lh /usr/local/ispconfig/server/lib/config.inc.php
     
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    To learn Linux, there are documents in the Internet, for example
    http://www.ee.surrey.ac.uk/Teaching/Unix/unix2.html
    Find more with Internet Search Engines:
    Code:
    linux tutorial beginner
    I learned Unix and Linux from books by Mark G. Sobell, "Practical Guide to Unix" and "Practical Guide to Linux".
     
  3. mymmo73

    mymmo73 Member

    I extrapolated with the following command:
    Code:
    more /usr/local/ispconfig/server/lib/config.inc.php
    I extrapolated with the following command: some information but now I don't know how to move, can I send it to you in private?
     
  4. Taleman

    Taleman Well-Known Member HowtoForge Supporter

  5. mymmo73

    mymmo73 Member

    the problem could depend on this information?:
    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'satus
     
  6. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    That may be one symptom or cause.
    You should verify the database password in the aforementioned file is correct. Try connect to database using users and passwords obtained from that file.
    I hope you have not mixed versions of applications or mysql/mariadb databases from outside the default operating system repositories?
     
  7. mymmo73

    mymmo73 Member

    These are the databases I found:

    Code:
    [email protected]:~# more /usr/local/ispconfig/server/lib/config.inc.php
    <?php
    /*
    Copyright (c) 2007 - 2013, Till Brehm, projektfarm Gmbh
    All rights reserved.
    
    Redistribution and use in source and binary forms, with or without modification,
    are permitted provided that the following conditions are met:
    
        * Redistributions of source code must retain the above copyright notice,
          this list of conditions and the following disclaimer.
        * Redistributions in binary form must reproduce the above copyright notice,
          this list of conditions and the following disclaimer in the documentation
          and/or other materials provided with the distribution.
        * Neither the name of ISPConfig nor the names of its contributors
          may be used to endorse or promote products derived from this software with
    out
          specific prior written permission.
    
    THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
    ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
    WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIME
    D.
    IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
    INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
    BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
    DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY
    OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
    NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
    EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
    */
    
    //** Web-only
    if( !empty($_SERVER['DOCUMENT_ROOT']) ) {
    
            Header("Pragma: no-cache");
            Header("Cache-Control: no-store, no-cache, max-age=0, must-revalidate");
            Header("Content-Type: text/html; charset=utf-8");
    
            //** Set a few php.ini values
            ini_set('register_globals',0);
            ini_set('magic_quotes_gpc', 0);
    
            if (isset($_REQUEST['GLOBALS']) || isset($_FILES['GLOBALS']) || isset($_
    REQUEST['s']) || isset($_REQUEST['s_old']) || isset($_REQUEST['conf'])) {
                    die('Internal Error: var override attempt detected');
                    exit;
            }
    }
    
    //** Set a few php.ini values
    if(get_magic_quotes_runtime()) set_magic_quotes_runtime(false);
    if(isset($app)) unset($app);
    if(isset($conf)) unset($conf);
    
    
    //** SVN Revision
    $svn_revision = '$Revision$';
    $revision = str_replace(array('Revision:','$',' '), '', $svn_revision);
    
    //** Application
    define('ISPC_APP_TITLE', 'ISPConfig');
    define('ISPC_APP_VERSION', '3.1.13p1');
    define('DEVSYSTEM', 0);
    
    
    //** Database
    $conf['db_type'] = 'mysql';
    $conf['db_host'] = 'localhost';
    $conf['db_port'] = '3306';
    $conf['db_database'] = 'dbispconfig';
    $conf['db_user'] = '#######';
    $conf['db_password'] = '##################';
    $conf['db_charset'] = 'utf8'; // same charset as html-charset - (HTML --> MYSQL:
     "utf-8" --> "utf8", "iso-8859-1" --> "latin1")
    $conf['db_new_link'] = false;
    $conf['db_client_flags'] = 0;
    
    define('DB_TYPE',$conf['db_type']);
    define('DB_HOST',$conf['db_host']);
    define('DB_PORT',$conf['db_port']);
    define('DB_DATABASE',$conf['db_database']);
    define('DB_USER',$conf['db_user']);
    define('DB_PASSWORD',$conf['db_password']);
    define('DB_CHARSET',$conf['db_charset']);
    
    
    //** Database settings for the master DB. This setting is only used in multiserv
    er setups
    $conf['dbmaster_type']                  = 'mysql';
    $conf['dbmaster_host']                  = '';
    $conf['dbmaster_port']                  = '';
    $conf['dbmaster_database']              = 'dbispconfig';
    $conf['dbmaster_user']                  = '';
    $conf['dbmaster_password']              = '#########################';
    $conf['dbmaster_new_link']              = false;
    $conf['dbmaster_client_flags']  = 0;
    
    
    //** Paths
    $conf['ispconfig_log_dir'] = '/var/log/ispconfig';
    define('ISPC_ROOT_PATH', realpath(dirname(__FILE__).'/../')); // Main ROOT is th
    e parent directory to this file, ie interface/ or server/. NO trailing slashes.
    define('ISPC_LIB_PATH', ISPC_ROOT_PATH.'/lib');
    define('ISPC_CLASS_PATH', ISPC_ROOT_PATH.'/lib/classes');
    define('ISPC_WEB_PATH', ISPC_ROOT_PATH.'/web');
    define('ISPC_THEMES_PATH', ISPC_ROOT_PATH.'/web/themes');
    define('ISPC_WEB_TEMP_PATH', ISPC_WEB_PATH.'/temp'); // Path for downloads, acce
    ssible via browser
    define('ISPC_CACHE_PATH', ISPC_ROOT_PATH.'/cache');
    define('ISPC_LOG_PATH', $conf['ispconfig_log_dir']);
    
    //** Paths (Do not change!)
    $conf['rootpath'] = substr(dirname(__FILE__),0,-4);
    $conf['fs_div'] = '/'; // File system separator, "\\" on Windows and "/" on Linu
    x and UNIX
    $conf['classpath'] = $conf['rootpath'].$conf['fs_div'].'lib'.$conf['fs_div'].'cl
    asses';
    $conf['temppath'] = $conf['rootpath'].$conf['fs_div'].'temp';
    $conf['logpath'] = ISPC_LOG_PATH; // Actually just a copy of $conf['ispconfig_lo
    g_dir'], might be removed in a later version
    
    define('FS_DIV',$conf['fs_div']);
    define('SERVER_ROOT',$conf['rootpath']);
    define('INCLUDE_ROOT',SERVER_ROOT.FS_DIV.'lib');
    define('CLASSES_ROOT',INCLUDE_ROOT.FS_DIV.'classes');
    
    
    //** Server
    $conf['app_title'] = ISPC_APP_TITLE;
    $conf['app_version'] = ISPC_APP_VERSION;
    $conf['app_link'] = 'http://www.ispconfig.org/';
    $conf['modules_available'] = 'dashboard,admin,mail,sites,monitor,client,dns,help
    ';
    $conf['server_id'] = '1';
    $conf['init_scripts'] = '/etc/init.d';
    
    
    //** Interface
    $conf['interface_modules_enabled'] = 'dashboard,mail,sites,dns,tools,help';
    
    //** Demo mode
    /* The demo mode is an option to restrict certain actions in the interface like
    *  changing the
    word of users with sys_userid < 3 etc. to be
    *  able to run the ISPConfig interface as online demo. It does not
    *  affect the server part. The demo mode should be always set to false
    *  on every normal installation
    */
    $conf['demo_mode'] = false;
    
    
    //** Logging
    $conf['log_file'] = $conf['ispconfig_log_dir'].$conf['fs_div'].'ispconfig.log';
    $conf['log_priority'] = 2; // 0 = Debug, 1 = Warning, 2 = Error
    
    
    //** Allow software package installations
    $conf['software_updates_enabled'] = false;
    
    
    //** Themes
    $conf['theme'] = 'default';
    $conf['html_content_encoding'] = 'utf-8'; // example: utf-8, iso-8859-1, ...
    $conf['logo'] = 'themes/default/images/header_logo.png';
    
    
    //** Default Language and Timezone
    $conf['language'] = 'en';
    $conf['debug_language'] = false;
    $conf['language_file_import_enabled'] = true; // Bool value: true / false
    
    //* Complete timezone list: http://php.net/manual/en/timezones.php
    $conf['timezone'] = 'Europe/Berlin';
    
    
    //** Misc.
    $conf['interface_logout_url'] = ''; // example: http://www.domain.tld/
    
    
    //** Auto Load Modules
    $conf['start_db'] = true;
    $conf['start_session'] = true;
    
    //** Constants
    define('LOGLEVEL_DEBUG',0);
    define('LOGLEVEL_WARN',1);
    define('LOGLEVEL_ERROR',2);
    
    //** include a local config-file if there is one
    //** IMPORTANT!!!
    //** DO NOT MAKE A COPY OF THIS FILE AS LOCAL CONFIG-FILE
    //** USE A EMPTY FILE AND ONLY COPY THE SETTINGS IN IT, YOU NEED TO OVERRIDE
    if (is_file(dirname(__FILE__) . '/config.inc.local.php')) include_once 'config.i
    nc.local.php';
    ?>
    [email protected]:~#
    then with this command "mysql -u root -p mysql" I managed to get into both databases but asked me only the password and no user
     
  8. mymmo73

    mymmo73 Member

    here is the session where I found the error:
    Code:
    [email protected]:~# mysql -u root -p mysql
    Enter password:
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A
    
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 107763
    Server version: 10.1.40-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04
    
    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    MariaDB [mysql]> help
    
    General information about MariaDB can be found at
    http://mariadb.org
    
    List of all MySQL commands:
    Note that all text commands must be first on line and end with ';'
    ?         (\?) Synonym for `help'.
    clear     (\c) Clear the current input statement.
    connect   (\r) Reconnect to the server. Optional arguments are db and host.
    delimiter (\d) Set statement delimiter.
    edit      (\e) Edit command with $EDITOR.
    ego       (\G) Send command to mysql server, display result vertically.
    exit      (\q) Exit mysql. Same as quit.
    go        (\g) Send command to mysql server.
    help      (\h) Display this help.
    nopager   (\n) Disable pager, print to stdout.
    notee     (\t) Don't write into outfile.
    pager     (\P) Set PAGER [to_pager]. Print the query results via PAGER.
    print     (\p) Print current command.
    prompt    (\R) Change your mysql prompt.
    quit      (\q) Quit mysql.
    rehash    (\#) Rebuild completion hash.
    source    (\.) Execute an SQL script file. Takes a file name as an argument.
    status    (\s) Get status information from the server.
    system    (\!) Execute a system shell command.
    tee       (\T) Set outfile [to_outfile]. Append everything into given outfile.
    use       (\u) Use another database. Takes database name as argument.
    charset   (\C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets.
    warnings  (\W) Show warnings after every statement.
    nowarning (\w) Don't show warnings after every statement.
    
    For server side help, type 'help contents'
    
    MariaDB [mysql]> satus
        -> \s
    --------------
    mysql  Ver 15.1 Distrib 10.1.40-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
    
    Connection id:          107763
    Current database:       mysql
    Current user:           ####@localhost
    SSL:                    Not in use
    Current pager:          stdout
    Using outfile:          ''
    Using delimiter:        ;
    Server:                 MariaDB
    Server version:         10.1.40-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04
    Protocol version:       10
    Connection:             Localhost via UNIX socket
    Server characterset:    latin1
    Db     characterset:    latin1
    Client characterset:    utf8
    Conn.  characterset:    utf8
    UNIX socket:            /var/run/mysqld/mysqld.sock
    Uptime:                 1 day 1 hour 58 min 55 sec
    
    Threads: 1  Questions: 166  Slow queries: 0  Opens: 36  Flush tables: 1  Open tables: 30  Queries per second avg: 0.001
    --------------
    
        -> mysql  Ver 15.1 Distrib 10.1.40-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
        ->
        -> Connection id:          107763
        -> Current database:       mysql
        -> Current user:           ####@localhost
        -> SSL:                    Not in use
        -> Current pager:          stdout
        -> Using outfile:          ''
        -> Using delimiter:        ;
    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'satus
    
    mysql  Ver 15.1 Distrib 10.1.40-MariaDB, for debian-linux-gnu (x86_64) us' at line 1
    MariaDB [mysql]> Server:                 MariaDB
        -> Server version:         10.1.40-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04
        -> Protocol version:       10
        -> Connection:             Localhost via UNIX socket
        -> Server characterset:    latin1
        -> Db     characterset:    latin1
        -> Client characterset:    utf8
        -> Conn.  characterset:    utf8
        -> UNIX socket:            /var/run/mysqld/mysqld.sock
        -> Uptime:                 1 day 1 hour 58 min 55 sec
        ->
        -> Threads: 1  Questions: 166  Slow queries: 0  Opens: 36  Flush tables: 1  Open tables: 30  Queries per second avg: 0.001
        -> --------------
        ->
    
     
  9. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    You can avoid that error by not mistyping. Like the error message says, satus is not a recognized command.
    I wish you would show a bit more effort in trying to solve the problems yourself.
     
  10. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    That command takes to database mysql. You can not get to the dbispconfig database with that command.
    Username was not asked, since you gave the user with the -u parameter.
    I'm sure you can find tutorials on SQL using Internet Seargh Engines, or visiting bookshop or library.
     
  11. till

    till Super Moderator Staff Member ISPConfig Developer

  12. mymmo73

    mymmo73 Member

    It's been a while since I tried to solve but unfortunately I can't manage it, I will reset the server in order to re-install everything, thank you very much for your availability ..
     

Share This Page