Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: eManX01 on February 09, 2005, 06:21:20 AM

Title: MySQL
Post by: eManX01 on February 09, 2005, 06:21:20 AM

I am trying to set up a small online store using zencart. Zencart asks me for SME Server's database username and password. What do I need to do to change the database username and password? I would also like to know how to update PHP and MySQL. Thanks.

Title: CD-RW
Post by: eManX01 on February 09, 2005, 02:56:45 PM

I would also like to know if the CD-RW on my server can be used by the PCs on my network and if so how?

Title: MySQL
Post by: syx on February 10, 2005, 06:23:12 AM

for the phpmyadmin question, go here  
http://no.longer.valid/phpwiki/index.php/phpMyAdmin

download and install that, restart your server and then go to yourserver.com/phpmyadmin

to setup your database stuff.

I dont know to update mysql and php. Are you sure you need to ?

Theres a contrib on here somewhere that allows you to share that cd drive. have a search and you'll find it.

 :-D

Title: username and password
Post by: eManX01 on February 11, 2005, 01:56:39 AM

I really appreciate you actually responding, but phpMyAdmin says it can't access MMySQL because it doesn't know the MySQL username and password. Where can I find the username and pasword and how can i create and/or change the username and password. I am running Windows XP Home. I don't know how to access SME server through Windows Command Promt either.

Title: MySQL
Post by: syx on February 11, 2005, 02:06:00 AM

so you have installed the phpmyadmin rpm on your sme server ?

If you have its just a matter of pointing your browser to yourdomain/phpmyadmin

From there you can set up the usernames and passwords.

The default user name is admin adn the password is whatever you specified during the install.


As far as accessing your sme server from another machine running windows you have to connect using ssh. You can do this with 'putty' which is a free program (google is your friend). There are instructions on how to configure putty on this site somewhere.

There are also instructions on how to create a new samba share so that you can access certain parts of your server from your windows boxen using windows explorer.

Hope this helps

Title: MySQL
Post by: eManX01 on February 11, 2005, 02:14:29 AM

How do i install the rpm. I've been downloading the zip file and extracting it into the html folder.

Title: MySQL
Post by: syx on February 11, 2005, 02:26:12 AM

its easier to work on the SME server.
Once your downloaded the rpm file and put it on the server, it doesnt really matter where, you need to use the rpm commadn to install that rpm.
rpm is equivilent to setup.exe for windows users.

using the mc command navigate to the folder that contains the rpm on your sme server. typically /home/e-smith/ibays/someibay/somedirectory/

then type
rpm -ivh *.rpm

this will install and .rpm files in that directory (you will most likely only have one)

then you restart the server (im not sure this is nessesary) and everything is hunkydory

Title: MySQL
Post by: eManX01 on February 11, 2005, 02:30:51 AM

how do i get to the command prompt on SME server?

Title: MySQL
Post by: syx on February 11, 2005, 02:38:53 AM

push alt+f2 to go to a second terminal, then if your then at the screen with all the blue on it you need to select the logout option. If not then you can log in as root and the admin password and then you should get a normal prompt.

hope that helps some more :)

Title: MySQL
Post by: eManX01 on February 11, 2005, 03:01:25 AM

thanks a bunch so far. I got into the command prompt, but when i type in where the rpm is, SME says that it cannot be found. i typed in "cd /home/e-smith/files/users/eman/". I then type "rpm -ivh *.rpm"

Title: MySQL
Post by: syx on February 11, 2005, 03:04:18 AM

type in mc at the command prompt, this will start the midnight commander, use this navigate to the corrent directory.

Title: MySQL
Post by: eManX01 on February 11, 2005, 03:09:40 AM

how do i get out of mc?

Title: MySQL
Post by: syx on February 11, 2005, 03:16:45 AM

press f10

Title: MySQL
Post by: eManX01 on February 11, 2005, 03:21:00 AM

now how do i get to phpmyadmin through a web browser? I tried www.mydomain.com/phpmyadmin and it gave me "403 Forbidden, You don't have permission to access /phpmyadmin on this server." What do I do. It didn't even ask me for the username and password

Title: MySQL
Post by: nmtrier on February 12, 2005, 01:45:21 PM

Did you try https://www.mydomain.com/phpmyadmin ?
                ^
                |

Title: MySQL
Post by: eManX01 on February 12, 2005, 04:20:31 PM

yes. It says that it's forbidden every time.

Title: MySQL
Post by: arthurhanlon on September 13, 2005, 11:52:57 PM

eMan,

Try the server IP address instead and note the https protocol instead of the standard http (sorry if you already have  ;-) )

I was having issues with Zencart install too, just wasn't doing anything, froze up at installation. Let us know if you are successful.

Arthur