Hello everyone, I have the following issue. iTop was previously in use on my system, installed under Linux. However, no data was provided to me during the handover. Now the system has failed, and due to the lack of data, I am unable to get it running again. I'm trying to install the system on Windows, but I'm having trouble following the existing instructions. I've installed MySQL, copied PHP, and copied iTop, integrating everything under IIS. PHP is running, and I can start the setup. During the initial check, everything is OK, and all extensions are present. However, when I click "Next," I encounter an error and can't proceed. It always says that there is no access in connection with MySQL. But what kind of access is it referring to? Is there a user that needs to be created with a specific password? In one attempt, I removed the password from the root user and was able to proceed with an older version of iTop and complete everything. However, I faced the same issue during the update. Can someone guide me on how to install and get iTop running on Windows precisely? Or do most people use it under Linux? Regards, Stefan
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The IIS has access to MySQL, I've verified that. The config-itop.php file is generated only after a successful configuration. I had already attempted an installation on Ubuntu, but during the configuration, the Apache suddenly shut down, and I can't get it running again.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have found the error and hope the solution will help some of you too. It's MariaDB or MySQL, iTop requires access to the SQL Server without user data. But only during the initial installation. In the directory, for example MySQL "C:\ 'ProgramData or Program Files' \MySQL\MySQL Server x.x", there is a file named my.ini. Here, you need to add the entry skip-grant-tables under the [mysqld] section. This allows anyone to access the database without authentication. After restarting the MySQL Server, I was suddenly able to begin the iTop installation. Just for your information, I encountered this error message before setting the entry in the my.ini file: "Could not connect to the DB server: host = , user = , mysql_errno = 1045, mysql_error = Access denied for user ''@'localhost' (using password: YES)".
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have found the error and hope the solution will help some of you too. It's MariaDB or MySQL, iTop requires access to the SQL Server without user data. But only during the initial installation. In the directory, for example MySQL "C:\ 'ProgramData or Program Files' \MySQL\MySQL Server x.x", there is a file named my.ini. Here, you need to add the entry skip-grant-tables under the [mysqld] section. This allows anyone to access the database without authentication. After restarting the MySQL Server, I was suddenly able to begin the iTop installation. Just for your information, I encountered this error message before setting the entry in the my.ini file: "Could not connect to the DB server: host = , user = , mysql_errno = 1045, mysql_error = Access denied for user ''@'localhost' (using password: YES)".
Hello everyone, I have the following issue. iTop was previously in use on my system, installed under Linux. However, no data was provided to me during the handover. Now the system has failed, and due to the lack of data, I am unable to get it running again. I'm trying to install the system on Windows, but I'm having trouble following the existing instructions. I've installed MySQL, copied PHP, and copied iTop, integrating everything under IIS. PHP is running, and I can start the setup. During the initial check, everything is OK, and all extensions are present. However, when I click "Next," I encounter an error and can't proceed. It always says that there is no access in connection with MySQL. But what kind of access is it referring to? Is there a user that needs to be created with a specific password? In one attempt, I removed the password from the root user and was able to proceed with an older version of iTop and complete everything. However, I faced the same issue during the update. Can someone guide me on how to install and get iTop running on Windows precisely? Or do most people use it under Linux? Regards, Stefan
Have you checked whether your IIS server (Windows host) can connect to the MySQL server? The user is specified in config-itop.php.
I would always recommend running it on a dedicated Ubuntu virtual machine; but it's perfectly possible to run everything on Windows.
Last edit: Jeffrey Bostoen 2024-02-05
The IIS has access to MySQL, I've verified that. The config-itop.php file is generated only after a successful configuration. I had already attempted an installation on Ubuntu, but during the configuration, the Apache suddenly shut down, and I can't get it running again.
During the iTop installation wizard: are you able to connect to your existing database with the database user credentials?
I have found the error and hope the solution will help some of you too. It's MariaDB or MySQL, iTop requires access to the SQL Server without user data. But only during the initial installation. In the directory, for example MySQL "C:\ 'ProgramData or Program Files' \MySQL\MySQL Server x.x", there is a file named my.ini. Here, you need to add the entry skip-grant-tables under the [mysqld] section. This allows anyone to access the database without authentication. After restarting the MySQL Server, I was suddenly able to begin the iTop installation. Just for your information, I encountered this error message before setting the entry in the my.ini file: "Could not connect to the DB server: host = , user = , mysql_errno = 1045, mysql_error = Access denied for user ''@'localhost' (using password: YES)".
Thank you!