phpMyAdmin installation

Questions about hosting a Website, using MySQL and PhP may be posted here.

Moderators: Synology Inc, Honorary Moderator

phpMyAdmin installation

Postby makinok » Wed Apr 18, 2007 4:12 pm

I use DS-106e with 4.28 firmware.

I have installed phpmyadmin 2.10.0.2 following the instructions in http://www.synology.com/enu/support/hel ... p?q_id=289.

When I access http://ds106e/phpMyAdmin/, the message appears:
Wrong permissions on configuration file, should not be world writable!

Where should I change to solve this?

I extracted phpmyadmin in WinXP.
Should I first activate telnet access and extract it in DS-106e?
Or should I use 2.7 used in the above web page?

makinok
makinok
Trainee
Trainee
 
Posts: 13
Joined: Fri Mar 09, 2007 8:34 pm

2.7 is OK

Postby makinok » Wed Apr 18, 2007 4:32 pm

Phpmyadmin 2.7 works correctly.

It may seem that newer versions requires
a telnet access to DS-106e.

Katsunori Makino
makinok
Trainee
Trainee
 
Posts: 13
Joined: Fri Mar 09, 2007 8:34 pm

Postby HarryPotter » Wed Apr 18, 2007 4:43 pm

It may seem that newer versions requires
a telnet access to DS-106e.

No, not at all
You can change the permissions of the config file with an ftp client
**Please do not Private Message me for support questions; leave it on the forum so all members can learn. Thanks!**

DS408 / DSM Beta 3.0 1285 / 4 x Seagate ST31000340AS RAID 0 / SSODS 4.9.1 / SqueezeboxServer 7.5.1 / 2 x Squeezebox 3 + Boom / Rapsody N35
DS109+ / DSM Beta 3.0 1285 / Samsung HD154UI
DS207+ / DSM Beta 3.0 1285 / 2 x Hitachi HDS721010KLA330 RAID 0
DS-106x / DSM Beta 3.0 1285 (from DS107) / WDC WD5000KS-00MNB0

FRITZ!Box Fon WLAN 7570 VDSL
APC Smart UPS 750
User avatar
HarryPotter
Honorary Moderator
Honorary Moderator
 
Posts: 6128
Joined: Mon Oct 23, 2006 12:48 pm
Location: Switzerland

Thanx

Postby makinok » Wed Apr 18, 2007 5:41 pm

Because I disable a ftp server of DS-106e,
I have no idea to use a ftp client to change
permissions of files.

I will try to use 2.10.2.

makinok
makinok
Trainee
Trainee
 
Posts: 13
Joined: Fri Mar 09, 2007 8:34 pm

Postby HarryPotter » Wed Apr 18, 2007 5:54 pm

Of course you have to enable ftp service (after the changes you can disable it again)
Then you connect with your DS using a ftp client like FlashFXP or WS_FTP or whatever.
Then you click with the right button on the confic file (config.inc.php) and chose "Attributs(chmod)" (FlashFXP) or similar (dont know the menu in english version) in WS_FTP and change the permissions to 755 or 555.

Thats it.
**Please do not Private Message me for support questions; leave it on the forum so all members can learn. Thanks!**

DS408 / DSM Beta 3.0 1285 / 4 x Seagate ST31000340AS RAID 0 / SSODS 4.9.1 / SqueezeboxServer 7.5.1 / 2 x Squeezebox 3 + Boom / Rapsody N35
DS109+ / DSM Beta 3.0 1285 / Samsung HD154UI
DS207+ / DSM Beta 3.0 1285 / 2 x Hitachi HDS721010KLA330 RAID 0
DS-106x / DSM Beta 3.0 1285 (from DS107) / WDC WD5000KS-00MNB0

FRITZ!Box Fon WLAN 7570 VDSL
APC Smart UPS 750
User avatar
HarryPotter
Honorary Moderator
Honorary Moderator
 
Posts: 6128
Joined: Mon Oct 23, 2006 12:48 pm
Location: Switzerland

Re: phpMyAdmin installation

Postby synouser » Sat Jan 10, 2009 5:08 pm

@HarryPotter

I also have the problem with "Wrong permissions on configuration file, should not be world writable!"

I went into the folder with ftp.

The permission looks like the screenshot shows here :

http://picpaste.com/permission.jpg

Remark that the owner is admin!
DS101J 160GB hardisk Firmware Version:DSM 2.0-0729
synouser
Novice
Novice
 
Posts: 56
Joined: Wed Mar 07, 2007 2:07 pm

Re: phpMyAdmin installation

Postby HarryPotter » Sat Jan 10, 2009 5:18 pm

you must change permissions for "others", they should not be allowed to write this file.
**Please do not Private Message me for support questions; leave it on the forum so all members can learn. Thanks!**

DS408 / DSM Beta 3.0 1285 / 4 x Seagate ST31000340AS RAID 0 / SSODS 4.9.1 / SqueezeboxServer 7.5.1 / 2 x Squeezebox 3 + Boom / Rapsody N35
DS109+ / DSM Beta 3.0 1285 / Samsung HD154UI
DS207+ / DSM Beta 3.0 1285 / 2 x Hitachi HDS721010KLA330 RAID 0
DS-106x / DSM Beta 3.0 1285 (from DS107) / WDC WD5000KS-00MNB0

FRITZ!Box Fon WLAN 7570 VDSL
APC Smart UPS 750
User avatar
HarryPotter
Honorary Moderator
Honorary Moderator
 
Posts: 6128
Joined: Mon Oct 23, 2006 12:48 pm
Location: Switzerland

Re: phpMyAdmin installation

Postby synouser » Sat Jan 10, 2009 6:48 pm

Thanks for your reply.

How do I change the owner ?:

http://picpaste.com/upload.php

Can I do that in the ftp program ?
DS101J 160GB hardisk Firmware Version:DSM 2.0-0729
synouser
Novice
Novice
 
Posts: 56
Joined: Wed Mar 07, 2007 2:07 pm

Re: phpMyAdmin installation

Postby synouser » Sat Jan 10, 2009 6:50 pm

DS101J 160GB hardisk Firmware Version:DSM 2.0-0729
synouser
Novice
Novice
 
Posts: 56
Joined: Wed Mar 07, 2007 2:07 pm

Re: phpMyAdmin installation

Postby HarryPotter » Sat Jan 10, 2009 7:22 pm

The owner can be changed via telnet/ssh (chown ....)

But why do you want to change the owner?
**Please do not Private Message me for support questions; leave it on the forum so all members can learn. Thanks!**

DS408 / DSM Beta 3.0 1285 / 4 x Seagate ST31000340AS RAID 0 / SSODS 4.9.1 / SqueezeboxServer 7.5.1 / 2 x Squeezebox 3 + Boom / Rapsody N35
DS109+ / DSM Beta 3.0 1285 / Samsung HD154UI
DS207+ / DSM Beta 3.0 1285 / 2 x Hitachi HDS721010KLA330 RAID 0
DS-106x / DSM Beta 3.0 1285 (from DS107) / WDC WD5000KS-00MNB0

FRITZ!Box Fon WLAN 7570 VDSL
APC Smart UPS 750
User avatar
HarryPotter
Honorary Moderator
Honorary Moderator
 
Posts: 6128
Joined: Mon Oct 23, 2006 12:48 pm
Location: Switzerland

Re: phpMyAdmin installation

Postby synouser » Sat Jan 10, 2009 7:43 pm

@HarryPotter.

You are rigt, and it didn't help anything. I ran the:

chown -R root:users .*


But to no luck.

The config.inc.php file looks like this:

<?php^M
^M
$i=0;^M
$i++;^M
$cfg['Servers'][$i]['user'] = 'root';^M
$cfg['Servers'][$i]['password'] = 'shamrock'; // use here your password^M
?>^M

But I cannot log in.

I changed the permissions back to admin:users again.

But now I cannot login
DS101J 160GB hardisk Firmware Version:DSM 2.0-0729
synouser
Novice
Novice
 
Posts: 56
Joined: Wed Mar 07, 2007 2:07 pm

Re: phpMyAdmin installation

Postby synouser » Sat Jan 10, 2009 7:47 pm

After I gave up logging in, I got this message, but I really use the userid and pass correct:

Code: Select all
Wrong username/password. Access denied.
DS101J 160GB hardisk Firmware Version:DSM 2.0-0729
synouser
Novice
Novice
 
Posts: 56
Joined: Wed Mar 07, 2007 2:07 pm

Re: phpMyAdmin installation

Postby HarryPotter » Sat Jan 10, 2009 8:38 pm

your config file is wrong


- its is missing the host parameter (host is "localhost")
- the password for mysql user "root" is empty (its not the "root" of your DS) for the initial MySQL DB (I assume you didnt use it before.)

Within the folder phpmyadmin you find a folder "libraries" There is a confic.default.php that you can use (rename and copy it) or use the confic.sample.inc.php
**Please do not Private Message me for support questions; leave it on the forum so all members can learn. Thanks!**

DS408 / DSM Beta 3.0 1285 / 4 x Seagate ST31000340AS RAID 0 / SSODS 4.9.1 / SqueezeboxServer 7.5.1 / 2 x Squeezebox 3 + Boom / Rapsody N35
DS109+ / DSM Beta 3.0 1285 / Samsung HD154UI
DS207+ / DSM Beta 3.0 1285 / 2 x Hitachi HDS721010KLA330 RAID 0
DS-106x / DSM Beta 3.0 1285 (from DS107) / WDC WD5000KS-00MNB0

FRITZ!Box Fon WLAN 7570 VDSL
APC Smart UPS 750
User avatar
HarryPotter
Honorary Moderator
Honorary Moderator
 
Posts: 6128
Joined: Mon Oct 23, 2006 12:48 pm
Location: Switzerland

Re: phpMyAdmin installation

Postby synouser » Sat Jan 10, 2009 9:06 pm

Ok, but this has worked before, but maybe I'm using a too old phpmyadmin ?.

Is it this file in the "libraries" you mean ?

http://picpaste.com/10-01-2009_20-55-10_1.jpg

Or is it this one:

From config.default.php

Code: Select all
<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* phpMyAdmin sample configuration, you can use it as base for
* manual configuration. For easier setup you can use scripts/setup.php
*
* All directives are explained in Documentation.html and on phpMyAdmin
* wiki <http://wiki.cihar.com>.
*
* @version $Id: config.sample.inc.php 10142 2007-03-20 10:32:13Z cybot_tm $
*/

/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

/*
* Servers configuration
*/
$i = 0;

/*
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'http';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';config.default.php
/* User for advanced features */
// $cfg['Servers'][$i]['controluser'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';
/* Advanced phpMyAdmin features */
// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
// $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]['designer_coords'] = 'pma_designer_coords';

/*
* End of servers configuration
*/

/*
* Directories for saving/loading files from server


Could I ask you to help me make the right file for me, and PM it to me ?
DS101J 160GB hardisk Firmware Version:DSM 2.0-0729
synouser
Novice
Novice
 
Posts: 56
Joined: Wed Mar 07, 2007 2:07 pm

Re: phpMyAdmin installation

Postby HarryPotter » Sat Jan 10, 2009 9:23 pm

You still did not tell us if this is an initial setup of your mysql or if you already changed root password.
hovewever, this is enough for your confic.inc.php (version 2.x, phpmyadmin version 3.x need additional parameter(s)):
Code: Select all
<?php
$cfg['blowfish_secret'] = '';
$i = 0;
$i++;
$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>


then enter "root" without a password for initial use of mysql or "root " with a password if already set earlier.

you may reset the mysql root password using the webUI.
**Please do not Private Message me for support questions; leave it on the forum so all members can learn. Thanks!**

DS408 / DSM Beta 3.0 1285 / 4 x Seagate ST31000340AS RAID 0 / SSODS 4.9.1 / SqueezeboxServer 7.5.1 / 2 x Squeezebox 3 + Boom / Rapsody N35
DS109+ / DSM Beta 3.0 1285 / Samsung HD154UI
DS207+ / DSM Beta 3.0 1285 / 2 x Hitachi HDS721010KLA330 RAID 0
DS-106x / DSM Beta 3.0 1285 (from DS107) / WDC WD5000KS-00MNB0

FRITZ!Box Fon WLAN 7570 VDSL
APC Smart UPS 750
User avatar
HarryPotter
Honorary Moderator
Honorary Moderator
 
Posts: 6128
Joined: Mon Oct 23, 2006 12:48 pm
Location: Switzerland

Next

Return to Web Server + PHP / MySQL

Who is online

Users browsing this forum: No registered users and 0 guests