john9
-
Posts
53 -
Joined
-
Last visited
Posts posted by john9
-
-
Ehi there,
Froxlor seems working fine but when I transfer the database, phpmyadmin do accept it but it says
Warning in ./libraries/sql.lib.php#613
count(): Parameter must be an array or an object that implements Countable
Backtrace
./libraries/sql.lib.php#2128: PMA_isRememberSortingOrder(array)
./libraries/sql.lib.php#2079: PMA_executeQueryAndGetQueryResponse(
array,
boolean true,
string 'Algosql1',
string 'wp_postmeta',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `wp_postmeta`',
NULL,
NULL,
)
./sql.php#221: PMA_executeQueryAndSendQueryResponse(
array,
boolean true,
string 'Algosql1',
string 'wp_postmeta',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `wp_postmeta`',
NULL,
NULL,
)and I tried fixing it with https://medium.com/@chaloemphonthipkasorn/แก้-bug-phpmyadmin-php7-2-ubuntu-16-04-92b287090b01
adding (array) just before $analyzed (my bug was a little different)
&& ((empty($analyzed_sql_results['select_expr']))
|| (count((array)$analyzed_sql_results['select_expr'] == 1)but it didn't fix. I guess it has nothing to do with Froxlor but myabe you have some ideas
-
maybe i'm wrong. I recheck everything. Thank you.
-
Thank you for your help. I'll try to replicate it again on a different server soon.
BUT
why I cannot see my phpmyadmin if it has been installed and I run
sudo ln -s /usr/share/phpmyadmin/ /var/www/phpmyadmin
-
-
-
-
You mean this:
VirtualHost configuration:
*:80 biz.algorithmicseo.xyz (/etc/apache2/sites-enabled/000-default.conf:1)
ServerRoot: "/etc/apache2"
Main DocumentRoot: "/var/www/html"
Main ErrorLog: "/var/log/apache2/error.log"
Mutex default: dir="/var/run/apache2/" mechanism=default
Mutex mpm-accept: using_defaults
Mutex watchdog-callback: using_defaults
PidFile: "/var/run/apache2/apache2.pid"
Define: DUMP_VHOSTS
Define: DUMP_RUN_CFG
User: name="www-data" id=33
Group: name="www-data" id=33
unfortunately I see the main document root is still var www html
that's quite strange because I'm sure to have edited that folder
-
I have already redownloaded it and reinstalled it
-
In the Froxlor folder yes.
that's the full list.
-
/var/www/
-
root@biz:~# ls -l /var/www/froxlor/
total 612
-rw-r--r-- 1 www-data www-data 2713 Nov 1 13:27 2fa.php
drwxr-xr-x 3 www-data www-data 4096 Nov 1 13:27 actions
-rw-r--r-- 1 www-data www-data 13445 Nov 1 13:27 admin_admins.php
-rw-r--r-- 1 www-data www-data 15043 Nov 1 13:27 admin_apcuinfo.php
-rw-r--r-- 1 www-data www-data 7256 Nov 1 13:27 admin_autoupdate.php
-rw-r--r-- 1 www-data www-data 9430 Nov 1 13:27 admin_configfiles.php
-rw-r--r-- 1 www-data www-data 4600 Nov 1 13:27 admin_cronjobs.php
-rw-r--r-- 1 www-data www-data 18717 Nov 1 13:27 admin_customers.php
-rw-r--r-- 1 www-data www-data 31839 Nov 1 13:27 admin_domains.php
-rw-r--r-- 1 www-data www-data 14156 Nov 1 13:27 admin_index.php
-rw-r--r-- 1 www-data www-data 5487 Nov 1 13:27 admin_ipsandports.php
-rw-r--r-- 1 www-data www-data 4265 Nov 1 13:27 admin_logger.php
-rw-r--r-- 1 www-data www-data 4178 Nov 1 13:27 admin_message.php
-rw-r--r-- 1 www-data www-data 7094 Nov 1 13:27 admin_opcacheinfo.php
-rw-r--r-- 1 www-data www-data 11103 Nov 1 13:27 admin_phpsettings.php
-rw-r--r-- 1 www-data www-data 12329 Nov 1 13:27 admin_plans.php
-rw-r--r-- 1 www-data www-data 14160 Nov 1 13:27 admin_settings.php
-rw-r--r-- 1 www-data www-data 17644 Nov 1 13:27 admin_templates.php
-rw-r--r-- 1 www-data www-data 4142 Nov 1 13:27 admin_traffic.php
-rw-r--r-- 1 www-data www-data 4080 Nov 1 13:27 admin_updates.php
-rw-r--r-- 1 www-data www-data 7815 Nov 1 13:27 api_keys.php
-rw-r--r-- 1 www-data www-data 2096 Nov 1 13:27 api.php
-rw-r--r-- 1 www-data www-data 10918 Nov 1 13:27 build.xml
-rw-r--r-- 1 www-data www-data 2155 Nov 1 13:27 composer.json
-rw-r--r-- 1 www-data www-data 105960 Nov 1 13:27 composer.lock
-rw-r--r-- 1 www-data www-data 15146 Nov 1 13:27 COPYING
drwxr-xr-x 3 www-data www-data 4096 Nov 1 13:27 css
-rw-r--r-- 1 www-data www-data 22412 Nov 1 13:27 customer_domains.php
-rw-r--r-- 1 www-data www-data 19153 Nov 1 13:27 customer_email.php
-rw-r--r-- 1 www-data www-data 15747 Nov 1 13:27 customer_extras.php
-rw-r--r-- 1 www-data www-data 8752 Nov 1 13:27 customer_ftp.php
-rw-r--r-- 1 www-data www-data 13428 Nov 1 13:27 customer_index.php
-rw-r--r-- 1 www-data www-data 4028 Nov 1 13:27 customer_logger.php
-rw-r--r-- 1 www-data www-data 7949 Nov 1 13:27 customer_mysql.php
-rw-r--r-- 1 www-data www-data 7938 Nov 1 13:27 customer_traffic.php
-rw-r--r-- 1 www-data www-data 3905 Nov 1 13:27 dns_editor.php
drwxr-xr-x 3 www-data www-data 4096 Nov 1 13:27 doc
-rw-r--r-- 1 www-data www-data 26781 Nov 1 13:27 index.php
drwxr-xr-x 7 www-data www-data 4096 Nov 1 13:27 install
drwxr-xr-x 3 www-data www-data 4096 Nov 1 13:27 js
drwxr-xr-x 6 www-data www-data 4096 Nov 1 13:27 lib
drwxr-xr-x 2 www-data www-data 4096 Nov 1 13:27 lng
-rw-r--r-- 1 www-data www-data 3243 Nov 1 13:27 logfiles_viewer.php
drwxr-xr-x 2 www-data www-data 4096 Nov 1 13:27 logs
-rw-r--r-- 1 www-data www-data 1309 Nov 1 13:27 phpcs.xml
-rw-r--r-- 1 www-data www-data 1119 Nov 1 13:27 phpdox.xml
-rw-r--r-- 1 www-data www-data 1325 Nov 1 13:27 phpmd.xml
-rw-r--r-- 1 www-data www-data 1606 Nov 1 13:27 phpunit.xml
-rw-r--r-- 1 www-data www-data 1906 Nov 1 13:27 README.md
drwxr-xr-x 2 www-data www-data 4096 Nov 1 13:27 scripts
-rw-r--r-- 1 www-data www-data 749 Nov 1 13:27 SECURITY.md
-rw-r--r-- 1 www-data www-data 5610 Nov 1 13:27 ssl_certificates.php
drwxr-xr-x 4 www-data www-data 4096 Nov 1 13:27 templates
drwxr-xr-x 19 www-data www-data 4096 Nov 1 13:27 tests
drwxr-xr-x 8 www-data www-data 4096 Nov 1 13:27 vendor
-
ehi there, I've been able to edit it using NANO, but despite my default document root is /var/www and I have installed froxflor too
I still have the same issue
Could not create /var/www/html/froxlor/lib/userdata.inc.php, please create it manually with the following content:
and I'm also wondering how it still uses var/www/html if the documentRoot is just www
-
Thank you for the clarification.
I'm struggling to find the wiki entry you mentioned above so to adjust the default vhost
please note I have already done the below steps:
https://github.com/Froxlor/Froxlor/wiki/Install-froxlor-on-ubuntu
https://github.com/Froxlor/Froxlor/wiki/Install-froxlor-from-tarball
-
should I change all to -rw-r-r- ?
-
example
-rw-r--r-- 1 1000 1000 1309 Nov 1 13:27 phpcs.xml
-rw-r--r-- 1 1000 1000 1119 Nov 1 13:27 phpdox.xml
-rw-r--r-- 1 1000 1000 1325 Nov 1 13:27 phpmd.xml
-rw-r--r-- 1 1000 1000 1606 Nov 1 13:27 phpunit.xml
-rw-r--r-- 1 1000 1000 1906 Nov 1 13:27 README.md
drwxr-xr-x 2 1000 1000 4096 Nov 1 13:27 scripts
-rw-r--r-- 1 1000 1000 749 Nov 1 13:27 SECURITY.md
-rw-r--r-- 1 1000 1000 5610 Nov 1 13:27 ssl_certificates.php
drwxr-xr-x 4 1000 1000 4096 Nov 1 13:27 templates
drwxr-xr-x 19 1000 1000 4096 Nov 1 13:27 tests
drwxr-xr-x 8 1000 1000 4096 Nov 1 13:27 vendor
-
I did check the ownership with ls -l /var/www/html/froxlor/ but it provided me with the list of files
-
And I have that froxlor folder too
-
user name and group name www-data
the permissions should be already set for this user
-
yes the main document root is /var/www/html/
-
root@biz:~# ps faux | grep apache
root 19974 0.0 0.0 14428 992 pts/0 S+ 08:57 0:00 \_ grep --color=auto apache
root 19549 0.0 2.7 497268 27068 ? Ss 08:16 0:00 /usr/sbin/apache2 -k start
www-data 19569 0.0 2.2 500428 22044 ? S 08:16 0:00 \_ /usr/sbin/apache2 -k start
www-data 19570 0.0 2.0 500288 20784 ? S 08:16 0:00 \_ /usr/sbin/apache2 -k start
www-data 19571 0.0 1.5 499632 15212 ? S 08:16 0:00 \_ /usr/sbin/apache2 -k start
www-data 19572 0.0 2.3 500372 23412 ? S 08:16 0:00 \_ /usr/sbin/apache2 -k start
www-data 19573 0.0 2.1 500364 21712 ? S 08:16 0:00 \_ /usr/sbin/apache2 -k start
www-data 19577 0.0 1.5 499608 15212 ? S 08:16 0:00 \_ /usr/sbin/apache2 -k start
-
root@biz:~# ls -la /var/www/
total 20
drwxr-xr-x 5 root root 4096 Nov 12 07:50 .
drwxr-xr-x 14 root root 4096 Nov 4 09:53 ..
drwxr-xr-x 15 www-data www-data 4096 Nov 1 13:27 froxlor
drwxr-xr-x 15 www-data www-data 4096 Nov 11 21:48 html
drwxr-xr-x 2 root root 4096 Nov 12 07:39 webalizer
-
following step by step https://github.com/Froxlor/Froxlor/wiki/Install-froxlor-on-ubuntu
and https://github.com/Froxlor/Froxlor/wiki/Install-froxlor-from-tarball
At the end of everything I come back to the same error message:
Could not create /var/www/html/froxlor/lib/userdata.inc.php, please create it manually with the following content
at same the chown command seems does not fix this issue
I'm ready to create it manually if you suggest me a kind of tutorial (not tons of pages)
-
I wasn't on it. I'm on it. I mean I'm installing it.
I understand the last parts are my issues. Let's see it.
For instance thank you very much for your support.
-
Just to be sure I'm on the right path - I'm on it.
https://github.com/Froxlor/Froxlor/wiki/Install-froxlor-on-ubuntu
Cannot Move Froxlor to VAR HTML
in General Discussion
Posted
Ok. :) Thank you.