I have a auction website using php and mySQL and categories are saved in database. When i tried to add new categories in Admin area such as: Đà Nẵng(Vietnamese) and when i saved, it displayed something funny like this:"ďà N&#ng". I have modified charset in myPhPadmin for the database and for categories table to uft-8, but it won't help.
View 4 RepliesI own and run the server I am having issues with FC5 running. it has been online with no issues. Until this new client.
I have a new client moving his sites to my servers. The issue is the sites have text in it that are not displaying correctly. When you view them through your browser or if I view them on the server with nano and look a the code, some characters are all messed up.
here is an example. on the websitethis is how its supposed to look.
“0” but when you view it with Firefox it looks like this �0�.
if I download the source and view it in word pad it is fine, and looks as it should I have change my charsets around even have the same charsets installed on his server installed on mine. I have commented out default charset in apache to let the browser choose but to no avail. My server has no problem showing Chinese text on web pages or anything else so i do not understand why this is happening. If anyone has any ideas please let me know, this is very frustrating as I have never had this issue before.
here is what is in my httpd.conf
AddLanguage da .dk
AddLanguage nl .nl
AddLanguage en .en
AddLanguage et .ee
AddLanguage fr .fr
AddLanguage de .de
AddLanguage el .el
AddLanguage he .he
AddCharset ISO-8859-8 .iso8859-8
AddLanguage it .it
AddLanguage ja .ja
AddCharset ISO-2022-JP .jis
AddLanguage kr .kr
AddCharset ISO-2022-KR .iso-kr
AddLanguage nn .nn
AddLanguage no .no
AddLanguage pl .po
AddCharset ISO-8859-2 .iso-pl
AddLanguage pt .pt
AddLanguage pt-br .pt-br
AddLanguage ltz .lu
AddLanguage ca .ca
AddLanguage es .es
AddLanguage sv .sv
AddLanguage cz .cz
AddLanguage ru .ru
AddLanguage zh-tw .tw
AddLanguage tw .tw
AddCharset Big5 .Big5 .big5
AddCharset WINDOWS-1251 .cp-1251
AddCharset CP866 .cp866
AddCharset ISO-8859-5 .iso-ru
AddCharset KOI8-R .koi8-r
AddCharset UCS-2 .ucs2
AddCharset UCS-4 .ucs4
AddLanguage ltz .lu
AddLanguage ca .ca
AddLanguage es .es
AddLanguage sv .sv
AddLanguage cz .cz
AddLanguage ru .ru
AddLanguage zh-tw .tw
AddLanguage tw .tw
AddCharset Big5 .Big5 .big5
AddCharset WINDOWS-1251 .cp-1251
AddCharset CP866 .cp866
AddCharset ISO-8859-5 .iso-ru
AddCharset KOI8-R .koi8-r
AddCharset UCS-2 .ucs2
AddCharset UCS-4 .ucs4
AddCharset UTF-8 .utf8
AddDefaultCharset UTF-8
i have problems with charsets in all the php-mysql sites whick i setup..i am from greece and i want all to have as default the greek lang...what exactly i must change from mysql or apache to have all working fine with greek charset ISO-8859-7
Before your answers i must tell you that
2))i have change in php.ini as default language to the greek ISO-8859-7
2)also in phpmyadmin mysql connection collation is set it in UTF_8 bin
BUT THE Problem stills remains
I have a server:
CentOS release 4.5 (Final)
PHP Version 4.3.9
Apache Version: 2.0.52-32.3.ent.centos4
mySQL 4.1.20-2.RHEL4.1
And i keep gettings these errors:
Code:
MySQL Error!
------------------------
The Error returned was:
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (cp1251_general_ci,COERCIBLE) for operation 'regexp'
Error Number:
1267
SELECT name FROM uxwarez_users WHERE LOWER(name) REGEXP '[[:<:]]d[a�][vu�][i1l!]d[[:>:]]'
You can see these: �
I get those also in my webpage. They replace almost every special character.
to change a mysql database and all its tables to a utf8 charset and collation, however I'm not sure specifically which one I should use. We are currently using latin1_general_ci.
On a forum I've noticed that in a couple of posts I made, sometimes characters such as the euro sign €, and the German ß get converted to question marks.
Being an English forum we don't often have members use these characters but we'd like them displayed correctly when they are.
I don't really know much about character sets and such, but I understand that they contain different characters and treat them differently in comparisons and sorts etc. So which of the following should I be using?
utf8_bin
utf8_general_ci
utf8_unicode_ci
I was leaning towards unicode, but I don't know what the differences between them are. Can anyone advise us on what to use?
This is for MySQL 4.1.22 btw.
I'm certain the problem is not with my browser, and the characters are typed from the keyboard, not copied and pasted from word docs. A charset is specified by a meta tag in the header too.
We have a special application that works on 3 servers, 1 of them is main server and others are mysql replicate servers basically used for generating reports or backups...
Server 1 - Centos 6.5/Mysql 5.5/Plesk 12
Server 2 - Centos 6.5/Mysql 5.5/Plesk 11
Server 3 - Server 2008 R2/Mysql 5.5/Plesk 12
Server 1->Server 2 replication works perfectly
Server 1->Server 3 replication sometimes fails with character issues (our database and tables use utf8_turkish_ci), when I tried to investigate this issue by logging in to mysql on Server 3 right after connection i saw "Unknown OS Character Set 'cp857' Switching to default character set latin1" and i am guessing that my replication issues are also related to this issue. I tried adding below settings to my.ini at "C:Program Files (x86)ParallelsPleskDatabasesMySQLdata"
[mysqld]
init_connect='SET collation_connection = utf8_turkish_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_turkish_ci
skip-character-set-client-handshake
[mysql]
default-character-set=utf8
default-collation=utf8_turkish_ci
[client]
default-character-set=utf8
default-collation=utf8_turkish_ci
but didnt change anything, i was wondering if these settings were wrong so i tried them at my local wamp installation which i was having same error, but error was gone after adding them to my.ini so i think settings are alright...
I have upgrade my mysql plesk installation from 5.1 to 5.6 and have troubles in setting utf8mb4 charset for server and databases. Special characters still display badly in my websites. I'm running Windows Server 2012 R2 and plsk 12.Â
View 1 Replies View Relatedi downloaded a copy of phpmyadmin and uploaded it to my hosting.. then i run mydomain.com/phpmyadmin/setup configured the server to my hosting IP address but it says i can't login using myusername@localhost do i need to do something on a cpanel mysql server to listen to the external phpmyadmin?
View 1 Replies View RelatedI've only messed around in php/mysql stuff on occasion, so I'm still new to it.
When I access domain.com/phpmyadmin and log in, I see two things that I believe are preventing my stuff from connecting and working properly.
**Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole.
**The mbstring PHP extension was not found and you seem to be using a multibyte charset.
Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.
I've just did the following on Ubuntu Server 9.03:
Code:
sudo apt-get install mysql-server
sudo apt-get install apache2
sudo apt-get install php5
sudo apt-get install php5-mysql
sudo apt-get install phpmyadmin
But when I say [url]-- it cannot be found..
I tried [url]as well, It cannot be found either.
I am using plesk and created one database from my control panel and also created a user to
access the database. Now my concern is how can I access phymyadmin. Is it possible to access
PHPMyadmin from Plesk? Or is there any other way to manage my database?
Anyone using phpMyAdmin for MySQL admin, you need to know about a newly discovered attack vector.
Here's the official announcement: [url]
The key to this is in their description, "A logged-in user can be subject of SQL injection through cross site request forgery. Several scripts in phpMyAdmin are vulnerable and the attack can be made through table parameter."
A logged in user... This attack is a combination of SQL injection through CSRF. In other words, you'd have to be logged into your phpMyAdmin program, hit a website setup for CSRF, and then the attacker could have access to your phpMyAdmin as you.
If there's interest here, I could write up a detailed description of CSRF and how to prevent this type of attack.
Just let me know...
You should upgrade immediately to either phpMyAdmin 2.9.11.4 or 3.1.1.0 or apply patch 12100.
I've got phpMyAdmin setup, but when I logout or try to browse a table I get 404 error. Everything is CHMOD as 755. Ideas? I'm also running off of LiteSpeed
View 3 Replies View Relatedi have a problme in the server .. that when any site try to login the phpmyadmin this message appears " #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
View 2 Replies View Relatedi m using DA server. i want to upgrade to latest version.
View 7 Replies View RelatedMy PhpMyAdmin is not working properly.
Everytime I try to use it, it tells me:
"Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly."
My PHP install is perfectly fine, and session support is enabled.
I am a newbie and now i am running a VPS account. I have some questions want to ask you
Where is the locate of phpMyAdmin?
I am running VPS server but get error when access to phpmyadmin.
Quote:
Wrong username/password. Access denied.
I created a user=root and passworld=xxx in my WHM.
How to find config.inc.php ?
- locate but error
Quote:
warning: locate: could not open database: /var/lib/slocate/slocate.db: No such file or directory
warning: You need to run the 'updatedb' command (as root) to create the database.
Please have a look at /etc/updatedb.conf to enable the daily cron job.
I've been struggling with getting phpMyAdmin to work on IIS7 for a long time. I've tried just about everything I can possibly think of, in the process, breaking both PHP and MySQL several times.
Ok...so my PHP and MySQL is working great now...but I still can't get phpMyAdmin to work. I get the following message :
Quote:
Cannot load mysql extension. Please check your PHP configuration. - Documentation
If you anyone has some advice, I will appreciate it.
I'm running :
PHP 5.1.2
MySQL 5
IIS7
Vista
Has anyone seen any docs on upgrading phpMyAdmin? And does it need to be done via SSH?
I'm on a MediaTemple (gs)...
I have a problem when i config config.inc.php file in my WHM . I don't know why share accounts can access to phpMyAdmin or create your database from cpanel .
This is a part of config.inc.php file
Quote:
/**
* 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 ''. If you want more than one server, just copy following section
// (including $i incrementation) serveral times. There is no need to define
// full server array, just define values you need to change.
$i++;
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['ssl'] = false; // Use SSL for connecting to MySQL server?
$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)
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (valid choices: config, http, HTTP, signon or cookie)
$cfg['Servers'][$i]['user'] = ''; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
// with 'config' auth_type)
$cfg['Servers'][$i]['SignonSession'] = ''; // Session to use for 'signon' auth method
$cfg['Servers'][$i]['SignonURL'] = ''; // URL where to redirect user to login for 'signon' auth method
$cfg['Servers'][$i]['LogoutURL'] = ''; // URL where to redirect user after logout
$cfg['Servers'][$i]['nopassword'] = FALSE; // Whether to try to connect without password
$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]['hide_db'] = ''; // Database name to be hidden from listings
$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]['designer_coords'] = ''; // table to store the coordinates for Designer
// - leave blank for no Designer feature
// DEFAULT: 'pma_designer_coords'
$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();
// 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)
/**
* Other core phpMyAdmin settings
*/
$cfg['MaxDbList'] = 100; // maximum number of db's displayed in left frame and databaes list
$cfg['OBGzip'] = 'auto'; // use GZIP output buffering if possible (TRUE|FALSE|'auto')
$cfg['PersistentConnections'] = FALSE; // use persistent connections to MySQL database
$cfg['ForceSSL'] = FALSE; // whether to force using https
$cfg['ExecTimeLimit'] = 300; // maximum execution time in seconds (0 for no limit)
$cfg['MemoryLimit'] = 0; // maximum allocated bytes (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['LoginCookieStore'] = 0; // how long login cookie should be stored (in seconds)
$cfg['LoginCookieDeleteAll'] = TRUE; // whether to delete all login cookies on logout
$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 libraries/import.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['LeftFrameDBTree'] = TRUE; // turn the select-based light menu into a tree
$cfg['LeftFrameDBSeparator'] = '_'; // the separator to sub-tree the select-based light menu tree
$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_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['LeftLogoLink'] = 'main.php'; // where should logo link point to
// (can also contain an external URL)
$cfg['LeftLogoLinkWindow'] = 'main'; // whether to open the linked page
// in the main window ('main')
// or in a new window ('new')
$cfg['LeftDisplayServers'] = FALSE; // display server choice at top of left frame
$cfg['DisplayServersList'] = FALSE; // server choice as links
$cfg['DisplayDatabasesList'] = FALSE; // database choice in light 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['ShowPhpInfo'] = FALSE; // show php info link
$cfg['ShowServerInfo'] = TRUE; // show MySQL server information
$cfg['ShowChgPassword'] = FALSE; // show change password link
$cfg['ShowCreateDb'] = TRUE; // show create database form
$cfg['SuggestDBName'] = TRUE; // suggest a new DB name if possible (false = keep empty)
Some questions
--------------------------------------------------
$cfg['Servers'][$i]['controluser'] =?
$cfg['Servers'][$i]['controlpass'] =?
--------------------------------------------------
$cfg['Servers'][$i]['user'] =?
$cfg['Servers'][$i]['password'] =?
Because phpmyadmin on powervps'directadmin doesnt support phpMyAdmin - 2.10.3 version, so I have to install it by my self. I read the instruction in here
[url]
But I dont understand.
First of all: How can I upload the file to directory /var/tmp?
2, when I type the command below, it did not work:
# cd /home/httpd/SSLSERVER-443/html
# tar zxvf /var/tmp/phpMyAdmin-2.7.0-pl1.tar.gz
# mv phpMyAdmin-2.7.0-pl1 phpMyAdmin
And the following commands did not work too.
I really need the version above to run my database. The current phpmyadmin does not support it and that why my database got error when I was trying to restore.
I found several requests in my error log which looks like someone was scanning my site for phpMyAdmin. This was a newly created subdomain. So I checked my main site and another subdomain and they also contained similar entries. Should I do something?
[Fri Jul 03 03:23:16 2009] [error] [client 65.23.157.214] File does not exist: /var/www/vhosts/mydomain.com/subdomains/mysubdomain/httpdocs/phpMyAdmin
[Fri Jul 03 03:23:16 2009] [error] [client 65.23.157.214] File does not exist: /var/www/vhosts/mydomain.com/subdomains/mysubdomain/httpdocs/phpmyadmin
[Fri Jul 03 03:23:16 2009] [error] [client 65.23.157.214] File does not exist: /var/www/vhosts/mydomain.com/subdomains/mysubdomain/httpdocs/pma ...
I host my own website on my computer (Mac mini Mac OS X 10.5.7)
I am running Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.7l DAV/2 PHP/5.2.9 - MySQL 5.1.35 - phpMyAdmin 3.2.0
I recently made MySQL and phpMyAdmin upgrades.
Before the upgrades, when performing a name search in the main table of my DB, if the query returned no result, the right frame displayed the result and the usual content of the Search Tab for performing a new search.
Now, the right frame displays a blank page with only the mention of ServerName - DatabaseName - TableName
Is this a bug or a new (bad) feature in phpMyAdmin 3.2.0?
how can install mbstring for phpmyadmin in lxadmin?
View 3 Replies View RelatedI rent a vps and currenly running on CentOS. I already setup 2 domain using VirtualHost and wondering how I can configure for each domain can access only 1 phpmyadmin directory
e.g :
example.com/phpmyadmin
example1.com/phpmyadmin
for now I manage to to it manually without using any cPanel or other tools.. cost saving , just want to learn to setup for myself.
i am on an VPS , i want to know how different vanilla mysql is from mysql
since i got vanilla mysql , and want to use Phpmyadmin is it paossible with vanilla or i have to insall mysql?
also my old site database was installed on Mysql , would it work the same with vanilla mysql?
also how can i create an sql dataabe , username , passwrd using vaniall mysql?
And do i have to unistall vanilla mysql to install mysql
I have a very good free web hosting company. My one user needs to be able to upload a 16 meg sql file in php. I tried bigphp, but it game me an error that the sql file doesent have a semicolon followed by a linebreak at the end of each query in the file.
I know there is some sort of SSH command i can run to import this sql file to his account. I am using layered panel. So what is the easiest way here?
Also i have 20MB php.ini settings for uploads, post size, etc.
Im getting an arror in phpmyadmin #2002
phpMyAdmin - Error
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
and when restarting mysql im getting this error
Attempting to restart mysql Waiting for mysql to restart.... . . . . . . . . . . finished.
mysql status
/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").
How can I configure the phpmyadmin in plesk to show databases?
because when my customers trying to access to phpmyadmin show access denied.
I just upgraded to Debian from RedHat, but I'm a little lost trying to get phpMyAdmin working. Below is a snapshot of my config.
I'm sure I'm missing something.
looks like I have the packages...
debianlinux [/root] # dpkg -l | grep php
ii libapache-mod-php5 5.2.0-8+etch4
ii libapache2-mod-php4 4.4.4-8+etch2
ii php4-common 4.4.4-8+etch2
ii php5-common 5.2.0-8+etch4
ii php5-gd 5.2.0-8+etch4
ii php5-mcrypt 5.2.0-8+etch4
ii php5-mysql 5.2.0-8+etch4
ii phpmyadmin 2.9.1.1-3
am I missing any apache modules?
debianlinux [/etc/apache2] # apache2ctl -t -D DUMP_MODULES
Loaded Modules:
core_module (static)
log_config_module (static)
logio_module (static)
mpm_prefork_module (static)
http_module (static)
so_module (static)
alias_module (shared)
auth_basic_module (shared)
authn_file_module (shared)
authz_default_module (shared)
authz_groupfile_module (shared)
authz_host_module (shared)
authz_user_module (shared)
autoindex_module (shared)
cgi_module (shared)
dir_module (shared)
env_module (shared)
mime_module (shared)
python_module (shared)
negotiation_module (shared)
perl_module (shared)
php4_module (shared)
setenvif_module (shared)
status_module (shared)
Syntax OK
here is my short and sweet apache2.conf
debianlinux [/etc/apache2] # cat apache2.conf
ServerRoot "/etc/apache2/"
ServerName debianlinux
LockFile /var/lock/apache2/accept.lock
PidFile /var/run/apache2.pid
Timeout 300
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 15
<IfModule mpm_prefork_module>
StartServers 5
MinSpareServers 5
MaxSpareServers 10
MaxClients 150
MaxRequestsPerChild 0
</IfModule>
<IfModule mpm_worker_module>
StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule>
User apache2
Group apache2
AccessFileName .htaccess
<Files ~ "^.ht">
Order allow,deny
Deny from all
</Files>
TypesConfig /etc/mime.types
DefaultType text/plain
HostnameLookups Off
ErrorLog /var/log/apache2/error.log
LogLevel warn
Include /etc/apache2/mods-enabled/*.load
Include /etc/apache2/mods-enabled/*.conf
Include /etc/apache2/ports.conf
Include /etc/apache2/conf.d/
LogFormat "%h %l %u %t "%r" %>s %b "%{Referer}i" "%{User-Agent}i"" combined
LogFormat "%h %l %u %t "%r" %>s %b" common
LogFormat "%{Referer}i -> %U" referer
LogFormat "%{User-agent}i" agent
ServerSignature Off
<IfModule alias_module>
Alias /icons/ "/usr/share/apache2/icons/"
<Directory "/usr/share/apache2/icons">
Options Indexes MultiViews
AllowOverride None
Order allow,deny
Allow from all
</Directory>
</IfModule>
<IfModule mod_autoindex.c>
IndexOptions FancyIndexing VersionSort HTMLTable NameWidth=*
DefaultIcon /icons/blank.gif
ReadmeName README.html
HeaderName HEADER.html
IndexIgnore .??* *~ *# RCS CVS *,v *,t
</IfModule>
<IfModule mod_mime.c>
AddType application/x-compress .Z
AddType application/x-gzip .gz .tgz
</IfModule>
<IfModule mod_mime.c>
AddCharset us-ascii .ascii .us-ascii
AddCharset ISO-8859-1 .iso8859-1 .latin1
AddHandler type-map var
AddType text/html .shtml
AddOutputFilter INCLUDES .shtml
</IfModule>
Include /etc/apache2/sites-enabled/
Include /etc/phpmyadmin/apache.conf
I can hit my default site okay, which in in /root (for testing)
debianlinux [/etc/apache2/sites-available] # cat default
NameVirtualHost *
<VirtualHost *>
ServerAdmin webmaster@localhost
DocumentRoot /root/public_html/
<Directory /root/public_html/>
Options FollowSymLinks
AllowOverride None
</Directory>
<Directory /root/public_html/>
Options Indexes FollowSymLinks MultiViews
AllowOverride None
Order allow,deny
allow from all
</Directory>
ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/
<Directory "/usr/lib/cgi-bin">
AllowOverride None
Options ExecCGI -MultiViews +SymLinksIfOwnerMatch
Order allow,deny
Allow from all
</Directory>
ErrorLog /var/log/apache2/error.log
LogLevel warn
CustomLog /var/log/apache2/access.log combined
Alias /doc/ "/usr/share/doc/"
<Directory "/usr/share/doc/">
Options Indexes MultiViews FollowSymLinks
AllowOverride None
Order deny,allow
Deny from all
Allow from 127.0.0.0/255.0.0.0 ::1/128
</Directory>
</VirtualHost>
what about phpMyAdmin configuration?
debianlinux [/etc/phpmyadmin] # ls -la
total 44
drwxr-xr-x 2 root root 4096 2007-06-02 06:54 .
drwxr-xr-x 72 root root 4096 2007-06-03 10:59 ..
-rw-r--r-- 1 root root 654 2007-06-02 06:34 apache.conf
-rw-r--r-- 1 root root 205 2007-06-02 06:35 apache.conf.beta
-rw-r----- 1 root www-data 63 2007-05-29 05:39 blowfish_secret.inc.php
-rw-r--r-- 1 root root 170 2007-05-29 05:39 config.footer.inc.php
-rw-r--r-- 1 root root 170 2007-05-29 05:39 config.header.inc.php
-rw-r--r-- 1 root root 5943 2007-05-29 05:39 config.inc.php
-rw-r--r-- 1 root root 1542 2007-06-02 06:35 htaccess
-rw-r----- 1 root www-data 8 2007-05-29 05:39 htpasswd.setup
here is contents of config.inc.php
<?php
$i = 0;
$i++;
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
?>
all the phpmyadmin files are in /usr/share/phpmyadmin - any config tasks here?