PDA

View Full Version : A bit more networking left on the to do list!



tarzy
08-Oct-2013, 07:14
Hello to all,

I have maybe one issue left, which I sensed after studying my plans for the directories' content (php database-driven cms on both virtual hosts) on my Server, which is no access to phpMyAdmin, as well as localhost, and 127.0.0.1.

My last post re: Network blundering successfully solved (thanks to this forum!) my local IP address' access to both vhost 1, and vhost 2, so I can display my main index page to both with perfect results. As mentioned, LAN IP gives both hosts dirs, but no phpMyAdmin, and replacing ip with either localhost or 127.0.0.1 gives a can't connect to the server, even without attempting to access phpMyAdmin.

I will post terminal output for php now, and after I find out the command for localhost and 127, I'll post them if neccessary.

************************************************** ************************************************** ****************
linux-2u6o:~ # ls -la /srv/www/htdocs/phpMyAdmin/
total 964
drwxr-xr-x 6 root root 4096 Oct 6 18:21 .
drwxr-xr-x 5 root root 4096 Oct 4 17:22 ..
-rw-r--r-- 1 root root 11178 Aug 7 06:12 browse_foreigners.php
-rw-r--r-- 1 root root 4798 Aug 7 06:12 changelog.php
-rw-r--r-- 1 root root 308 Aug 7 06:12 chk_rel.php
-rwxr--r-- 1 root root 12443 Oct 6 18:21 config.inc.php
-rw-r--r-- 1 root root 12444 Oct 6 18:19 config.inc.php~
-rw-r--r-- 1 root root 12351 Aug 7 06:12 config.sample.inc.php
-rw-r--r-- 1 root root 4262 Aug 7 06:12 db_create.php
-rw-r--r-- 1 root root 8948 Aug 7 06:12 db_datadict.php
-rw-r--r-- 1 root root 401 Aug 7 06:12 db_events.php
-rw-r--r-- 1 root root 2694 Aug 7 06:12 db_export.php
-rw-r--r-- 1 root root 493 Aug 7 06:12 db_import.php
-rw-r--r-- 1 root root 9215 Aug 7 06:12 db_operations.php
-rw-r--r-- 1 root root 7110 Aug 7 06:12 db_printview.php
-rw-r--r-- 1 root root 1596 Aug 7 06:12 db_qbe.php
-rw-r--r-- 1 root root 454 Aug 7 06:12 db_routines.php
-rw-r--r-- 1 root root 1636 Aug 7 06:12 db_search.php
-rw-r--r-- 1 root root 1331 Aug 7 06:12 db_sql.php
-rw-r--r-- 1 root root 10012 Aug 7 06:12 db_structure.php
-rw-r--r-- 1 root root 8175 Aug 7 06:12 db_tracking.php
-rw-r--r-- 1 root root 364 Aug 7 06:12 db_triggers.php
-rw-r--r-- 1 root root 34089 Aug 7 06:12 export.php
-rw-r--r-- 1 root root 18902 Aug 7 06:12 favicon.ico
-rw-r--r-- 1 root root 2143 Aug 7 06:12 file_echo.php
-rw-r--r-- 1 root root 15529 Aug 7 06:12 gis_data_editor.php
-rw-r--r-- 1 root root 20321 Aug 7 06:12 import.php
-rw-r--r-- 1 root root 2892 Aug 7 06:12 import_status.php
-rw-r--r-- 1 root root 18833 Aug 7 06:12 index.php
drwxr-xr-x 8 root root 4096 Oct 4 17:22 js
drwxr-xr-x 15 root root 4096 Oct 4 17:22 libraries
-rw-r--r-- 1 root root 728 Aug 7 06:12 license.php
drwxr-xr-x 43 root root 4096 Oct 4 17:22 locale
-rw-r--r-- 1 root root 696 Aug 7 06:12 navigation.php
-rw-r--r-- 1 root root 389 Aug 7 06:12 phpinfo.php
-rw-r--r-- 1 root root 746 Aug 7 06:12 phpmyadmin.css.php
-rw-r--r-- 1 root root 2150 Aug 7 06:12 pmd_display_field.php
-rw-r--r-- 1 root root 36878 Aug 7 06:12 pmd_general.php
-rw-r--r-- 1 root root 4943 Aug 7 06:12 pmd_pdf.php
-rw-r--r-- 1 root root 4318 Aug 7 06:12 pmd_relation_new.php
-rw-r--r-- 1 root root 2355 Aug 7 06:12 pmd_relation_upd.php
-rw-r--r-- 1 root root 2443 Aug 7 06:12 pmd_save_pos.php
-rw-r--r-- 1 root root 2555 Aug 7 06:12 prefs_forms.php
-rw-r--r-- 1 root root 14327 Aug 7 06:12 prefs_manage.php
-rw-r--r-- 1 root root 1213 Aug 7 06:12 print.css
-rw-r--r-- 1 root root 6222 Aug 7 06:12 querywindow.php
-rw-r--r-- 1 root root 3967 Aug 7 06:12 schema_edit.php
-rw-r--r-- 1 root root 1712 Aug 7 06:12 schema_export.php
-rw-r--r-- 1 root root 6205 Aug 7 06:12 server_binlog.php
-rw-r--r-- 1 root root 2304 Aug 7 06:12 server_collations.php
-rw-r--r-- 1 root root 11421 Aug 7 06:12 server_databases.php
-rw-r--r-- 1 root root 4050 Aug 7 06:12 server_engines.php
-rw-r--r-- 1 root root 2261 Aug 7 06:12 server_export.php
-rw-r--r-- 1 root root 431 Aug 7 06:12 server_import.php
-rw-r--r-- 1 root root 6594 Aug 7 06:12 server_plugins.php
-rw-r--r-- 1 root root 15927 Aug 7 06:12 server_privileges.php
-rw-r--r-- 1 root root 14697 Aug 7 06:12 server_replication.php
-rw-r--r-- 1 root root 524 Aug 7 06:12 server_sql.php
-rw-r--r-- 1 root root 2193 Aug 7 06:12 server_status_advisor.php
-rw-r--r-- 1 root root 29621 Aug 7 06:12 server_status_monitor.php
-rw-r--r-- 1 root root 16719 Aug 7 06:12 server_status.php
-rw-r--r-- 1 root root 5723 Aug 7 06:12 server_status_queries.php
-rw-r--r-- 1 root root 30044 Aug 7 06:12 server_status_variables.php
-rw-r--r-- 1 root root 7857 Aug 7 06:12 server_variables.php
-rw-r--r-- 1 root root 1039 Aug 7 06:12 show_config_errors.php
-rw-r--r-- 1 root root 59880 Aug 7 06:12 sql.php
-rw-r--r-- 1 root root 8660 Aug 7 06:12 tbl_addfield.php
-rw-r--r-- 1 root root 13691 Aug 7 06:12 tbl_change.php
-rw-r--r-- 1 root root 9476 Aug 7 06:12 tbl_chart.php
-rw-r--r-- 1 root root 15868 Aug 7 06:12 tbl_create.php
-rw-r--r-- 1 root root 2855 Aug 7 06:12 tbl_export.php
-rw-r--r-- 1 root root 1451 Aug 7 06:12 tbl_get_field.php
-rw-r--r-- 1 root root 7308 Aug 7 06:12 tbl_gis_visualization.php
-rw-r--r-- 1 root root 574 Aug 7 06:12 tbl_import.php
-rw-r--r-- 1 root root 10827 Aug 7 06:12 tbl_indexes.php
-rw-r--r-- 1 root root 2798 Aug 7 06:12 tbl_move_copy.php
-rw-r--r-- 1 root root 11470 Aug 7 06:12 tbl_operations.php
-rw-r--r-- 1 root root 15959 Aug 7 06:12 tbl_printview.php
-rw-r--r-- 1 root root 27396 Aug 7 06:12 tbl_relation.php
-rw-r--r-- 1 root root 13340 Aug 7 06:12 tbl_replace.php
-rw-r--r-- 1 root root 4008 Aug 7 06:12 tbl_row_action.php
-rw-r--r-- 1 root root 1966 Aug 7 06:12 tbl_select.php
-rw-r--r-- 1 root root 928 Aug 7 06:12 tbl_sql.php
-rw-r--r-- 1 root root 13587 Aug 7 06:12 tbl_structure.php
-rw-r--r-- 1 root root 31246 Aug 7 06:12 tbl_tracking.php
-rw-r--r-- 1 root root 144 Aug 7 06:12 tbl_triggers.php
-rw-r--r-- 1 root root 5978 Aug 7 06:12 tbl_zoom_select.php
drwxr-xr-x 4 root root 4096 Oct 4 17:22 themes
-rw-r--r-- 1 root root 835 Aug 7 06:12 themes.php
-rw-r--r-- 1 root root 1306 Aug 7 06:12 transformation_overview.php
-rw-r--r-- 1 root root 3771 Aug 7 06:12 transformation_wrapper.php
-rw-r--r-- 1 root root 471 Aug 7 06:12 url.php
-rw-r--r-- 1 root root 6755 Aug 7 06:12 user_password.php
-rw-r--r-- 1 root root 1453 Aug 7 06:12 version_check.php
-rw-r--r-- 1 root root 7070 Aug 7 06:12 view_create.php
-rw-r--r-- 1 root root 2671 Aug 7 06:12 view_operations.php
-rw-r--r-- 1 root root 1128 Aug 7 06:12 webapp.php
************************************************** ************************************************** *************

I may be a bit slow to respond here and in my work here as I've sustained a family tragedy last Thursday and the Funeral is tomorrow, so bear with me if I don't check in for a few days, although I'll say keeping busy and my 3 fine little Lhasas have made life bearable since I was last here.

Regards to all, tarzy

ab
08-Oct-2013, 13:02
On 10/08/2013 12:24 AM, tarzy wrote:
>
> Hello to all,
>
> I have maybe one issue left, which I sensed after studying my plans for
> the directories' content (php database-driven cms on both virtual hosts)
> on my Server, which is no access to phpMyAdmin, as well as localhost,
> and 127.0.0.1.

Are you trying to access either 'localhost' or '127.0.0.1' from the server
itself? If not, it's a futile endeavor. If so, post the output from the
following command to see if the web service is even listening on the
non-network-accessible IPs:

Code:
--------------------
/usr/sbin/ss -planeto | grep ':80\|:443'
--------------------

> ************************************************** ************************************************** ****************
> linux-2u6o:~ # ls -la /srv/www/htdocs/phpMyAdmin/
> total 964
> drwxr-xr-x 6 root root 4096 Oct 6 18:21 .
> drwxr-xr-x 5 root root 4096 Oct 4 17:22 ..
> -rw-r--r-- 1 root root 11178 Aug 7 06:12 browse_foreigners.php
> -rw-r--r-- 1 root root 4798 Aug 7 06:12 changelog.php
> -rw-r--r-- 1 root root 308 Aug 7 06:12 chk_rel.php
> -rwxr--r-- 1 root root 12443 Oct 6 18:21 config.inc.php
> -rw-r--r-- 1 root root 12444 Oct 6 18:19 config.inc.php~
> -rw-r--r-- 1 root root 12351 Aug 7 06:12 config.sample.inc.php
> -rw-r--r-- 1 root root 4262 Aug 7 06:12 db_create.php
> -rw-r--r-- 1 root root 8948 Aug 7 06:12 db_datadict.php
> -rw-r--r-- 1 root root 401 Aug 7 06:12 db_events.php
> -rw-r--r-- 1 root root 2694 Aug 7 06:12 db_export.php
> -rw-r--r-- 1 root root 493 Aug 7 06:12 db_import.php
> -rw-r--r-- 1 root root 9215 Aug 7 06:12 db_operations.php
> -rw-r--r-- 1 root root 7110 Aug 7 06:12 db_printview.php
> -rw-r--r-- 1 root root 1596 Aug 7 06:12 db_qbe.php
> -rw-r--r-- 1 root root 454 Aug 7 06:12 db_routines.php
> -rw-r--r-- 1 root root 1636 Aug 7 06:12 db_search.php
> -rw-r--r-- 1 root root 1331 Aug 7 06:12 db_sql.php
> -rw-r--r-- 1 root root 10012 Aug 7 06:12 db_structure.php
> -rw-r--r-- 1 root root 8175 Aug 7 06:12 db_tracking.php
> -rw-r--r-- 1 root root 364 Aug 7 06:12 db_triggers.php
> -rw-r--r-- 1 root root 34089 Aug 7 06:12 export.php
> -rw-r--r-- 1 root root 18902 Aug 7 06:12 favicon.ico
> -rw-r--r-- 1 root root 2143 Aug 7 06:12 file_echo.php
> -rw-r--r-- 1 root root 15529 Aug 7 06:12 gis_data_editor.php
> -rw-r--r-- 1 root root 20321 Aug 7 06:12 import.php
> -rw-r--r-- 1 root root 2892 Aug 7 06:12 import_status.php
> -rw-r--r-- 1 root root 18833 Aug 7 06:12 index.php
> drwxr-xr-x 8 root root 4096 Oct 4 17:22 js
> drwxr-xr-x 15 root root 4096 Oct 4 17:22 libraries
> -rw-r--r-- 1 root root 728 Aug 7 06:12 license.php
> drwxr-xr-x 43 root root 4096 Oct 4 17:22 locale
> -rw-r--r-- 1 root root 696 Aug 7 06:12 navigation.php
> -rw-r--r-- 1 root root 389 Aug 7 06:12 phpinfo.php
> -rw-r--r-- 1 root root 746 Aug 7 06:12 phpmyadmin.css.php
> -rw-r--r-- 1 root root 2150 Aug 7 06:12 pmd_display_field.php
> -rw-r--r-- 1 root root 36878 Aug 7 06:12 pmd_general.php
> -rw-r--r-- 1 root root 4943 Aug 7 06:12 pmd_pdf.php
> -rw-r--r-- 1 root root 4318 Aug 7 06:12 pmd_relation_new.php
> -rw-r--r-- 1 root root 2355 Aug 7 06:12 pmd_relation_upd.php
> -rw-r--r-- 1 root root 2443 Aug 7 06:12 pmd_save_pos.php
> -rw-r--r-- 1 root root 2555 Aug 7 06:12 prefs_forms.php
> -rw-r--r-- 1 root root 14327 Aug 7 06:12 prefs_manage.php
> -rw-r--r-- 1 root root 1213 Aug 7 06:12 print.css
> -rw-r--r-- 1 root root 6222 Aug 7 06:12 querywindow.php
> -rw-r--r-- 1 root root 3967 Aug 7 06:12 schema_edit.php
> -rw-r--r-- 1 root root 1712 Aug 7 06:12 schema_export.php
> -rw-r--r-- 1 root root 6205 Aug 7 06:12 server_binlog.php
> -rw-r--r-- 1 root root 2304 Aug 7 06:12 server_collations.php
> -rw-r--r-- 1 root root 11421 Aug 7 06:12 server_databases.php
> -rw-r--r-- 1 root root 4050 Aug 7 06:12 server_engines.php
> -rw-r--r-- 1 root root 2261 Aug 7 06:12 server_export.php
> -rw-r--r-- 1 root root 431 Aug 7 06:12 server_import.php
> -rw-r--r-- 1 root root 6594 Aug 7 06:12 server_plugins.php
> -rw-r--r-- 1 root root 15927 Aug 7 06:12 server_privileges.php
> -rw-r--r-- 1 root root 14697 Aug 7 06:12 server_replication.php
> -rw-r--r-- 1 root root 524 Aug 7 06:12 server_sql.php
> -rw-r--r-- 1 root root 2193 Aug 7 06:12 server_status_advisor.php
> -rw-r--r-- 1 root root 29621 Aug 7 06:12 server_status_monitor.php
> -rw-r--r-- 1 root root 16719 Aug 7 06:12 server_status.php
> -rw-r--r-- 1 root root 5723 Aug 7 06:12 server_status_queries.php
> -rw-r--r-- 1 root root 30044 Aug 7 06:12 server_status_variables.php
> -rw-r--r-- 1 root root 7857 Aug 7 06:12 server_variables.php
> -rw-r--r-- 1 root root 1039 Aug 7 06:12 show_config_errors.php
> -rw-r--r-- 1 root root 59880 Aug 7 06:12 sql.php
> -rw-r--r-- 1 root root 8660 Aug 7 06:12 tbl_addfield.php
> -rw-r--r-- 1 root root 13691 Aug 7 06:12 tbl_change.php
> -rw-r--r-- 1 root root 9476 Aug 7 06:12 tbl_chart.php
> -rw-r--r-- 1 root root 15868 Aug 7 06:12 tbl_create.php
> -rw-r--r-- 1 root root 2855 Aug 7 06:12 tbl_export.php
> -rw-r--r-- 1 root root 1451 Aug 7 06:12 tbl_get_field.php
> -rw-r--r-- 1 root root 7308 Aug 7 06:12 tbl_gis_visualization.php
> -rw-r--r-- 1 root root 574 Aug 7 06:12 tbl_import.php
> -rw-r--r-- 1 root root 10827 Aug 7 06:12 tbl_indexes.php
> -rw-r--r-- 1 root root 2798 Aug 7 06:12 tbl_move_copy.php
> -rw-r--r-- 1 root root 11470 Aug 7 06:12 tbl_operations.php
> -rw-r--r-- 1 root root 15959 Aug 7 06:12 tbl_printview.php
> -rw-r--r-- 1 root root 27396 Aug 7 06:12 tbl_relation.php
> -rw-r--r-- 1 root root 13340 Aug 7 06:12 tbl_replace.php
> -rw-r--r-- 1 root root 4008 Aug 7 06:12 tbl_row_action.php
> -rw-r--r-- 1 root root 1966 Aug 7 06:12 tbl_select.php
> -rw-r--r-- 1 root root 928 Aug 7 06:12 tbl_sql.php
> -rw-r--r-- 1 root root 13587 Aug 7 06:12 tbl_structure.php
> -rw-r--r-- 1 root root 31246 Aug 7 06:12 tbl_tracking.php
> -rw-r--r-- 1 root root 144 Aug 7 06:12 tbl_triggers.php
> -rw-r--r-- 1 root root 5978 Aug 7 06:12 tbl_zoom_select.php
> drwxr-xr-x 4 root root 4096 Oct 4 17:22 themes
> -rw-r--r-- 1 root root 835 Aug 7 06:12 themes.php
> -rw-r--r-- 1 root root 1306 Aug 7 06:12 transformation_overview.php
> -rw-r--r-- 1 root root 3771 Aug 7 06:12 transformation_wrapper.php
> -rw-r--r-- 1 root root 471 Aug 7 06:12 url.php
> -rw-r--r-- 1 root root 6755 Aug 7 06:12 user_password.php
> -rw-r--r-- 1 root root 1453 Aug 7 06:12 version_check.php
> -rw-r--r-- 1 root root 7070 Aug 7 06:12 view_create.php
> -rw-r--r-- 1 root root 2671 Aug 7 06:12 view_operations.php
> -rw-r--r-- 1 root root 1128 Aug 7 06:12 webapp.php
> ************************************************** ************************************************** *************

These all look okay to me. Note that the directory name is
case-sensitive, so are you accessing http://box.here/phpMyAdmin/ or
http://box.here/phpmyadmin/ ? I would highly recommend renaming
'phpMyAdmin' to 'phpmyadmin' in the filesystem since, generally speaking,
upper-case characters in URLs just cause human problems.

> I may be a bit slow to respond here and in my work here as I've
> sustained a family tragedy last Thursday and the Funeral is tomorrow, so
> bear with me if I don't check in for a few days, although I'll say
> keeping busy and my 3 fine little Lhasas have made life bearable since I
> was last here.

I'm sorry to hear about your tragedy. Do not worry about us; we are
pretty patient around here with replies.

Good luck.

ab
08-Oct-2013, 13:03
Btw... it may be useful to see what happens in /var/log/apache2/access_log
and /var/log/apache2/error_log when trying to access the PhpMyAdmin URL.
Post everything happening at the time you point your browser to the real
IP address and the phpmyadmin URL and let's see what shows up.

Good luck.

tarzy
08-Oct-2013, 19:04
Here's the output from the given command, which I have saved for future use:
************************************************** ************************************************** ************************
linux-2u6o:~ # /usr/sbin/ss -planeto | grep ':80\|:443'
LISTEN 0 128 *:22 *:* users:(("sshd",2750,3)) ino:8015 sk:b6363480ffff8800
LISTEN 0 128 192.168.1.26:80 *:* users:(("httpd2-prefork",17786,3),("httpd2-prefork",17787,3),("httpd2-prefork",17788,3),("httpd2-prefork",17789,3),("httpd2-prefork",17790,3),("httpd2-prefork",17791,3),("httpd2-prefork",17797,3)) ino:1456535 sk:b436f4c0ffff8800
ESTAB 0 0 192.168.1.26:38403 130.57.66.10:443 users:(("firefox",14704,94)) ino:1500217 sk:b696f800ffff8800
ESTAB 0 0 192.168.1.26:38398 130.57.66.10:443 users:(("firefox",14704,67)) ino:1500212 sk:b436e080ffff8800
ESTAB 0 0 192.168.1.26:53852 130.57.66.3:443 users:(("firefox",14704,103)) ino:1500404 sk:2943e480ffff8800
TIME-WAIT 0 0 192.168.1.26:38370 130.57.66.10:443 timer:(timewait,55sec,0) ino:0 sk:22e0fa40ffff8800
ESTAB 0 0 192.168.1.26:38400 130.57.66.10:443 users:(("firefox",14704,91)) ino:1500214 sk:42975100ffff8800
ESTAB 0 0 192.168.1.26:51946 130.57.66.4:443 users:(("firefox",14704,75)) ino:1500396 sk:b6dea180ffff8800
ESTAB 0 0 192.168.1.26:38402 130.57.66.10:443 users:(("firefox",14704,93)) ino:1500216 sk:42974380ffff8800
TIME-WAIT 0 0 192.168.1.26:38381 130.57.66.10:443 timer:(timewait,55sec,0) ino:0 sk:22e0fb00ffff8800
ESTAB 0 0 192.168.1.26:38399 130.57.66.10:443 users:(("firefox",14704,84)) ino:1500213 sk:b436ee00ffff8800
ESTAB 0 0 192.168.1.26:38369 130.57.66.10:443 users:(("firefox",14704,56)) ino:1499175 sk:b6deaf00ffff8800
ESTAB 0 0 192.168.1.26:53851 130.57.66.3:443 users:(("firefox",14704,102)) ino:1500403 sk:2943eb40ffff8800
ESTAB 0 0 192.168.1.26:46642 130.57.66.5:443 users:(("firefox",14704,85)) ino:1500407 sk:b436cb80ffff8800
ESTAB 0 0 192.168.1.26:38371 130.57.66.10:443 users:(("firefox",14704,65)) ino:1500187 sk:429b0fc0ffff8800
ESTAB 0 0 192.168.1.26:43185 130.57.66.6:443 users:(("firefox",14704,86)) ino:1499371 sk:428d02c0ffff8800
ESTAB 0 0 192.168.1.26:53839 130.57.66.3:443 users:(("firefox",14704,62)) ino:1499312 sk:429a16c0ffff8800
ESTAB 0 0 192.168.1.26:47338 130.57.66.7:443 users:(("firefox",14704,74)) ino:1500398 sk:2943f8c0ffff8800
ESTAB 0 0 192.168.1.26:53853 130.57.66.3:443 users:(("firefox",14704,104)) ino:1500405 sk:b436d900ffff8800
ESTAB 0 0 192.168.1.26:38401 130.57.66.10:443 users:(("firefox",14704,92)) ino:1500215 sk:42974a40ffff8800
ESTAB 0 0 192.168.1.26:51952 130.57.66.4:443 users:(("firefox",14704,90)) ino:1499373 sk:b6235740ffff8800
ESTAB 0 0 192.168.1.26:49649 130.57.66.9:443 users:(("firefox",14704,69)) ino:1499315 sk:429a1000ffff8800
TIME-WAIT 0 0 192.168.1.26:38374 130.57.66.10:443 timer:(timewait,55sec,0) ino:0 sk:22e0fbc0ffff8800
************************************************** ************************************************** ***************************
Here is the output from just before the original posting of this subject, and from the machine. I chose to leave out all the 404's from other Windows boxes on my network, especially given your advice as to the futility of that endeavor (at least at this time). Also, note I cannot assign 80 to this new machine, as the old machine is serving to the WWW, henceforth the need to test behind the scenes on the LAN IPs.
************************************************** ************************************************** **************************
192.168.1.26 - - [07/Oct/2013:13:04:55 -0700] "GET /phpMyAdmin/ HTTP/1.1" 404 1039 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20100101 Firefox/17.0"
linux-2u6o - - [07/Oct/2013:17:53:26 -0700] "GET /phpMyAdmin/ HTTP/1.1" 404 1039 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20100101 Firefox/17.0"
linux-2u6o - - [07/Oct/2013:17:53:30 -0700] "GET /phpMyAdmin/ HTTP/1.1" 404 1039 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20100101 Firefox/17.0"
linux-2u6o - - [07/Oct/2013:17:55:58 -0700] "GET /phpMyAdmin/ HTTP/1.1" 404 1039 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20100101 Firefox/17.0"
linux-2u6o - - [07/Oct/2013:22:52:06 -0700] "GET /phpMyAdmin/ HTTP/1.1" 404 1039 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20100101 Firefox/17.0"
linux-2u6o - - [07/Oct/2013:22:52:16 -0700] "GET / HTTP/1.1" 200 44 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20100101 Firefox/17.0"
192.168.1.26 - - [07/Oct/2013:22:53:11 -0700] "GET /playguitarvideos/index.html HTTP/1.1" 200 44 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20100101 Firefox/17.0"
************************************************** ************************************************** ************************
The last 2 lines show that access using the LAN IP of this SUSE machine obtain the index page of vhost 1, and vhost 2 with no problem; and note that even though I've not included it, they also show on any other machine on the LAN, using the SUSE IP: 192.168.1.26. So, in conclusion, .23 (my GMail eBay machine), .25 (Fedora 9 WWW Server), .27 (my WIN 8 Ent. Mail Server), .31 (WIN 8 Ent. slooow X64 Laptop), all gain access using their ipV4 internal static IPs. The Laptop is wireless.

I'm off to my Funeral; will check more later this evening.

Regards, tarzy



Btw... it may be useful to see what happens in /var/log/apache2/access_log
and /var/log/apache2/error_log when trying to access the PhpMyAdmin URL.
Post everything happening at the time you point your browser to the real
IP address and the phpmyadmin URL and let's see what shows up.

Good luck.

tarzy
08-Oct-2013, 20:24
Forgot to include that localhost is a 404 like phpMyAdmin error: "Object not found". 127.0.0.1 "cannot establish connection to the server"



Here's the output from the given command, which I have saved for future use:
************************************************** ************************************************** ************************
linux-2u6o:~ # /usr/sbin/ss -planeto | grep ':80\|:443'
LISTEN 0 128 *:22 *:* users:(("sshd",2750,3)) ino:8015 sk:b6363480ffff8800
LISTEN 0 128 192.168.1.26:80 *:* users:(("httpd2-prefork",17786,3),("httpd2-prefork",17787,3),("httpd2-prefork",17788,3),("httpd2-prefork",17789,3),("httpd2-prefork",17790,3),("httpd2-prefork",17791,3),("httpd2-prefork",17797,3)) ino:1456535 sk:b436f4c0ffff8800
ESTAB 0 0 192.168.1.26:38403 130.57.66.10:443 users:(("firefox",14704,94)) ino:1500217 sk:b696f800ffff8800
ESTAB 0 0 192.168.1.26:38398 130.57.66.10:443 users:(("firefox",14704,67)) ino:1500212 sk:b436e080ffff8800
ESTAB 0 0 192.168.1.26:53852 130.57.66.3:443 users:(("firefox",14704,103)) ino:1500404 sk:2943e480ffff8800
TIME-WAIT 0 0 192.168.1.26:38370 130.57.66.10:443 timer:(timewait,55sec,0) ino:0 sk:22e0fa40ffff8800
ESTAB 0 0 192.168.1.26:38400 130.57.66.10:443 users:(("firefox",14704,91)) ino:1500214 sk:42975100ffff8800
ESTAB 0 0 192.168.1.26:51946 130.57.66.4:443 users:(("firefox",14704,75)) ino:1500396 sk:b6dea180ffff8800
ESTAB 0 0 192.168.1.26:38402 130.57.66.10:443 users:(("firefox",14704,93)) ino:1500216 sk:42974380ffff8800
TIME-WAIT 0 0 192.168.1.26:38381 130.57.66.10:443 timer:(timewait,55sec,0) ino:0 sk:22e0fb00ffff8800
ESTAB 0 0 192.168.1.26:38399 130.57.66.10:443 users:(("firefox",14704,84)) ino:1500213 sk:b436ee00ffff8800
ESTAB 0 0 192.168.1.26:38369 130.57.66.10:443 users:(("firefox",14704,56)) ino:1499175 sk:b6deaf00ffff8800
ESTAB 0 0 192.168.1.26:53851 130.57.66.3:443 users:(("firefox",14704,102)) ino:1500403 sk:2943eb40ffff8800
ESTAB 0 0 192.168.1.26:46642 130.57.66.5:443 users:(("firefox",14704,85)) ino:1500407 sk:b436cb80ffff8800
ESTAB 0 0 192.168.1.26:38371 130.57.66.10:443 users:(("firefox",14704,65)) ino:1500187 sk:429b0fc0ffff8800
ESTAB 0 0 192.168.1.26:43185 130.57.66.6:443 users:(("firefox",14704,86)) ino:1499371 sk:428d02c0ffff8800
ESTAB 0 0 192.168.1.26:53839 130.57.66.3:443 users:(("firefox",14704,62)) ino:1499312 sk:429a16c0ffff8800
ESTAB 0 0 192.168.1.26:47338 130.57.66.7:443 users:(("firefox",14704,74)) ino:1500398 sk:2943f8c0ffff8800
ESTAB 0 0 192.168.1.26:53853 130.57.66.3:443 users:(("firefox",14704,104)) ino:1500405 sk:b436d900ffff8800
ESTAB 0 0 192.168.1.26:38401 130.57.66.10:443 users:(("firefox",14704,92)) ino:1500215 sk:42974a40ffff8800
ESTAB 0 0 192.168.1.26:51952 130.57.66.4:443 users:(("firefox",14704,90)) ino:1499373 sk:b6235740ffff8800
ESTAB 0 0 192.168.1.26:49649 130.57.66.9:443 users:(("firefox",14704,69)) ino:1499315 sk:429a1000ffff8800
TIME-WAIT 0 0 192.168.1.26:38374 130.57.66.10:443 timer:(timewait,55sec,0) ino:0 sk:22e0fbc0ffff8800
************************************************** ************************************************** ***************************
Here is the output from just before the original posting of this subject, and from the machine. I chose to leave out all the 404's from other Windows boxes on my network, especially given your advice as to the futility of that endeavor (at least at this time). Also, note I cannot assign 80 to this new machine, as the old machine is serving to the WWW, henceforth the need to test behind the scenes on the LAN IPs.
************************************************** ************************************************** **************************
192.168.1.26 - - [07/Oct/2013:13:04:55 -0700] "GET /phpMyAdmin/ HTTP/1.1" 404 1039 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20100101 Firefox/17.0"
linux-2u6o - - [07/Oct/2013:17:53:26 -0700] "GET /phpMyAdmin/ HTTP/1.1" 404 1039 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20100101 Firefox/17.0"
linux-2u6o - - [07/Oct/2013:17:53:30 -0700] "GET /phpMyAdmin/ HTTP/1.1" 404 1039 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20100101 Firefox/17.0"
linux-2u6o - - [07/Oct/2013:17:55:58 -0700] "GET /phpMyAdmin/ HTTP/1.1" 404 1039 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20100101 Firefox/17.0"
linux-2u6o - - [07/Oct/2013:22:52:06 -0700] "GET /phpMyAdmin/ HTTP/1.1" 404 1039 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20100101 Firefox/17.0"
linux-2u6o - - [07/Oct/2013:22:52:16 -0700] "GET / HTTP/1.1" 200 44 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20100101 Firefox/17.0"
192.168.1.26 - - [07/Oct/2013:22:53:11 -0700] "GET /playguitarvideos/index.html HTTP/1.1" 200 44 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20100101 Firefox/17.0"
************************************************** ************************************************** ************************
The last 2 lines show that access using the LAN IP of this SUSE machine obtain the index page of vhost 1, and vhost 2 with no problem; and note that even though I've not included it, they also show on any other machine on the LAN, using the SUSE IP: 192.168.1.26. So, in conclusion, .23 (my GMail eBay machine), .25 (Fedora 9 WWW Server), .27 (my WIN 8 Ent. Mail Server), .31 (WIN 8 Ent. slooow X64 Laptop), all gain access using their ipV4 internal static IPs. The Laptop is wireless.

I'm off to my Funeral; will check more later this evening.

Regards, tarzy

ab
09-Oct-2013, 05:53
Have you tried moving /srv/www/htdocs/phpMyAdmin into one of the
directories for your vhosts? If that works then the problem is that you
do not have a way for a client going to your server, but not intending to
reach one of the vhosts, to reach the /srv/www/htdocs directory which is
probably easy to fix. See if moving phpMyAdmin into a vhost temporarily
allows you to access it. If it does, then post your vhost config files as
they current exist, as well as your main httpd.conf file, and maybe that
will be enough, assuming you cannot just create a vhost for phpMyAdmin
specifically or something.

Good luckj.

tarzy
11-Oct-2013, 19:34
Thanks for your suggestion, on my Fedora server phpmyadmin is not in the vhost directory and until I started tinkering it worked fine. It has "broken" a few times in the past.

I installed an app called Valentina Studio, which looks promising, but even though it was given a Green light by the Software install manager, I can't find it anywhere (so far at least).

I can administer MySQL via Webmin from anywhere, so until I resolve these petty issues, I'll just do it that way. My need to manage is based on the fact that my main directories for my 2 virtual servers will be php database-driven shopping carts, and as you would suspect, they both need their own database.

I am guilty of being attracted to "Fancy Software" by the way.



Have you tried moving /srv/www/htdocs/phpMyAdmin into one of the
directories for your vhosts? If that works then the problem is that you
do not have a way for a client going to your server, but not intending to
reach one of the vhosts, to reach the /srv/www/htdocs directory which is
probably easy to fix. See if moving phpMyAdmin into a vhost temporarily
allows you to access it. If it does, then post your vhost config files as
they current exist, as well as your main httpd.conf file, and maybe that
will be enough, assuming you cannot just create a vhost for phpMyAdmin
specifically or something.

Good luckj.

tarzy
11-Oct-2013, 21:22
This is completely crazy: I can place a plain index.html (the same one- "it works", white background) into the htdocs dir., (virtualhost 1), and virtualhost 2's folder in htdocs, and both display on any machine on my LAN, all of which are fixed 192.168.1xx static ip's, but even after creating users/database permissions for both hosts, my scripts will not execute the PHP CSS pages in the browser's address fields, which should be for vhost 1: the internal static ip, and vhost 2 would be the same/foldername/index.php or even just vhost2/foldername/ For instance, my working server, which is of course open to port 80, has Joomla (devoid of all features very plain) and my store is in a sub-directory. I also have 2 other sub-directories with working php carts.

This is not quite enough to make me give up, but close. Given my complete lack of knowledge in 2008 when I moved to Linux, I've come quite a ways, but I'm likely forgetting Linux distros have too. When I first started with SUSE 11 SP3, I had a bad CAT5 cable, and I went back and forth trying every distro I could only to get the bad news by checking the cable, since not all distros could have basic networking issues. (This long-winded diatribe is to explain how I've arrived at my current state)

This forum is more friendly than any others I've tried, and I don't know if this is incorrect forum-wise or not, but here is what I'm trying to get tuned on SUSE, and it is all running right now on Fedora 9 to the WWW:

http://craigtarwater.com vhost 1
http://craigtarwater.com/guitar vhost 1/subdirectory ***This one just became "broken", I don't know how***
http://craigtarwater.com/motorcycle vhost 1/subdirectory
http://craigtarwater.com/vintage vhost 1 subdirectory
http://playguitarvideos.com vhost 2

Looks like I've got nothing to lose after a sale is finished in the motorcycle one later today. Guess I'll just start over on this rig, and turn it onto port 80, paying attention to my security!

Error on the "guitar" page: Notice: `name` is not allowed as a key in 'CubeCart_config' table! in /var/www/html/guitar/classes/db/database.class.php on line 791 (I can take any file from my servers with my WinSCP client, edit it, and save it right back to the server, so I'll have a look at it later)

Given my database issues (I may have said earlier ohoMyAdmin is currently broken on the Fedora box), I'm going to go back to stripping paint for a few hours to assuage my soul.

The other 2 subdirectories work fine, they're on an older version of cubecart. The broken one is on their newest version and I'm still trying it out.

Regards, tarzy




Thanks for your suggestion, on my Fedora server phpmyadmin is not in the vhost directory and until I started tinkering it worked fine. It has "broken" a few times in the past.

I installed an app called Valentina Studio, which looks promising, but even though it was given a Green light by the Software install manager, I can't find it anywhere (so far at least).

I can administer MySQL via Webmin from anywhere, so until I resolve these petty issues, I'll just do it that way. My need to manage is based on the fact that my main directories for my 2 virtual servers will be php database-driven shopping carts, and as you would suspect, they both need their own database.

I am guilty of being attracted to "Fancy Software" by the way.

jmozdzen
14-Oct-2013, 17:36
Hi tarzy,

> Error on the "guitar" page: Notice: `name` is not allowed as a key in 'CubeCart_config' table! in /var/www/html/guitar/classes/db/database.class.php on line 791
> The broken one is on their newest version

seems you're not alone (see i.e. http://www.cubecartforums.org/index.php?showtopic=17582)... and it seems to be a "native CubeCart problem", you might want to draw a number at CubeCart's forum ;)

Regards,

Jens

jmozdzen
14-Oct-2013, 18:04
Hi tarzy,

have you seen this message? http://www.cubecartforums.org/index.php?showtopic=17324&view=findpost&p=70838

I don't know a bit about CubeCart, but I'm sure you can make something of that reference to the configuration file :)

Regards,
Jens

tarzy
15-Oct-2013, 09:06
In one of my random strokes of brilliance, I had nothing to lose, so using my WinSCP app on the 8 enterprise machine, I copied the file in question from the CC install/upload folder, and bang! I was back in the saddle.


Hi tarzy,

> Error on the "guitar" page: Notice: `name` is not allowed as a key in 'CubeCart_config' table! in /var/www/html/guitar/classes/db/database.class.php on line 791
> The broken one is on their newest version

seems you're not alone (see i.e. http://www.cubecartforums.org/index.php?showtopic=17582)... and it seems to be a "native CubeCart problem", you might want to draw a number at CubeCart's forum ;)

Regards,

Jens

tarzy
15-Oct-2013, 09:22
Thanks, I posted to your other reply it has been resolved.

Now if I could get this SLES 11SP3 machine working. I should mention I did locate this Valentina Studio app (for MySQL administering), and found it may be useful.

So, to update where I'm at, vhost 1 displays an index page by internal static IP addy, and vhost 2 displays an index page by internal staic IP addy/vhost 2 directory/index.html......this tells me if I switched it over to port 80, we could all see it on the Web. So, after the Cubecart experience, my hunch is that my failures to get PHP CMS/Shopping Carts working on SLES is likely related to some minor database impropriety.

Interesting to note that I had Opencart working on this very machine 7-8 weeks ago with CentOS 6.4. I just thought Opencart (based on OSCommerce) was way too laborious for a site that maybe has 100 items to sell.

I came to SUSE because of a bad CAT 5 cable, but I'm determined it is far and away the best for my new server. What I sell are Guitar Lessons, and I have some that are available for digital delivery, which I'm very excited about.

If I only had 6-12 days to sit at the machine for 4-6 hours a day, I can solve this eventually.



Hi tarzy,

have you seen this message? http://www.cubecartforums.org/index.php?showtopic=17324&view=findpost&p=70838

I don't know a bit about CubeCart, but I'm sure you can make something of that reference to the configuration file :)

Regards,
Jens