Topic: phpmyadmin

[bins]

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! 

[cactus]

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

[bins]

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

[raem]

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.

[bins]

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

[raem]

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

[cactus]

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

[bins]

yup, tried those!

[raem]

bins

So what is your progress now ?

[bins]

still doesnt work!!!

I will try again, this afternoon and report back!

[raem]

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

[william_syd]

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

[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

[bins]

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?

[cactus]

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...

[william_syd]

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.

[bins]

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!

[william_syd]

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

[Franco]

Do you have the sail contrib installed? If so be sure to disable the proxy in the General panel.