NomisCZ / hlstatsx-community-edition

HLstatsX Community Edition - PHP 7 and GeoIP2 supported
GNU General Public License v2.0
83 stars 48 forks source link

Perl Modules Installed but file cannot be located!! #72

Closed Pervaded closed 1 year ago

Pervaded commented 2 years ago

NomiCZ i was running perfectly fine the stats but 2 weeks ago im come up with this issue after php updates or MariaDB:

Log File: ------------ERROR 1------------- install_driver(mysql) failed: Can't load '/home/greekgam/perl/usr/lib64/perl5/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.20: cannot open shared object file: No such file or directory at /usr/lib64/perl5/DynaLoader.pm line 190. at (eval 10) line 3. Compilation failed in require at (eval 10) line 3. Perhaps a required shared library or dll isn't installed where expected at /home/greekgam/perl//HLstats.plib line 152. ------------ERROR 2--------------------------- DBI connect('csgreekg_hlxce:localhost','csgreekg_hlx',...) failed: Access denied for user 'csgreekg_hlx'@'localhost' (using password: YES) at /home/greekgam/perl//HLstats.plib line 160. : - MYSQL: Can't connect to MySQL database 'csgreekg_hlxce' on 'localhost' Server error: Access denied for user 'csgreekg_hlx'@'localhost' (using password: YES)

Im just thinking its host issue and not mine what do you believe?

this is their answers: 1)Mariadb doesent recognise mysql as i know only mysqli and your php is mysql. Check error line what it says in your hlstats file. Its myslq problem.(Actualy the php files are already at mysqli as i see and edited for php 7.2)

Have you ever dealed with that? because i think its like their modules are not installed correctly or hlstatsx are looking in wrong libraries. what do you think?is there anything i can do?

Thanks in advance.!

Pervaded commented 2 years ago

Solved.

For ERROR 1 Solution was that that the script (run_hlstats) was looking at wrong perl paths to find the perm modules required. Usually the perl modules app at cpanel provides this path as correct searching path for modules at the very top offer script:

!/usr/bin/perlml

but its better to have it as default like this:

!/usr/bin/perl

So that the script looks correctly for perl modules files.

For ERROR 2 You have to use the same database table both for your main website and hlstatsx website. That means the install.sql file must be uploaded to the same database your main website tables are.

This happens only in MariaDB for some reason when you create a new database other than the main database for some reason the root access is limited thats why it returns that error.Thats why hlstatsx must be in the same database as your main website is.

Thats all.