The phpMyAdmin configuration storage is not completely configured

xuancong6000

Verified User
Joined
Oct 12, 2012
Messages
79
My server have an error like this:
Code:
$cfg['Servers'][$i]['pmadb'] ...	not OK [ Documentation ]
$cfg['Servers'][$i]['relation'] ...	not OK [ Documentation ]
General relation features: Disabled
 
$cfg['Servers'][$i]['table_info'] ...	not OK [ Documentation ]
Display Features: Disabled
 
$cfg['Servers'][$i]['table_coords'] ...	not OK [ Documentation ]
$cfg['Servers'][$i]['pdf_pages'] ...	not OK [ Documentation ]
Creation of PDFs: Disabled
 
$cfg['Servers'][$i]['column_info'] ...	not OK [ Documentation ]
Displaying Column Comments: Disabled
Browser transformation: Disabled
 
$cfg['Servers'][$i]['bookmarktable'] ...	not OK [ Documentation ]
Bookmarked SQL query: Disabled
 
$cfg['Servers'][$i]['history'] ...	not OK [ Documentation ]
SQL history: Disabled
 
$cfg['Servers'][$i]['designer_coords'] ...	not OK [ Documentation ]
Designer: Disabled
 
$cfg['Servers'][$i]['recent'] ...	not OK [ Documentation ]
Persistent recently used tables: Disabled
 
$cfg['Servers'][$i]['table_uiprefs'] ...	not OK [ Documentation ]
Persistent tables' UI preferences: Disabled
 
$cfg['Servers'][$i]['tracking'] ...	not OK [ Documentation ]
Tracking: Disabled
 
$cfg['Servers'][$i]['userconfig'] ...	not OK [ Documentation ]
User preferences: Disabled
I do this but I can't:
Code:
1. Login to your server over ssh
2. Change dir to PMAs script dir:
# cd /var/www/html/phpMyAdmin-3.5.4-all-languages/scripts
2. Connect to your database using mysql and enter your mysql root pass
# mysql -u root -p
3. Create the user and database and grant privileges:
mysql> create database phpmyadmin;
mysql> create user 'pma'@'localhost' identified by 'YOUR_PASSWORD';
mysql> grant all privileges on phpmyadmin.* to 'pma'@'localhost';
4. Import the SQL file:
mysql> use phpmyadmin;
mysql> \. create_tables.sql;
mysql> exit
5. Open config.inc.php in your favorite editor (i use MCs built in editor or nano):
# nano ../config.inc.php
6. Search for the comment /* User used to manipulate with storage */ and uncomment the two lines after it. Put on the second line the password you have set for your pma user
7. Go to the next section /* Storage database and tables */ and uncomment the next 11 lines
8. Login to your PMA... if you are already logged in then logout and then log back in.
I can't do on step 2:
Code:
[root@server ~]# cd /var/www/html/phpMyAdmin-3.5.4-all-languages/scripts
-bash: cd: /var/www/html/phpMyAdmin-3.5.4-all-languages/scripts: No such file or directory
and step 4:
Code:
mysql> use phpmyadmin;
Database changed
mysql> \. create_tables.sql;
ERROR: 
Failed to open file 'create_tables.sql;', error: 2
could you please help me
 
Last edited:
You should install phpMyAdmin using custombuild, you should not install it manually. Do this to intall phpMyAdmin using custombuild:

Code:
cd /usr/lcoal/directadmin/custombuild
./build update
./build versions
./build phpmyadmin
 
Sorry I can't do that:
Code:
[root@server custombuild]# ./build update
--2012-12-18 17:13:06--  http://files2.directadmin.com/services/custombuild/1.2/custombuild.tar.gz
Resolving files2.directadmin.com... 69.30.193.202
Connecting to files2.directadmin.com|69.30.193.202|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 112038 (109K) [application/x-gzip]
Saving to: `./custombuild.tar.gz'

100%[=====================================>] 112,038     --.-K/s   in 0.1s    

2012-12-18 17:13:06 (846 KB/s) - `./custombuild.tar.gz' saved [112038/112038]

extracting custombuild.tar.gz ...
custombuild/
custombuild/build
custombuild/configure/
custombuild/configure/dovecot/
custombuild/configure/dovecot/dovecot.conf
custombuild/configure/pureftpd/
custombuild/configure/pureftpd/configure.pureftpd
custombuild/configure/suphp/
custombuild/configure/suphp/configure.php6
custombuild/configure/suphp/configure.php5
custombuild/configure/suphp/configure.suphp
custombuild/configure/proftpd/
custombuild/configure/proftpd/configure.proftpd
custombuild/configure/ap1/
custombuild/configure/ap1/configure.apache_ssl
custombuild/configure/ap1/configure.php6
custombuild/configure/ap1/conf/
custombuild/configure/ap1/conf/extra/
custombuild/configure/ap1/conf/extra/httpd-userdir.conf
custombuild/configure/ap1/conf/extra/httpd-vhosts.conf
custombuild/configure/ap1/conf/extra/httpd-languages.conf
custombuild/configure/ap1/conf/extra/httpd-autoindex.conf
custombuild/configure/ap1/conf/extra/httpd-ssl.conf
custombuild/configure/ap1/conf/extra/httpd-default.conf
custombuild/configure/ap1/conf/extra/httpd-alias.conf
custombuild/configure/ap1/conf/extra/httpd-multilang-errordoc.conf
custombuild/configure/ap1/conf/extra/httpd-deflate.conf
custombuild/configure/ap1/conf/extra/httpd-info.conf
custombuild/configure/ap1/conf/extra/directadmin-vhosts.conf
custombuild/configure/ap1/conf/mime.types
custombuild/configure/ap1/conf/magic
custombuild/configure/ap1/conf/httpd.conf
custombuild/configure/ap1/configure.php5
custombuild/configure/ap2/
custombuild/configure/ap2/cert_config
custombuild/configure/ap2/configure.php6
custombuild/configure/ap2/conf/
custombuild/configure/ap2/conf/extra/
custombuild/configure/ap2/conf/extra/httpd-userdir.conf
custombuild/configure/ap2/conf/extra/httpd-vhosts.conf
custombuild/configure/ap2/conf/extra/httpd-languages.conf
custombuild/configure/ap2/conf/extra/httpd-autoindex.conf
custombuild/configure/ap2/conf/extra/httpd-ssl.conf
custombuild/configure/ap2/conf/extra/httpd-default.conf
custombuild/configure/ap2/conf/extra/httpd-alias.conf
custombuild/configure/ap2/conf/extra/httpd-dav.conf
custombuild/configure/ap2/conf/extra/httpd-directories-old.conf
custombuild/configure/ap2/conf/extra/httpd-mpm.conf
custombuild/configure/ap2/conf/extra/httpd-directories-new.conf
custombuild/configure/ap2/conf/extra/httpd-multilang-errordoc.conf
custombuild/configure/ap2/conf/extra/httpd-deflate.conf
custombuild/configure/ap2/conf/extra/httpd-mpm.conf_2.0
custombuild/configure/ap2/conf/extra/httpd-info.conf
custombuild/configure/ap2/conf/extra/directadmin-vhosts.conf
custombuild/configure/ap2/conf/extra/httpd-manual.conf
custombuild/configure/ap2/conf/mime.types
custombuild/configure/ap2/conf/magic
custombuild/configure/ap2/conf/httpd.conf
custombuild/configure/ap2/conf/httpd.conf_2.0
custombuild/configure/ap2/configure.php5
custombuild/configure/ap2/configure.apache
--2012-12-18 17:13:06--  http://files2.directadmin.com/services/custombuild/versions.txt
Resolving files2.directadmin.com... 69.30.193.202
Connecting to files2.directadmin.com|69.30.193.202|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 6202 (6.1K) [text/plain]
Saving to: `./versions.txt'

100%[=====================================>] 6,202       --.-K/s   in 0.03s   

2012-12-18 17:13:06 (239 KB/s) - `./versions.txt' saved [6202/6202]

File already exists:    servers.txt
MD5 Checksum on servers.txt passed.
File already exists:    httpd-2.2.23.tar.gz
MD5 Checksum on httpd-2.2.23.tar.gz passed.
File already exists:    apr-1.4.6.tar.gz
MD5 Checksum on apr-1.4.6.tar.gz passed.
File already exists:    apr-util-1.4.1.tar.gz
MD5 Checksum on apr-util-1.4.1.tar.gz passed.
File already exists:    httpd_2
File already exists:    httpd_2_freebsd
File already exists:    httpd_2_debian
File already exists:    mime.types
File already exists:    mod_perl-2.0.4.tar.gz
MD5 Checksum on mod_perl-2.0.4.tar.gz passed.
File already exists:    curl-7.28.1.tar.gz
MD5 Checksum on curl-7.28.1.tar.gz passed.
File already exists:    pcre-8.20.tar.gz
MD5 Checksum on pcre-8.20.tar.gz passed.
File already exists:    libmcrypt-2.5.8.tar.gz
MD5 Checksum on libmcrypt-2.5.8.tar.gz passed.
File already exists:    mhash-0.9.9.9.tar.gz
MD5 Checksum on mhash-0.9.9.9.tar.gz passed.
File already exists:    freetype-2.4.10.tar.gz
MD5 Checksum on freetype-2.4.10.tar.gz passed.
File already exists:    libiconv-1.14.tar.gz
MD5 Checksum on libiconv-1.14.tar.gz passed.
File already exists:    libxml2-2.7.6.tar.gz
MD5 Checksum on libxml2-2.7.6.tar.gz passed.
File already exists:    libxslt-1.1.28.tar.gz
MD5 Checksum on libxslt-1.1.28.tar.gz passed.
File already exists:    icu4c-4_8_1_1-src.tgz
MD5 Checksum on icu4c-4_8_1_1-src.tgz passed.
File already exists:    php-5.3.19.tar.gz
MD5 Checksum on php-5.3.19.tar.gz passed.
File already exists:    webalizer-2.23-05-src.tgz
MD5 Checksum on webalizer-2.23-05-src.tgz passed.
File already exists:    suphp-0.7.1.tar.gz
MD5 Checksum on suphp-0.7.1.tar.gz passed.
File already exists:    dovecot-2.1.12.tar.gz
MD5 Checksum on dovecot-2.1.12.tar.gz passed.
File already exists:    dovecot.boot
File already exists:    dovecot.boot.freebsd
File already exists:    dovecot.boot.debian
File already exists:    dovecot.conf
File already exists:    exim.conf.dovecot.patch
MD5 Checksum on exim.conf.dovecot.patch passed.
File already exists:    autoconf-2.68.tar.gz
MD5 Checksum on autoconf-2.68.tar.gz passed.
File already exists:    automake-1.11.1.tar.gz
MD5 Checksum on automake-1.11.1.tar.gz passed.
File already exists:    m4-1.4.16.tar.gz
MD5 Checksum on m4-1.4.16.tar.gz passed.
File already exists:    libtool-2.4.tar.gz
MD5 Checksum on libtool-2.4.tar.gz passed.
[root@server custombuild]# ./build versions
Latest version of DirectAdmin: 1.42.1
Installed version of DirectAdmin: 1.42.1

Latest version of Apache: 2.2.23
Installed version of Apache: 2.2.23

Latest version of PCRE: 8.20
Installed version of PCRE: 8.20

Latest version of FreeType: 2.4.10
Installed version of FreeType: 2.4.10

Latest version of dovecot: 2.1.12
Installed version of dovecot: 2.1.12

Latest version of PHP (CLI): 5.3.19
Installed version of PHP (CLI): 5.3.19

Latest version of RoundCube webmail: 0.8.4
Installed version of RoundCube webmail: 0.8.4

Latest version of phpMyAdmin: 3.5.4-all-languages
Installed version of phpMyAdmin: 3.5.4-all-languages

Latest version of SquirrelMail: 1.4.22
Installed version of SquirrelMail: 1.4.22

If you want to update all the available versions run: ./build update_versions
[root@server custombuild]# ./build phpmyadmin
phpMyAdmin 3.5.4-all-languages installation is done.
[root@server custombuild]#
 
Yes I had installed phpmyadmin before but when I login phpmyadmin it had an error:
Code:
$cfg['Servers'][$i]['pmadb'] ...	not OK [ Documentation ]
$cfg['Servers'][$i]['relation'] ...	not OK [ Documentation ]
General relation features: Disabled
 
$cfg['Servers'][$i]['table_info'] ...	not OK [ Documentation ]
Display Features: Disabled
 
$cfg['Servers'][$i]['table_coords'] ...	not OK [ Documentation ]
$cfg['Servers'][$i]['pdf_pages'] ...	not OK [ Documentation ]
Creation of PDFs: Disabled
 
$cfg['Servers'][$i]['column_info'] ...	not OK [ Documentation ]
Displaying Column Comments: Disabled
Browser transformation: Disabled
 
$cfg['Servers'][$i]['bookmarktable'] ...	not OK [ Documentation ]
Bookmarked SQL query: Disabled
 
$cfg['Servers'][$i]['history'] ...	not OK [ Documentation ]
SQL history: Disabled
 
$cfg['Servers'][$i]['designer_coords'] ...	not OK [ Documentation ]
Designer: Disabled
 
$cfg['Servers'][$i]['recent'] ...	not OK [ Documentation ]
Persistent recently used tables: Disabled
 
$cfg['Servers'][$i]['table_uiprefs'] ...	not OK [ Documentation ]
Persistent tables' UI preferences: Disabled
 
$cfg['Servers'][$i]['tracking'] ...	not OK [ Documentation ]
Tracking: Disabled
 
$cfg['Servers'][$i]['userconfig'] ...	not OK [ Documentation ]
User preferences: Disabled
 
I don't see MySQL in your output in post reply #3. So, don't you have MySQL installed? Or have you installed MySQL manually? On a DirectAdmin server, you should not install MySQL manually, you should install MySQL in custombuild. I guess you need to hire a system admin to look at your server.
 
Back
Top