kan geen PHP pagina bekijken, alleen de bestandsnamen zijn zichtbaar

Ome Merde · 17 januari 2007

dat bestand staat in libexec en heb ik in httpd.conf gezet maar toch werkt phpmyadmin niet. Openshowcenter (ook php) werkt wel.

merDe

17 januari 2007

wat is de melding nu dan bij phpmyadmin? nog steeds krijg je de code te zien?

Ome Merde · 17 januari 2007

nu weer error 403

merDe

17 januari 2007

Kan het zijn dat de website alleen aan een bepaalde hostname hebt gekoppeld is(nslu2) via een namevirtualhost en je nu van buitenaf verbinding probeert te maken? Voorbeeld:

NameVirtualHost *:8000

DocumentRoot /www/domain

ServerName nslu2

</VirtualHost>

Even nog een toevoeging aan wat ik eerder heb gezegd. de AddType regels moeten binnen het IfModule mime_module blok staat(als die er is, anders aanmaken).

AddType application/x-httpd-php .php

AddType application/x-httpd-php-source .phps

</IfModule>

Mijn directoryblok ziet er trouwens als volgt uit:

Options FollowSymLinks

AllowOverride None

Order deny,allow

Deny from all

Satisfy all

</Directory>

Werkt openshowcenter ook zonder de Include /opt/etc/apache2/conf.d/php.conf trouwens?

Ome Merde · 17 januari 2007

Kan het zijn dat de website alleen aan een bepaalde hostname hebt gekoppeld is(nslu2) via een namevirtualhost en je nu van buitenaf verbinding probeert te maken? Voorbeeld:

NameVirtualHost *:8000

DocumentRoot /www/domain

ServerName nslu2

</VirtualHost>

[color:"black"] neen, gebeurd nu via LAN ook weer. ik kan ze 1 2 3 niet reproduceren hoe dat komt <img src="/forums/images/graemlins/smile.gif" alt="" /> [/color]

Even nog een toevoeging aan wat ik eerder heb gezegd. de AddType regels moeten binnen het IfModule mime_module blok staat(als die er is, anders aanmaken).

AddType application/x-httpd-php .php

AddType application/x-httpd-php-source .phps

</IfModule>

[color:"black"] heb ik erbij gezet, geen verschil

[/color]

Mijn directoryblok ziet er trouwens als volgt uit:

Options FollowSymLinks

AllowOverride None

Order deny,allow

Deny from all

Satisfy all

</Directory>

[color:"black"] aangepast, geen verschil. error 403 bij phpmyadmin [/color]

Werkt openshowcenter ook zonder de Include /opt/etc/apache2/conf.d/php.conf trouwens?

[color:"black"] ja, die regel heb ik nu gecommented zegmaar <img src="/forums/images/graemlins/smile.gif" alt="" /> [/color]

Staat er een libphp5.so bestand in de /usr/local/apache2/modules directory? voeg dan de volgende regel toe(als die er nog niet instaat):

LoadModule php5_module /usr/local/apache2/modules/libphp5.so

[color:"black"]als ik die regel toevoeg aan httpd.conf dan zegt ie dat de module al geladen is terwijl ie er niet in staat. [/color]

ik snap er niks meer van ...

merDe

Ome Merde · 17 januari 2007

nog een stukje apache-log :

[color:"#666666"][sat Jan 03 00:37:55 1970] [notice] SIGHUP received. Attempting to restart

httpd: Could not reliably determine the server's fully qualified domain name, using 192.168.1.77 for ServerName

[sat Jan 03 00:37:56 1970] [notice] Digest: generating secret for digest authentication ...

[sat Jan 03 00:37:56 1970] [notice] Digest: done

[sat Jan 03 00:38:04 1970] [notice] Apache/2.2.4 (Unix) mod_ssl/2.2.4 OpenSSL/0.9.7l DAV/2 configured -- resuming normal operations

[sat Jan 03 00:38:04 1970] [error] [client 192.168.1.25] (13)Permission denied: access to /phpmyadmin/index.html denied

[sat Jan 03 00:38:04 1970] [error] [client 192.168.1.25] (13)Permission denied: access to /phpmyadmin/index.shtml denied

[sat Jan 03 00:38:04 1970] [error] [client 192.168.1.25] (13)Permission denied: access to /phpmyadmin/index.wml denied

[sat Jan 03 00:38:04 1970] [error] [client 192.168.1.25] (13)Permission denied: access to /phpmyadmin/index.pwml denied

[sat Jan 03 00:38:04 1970] [error] [client 192.168.1.25] (13)Permission denied: access to /phpmyadmin/index.php denied

[sat Jan 03 00:38:04 1970] [error] [client 192.168.1.25] (13)Permission denied: access to /phpmyadmin/index.php3 denied

[sat Jan 03 00:38:04 1970] [error] [client 192.168.1.25] (13)Permission denied: access to /phpmyadmin/index.php4 denied

[sat Jan 03 00:38:04 1970] [error] [client 192.168.1.25] (13)Permission denied: access to /phpmyadmin/index.php5 denied

[/color]

merDe

Ome Merde · 17 januari 2007

Ik heb in httpd.conf het volgende onderaan toegevoegd:

# toegevoegd voor php

Include /opt/etc/apache2/conf.d/php.conf

de inhoud van php.conf :

Code:

## PHP is an HTML-embedded scripting language which attempts to make it# easy for developers to write dynamically generated webpages.#LoadModule php5_module libexec/libphp5.so## Cause the PHP interpreter to handle files with a .php extension.#AddType application/x-httpd-php .phpAddType application/x-httpd-php-source .phps## Add index.php to the list of files that will be served as directory# indexes.#DirectoryIndex index.php

merDe

Ome Merde · 17 januari 2007

als ik nu http://192.168.1.77:8000/phpmyadmin/index.php in de browser intyp blijft iexplorer nu al 4 minuten hangen op :

firefox doet hetzelfde ....

merDe

thisone · 17 januari 2007

Hallo Ome Merde,

Dit is mijn httpd.conf....

#

# This is the main Apache HTTP server configuration file. It contains the

# configuration directives that give the server its instructions.

# See <URL:http://httpd.apache.org/docs/2.2> for detailed information.

# In particular, see

# <URL:http://httpd.apache.org/docs/2.2/mod/directives.html>

# for a discussion of each configuration directive.

#

# Do NOT simply read the instructions in here without understanding

# what they do. They're here only as hints or reminders. If you are unsure

# consult the online docs. You have been warned.

#

# Configuration and logfile names: If the filenames you specify for many

# of the server's control files begin with "/" (or "drive:/" for Win32), the

# server will use that explicit path. If the filenames do *not* begin

# with "/", the value of ServerRoot is prepended -- so "var/apache2/log/foo.log"

# with ServerRoot set to "/opt" will be interpreted by the

# server as "/opt/var/apache2/log/foo.log".

#

# ServerRoot: The top of the directory tree under which the server's

# configuration, error, and log files are kept.

#

# Do not add a slash at the end of the directory path. If you point

# ServerRoot at a non-local disk, be sure to point the LockFile directive

# at a local disk. If you wish to share the same ServerRoot for multiple

# httpd daemons, you will need to change at least LockFile and PidFile.

#

ServerRoot "/opt"

#

# Listen: Allows you to bind Apache to specific IP addresses and/or

# ports, instead of the default. See also the <VirtualHost>

# directive.

#

# Change this to Listen on specific IP addresses as shown below to

# prevent Apache from glomming onto all bound IP addresses.

#

#Listen 12.34.56.78:80

Listen 8001

#

# Dynamic Shared Object (DSO) Support

#

# To be able to use the functionality of a module which was built as a DSO you

# have to place corresponding `LoadModule' lines at this location so the

# directives contained in it are actually available _before_ they are used.

# Statically compiled modules (those listed by `httpd -l') do not need

# to be loaded here.

#

# Example:

# LoadModule foo_module modules/mod_foo.so

#

LoadModule authn_file_module libexec/mod_authn_file.so

LoadModule authn_dbm_module libexec/mod_authn_dbm.so

LoadModule authn_anon_module libexec/mod_authn_anon.so

LoadModule authn_dbd_module libexec/mod_authn_dbd.so

LoadModule authn_default_module libexec/mod_authn_default.so

LoadModule authz_host_module libexec/mod_authz_host.so

LoadModule authz_groupfile_module libexec/mod_authz_groupfile.so

LoadModule authz_user_module libexec/mod_authz_user.so

LoadModule authz_dbm_module libexec/mod_authz_dbm.so

LoadModule authz_owner_module libexec/mod_authz_owner.so

LoadModule authz_default_module libexec/mod_authz_default.so

LoadModule auth_basic_module libexec/mod_auth_basic.so

LoadModule auth_digest_module libexec/mod_auth_digest.so

LoadModule file_cache_module libexec/mod_file_cache.so

LoadModule cache_module libexec/mod_cache.so

LoadModule disk_cache_module libexec/mod_disk_cache.so

LoadModule mem_cache_module libexec/mod_mem_cache.so

LoadModule dbd_module libexec/mod_dbd.so

LoadModule dumpio_module libexec/mod_dumpio.so

LoadModule ext_filter_module libexec/mod_ext_filter.so

LoadModule include_module libexec/mod_include.so

LoadModule filter_module libexec/mod_filter.so

LoadModule deflate_module libexec/mod_deflate.so

LoadModule ldap_module libexec/mod_ldap.so

LoadModule log_config_module libexec/mod_log_config.so

LoadModule log_forensic_module libexec/mod_log_forensic.so

LoadModule logio_module libexec/mod_logio.so

LoadModule env_module libexec/mod_env.so

LoadModule mime_magic_module libexec/mod_mime_magic.so

LoadModule cern_meta_module libexec/mod_cern_meta.so

LoadModule expires_module libexec/mod_expires.so

LoadModule headers_module libexec/mod_headers.so

LoadModule ident_module libexec/mod_ident.so

LoadModule usertrack_module libexec/mod_usertrack.so

LoadModule unique_id_module libexec/mod_unique_id.so

LoadModule setenvif_module libexec/mod_setenvif.so

LoadModule version_module libexec/mod_version.so

LoadModule proxy_module libexec/mod_proxy.so

LoadModule proxy_connect_module libexec/mod_proxy_connect.so

LoadModule proxy_ftp_module libexec/mod_proxy_ftp.so

LoadModule proxy_http_module libexec/mod_proxy_http.so

LoadModule proxy_ajp_module libexec/mod_proxy_ajp.so

LoadModule proxy_balancer_module libexec/mod_proxy_balancer.so

LoadModule ssl_module libexec/mod_ssl.so

LoadModule mime_module libexec/mod_mime.so

LoadModule dav_module libexec/mod_dav.so

LoadModule status_module libexec/mod_status.so

LoadModule autoindex_module libexec/mod_autoindex.so

LoadModule asis_module libexec/mod_asis.so

LoadModule info_module libexec/mod_info.so

LoadModule cgid_module libexec/mod_cgid.so

LoadModule dav_fs_module libexec/mod_dav_fs.so

LoadModule vhost_alias_module libexec/mod_vhost_alias.so

LoadModule negotiation_module libexec/mod_negotiation.so

LoadModule dir_module libexec/mod_dir.so

LoadModule imagemap_module libexec/mod_imagemap.so

LoadModule actions_module libexec/mod_actions.so

LoadModule speling_module libexec/mod_speling.so

LoadModule userdir_module libexec/mod_userdir.so

LoadModule alias_module libexec/mod_alias.so

LoadModule rewrite_module libexec/mod_rewrite.so

#

# If you wish httpd to run as a different user or group, you must run

# httpd as root initially and it will switch.

#

# User/Group: The name (or #number) of the user/group to run httpd as.

# It is usually good practice to create a dedicated user and group for

# running httpd, as with most system services.

#

User nobody

Group everyone

</IfModule>

# 'Main' server configuration

#

# The directives in this section set up the values used by the 'main'

# server, which responds to any requests that aren't handled by a

# <VirtualHost> definition. These values also provide defaults for

# any <VirtualHost> containers you may define later in the file.

#

# All of these directives may appear inside <VirtualHost> containers,

# in which case these default settings will be overridden for the

# virtual host being defined.

#

# ServerAdmin: Your address, where problems with the server should be

# e-mailed. This address appears on some server-generated pages, such

# as error documents. e.g. admin@your-domain.com

#

ServerAdmin mijn@emailadres.nl

#

# ServerName gives the name and port that the server uses to identify itself.

# This can often be determined automatically, but we recommend you specify

# it explicitly to prevent problems during startup.

#

# If your host doesn't have a registered DNS name, enter its IP address here.

#

ServerName 192.168.1.77:8001

#

# DocumentRoot: The directory out of which you will serve your

# documents. By default, all requests are taken from this directory, but

# symbolic links and aliases may be used to point to other locations.

#

DocumentRoot "/opt/share/www/oxyl"

#

# Each directory to which Apache has access can be configured with respect

# to which services and features are allowed and/or disabled in that

# directory (and its subdirectories).

#

# First, we configure the "default" to be a very restrictive set of

# features.

#

Options -Indexes

AllowOverride None

Order deny,allow

Deny from all

</Directory>

#

# Note that from this point forward you must specifically allow

# particular features to be enabled - so if something's not working as

# you might expect, make sure that you have specifically enabled it

# below.

#

# This should be changed to whatever you set DocumentRoot to.

#

#

# Possible values for the Options directive are "None", "All",

# or any combination of:

# Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews

#

# Note that "MultiViews" must be named *explicitly* --- "Options All"

# doesn't give it to you.

#

# The Options directive is both complicated and important. Please see

# http://httpd.apache.org/docs/2.2/mod/core.html#options

# for more information.

#

Options Indexes FollowSymLinks

#

# AllowOverride controls what directives may be placed in .htaccess files.

# It can be "All", "None", or any combination of the keywords:

# Options FileInfo AuthConfig Limit

#

AllowOverride None

#

# Controls who can get stuff from this server.

#

Order allow,deny

Allow from all

</Directory>

#

# DirectoryIndex: sets the file that Apache will serve if a directory

# is requested.

#

DirectoryIndex index.html

</IfModule>

#

# The following lines prevent .htaccess and .htpasswd files from being

# viewed by Web clients.

#

Order allow,deny

Deny from all

Satisfy All

</FilesMatch>

#

# ErrorLog: The location of the error log file.

# If you do not specify an ErrorLog directive within a <VirtualHost>

# container, error messages relating to that virtual host will be

# logged here. If you *do* define an error logfile for a <VirtualHost>

# container, that host's errors will be logged there and not here.

#

ErrorLog var/apache2/log/error_log

#

# LogLevel: Control the number of messages logged to the error_log.

# Possible values include: debug, info, notice, warn, error, crit,

# alert, emerg.

#

LogLevel warn

#

# The following directives define some format nicknames for use with

# a CustomLog directive (see below).

#

LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined

LogFormat "%h %l %u %t \"%r\" %>s %b" common

# You need to enable mod_logio.c to use %I and %O

LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\" %I %O" combinedio

</IfModule>

#

# The location and format of the access logfile (Common Logfile Format).

# If you do not define any access logfiles within a <VirtualHost>

# container, they will be logged here. Contrariwise, if you *do*

# define per-<VirtualHost> access logfiles, transactions will be

# logged therein and *not* in this file.

#

CustomLog var/apache2/log/access_log common

#

# If you prefer a logfile with access, agent, and referer information

# (Combined Logfile Format) you can use the following directive.

#

#CustomLog var/apache2/log/access_log combined

</IfModule>

#

# Redirect: Allows you to tell clients about documents that used to

# exist in your server's namespace, but do not anymore. The client

# will make a new request for the document at its new location.

# Example:

# Redirect permanent /foo http://www.example.com/bar

#

# Alias: Maps web paths into filesystem paths and is used to

# access content that does not live under the DocumentRoot.

# Example:

Alias /root/ ¨/¨

#

# If you include a trailing / on /webpath then the server will

# require it to be present in the URL. You will also likely

# need to provide a <Directory> section to allow access to

# the filesystem path.

#

# ScriptAlias: This controls which directories contain server scripts.

# ScriptAliases are essentially the same as Aliases, except that

# documents in the target directory are treated as applications and

# run by the server when requested rather than as documents sent to the

# client. The same rules about trailing "/" apply to ScriptAlias

# directives as to Alias.

#

ScriptAlias /cgi-bin/ "/opt/share/apache2/cgi-bin/"

</IfModule>

#

# ScriptSock: On threaded servers, designate the path to the UNIX

# socket used to communicate with the CGI daemon of mod_cgid.

#

#Scriptsock var/apache2/run/cgisock

</IfModule>

#

# "/opt/share/apache2/cgi-bin" should be changed to whatever your ScriptAliased

# CGI directory exists, if you have that configured.

#

AllowOverride None

Options None

Order allow,deny

Allow from all

</Directory>

#

# DefaultType: the default MIME type the server will use for a document

# if it cannot otherwise determine one, such as from filename extensions.

# If your server contains mostly text or HTML documents, "text/plain" is

# a good value. If most of your content is binary, such as applications

# or images, you may want to use "application/octet-stream" instead to

# keep browsers from trying to display binary files as though they are

# text.

#

DefaultType text/plain

#

# TypesConfig points to the file containing the list of mappings from

# filename extension to MIME-type.

#

TypesConfig etc/apache2/mime.types

#

# AddType allows you to add to or override the MIME configuration

# file specified in TypesConfig for specific file types.

#

#AddType application/x-gzip .tgz

#

# AddEncoding allows you to have certain browsers uncompress

# information on the fly. Note: Not all browsers support this.

#

#AddEncoding x-compress .Z

#AddEncoding x-gzip .gz .tgz

#

# If the AddEncoding directives above are commented-out, then you

# probably should define those extensions to indicate media types:

#

AddType application/x-compress .Z

AddType application/x-gzip .gz .tgz

#

# AddHandler allows you to map certain file extensions to "handlers":

# actions unrelated to filetype. These can be either built into the server

# or added with the Action directive (see below)

#

# To use CGI scripts outside of ScriptAliased directories:

# (You will also need to add "ExecCGI" to the "Options" directive.)

#

#AddHandler cgi-script .cgi

# For type maps (negotiated resources):

#AddHandler type-map var

#

# Filters allow you to process content before it is sent to the client.

#

# To parse .shtml files for server-side includes (SSI):

# (You will also need to add "Includes" to the "Options" directive.)

#

#AddType text/html .shtml

#AddOutputFilter INCLUDES .shtml

</IfModule>

#

# The mod_mime_magic module allows the server to use various hints from the

# contents of the file itself to determine its type. The MIMEMagicFile

# directive tells the module where the hint definitions are located.

#

#MIMEMagicFile etc/apache2/magic

#

# Customizable error responses come in three flavors:

# 1) plain text 2) local redirects 3) external redirects

#

# Some examples:

#ErrorDocument 500 "The server made a boo boo."

#ErrorDocument 404 /missing.html

#ErrorDocument 404 "/cgi-bin/missing_handler.pl"

#ErrorDocument 402 http://www.example.com/subscription_info.html

#

# EnableMMAP and EnableSendfile: On systems that support it,

# memory-mapping or the sendfile syscall is used to deliver

# files. This usually improves server performance, but must

# be turned off when serving from networked-mounted

# filesystems or if support for these functions is otherwise

# broken on your system.

#

#EnableMMAP off

#EnableSendfile off

# Supplemental configuration

#

# The configuration files in the etc/apache2/extra/ directory can be

# included to add extra features or to modify the default configuration of

# the server, or you may simply copy their contents here and change as

# necessary.

# Server-pool management (MPM specific)

#Include etc/apache2/extra/httpd-mpm.conf

# Multi-language error messages

#Include etc/apache2/extra/httpd-multilang-errordoc.conf

# Fancy directory listings

#Include etc/apache2/extra/httpd-autoindex.conf

# Language settings

#Include etc/apache2/extra/httpd-languages.conf

# User home directories

#Include etc/apache2/extra/httpd-userdir.conf

# toegevoegd voor php

Include /opt/etc/apache2/conf.d/php.conf

# Real-time info on requests and configuration

#Include etc/apache2/extra/httpd-info.conf

# Virtual hosts

#Include etc/apache2/extra/httpd-vhosts.conf

# Local access to the Apache HTTP Server Manual

#Include etc/apache2/extra/httpd-manual.conf

# Distributed authoring and versioning (WebDAV)

#Include etc/apache2/extra/httpd-dav.conf

# Various default settings

#Include etc/apache2/extra/httpd-default.conf

# Secure (SSL/TLS) connections

#Include etc/apache2/extra/httpd-ssl.conf

#

# Note: The following must must be present to support

# starting without SSL on platforms with no /dev/random equivalent

# but a statically compiled-in mod_ssl.

#

SSLRandomSeed startup builtin

SSLRandomSeed connect builtin

</IfModule>

RewriteEngine on

# RewriteRule ^/(.*)/[0-9][0-9][0-9])*.vdr.mpg$ /$1/$2.vdr

RewriteRule ^/config(.*)/oxylstart.php [R]

ErrorDocument 403 /common/error.php?error=403

thisone · 17 januari 2007

Hallo Ome Merde,

Gelijk aan die van mij dus... <img src="/forums/images/graemlins/laugh.gif" alt="" />

Ome Merde · 17 januari 2007

bijna wel.

ik heb de nslu2 eens een reboot gegeven (duurde deze keer wel erg lang, maargoed ....)

http://192.168.1.77:8000/phpmyadmin :

kijk, zo komen we ergens <img src="/forums/images/graemlins/smile.gif" alt="" />

merDe

Ome Merde · 17 januari 2007

hmmmm ... ik heb config.inc.php aangepast.

auth stond op 'config' en heb ik op 'http' gezet. vervolgens vraagt phpmyadmin mij om m'n logingegevens.

ik heb van deze site het MySQL root password gewijzigd :

/opt/etc/init.d/S70mysqld stop

/opt/bin/mysqld_safe --skip-grant-tables

Start a new terminal window

/opt/bin/mysql -u root

mysql> use mysql;

mysql> update user set Password = PASSWORD('pass') where User ='root';

Query OK, 2 rows affected (0.02 sec)

Rows matched: 2 Changed: 2 Warnings: 0

mysql> exit

Bye

/opt/etc/init.d/S70mysqld stop

rm -f ~/.mysql_history

/opt/etc/init.d/S70mysqld start

klopt het dat het root-wachtwoord nu pass is of is dit gewoon het root-wachtwoord wat ik ook gebruik om mee te kunnen telnetten ?

hoe moet config.inc.php er uit komen te zien. Ik heb de mijne met vi aangepast naar het volgende :

Code:

<?php/* $Id: config.inc.php,v 2.52 2005/03/16 17:22:08 lem9 Exp $ */// vim: expandtab sw=4 ts=4 sts=4:/** * phpMyAdmin Configuration File * * All directives are explained in Documentation.html *//** * Sets the php error reporting - Please do not change this line! */if (!isset($old_error_reporting)) {    error_reporting(E_ALL);    @ini_set('display_errors', '1');}/** * Your phpMyAdmin url * * Complete the variable below with the full url ie *    http://www.your_web.net/path_to_your_phpMyAdmin_directory/ * * It must contain characters that are valid for a URL, and the path is * case sensitive on some Web servers, for example Unix-based servers. * * In most cases you can leave this variable empty, as the correct value * will be detected automatically. However, we recommend that you do * test to see that the auto-detection code works in your system. A good * test is to browse a table, then edit a row and save it.  There will be * an error message if phpMyAdmin cannot auto-detect the correct value. * * If the auto-detection code does work properly, you can set to TRUE the * $cfg['PmaAbsoluteUri_DisableWarning'] variable below. */$cfg['PmaAbsoluteUri'] = '';/** * Disable the default warning about $cfg['PmaAbsoluteUri'] not being set * You should use this if and ONLY if the PmaAbsoluteUri auto-detection * works perfectly. */$cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;/** * Disable the default warning that is displayed on the DB Details Structure page if * any of the required Tables for the relationfeatures could not be found */$cfg['PmaNoRelation_DisableWarning']  = FALSE;/** * The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If * at least one server configuration uses 'cookie' auth_type, enter here a * passphrase that will be used by blowfish. The maximum length seems to be 46 * characters. */$cfg['blowfish_secret'] = '';/** * Server(s) configuration */$i = 0;// The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use $cfg['Servers'][0].// You can disable a server config entry by setting host to ''.$i++; [color:"red"]$cfg['Servers'][$i]['host']          = '192.168.1.77'; // MySQL hostname or IP address$cfg['Servers'][$i]['port']          = '8000';          // MySQL port - leave blank for default port  [/color] $cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket$cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')$cfg['Servers'][$i]['extension']     = 'mysql';     // The php MySQL extension to use ('mysql' or 'mysqli')$cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection                                                    // (requires PHP >= 4.3.0)$cfg['Servers'][$i]['controluser']   = '';          // MySQL control user settings                                                    // (this user must have read-only$cfg['Servers'][$i]['controlpass']   = '';          // access to the "mysql/user"                                                    // and "mysql/db" tables).                                                    // The controluser is also                                                    // used for all relational                                                    // features (pmadb) [color:"red"]$cfg['Servers'][$i]['auth_type']     = 'http';    // Authentication method (config, http or cookie based)?  [/color] $cfg['Servers'][$i]['user']          = 'root';      // MySQL user$cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed                                                    // with 'config' auth_type)$cfg['Servers'][$i]['only_db']       = '';          // If set to a db-name, only                                                    // this db is displayed in left frame                                                    // It may also be an array of db-names, where sorting order is relevant.$cfg['Servers'][$i]['verbose']       = '';          // Verbose name for this host - leave blank to show the hostname$cfg['Servers'][$i]['pmadb']         = '';          // Database used for Relation, Bookmark and PDF Features                                                    // (see scripts/create_tables.sql)                                                    //   - leave blank for no support                                                    //     DEFAULT: 'phpmyadmin'$cfg['Servers'][$i]['bookmarktable'] = '';          // Bookmark table                                                    //   - leave blank for no bookmark support                                                    //     DEFAULT: 'pma_bookmark'$cfg['Servers'][$i]['relation']      = '';          // table to describe the relation between links (see doc)                                                    //   - leave blank for no relation-links support                                                    //     DEFAULT: 'pma_relation'$cfg['Servers'][$i]['table_info']    = '';          // table to describe the display fields                                                    //   - leave blank for no display fields support                                                    //     DEFAULT: 'pma_table_info'$cfg['Servers'][$i]['table_coords']  = '';          // table to describe the tables position for the PDF schema                                                    //   - leave blank for no PDF schema support                                                    //     DEFAULT: 'pma_table_coords'$cfg['Servers'][$i]['pdf_pages']     = '';          // table to describe pages of relationpdf                                                    //   - leave blank if you don't want to use this                                                    //     DEFAULT: 'pma_pdf_pages'$cfg['Servers'][$i]['column_info']   = '';          // table to store column information                                                    //   - leave blank for no column comments/mime types                                                    //     DEFAULT: 'pma_column_info'$cfg['Servers'][$i]['history']       = '';          // table to store SQL history                                                    //   - leave blank for no SQL query history                                                    //     DEFAULT: 'pma_history'$cfg['Servers'][$i]['verbose_check'] = TRUE;        // set to FALSE if you know that your pma_* tables                                                    // are up to date. This prevents compatibility                                                    // checks and thereby increases performance.$cfg['Servers'][$i]['AllowRoot']     = TRUE;        // whether to allow root login$cfg['Servers'][$i]['AllowDeny']['order']           // Host authentication order, leave blank to not use                                     = '';$cfg['Servers'][$i]['AllowDeny']['rules']           // Host authentication rules, leave blank for defaults                                     = array();$i++;$cfg['Servers'][$i]['host']            = '';$cfg['Servers'][$i]['port']            = '';$cfg['Servers'][$i]['socket']          = '';$cfg['Servers'][$i]['connect_type']    = 'tcp';$cfg['Servers'][$i]['extension']       = 'mysql';$cfg['Servers'][$i]['compress']        = FALSE;$cfg['Servers'][$i]['controluser']     = '';$cfg['Servers'][$i]['controlpass']     = ''; [color:"red"]$cfg['Servers'][$i]['auth_type']       = 'http';  [/color] $cfg['Servers'][$i]['user']            = 'root';$cfg['Servers'][$i]['password']        = '';$cfg['Servers'][$i]['only_db']         = '';$cfg['Servers'][$i]['verbose']         = '';$cfg['Servers'][$i]['pmadb']           = ''; // 'phpmyadmin' - see scripts/create_tables.sql$cfg['Servers'][$i]['bookmarktable']   = ''; // 'pma_bookmark'$cfg['Servers'][$i]['relation']        = ''; // 'pma_relation'$cfg['Servers'][$i]['table_info']      = ''; // 'pma_table_info'$cfg['Servers'][$i]['table_coords']    = ''; // 'pma_table_coords'$cfg['Servers'][$i]['pdf_pages']       = ''; // 'pma_pdf_pages'$cfg['Servers'][$i]['column_info']     = ''; // 'pma_column_info'$cfg['Servers'][$i]['history']         = ''; // 'pma_history'$cfg['Servers'][$i]['verbose_check']   = TRUE;$cfg['Servers'][$i]['AllowRoot']       = TRUE;$cfg['Servers'][$i]['AllowDeny']['order']                                       = '';$cfg['Servers'][$i]['AllowDeny']['rules']                                       = array();$i++;$cfg['Servers'][$i]['host']            = '';$cfg['Servers'][$i]['port']            = '';$cfg['Servers'][$i]['socket']          = '';$cfg['Servers'][$i]['connect_type']    = 'tcp';$cfg['Servers'][$i]['extension']       = 'mysql';$cfg['Servers'][$i]['compress']        = FALSE;$cfg['Servers'][$i]['controluser']     = '';$cfg['Servers'][$i]['controlpass']     = ''; [color:"red"]$cfg['Servers'][$i]['auth_type']       = 'http';  [/color] $cfg['Servers'][$i]['user']            = 'root';$cfg['Servers'][$i]['password']        = '';$cfg['Servers'][$i]['only_db']         = '';$cfg['Servers'][$i]['verbose']         = '';$cfg['Servers'][$i]['pmadb']           = ''; // 'phpmyadmin' - see scripts/create_tables.sql$cfg['Servers'][$i]['bookmarktable']   = ''; // 'pma_bookmark'$cfg['Servers'][$i]['relation']        = ''; // 'pma_relation'$cfg['Servers'][$i]['table_info']      = ''; // 'pma_table_info'$cfg['Servers'][$i]['table_coords']    = ''; // 'pma_table_coords'$cfg['Servers'][$i]['pdf_pages']       = ''; // 'pma_pdf_pages'$cfg['Servers'][$i]['column_info']     = ''; // 'pma_column_info'$cfg['Servers'][$i]['history']         = ''; // 'pma_history'$cfg['Servers'][$i]['verbose_check']   = TRUE;$cfg['Servers'][$i]['AllowRoot']       = TRUE;$cfg['Servers'][$i]['AllowDeny']['order']                                       = '';$cfg['Servers'][$i]['AllowDeny']['rules']                                       = array();// If you have more than one server configured, you can set $cfg['ServerDefault']// to any one of them to autoconnect to that server when phpMyAdmin is started,// or set it to 0 to be given a list of servers without logging in// If you have only one server configured, $cfg['ServerDefault'] *MUST* be// set to that server.$cfg['ServerDefault'] = 1;              // Default server (0 = no default server)$cfg['Server']        = '';unset($cfg['Servers'][0]);/** * Other core phpMyAdmin settings */$cfg['OBGzip']                  = 'auto'; // use GZIP output buffering if possible (TRUE|FALSE|'auto')$cfg['PersistentConnections']   = FALSE;  // use persistent connections to MySQL database$cfg['ExecTimeLimit']           = 300;    // maximum execution time in seconds (0 for no limit)$cfg['SkipLockedTables']        = FALSE;  // mark used tables, make possible to show                                          // locked tables (since MySQL 3.23.30)$cfg['ShowSQL']                 = TRUE;   // show SQL queries as run$cfg['AllowUserDropDatabase']   = FALSE;  // show a 'Drop database' link to normal users$cfg['Confirm']                 = TRUE;   // confirm 'DROP TABLE' & 'DROP DATABASE'$cfg['LoginCookieRecall']       = TRUE;   // recall previous login in cookie auth. mode or not$cfg['LoginCookieValidity']     = 1800;   // validity of cookie login (in seconds)$cfg['UseDbSearch']             = TRUE;   // whether to enable the "database search" feature                                          // or not$cfg['IgnoreMultiSubmitErrors'] = FALSE;  // if set to true, PMA continues computing multiple-statement queries                                          // even if one of the queries failed$cfg['VerboseMultiSubmit']      = TRUE;   // if set to true, PMA will show the affected rows of EACH statement on                                          // multiple-statement queries. See the read_dump.php file for hardcoded                                          // defaults on how many queries a statement may contain!$cfg['AllowArbitraryServer']    = FALSE;  // allow login to any user entered server in cookie based auth// Left frame setup$cfg['LeftFrameLight']        = TRUE;    // use a select-based menu and display only the                                         // current tables in the left frame.$cfg['LeftFrameTableSeparator']= '__';   // Which string will be used to generate table prefixes                                         // to split/nest tables into multiple categories$cfg['LeftFrameTableLevel']   = '1';     // How many sublevels should be displayed when splitting                                         // up tables by the above Separator$cfg['ShowTooltip']           = TRUE;    // display table comment as tooltip in left frame$cfg['ShowTooltipAliasDB']    = FALSE;   // if ShowToolTip is enabled, this defines that table/db comments$cfg['ShowTooltipAliasTB']    = FALSE;   // are shown (in the left menu and db_details_structure) instead of                                         // table/db names. Setting ShowTooltipAliasTB to 'nested' will only                                         // use the Aliases for nested descriptors, not the table itself.$cfg['LeftDisplayLogo']       = TRUE;   // display logo at top of left frame$cfg['LeftDisplayServers']    = FALSE;  // display server choice at top of left frame$cfg['DisplayServersList']    = FALSE;  // server choice as links// In the main frame, at startup...$cfg['ShowStats']             = TRUE;   // allow to display statistics and space usage in                                        // the pages about database details and table                                        // properties$cfg['ShowMysqlInfo']         = FALSE;  // whether to display the "MySQL runtime$cfg['ShowMysqlVars']         = FALSE;  // information", "MySQL system variables", "PHP$cfg['ShowPhpInfo']           = FALSE;  // information" and "change password" links for$cfg['ShowChgPassword']       = FALSE;  // simple users or not$cfg['SuggestDBName']         = TRUE;   // suggest a new DB name if possible (false = keep empty)// In browse mode...$cfg['ShowBlob']              = FALSE;  // display blob field contents$cfg['NavigationBarIconic']   = TRUE;   // do not display text inside navigation bar buttons$cfg['ShowAll']               = FALSE;  // allows to display all the rows$cfg['MaxRows']               = 30;     // maximum number of rows to display$cfg['Order']                 = 'ASC';  // default for 'ORDER BY' clause (valid                                        // values are 'ASC', 'DESC' or 'SMART' -ie                                        // descending order for fields of type                                        // TIME, DATE, DATETIME & TIMESTAMP,                                        // ascending order else-)// In edit mode...$cfg['ProtectBinary']         = 'blob'; // disallow editing of binary fields                                        // valid values are:                                        //   FALSE  allow editing                                        //   'blob' allow editing except for BLOB fields                                        //   'all'  disallow editing$cfg['ShowFunctionFields']    = TRUE;   // Display the function fields in edit/insert mode$cfg['CharEditing']           = 'input';                                        // Which editor should be used for CHAR/VARCHAR fields:                                        //  input - allows limiting of input length                                        //  textarea - allows newlines in fields$cfg['InsertRows']            = 2;      // How many rows can be inserted at one time// For the export features...$cfg['ZipDump']               = TRUE;   // Allow the use of zip/gzip/bzip$cfg['GZipDump']              = TRUE;   // compression for$cfg['BZipDump']              = TRUE;   // dump files$cfg['CompressOnFly']         = TRUE;   // Will compress gzip/bzip2 exports on                                        // fly without need for much memory.                                        // If you encounter problems with                                        // created gzip/bzip2 files disable                                        // this feature.// Tabs display settings$cfg['LightTabs']             = FALSE;  // use graphically less intense menu tabs$cfg['PropertiesIconic']      = TRUE;   // Use icons instead of text for the table display of a database (TRUE|FALSE|'both')$cfg['PropertiesNumColumns']  = 1;      // How many columns should be used for table display of a database?                                        // (a value larger than 1 results in some information being hidden)$cfg['DefaultTabServer']      = 'main.php';                                   // Possible values:                                   // 'main.php' = the welcome page                                   // (recommended for multiuser setups)                                   // 'server_databases.php' = list of databases                                   // 'server_status.php' = runtime information                                   // 'server_variables.php' = MySQL server variables                                   // 'server_privileges.php' = user management                                   // 'server_processlist.php' = process list$cfg['DefaultTabDatabase']    = 'db_details_structure.php';                                   // Possible values:                                   // 'db_details_structure.php' = tables list                                   // 'db_details.php' = sql form                                   // 'db_search.php' = search query                                   // 'db_operations.php' = operations on database$cfg['DefaultTabTable']       = 'tbl_properties_structure.php';                                   // Possible values:                                   // 'tbl_properties_structure.php' = fields list                                   // 'tbl_properties.php' = sql form                                   // 'tbl_select.php = select page                                   // 'tbl_change.php = insert row page/** * Export defaults */$cfg['Export']['format']                    = 'sql';  // sql/latex/excel/csv/xml/xls/hmtlexcel/htmlword$cfg['Export']['compression']               = 'none'; // none/zip/gzip/bzip2$cfg['Export']['asfile']                    = FALSE;$cfg['Export']['onserver']                  = FALSE;$cfg['Export']['onserver_overwrite']        = FALSE;$cfg['Export']['remember_file_template']    = TRUE;$cfg['Export']['htmlexcel_columns']         = FALSE;$cfg['Export']['htmlexcel_null']            = 'NULL';$cfg['Export']['htmlword_structure']        = TRUE;$cfg['Export']['htmlword_data']             = TRUE;$cfg['Export']['htmlword_columns']          = FALSE;$cfg['Export']['htmlword_null']             = 'NULL';$cfg['Export']['xls_columns']               = FALSE;$cfg['Export']['xls_null']                  = 'NULL';$cfg['Export']['csv_columns']               = FALSE;$cfg['Export']['csv_null']                  = 'NULL';$cfg['Export']['csv_separator']             = ';';$cfg['Export']['csv_enclosed']              = '"';$cfg['Export']['csv_escaped']               = '\\';$cfg['Export']['csv_terminated']            = 'AUTO';$cfg['Export']['excel_columns']             = FALSE;$cfg['Export']['excel_null']                = 'NULL';$cfg['Export']['excel_edition']             = 'win'; // win/mac$cfg['Export']['latex_structure']           = TRUE;$cfg['Export']['latex_data']                = TRUE;$cfg['Export']['latex_columns']             = TRUE;$cfg['Export']['latex_relation']            = TRUE;$cfg['Export']['latex_comments']            = TRUE;$cfg['Export']['latex_mime']                = TRUE;$cfg['Export']['latex_null']                = '\textit{NULL}';$cfg['Export']['latex_caption']             = TRUE;$cfg['Export']['latex_data_label']          = 'tab:__TABLE__-data';$cfg['Export']['latex_structure_label']     = 'tab:__TABLE__-structure';$cfg['Export']['sql_structure']             = TRUE;$cfg['Export']['sql_data']                  = TRUE;$cfg['Export']['sql_compat']                = 'NONE';$cfg['Export']['sql_disable_fk']            = FALSE;$cfg['Export']['sql_use_transaction']       = FALSE;$cfg['Export']['sql_drop_database']         = FALSE;$cfg['Export']['sql_drop_table']            = FALSE;$cfg['Export']['sql_if_not_exists']         = FALSE;$cfg['Export']['sql_auto_increment']        = TRUE;$cfg['Export']['sql_backquotes']            = TRUE;$cfg['Export']['sql_dates']                 = FALSE;$cfg['Export']['sql_relation']              = FALSE;$cfg['Export']['sql_columns']               = FALSE;$cfg['Export']['sql_delayed']               = FALSE;$cfg['Export']['sql_ignore']                = FALSE;$cfg['Export']['sql_hex_for_binary']        = TRUE;$cfg['Export']['sql_type']                  = 'insert'; // insert/update/replace$cfg['Export']['sql_extended']              = FALSE;$cfg['Export']['sql_comments']              = FALSE;$cfg['Export']['sql_mime']                  = FALSE;$cfg['Export']['sql_header_comment']        = ''; // \n is replaced by new line/** * Link to the official MySQL documentation. * Be sure to include no trailing slash on the path. * See http://dev.mysql.com/doc/ for more information * about MySQL manuals and their types. */$cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/mysql/en';/** * Type of MySQL documentation: *   old        - old style used in phpMyAdmin 2.3.0 and sooner *   searchable - "Searchable, with user comments" *   chapters   - "HTML, one page per chapter" *   big        - "HTML, all on one page" *   none       - do not show documentation links */$cfg['MySQLManualType'] = 'searchable';/** * PDF options */$cfg['PDFPageSizes']        = array('A3', 'A4', 'A5', 'letter', 'legal');$cfg['PDFDefaultPageSize']  = 'A4';/** * Language and charset conversion settings */// Default language to use, if not browser-defined or user-defined$cfg['DefaultLang'] = 'en-iso-8859-1';// Force: always use this language - must be defined in//        libraries/select_lang.lib.php// $cfg['Lang']     = 'en-iso-8859-1';// Default charset to use for recoding of MySQL queries, does not take// any effect when charsets recoding is switched off by// $cfg['AllowAnywhereRecoding'] or in language file// (see $cfg['AvailableCharsets'] to possible choices, you can add your own)$cfg['DefaultCharset'] = 'iso-8859-1';// Allow charset recoding of MySQL queries, must be also enabled in language// file to make harder using other language files than unicode.// Default value is FALSE to avoid problems on servers without the iconv// extension and where dl() is not supported$cfg['AllowAnywhereRecoding'] = FALSE;// You can select here which functions will be used for charset conversion.// Possible values are://      auto   - automatically use available one (first is tested iconv, then//               recode)//      iconv  - use iconv or libiconv functions//      recode - use recode_string function$cfg['RecodingEngine'] = 'auto';// Specify some parameters for iconv used in charset conversion. See iconv// documentation for details:// http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html$cfg['IconvExtraParams'] = '';// Available charsets for MySQL conversion. currently contains all which could// be found in lang/* files and few more.// Charsets will be shown in same order as here listed, so if you frequently// use some of these move them to the top.$cfg['AvailableCharsets'] = array(    'iso-8859-1',    'iso-8859-2',    'iso-8859-3',    'iso-8859-4',    'iso-8859-5',    'iso-8859-6',    'iso-8859-7',    'iso-8859-8',    'iso-8859-9',    'iso-8859-10',    'iso-8859-11',    'iso-8859-12',    'iso-8859-13',    'iso-8859-14',    'iso-8859-15',    'windows-1250',    'windows-1251',    'windows-1252',    'windows-1256',    'windows-1257',    'koi8-r',    'big5',    'gb2312',    'utf-8',    'utf-7',    'x-user-defined',    'euc-jp',    'ks_c_5601-1987',    'tis-620',    'SHIFT_JIS');/** * Customization & design * * The graphical settings are now located in themes/themename/layout.inc.php */$cfg['LeftPointerEnable']   = TRUE;         // enable the left panel pointer                                            // (used when LeftFrameLight is FALSE)                                            // see also LeftPointerColor                                            // in layout.inc.php$cfg['BrowsePointerEnable'] = TRUE;        // enable the browse pointer                                            // see also BrowsePointerColor                                            // in layout.inc.php$cfg['BrowseMarkerEnable'] = TRUE;         // enable the browse marker                                            // see also BrowseMarkerColor                                            // in layout.inc.php$cfg['TextareaCols']        = 40;           // textarea size (columns) in edit mode                                            // (this value will be emphasized (*2) for sql                                            // query textareas and (*1.25) for query window)$cfg['TextareaRows']        = 7;            // textarea size (rows) in edit mode$cfg['LongtextDoubleTextarea'] = TRUE;      // double size of textarea size for longtext fields$cfg['TextareaAutoSelect']  = TRUE;         // autoselect when clicking in the textarea of the querybox$cfg['CharTextareaCols']    = 40;           // textarea size (columns) for CHAR/VARCHAR$cfg['CharTextareaRows']    = 2;            // textarea size (rows) for CHAR/VARCHAR$cfg['CtrlArrowsMoving']    = TRUE;         // Enable Ctrl+Arrows moving between fields when editing?$cfg['LimitChars']          = 50;           // Max field data length in browse mode for all non-numeric fields$cfg['ModifyDeleteAtLeft']  = TRUE;         // show edit/delete links on left side of browse                                            // (or at the top with vertical browse)$cfg['ModifyDeleteAtRight'] = FALSE;        // show edit/delete links on right side of browse                                            // (or at the bottom with vertical browse)$cfg['DefaultDisplay']      = 'horizontal'; // default display direction                                            // (horizontal|vertical|horizontalflipped)$cfg['DefaultPropDisplay']  = 'horizontal'; // default display direction for altering/                                            // creating columns (tbl_properties)                                            // (horizontal|vertical)$cfg['HeaderFlipType']      = 'css';        // table-header rotation via faking or css? (css|fake)                                            // NOTE: CSS only works in IE browsers!$cfg['ShowBrowseComments']  = TRUE;         // shows stored relation-comments in 'browse' mode.$cfg['ShowPropertyComments']= TRUE;         // shows stored relation-comments in 'table property' mode.$cfg['RepeatCells']         = 100;          // repeat header names every X cells? (0 = deactivate)$cfg['QueryFrame']          = TRUE;         // displays a link or icon in the left frame to open the querybox, and activates the querybox when clicking on [Edit] on the results page.$cfg['QueryFrameJS']        = TRUE;         // whether to use JavaScript functions for opening a new window for SQL commands.                                            // if set to 'false', the target of the querybox is always the right frame.$cfg['QueryWindowWidth']    = 550;          // Width of Query window$cfg['QueryWindowHeight']   = 310;          // Height of Query window$cfg['QueryHistoryDB']      = FALSE;         // Set to TRUE if you want DB-based query history.                                            // If FALSE, this utilizes JS-routines to display                                            // query history (lost by window close)$cfg['QueryWindowDefTab']   = 'sql';        // which tab to display in the querywindow on startup                                            // (sql|files|history|full)$cfg['QueryHistoryMax']     = 25;           // When using DB-based query history, how many entries                                            // should be kept?$cfg['BrowseMIME']          = TRUE;         // Use MIME-Types (stored in column comments table) for$cfg['MaxExactCount']       = 20000;        // When approximate count < this, PMA will get exact count for                                            // table rows.$cfg['WYSIWYG-PDF']         = TRUE;         // Utilize DHTML/JS capabilities to allow WYSIWYG editing of                                            // the PDF page editor. Requires an IE6/Mozilla based browser.$cfg['NaturalOrder']        = TRUE;         // Sort table and database in natural order//-----------------------------------------------------------------------------// custom-setup by mkkeck: 2004-05-04//    some specials for new icons and scrollings// FIXME:// 2004-05-08 rabus: We need to rearrange these variables.$cfg['ShowHttpHostTitle']   = TRUE;            // show HttpHost in browsers window title (true|false)?$cfg['SetHttpHostTitle']    = '';              // if ShowHttpHostTitle=true, please set your host (server)                                             // or an other string, wich should be shown in browsers window title.                                             // If not set (or empty), the PMA will get your real Host-Adress.$cfg['ErrorIconic']          = TRUE;    // show some icons for warning, error and information messages (true|false)?$cfg['MainPageIconic']       = TRUE;    // show icons in list on main page, on right panel top menu (server db table)  and on menu tabs (true|false)?$cfg['ReplaceHelpImg']       = TRUE;    // show help button instead of strDocumentation (true|false)?// theme manager$cfg['ThemePath']           = './themes';    // using themes manager please set up here the path to 'themes'                                             // else leave empty$cfg['ThemeManager']        = TRUE;          // if you want to use selectable themes and if ThemesPath not empty                                             // set it to true, else set it to false (default is false);$cfg['ThemeDefault']        = 'original';         // set up default theme, if ThemePath not empty                                             // you can set up here an valid path to themes or 'original' for                                             // the original pma-theme//-----------------------------------------------------------------------------/** * Default queries * %d will be replaced by the database name. * %t will be replaced by the table name. * %f will be replaced by a list of field names. * (%t and %f only applies to DefaultQueryTable) */$cfg['DefaultQueryTable']    = 'SELECT * FROM %t WHERE 1';$cfg['DefaultQueryDatabase'] = '';/** * SQL Query box settings * These are the links display in all of the SQL Query boxes */$cfg['SQLQuery']['Edit']      = TRUE;       // Edit link to change a query$cfg['SQLQuery']['Explain']   = TRUE;       // EXPLAIN on SELECT queries$cfg['SQLQuery']['ShowAsPHP'] = TRUE;       // Wrap a query in PHP$cfg['SQLQuery']['Validate']  = FALSE;      // Validate a query (see $cfg['SQLValidator'] as well)$cfg['SQLQuery']['Refresh']   = TRUE;       // Refresh the results page/** * Webserver upload/save/import directories */$cfg['UploadDir']             = '';         // Directory for uploaded files that can be executed by                                            // phpMyAdmin. For example './upload'. Leave empty for                                            // no upload directory support$cfg['SaveDir']               = '';         // Directory where phpMyAdmin can save exported data on                                            // server. For example './save'. Leave empty for no save                                            // directory support.$cfg['docSQLDir']             = '';         // Directory for docSQL imports, phpMyAdmin can import                                            // docSQL files from that directory. For example                                            // './docSQL'. Leave empty for no docSQL import support.$cfg['TempDir']               = '';         // Directory where phpMyAdmin can save temporary files.                                            // This is needed for MS Excel export, see documentation                                            // how to enable that./** * Misc. settings */$cfg['GD2Available']          = 'auto';     // Is GD >= 2 available? Set to yes/no/auto. 'auto'                                            // does autodetection, which is a bit expensive for                                            // php < 4.3.0, but it is the only safe vay how to                                            // determine GD version./** * SQL Parser Settings */$cfg['SQP']['fmtType']      = 'html';       // Pretty-printing style to use on queries (html, text, none)$cfg['SQP']['fmtInd']       = '1';          // Amount to indent each level (floats ok)$cfg['SQP']['fmtIndUnit']   = 'em';         // Units for indenting each level (CSS Types - {em,px,pt})// The graphical settings are now located in themes/themename/layout.inc.php/** * If you wish to use the SQL Validator service, you should be * aware of the following: * All SQL statements are stored anonymously for statistical purposes. * Mimer SQL Validator, Copyright 2002 Upright Database Technology. * All rights reserved. */$cfg['SQLValidator']['use']      = FALSE;   // Make the SQL Validator available$cfg['SQLValidator']['username'] = '';      // If you have a custom username, specify it here (defaults to anonymous)$cfg['SQLValidator']['password'] = '';      // Password for username/** * Developers ONLY! * To use the following, please install the DBG extension from http://dd.cron.ru/dbg/ */$cfg['DBG']['enable'] = FALSE;              // Make the DBG stuff available$cfg['DBG']['profile']['enable'] = FALSE;   // Produce profiling results of PHP$cfg['DBG']['profile']['threshold'] = 0.5;  // Threshold of long running code to display                                            // Anything below the threshold is not displayed/** * MySQL settings */// Column types;// varchar, tinyint, text and date are listed first, based on estimated popularity$cfg['ColumnTypes'] = array(   'VARCHAR',   'TINYINT',   'TEXT',   'DATE',   'SMALLINT',   'MEDIUMINT',   'INT',   'BIGINT',   'FLOAT',   'DOUBLE',   'DECIMAL',   'DATETIME',   'TIMESTAMP',   'TIME',   'YEAR',   'CHAR',   'TINYBLOB',   'TINYTEXT',   'BLOB',   'MEDIUMBLOB',   'MEDIUMTEXT',   'LONGBLOB',   'LONGTEXT',   'ENUM',   'SET');// Attributes// Note: the "ON UPDATE CURRENT_TIMESTAMP" attribute is added dynamically // for MySQL >= 4.1.2, in tbl_properties.inc.php$cfg['AttributeTypes'] = array(   '',   'BINARY',   'UNSIGNED',   'UNSIGNED ZEROFILL');// Available functionsif ($cfg['ShowFunctionFields']) {    $cfg['Functions'] = array(       'ASCII',       'CHAR',       'SOUNDEX',       'LCASE',       'UCASE',       'NOW',       'PASSWORD',       'MD5',       'SHA1',       'ENCRYPT',       'RAND',       'LAST_INSERT_ID',       'COUNT',       'AVG',       'SUM',       'CURDATE',       'CURTIME',       'FROM_DAYS',       'FROM_UNIXTIME',       'PERIOD_ADD',       'PERIOD_DIFF',       'TO_DAYS',       'UNIX_TIMESTAMP',       'USER',       'WEEKDAY',       'CONCAT'    );    // Which column types will be mapped to which Group?    $cfg['RestrictColumnTypes'] = array(       'VARCHAR'      => 'FUNC_CHAR',       'TINYINT'      => 'FUNC_NUMBER',       'TEXT'         => 'FUNC_CHAR',       'DATE'         => 'FUNC_DATE',       'SMALLINT'     => 'FUNC_NUMBER',       'MEDIUMINT'    => 'FUNC_NUMBER',       'INT'          => 'FUNC_NUMBER',       'BIGINT'       => 'FUNC_NUMBER',       'FLOAT'        => 'FUNC_NUMBER',       'DOUBLE'       => 'FUNC_NUMBER',       'DECIMAL'      => 'FUNC_NUMBER',       'DATETIME'     => 'FUNC_DATE',       'TIMESTAMP'    => 'FUNC_DATE',       'TIME'         => 'FUNC_DATE',       'YEAR'         => 'FUNC_DATE',       'CHAR'         => 'FUNC_CHAR',       'TINYBLOB'     => 'FUNC_CHAR',       'TINYTEXT'     => 'FUNC_CHAR',       'BLOB'         => 'FUNC_CHAR',       'MEDIUMBLOB'   => 'FUNC_CHAR',       'MEDIUMTEXT'   => 'FUNC_CHAR',       'LONGBLOB'     => 'FUNC_CHAR',       'LONGTEXT'     => 'FUNC_CHAR',       'ENUM'         => '',       'SET'          => ''    );    // Map above defined groups to any function    $cfg['RestrictFunctions'] = array(        'FUNC_CHAR'   => array(            'ASCII',            'CHAR',            'SOUNDEX',            'LCASE',            'UCASE',            'PASSWORD',            'MD5',            'SHA1',            'ENCRYPT',            'LAST_INSERT_ID',            'USER',            'CONCAT'        ),        'FUNC_DATE'   => array(            'NOW',            'CURDATE',            'CURTIME',            'FROM_DAYS',            'FROM_UNIXTIME',            'PERIOD_ADD',            'PERIOD_DIFF',            'TO_DAYS',            'UNIX_TIMESTAMP',            'WEEKDAY'        ),        'FUNC_NUMBER' => array(            'ASCII',            'CHAR',            'MD5',            'SHA1',            'ENCRYPT',            'RAND',            'LAST_INSERT_ID',            'UNIX_TIMESTAMP',            'COUNT',            'AVG',            'SUM'        )    );    // Default functions for above defined groups    $cfg['DefaultFunctions'] = array(        'FUNC_CHAR'         => '',        'FUNC_DATE'         => '',        'FUNC_NUMBER'       => '',        'first_timestamp'   => 'NOW'    );} // end if// Search operators$cfg['NumOperators'] = array(   '=',   '>',   '>=',   '<',   '<=',   '!=',   'LIKE',   'NOT LIKE');$cfg['TextOperators'] = array(   'LIKE',   'LIKE %...%',   'NOT LIKE',   '=',   '!=',   'REGEXP',   'NOT REGEXP');$cfg['EnumOperators'] = array(   '=',   '!=');$cfg['NullOperators'] = array(   'IS NULL',   'IS NOT NULL');$cfg['UnaryOperators'] = array(   'IS NULL'     => 1,   'IS NOT NULL' => 1);/** * Unset magic_quotes_runtime - do not change! */set_magic_quotes_runtime(0);/** * File Revision - do not change either! */$cfg['FileRevision'] = '$Revision: 2.52 $';?>

ps. in rood is wat ik heb veranderd. waar nu http staat, stond dus 'config' maar dan krijg ik het scherm zoals hierboven stond.

check :

merDe

WPW · 17 januari 2007

Was er niet iets met pw compatibiliteit? (old-passwords)

Ome Merde · 17 januari 2007

ik heb geeb idee. als ik config.inc.php wil gaan editten met "vi" loopt vi vast.

I rest my case, morgen reset ik hem ....

merDe

Ome Merde · 18 januari 2007

toch nog maar even een schot gewaagd <img src="/forums/images/graemlins/smile.gif" alt="" />

config.inc.php aangepast (auth-type (cookie), gebruikersnaam en password) en nu krijg ik dit :

whaaaa ...

merDe

Inloggen

kan geen PHP pagina bekijken, alleen de bestandsnamen zijn zichtbaar

Aanbevolen berichten

Link naar reactie

Delen op andere sites

Beste reacties in dit topic

Populaire dagen

Beste reacties in dit topic

Populaire dagen

Geplaatste afbeeldingen

Gast

Link naar reactie

Delen op andere sites

Link naar reactie

Delen op andere sites

Gast

Link naar reactie

Delen op andere sites

Link naar reactie

Delen op andere sites

Link naar reactie

Delen op andere sites

Link naar reactie

Delen op andere sites

Link naar reactie

Delen op andere sites

Link naar reactie

Delen op andere sites

Link naar reactie

Delen op andere sites

Link naar reactie

Delen op andere sites

Link naar reactie

Delen op andere sites

Link naar reactie

Delen op andere sites

Link naar reactie

Delen op andere sites

Link naar reactie

Delen op andere sites

Maak een account aan of log in om te reageren

Account aanmaken

Inloggen

Wie is er online 0 leden