Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: bins on January 25, 2008, 02:55:13 AM

Title: phpmyadmin
Post by: bins on January 25, 2008, 02:55:13 AM
I have tried installing both of the options and in both cases, at first they jsut wouldnt work - the pages error'ed.  I uninstalled/reinstalled and managed to get to a login screen (without a template, just white), where I entered credentials and the went to an error page!

Am I missing something obvious?

I am using 7.2

Any pointers appreciated! 
Title: Re: phpmyadmin
Post by: cactus on January 25, 2008, 10:52:02 AM
I have tried installing both of the options
What options?
and in both cases, at first they jsut wouldnt work - the pages error'ed.
If you want us to help you need to be more specific, what steps did you take, in what order, what were the results and what was the precise error?
I uninstalled/reinstalled and managed to get to a login screen (without a template, just white), where I entered credentials and the went to an error page!
Again, more details what username, what error?
Any pointers appreciated! 
More and clearer information :-)
Title: Re: phpmyadmin
Post by: bins on January 25, 2008, 11:13:41 AM
I have tried installing both of the options
What options?
phpmyadmin
phpmyadminmulti



and in both cases, at first they jsut wouldnt work - the pages error'ed.
If you want us to help you need to be more specific, what steps did you take, in what order, what were the results and what was the precise error?
I took the steps as described in the contrib wiki page, in the order described and got:
phpmyadmin - it asked for credentials, enter (admin/admin or admin/pw tried)and got a split page (left column/main body) with 'cant display page'.  Page headers show phpmyadmin 2.11.1.2
multi - get to plain login page, enter credentials and then goto error page.



Quote from: bins on Yesterday at 06:55:13 PM
I uninstalled/reinstalled and managed to get to a login screen (without a template, just white), where I entered credentials and the went to an error page!

Again, more details what username, what error?
installed as root, access attemoted as admin.  error as above!


Does that clarify things??

Bins
Title: Re: phpmyadmin
Post by: raem on January 25, 2008, 11:56:32 AM
bins

I just installed smeserver-phpmyadmin
and it works OK.

Try a different browser

Have a look in your log files to see if there are any error messages eg in the various http log files & in the messages log file.
Title: Re: phpmyadmin
Post by: bins on January 26, 2008, 05:11:31 AM
I am no Linux expert, but this is what I am doing with the same package:

wget http://mirror.pacific.net.au/linux/smeserver/contribs/dmay/smeserver/7.x/smeserver-phpmyadmin-

this is downloading the file.
Then:

yum localinstall smeserver-phpmyadmin.rpm
or
yum localinstall smeserver-phpmyadmin-2.11.1.2-0.dmay.noarch.rpm

it is saying it cant fine the file.  I have put it into a folder like /home/httpd/html/ and it cant fine it either!

aargghh

Title: Re: phpmyadmin
Post by: raem on January 26, 2008, 05:18:31 AM
bins

If you have changed (cd /...) to the folder the file is in, ie
cd /home/httpd/html
then that should be:
yum localinstall smeserver-phpmyadmin*.rpm

or you can specify the actual file location
yum localinstall /home/httpd/html/smeserver-phpmyadmin-2.11.1.2-0.dmay.noarch.rpm
Title: Re: phpmyadmin
Post by: cactus on January 26, 2008, 10:42:59 AM
Code: [Select]
[code][quote author=bins link=topic=39843.msg183151#msg183151 date=1201320691]
I am no Linux expert, but this is what I am doing with the same package:

wget http://mirror.pacific.net.au/linux/smeserver/contribs/dmay/smeserver/7.x/smeserver-phpmyadmin-

this is downloading the file.
[/quote]You should install using:
yum localinstall /path/to/rpm[/code] which will probably be the directory you ran the wget command from, so probably
Code: [Select]
yum localinstall ./rpm-name should do the trick.

The phpmyadmin-multi is in the smecontribs repository and can be installed like this:
Code: [Select]
yum install phpadmin-multi --enablerepo=smecontribs
Title: Re: phpmyadmin
Post by: bins on January 26, 2008, 11:10:56 AM
yup, tried those!
Title: Re: phpmyadmin
Post by: raem on January 26, 2008, 12:14:52 PM
bins

So what is your progress now ?
Title: Re: phpmyadmin
Post by: bins on January 26, 2008, 01:48:54 PM
still doesnt work!!!

I will try again, this afternoon and report back!
Title: Re: phpmyadmin
Post by: raem on January 27, 2008, 04:31:17 AM
bins

I have installed the app 3 or 4 times in sequence without any problems, except for a missing * in the wiki install instructions

Here are the sure fire steps:

login to your sme server command prompt as root
cd /tmp
wget http://distro.ibiblio.org/pub/linux/distributions/smeserver/contribs/dmay/smeserver/7.x/smeserver-phpmyadmin-2.11.1.2-0.dmay.noarch.rpm

to check the rpm  has successfully downloaded and is actually listed in the /tmp folder do
ls -al

Then to install do
yum localinstall smeserver-phpmyadmin*.rpm

answer y

When the install is finished, (in this case) you do not need to run the signal-event post-upgrade and reboot commands

Then open your web browser to
https://www.yourdomain.com/phpmyadmin

You should be presented with a login screen:
User Name = admin
Password = admin

If that combination does not work, (eg the password has been previously reset to the sme server's real admin password) try
User Name = admin
Password = your actual sme server admin password

Read up about phpmyadmin to know how to use it correctly, and be very careful as you can make changes here that will prevent access to your databases if you do something incorrectly.

Reset your phpmyadmin admin password immediately if it is the default of admin
Title: Re: phpmyadmin
Post by: william_syd on January 27, 2008, 05:56:26 AM


it is saying it cant fine the file.  I have put it into a folder like /home/httpd/html/ and it cant fine it either!

aargghh



For me, a missing rpm gives

Quote
[root@tiger ~]# yum localinstall smeserver-phpmyadmin*.rpm
==============================================================
WARNING: Additional commands may be required after running yum
==============================================================
Loading "fastestmirror" plugin
Loading "smeserver" plugin
Setting up Local Package Process
Cannot open file: smeserver-phpmyadmin*.rpm. Skipping.
Nothing to do
================================================================
No new rpms were installed. No additional commands are required.
================================================================
[root@tiger ~]#

No mention of not finding file.

I don't see why the following command wouldn't work.

[root@tiger ~]# yum install smeserver-phpmyadmin-multiuser --enablerepo=smecontribs
==============================================================
WARNING: Additional commands may be required after running yum
==============================================================
Loading "fastestmirror" plugin
Loading "smeserver" plugin
Setting up Install Process
Setting up repositories
Loading mirror speeds from cached hostfile
Reading repository metadata in from local files
Excluding Packages from CentOS - os
Finished
Excluding Packages from CentOS - updates
Finished
Parsing package install arguments
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package smeserver-phpmyadmin-multiuser.noarch 0:2.11.3-1.el4.sme set to be updated
--> Running transaction check

Dependencies Resolved

=============================================================================
 Package                 Arch       Version          Repository        Size
=============================================================================
Installing:
 smeserver-phpmyadmin-multiuser  noarch     2.11.3-1.el4.sme  smecontribs       6.2 M

Transaction Summary
=============================================================================
Install      1 Package(s)
Update       0 Package(s)
Remove       0 Package(s)
Total download size: 6.2 M
Title: Re: phpmyadmin
Post by: bins on January 27, 2008, 06:14:52 PM
First, i do appreciate your help on this.

I followed instructions as written and thought 'ahhh, maybe it is a * issue!'.  All installed ok.

When I tried to login I got the login popup, then it went to 'cannot dispay the web fage, in 2 frames (left clumn/mainpage).  The header reads phpmyadmin 2.1.11.2, but still nothing!

Will using a remote manager like sqlyog or similar do the job?
Title: Re: phpmyadmin
Post by: cactus on January 27, 2008, 10:58:02 PM
When I tried to login I got the login popup, then it went to 'cannot dispay the web fage, in 2 frames (left clumn/mainpage).  The header reads phpmyadmin 2.1.11.2, but still nothing!
And tehn you should look into your log files at the time the error occured, there should be a clue in the /var/log/httpd/error_log, /var/log/httpd/access_log and perhaps /var/log/messages as well...
 
Will using a remote manager like sqlyog or similar do the job?
Perhaps, depends on what your wishes are...
Title: Re: phpmyadmin
Post by: william_syd on January 27, 2008, 11:40:15 PM
A quick test shows that the two contribs can co-exist.

However, the url's and login methods differ.

If you get a 'pop-up', you are using smeserver-phpmyadmin-2.11.1.2-0.dmay and the url ends with /phpmyadmin

If you get a phpmyadmin login screen, you are using smeserver-phpmyadmin-multiuser-2.11.3-1.el4.sme and the url ends with /myadmin

I would suggest you go back to square one.

First, determine what you have installed.

rpm -qa | grep phpmyadmin

Then remove them. Ensure yum only wants to remove one file at a time. For example -

yum remove smeserver-phpmyadmin-2.11.1.2-0.dmay

yum remove smeserver-phpmyadmin-multiuser-2.11.3-1.el4.sme


Your using 7.2, but I would still check that yum and its support files are up to date.

yum update dbus dbus-glib smeserver-support smeserver-yum yum yum-plugin-fastest-mirror python-sqlite
signal-event post-upgrade; signal-event reboot


Now, pick which contrib you want to use and install it.

dmay version

cd /tmp
wget http://mirror.pacific.net.au/linux/smeserver/contribs/dmay/smeserver/7.x/smeserver-phpmyadmin-2.11.1.2-0.dmay.noarch.rpm
yum localinstall smeserver-phpmyadmin-2.11.1.2-0.dmay.noarch.rpm


URL ends with /phpmyadmin
Username: admin
Password: <password you set when you installed SME>

multi version

yum install smeserver-phpmyadmin-multiuser --enablerepo=smecontribs
db configuration setprop phpmyadminmulti access public
signal-event console-save


URL ends with /myadmin
Username: admin
Password: admin



If all this still fails, consult the log files per Cactus' post.


Title: Re: phpmyadmin
Post by: bins on February 05, 2008, 04:45:40 AM
Still not working, but additional info is if I try to login to phpmyadmin and refresh, I get:

Not Found
The requested URL /phpmyadmin/phpmyadmin/phpmyadmin/phpmyadmin/phpmyadmin/phpmyadmin/phpmyadmin/phpmyadmin/phpmyadmin/phpmyadmin/phpmyadmin/main.php was not found on this server.


As for logs, I am not sure what I am looking for!

Title: Re: phpmyadmin
Post by: william_syd on February 05, 2008, 06:12:40 AM



Right after it fails look at

  tail /var/log/httpd/error_log
  tail /var/log/httpd/access_log
  tail /var/log/messages


and anytime

/sbin/e-smith/audittools/newrpms




Title: Re: phpmyadmin
Post by: Franco on February 05, 2008, 01:42:44 PM
Do you have the sail contrib installed? If so be sure to disable the proxy in the General panel.