Koozali.org: home of the SME Server

I'm new and need some help

Offline gmschmitz

  • *
  • 19
  • +0/-0
I'm new and need some help
« on: November 12, 2008, 12:12:12 AM »
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.

Offline versa

  • ****
  • 109
  • +0/-0
Re: I'm new and need some help
« Reply #1 on: November 12, 2008, 12:35:43 AM »
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
......

Offline gmschmitz

  • *
  • 19
  • +0/-0
Re: I'm new and need some help
« Reply #2 on: November 12, 2008, 04:26:16 AM »
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?

Offline tspoon1986

  • **
  • 33
  • +0/-0
Re: I'm new and need some help
« Reply #3 on: November 12, 2008, 05:43:54 AM »
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.

Offline gmschmitz

  • *
  • 19
  • +0/-0
Re: I'm new and need some help
« Reply #4 on: November 12, 2008, 05:52:17 AM »
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 :)

Offline versa

  • ****
  • 109
  • +0/-0
Re: I'm new and need some help
« Reply #5 on: November 12, 2008, 09:22:11 AM »
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
......

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: I'm new and need some help
« Reply #6 on: November 12, 2008, 02:27:31 PM »
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?
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline gmschmitz

  • *
  • 19
  • +0/-0
Re: I'm new and need some help
« Reply #7 on: November 13, 2008, 02:37:54 AM »
Thanks Versa, I'll give it a shot.

Offline tspoon1986

  • **
  • 33
  • +0/-0
Re: I'm new and need some help
« Reply #8 on: November 13, 2008, 05:11:34 AM »
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?

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: I'm new and need some help
« Reply #9 on: November 13, 2008, 09:05:25 AM »
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.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: I'm new and need some help
« Reply #10 on: November 13, 2008, 09:07:27 AM »
AFAIK the admin password (for PHPMyAdmin) is either a default value
As described here a default value: http://wiki.contribs.org/PHPMyAdmin#Additional_information
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline gmschmitz

  • *
  • 19
  • +0/-0
Re: I'm new and need some help
« Reply #11 on: November 26, 2008, 10:10:45 PM »
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?
« Last Edit: November 26, 2008, 10:42:07 PM by gmschmitz »

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: I'm new and need some help
« Reply #12 on: November 26, 2008, 10:58:24 PM »
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
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline gmschmitz

  • *
  • 19
  • +0/-0
Re: I'm new and need some help
« Reply #13 on: November 26, 2008, 11:35:02 PM »
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.

Offline tspoon1986

  • **
  • 33
  • +0/-0
Re: I'm new and need some help
« Reply #14 on: November 27, 2008, 03:42:59 AM »
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.