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
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".
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?
Please do not send private messages. If you can not fix the system yourself, you can pay for business support : https://www.ispconfig.org/support/
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
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?
These are the databases I found: Code: root@webitalia:~# 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'; ?> root@webitalia:~# 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
here is the session where I found the error: Code: root@webitalia:~# 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 -> -------------- ->
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.
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.
Not sure if this thread will go anywhere, maybe you should consider contacting Florian from business support to take a look directly on your system and fix the issue remotely. https://www.ispconfig.org/get-support/?type=ispconfig
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 ..
