Topic: I'm new and need some help

[gmschmitz]

I am trying to update a website for a company that is running sme server. The problem is the guy who set up the server is no longer with the company. I can log in to the server manager, but I can see anywhere to upload new files for a new website. Can someone point me in the right direction.

I've been reading about the i-bays but I'm not sure how to access them. Any help would be great.

[versa]

Assuming its in the default primary ibay the path is:

Code: [Select]

/home/e-smith/files/ibays/Primary/html
I usually use http://winscp.net/eng/index.php to upload things to the server

I you are using another ftp client log in with "admin" and "adminpassword" and go to

Code: [Select]

/ibays/Primary/html

[gmschmitz]

Versa,
  Thanks I was able to ftp into the i-bays and find the files. I was trying to ftp in earlier and just kept getting a blank screen. I used the program that you suggested and it worked. I really appreciate the help.

I was thinking about putting a wordpress site on there and I was wondering about do the database for the site. Is there PHPmyadmin on the server already?

[tspoon1986]

See http://wiki.contribs.org/PHPMyAdmin. This page shows you how to check if phpmyadmin is installed on your system already (or you could just try to access http://www.yourserver.com/phpmyadmin).

I think the wiki page is a bit outdated though. If you need to install it, you can run:

Code: [Select]

yum install smeserver-phpmyadmin
I also needed to start the mysql program and issue:

Code: [Select]

GRANT ALL PRIVILEGES on *.* to admin@localhost identified by ‘password’ with GRANT OPTION;
in order to enable php to access the DB.

[gmschmitz]

Thanks for the reply. I guess my problem is I don't really know what shell is. I tried the server.com/phpmyadmin and nothing so it must not be installed. Ther server is hooked up to the network without a monitor and mouse and I'm not sure how the guy that use to manage it accessed it.

I tried to load WordPress on an i-bay and use a database on a hosted server that I have but for some reason it wouldn't see that database.

With the sme server is the only way to do things through shell commands? I guess I have a lot of reading to do

[versa]

Yes there is a learning curve and the manual is a must.

To get to the command console use putty http://www.chiark.greenend.org.uk/~sgtatham/putty/

Log in as root and the same password you are using for the admin login

[cactus]

Code: [Select]

GRANT ALL PRIVILEGES on *.* to admin@localhost identified by ‘password’ with GRANT OPTION;
in order to enable php to access the DB.

AFAIK this is not needed. Why did you do so?

[gmschmitz]

Thanks Versa, I'll give it a shot.

[tspoon1986]

AFAIK this is not needed. Why did you do so?

You might be right, I can't actually remember why I needed that, it was just in my notes. But I think it had something to do with the fact that the root password is a random 72 character string, as explained by yourself here: http://forums.contribs.org/index.php/topic,40969.msg190421.html#msg190421

Would this mean that it is necessary to create a new mysql user admin in order to access the database, or know the 72 character password to log in as root?

[cactus]

You might be right, I can't actually remember why I needed that, it was just in my notes. But I think it had something to do with the fact that the root password is a random 72 character string, as explained by yourself here: http://forums.contribs.org/index.php/topic,40969.msg190421.html#msg190421

Would this mean that it is necessary to create a new mysql user admin in order to access the database, or know the 72 character password to log in as root?

AFAIK the admin password (for PHPMyAdmin) is either a default value, you should change immediately, but more likely it is set to be your admin password you use to login to the server-manager. If that is not the case I suggest you launch a bug report instead of fiddling on your own. If it really is broken it should be fixed, by messing around yourself and not reporting back (in the bugtracker) other users will suffer the same problem.

[cactus]

AFAIK the admin password (for PHPMyAdmin) is either a default value

As described here a default value: http://wiki.contribs.org/PHPMyAdmin#Additional_information

[gmschmitz]

Can someone help me with how to use putty to get a command prompt. So I can load phpmyadmin.
I guess I really am trying to get the command line. Then I think I just need to type in yum localinstall /path/to/smeserver-phpmyadmin*.rpm, but maybe I am wrong. Do I need to download a file somewhere before I run that command and if so where do I put that file?

[cactus]

Can someone help me with how to use putty to get a command prompt. So I can load phpmyadmin.
I guess I really am trying to get the command line. Then I think I just need to type in yum localinstall /path/to/smeserver-phpmyadmin*.rpm, but maybe I am wrong. Do I need to download a file somewhere before I run that command and if so where do I put that file?

Download putty, open it. Type in the IP number of your server, username (root), password (the one you set during installation) and then:
download all required packages using the url using something like this:

Code: [Select]

wget http://url/to/package1 http://url/to/package2After succesfull download do:

Code: [Select]

yum localinstall *.rpm
I suggest you read up a little bit on linux command line, there is a lot to be found using google, but this is a good start: http://www.redhat.com/docs/manuals/linux/RHL-7.3-Manual/getting-started-guide/ch-basics.html

[gmschmitz]

Well my admin password that I have does not work for root access and the person who set up this server is no longer with the company. Is there a way to host a website on the server, but use a database from another hosting company. I tried it and it could not access the other database.

[tspoon1986]

If you have a password that can get in to the server-manager, it should be the same password that lets you in to the command prompt. Check to see if you're allowed to log in remotely by going to the server-manager (http://yourserver/server-manager/) and going to Remote Access. Check the settings under Secure Shell Settings. You'll need to allow at least access from local networks, and public access if you're not behind the SME firewall. Also make sure that allow administrative command line access over secure shell is set to yes, and depending on the password you may need to set allow secure shell access using standard passwords to yes.

[gmschmitz]

tspoon,
  Thanks I was able to get to the command line now, I must have typed in something wrong earlier. I ran the command to see what is installed on the server and I see phpmyadmin. I'm not sure what the exact path is to run the yum localinstall /path/to/smeserver-phpmyadmin*.rpm. I tried to ftp in and find it but I don't see anything. Do you know what the path would be?

[tspoon1986]

You'd have to download the rpm first to do a local install. Try the following command instead:

I think the wiki page is a bit outdated though. If you need to install it, you can run:

Code: [Select]

yum install smeserver-phpmyadmin

[gmschmitz]

That didn't work either, I get this message:

Parsing package install arguments
No Match for argument: smeserver-phpmyadmin
Nothing to do

[Stefano]

That didn't work either, I get this message:

Parsing package install arguments
No Match for argument: smeserver-phpmyadmin
Nothing to do

hi

the right syntax is

Code: [Select]

yum --enablerepo=smecontribs install smeserver-phpmyadmin

HTH
ciao

Stefano

[gmschmitz]

Thanks that seemed to work. It said I should run this below:
signal-event post-upgrade; signal-event reboot

Should I or do I have to? Does this mean the server will reboot? Does it turn off and power back on by itself. I am not where the server is and I can't afford for it to not come back on line.

[Stefano]

I think that it's not necessary..

Ciao
Stefano

[gmschmitz]

Thanks nenonano,
 Now I guess my question is how to I access the PHPMyadmin. I tried to go to domainname.com/phpmyadmin and domainname.com/myadmin and got 404error pages. Thanks for all your help and Happy Thanksgiving !!

[Stefano]

Hi

AFAIK you have to use https.. so htpps://yourserver/myadmin should work

Ciao

Stefano

[e[nt]e]

AFAIK you have to use https.. so htpps://yourserver/myadmin should work

https://yourserver/phpmyadmin

[gmschmitz]

hmmm that didn't work either

[Frank VB]

If you install the phpmyadmin contrib you'll probably have to expand the template config.inc.php. I had this issue a couple of weeks ago and issueing this command at the command line solved the problem:

Code: [Select]

expand-template /opt/phpmyadmin/config.inc.phpand then

Code: [Select]

service httpd-e-smith restart
Use https://servername.domainname.toplevel/phpmyadmin for accessing phpmyadmin.

[gmschmitz]

I tried that and got:

Code: [Select]

expand-template /opt/phpmyadmin/config.inc.php
ERROR: Cannot create output file //opt/phpmyadmin/config.inc.php.28576 No such file or directory
 at /sbin/e-smith/expand-template line 45
I looked at it and thought maybe to delete one of th/ in front of opt, but still got this:

Code: [Select]


[root@mml ~]# expand-template opt/phpmyadmin/config.inc.php
ERROR: Cannot create output file /opt/phpmyadmin/config.inc.php.28580 No such file or directory
 at /sbin/e-smith/expand-template line 45

My IP is set up in the server so I can remote in but the phpmyadmin is set to private right now. Should I be able to get in remotely if I can with everything else or do I need to set it to public?

I see that I can use the command
db configuration setprop phpmyadmin access (private|public)
signal-event ibay-modify

I'm assuming I need to put:
db configuration setprop phpmyadmin access public
signal-event ibay-modify

Is that correct or do I need to change any more of that?

[Frank VB]

Code: [Select]


[root@mml ~]# expand-template opt/phpmyadmin/config.inc.php
ERROR: Cannot create output file /opt/phpmyadmin/config.inc.php.28580 No such file or directory
 at /sbin/e-smith/expand-template line 45


Could you verify (with Midnight Commander) if this file config.inc.php and directory (opt/phpmyadmin) exist at all. Just type:

Code: [Select]

mcat the command line and browse through your directory structure. They should be there.

[gmschmitz]

I do not see either one.

[Frank VB]

If you're in MC type:

Code: [Select]

cd /optWhat directories do you see in the /opt directory? If you see a phpmyadmin directory then type:

Code: [Select]

cd phpmyadminWhat files and directories do you see there? Do you see the config.inc.php file listed?

[gmschmitz]

/opt looks empty

[Frank VB]

Well, are you 100% sure that the installation of the phpmyadmin contrib was succesful? First quit MC (press function key F10, confirm with Y). Then issue this command at the command line:

Code: [Select]

yum list installed smeserver-phpmyadminThe output should be something like this:

Code: [Select]

Installed Packages
smeserver-phpmyadmin.noarch              2.11.1.2-0.dmay        installed


[gmschmitz]

Code: [Select]

Installed Packages
smeserver-phpmyadmin.noarch              2.11.1.2-3.el4.sme     installed
Thanks for all your help on this !!

[Frank VB]

That seems OK then. You have a newer version that I haven't installed yet. So I don't know for sure if there should be an opt/phpmyadmin directory (and a config.inc.php file) in your version ... Maybe someone else on the forum can confirm this.

[gmschmitz]

Any help on how to see if PHPMyadmin is installed correctly. It shows installed but I can't access it. through https://domainname.com/phpmyadmin

[David Harper]

Do you get an error message? Are you trying to access the URL remotely or from the local network? What happens when you try to log in using the username admin and the password admin?

[tspoon1986]

It doesn't look like it's installed correctly. I have the version installed that you have, and in my /opt folder I have phpmyadmin/config.inc.php. Sorry I'm not really sure where you should go from here, hopefully this info will help someone else help you!

[gmschmitz]

I am trying remotely, I get a 404 error page.

[gmschmitz]

I was able to install Phpmyadminmulti  and it seems to be working correctly
Thanks for the help to all !!

[Frank VB]

FYI, today I updated a test server with smeserver-phpmyadmin 2.11.1.2-1.el4 to smeserver-phpmyadmin 2.11.1.2-3.el4. After issueing the signal-event post-upgrade and reboot commands I could access the admin page (from the local network). In the newer version the /opt/phpmyadmin directory is no longer used, the files are installed in the /usr/share/phpmyadmin directory instead.