Topic: New Server being setup

[RKB]

Hi,
I am in the process of setting up a web server to Host about 10 websites that I have.

I have been around the block a number of times installing Ubuntu, SuSe, Centos, Fedora but there always seems to be an issue with some part of the installation.

SME appears to hold the key to success, as always being new there are questions and problems to be resolved.

I have SME 7.4 installed and working fine, I think, I am using another computer on the local network.

My first challenge is to gain access to MYSQL using MYSQLADMIN, I have it installed but I can not run it, my root access fails.

My second question is; I have the SME server setup as a server / gateway and I have SpeedStream router 10.0.0.138 for Internet access, I don,t seem to be able to get through the SME server to get to the Router to make adjustments, should I be able to.

I have looked about for info on webhosting on the SME server, have not found much at all

I would be very grateful to be pointed in the right direction on these initial issues.

Cheers

Ron   

[Stefano]

My first challenge is to gain access to MYSQL using MYSQLADMIN, I have it installed but I can not run it, my root access fails.

please read carefully this howto and this one too.. almost everything you need to know abount mysql on SME is there

My second question is; I have the SME server setup as a server / gateway and I have SpeedStream router 10.0.0.138 for Internet access, I don,t seem to be able to get through the SME server to get to the Router to make adjustments, should I be able to.

how did you setup wan and lan? I'm in the same situation, but I have no problem to go to 10.0.0.138 from lan pc..

ciao
Stefano

[m]

My first challenge is to gain access to MYSQL using MYSQLADMIN, I have it installed but I can not run it, my root access fails.

Log into phpmyadmin with user "admin" and the root password

[christian]

I have looked about for info on webhosting on the SME server, have not found much at all

If it is hosting where you control everything then you should be able to find everything you need in http://wiki.contribs.org/SME_Server:Documentation.

If it is hosting for others then it is all still possible without having to dig under the covers but it may not be completely obvious.

iBays may be what you are looking for (in the doc at http://wiki.contribs.org/SME_Server:Documentation:Administration_Manual:Chapter14).

iBays can be used for web sites and file server and maintain proper user/group permissions. You can also access these remotely if your remote user has the permissions you have given them specifically.

Depending on what you are doing, most of what you want you will be able to do from the web admin interface. As a beginner, I would strongly recommend you use the web admin interface by default until you learn and understand the architecture.

If you are asking about mysql then you likely have a good grasp of linux and mysql. In general managing databases here is safe. Per nenonano's comment, the mysql FAQ will tell you how it is used in this system.


Hope that helps get you started.

[cactus]

My first challenge is to gain access to MYSQL using MYSQLADMIN, I have it installed but I can not run it, my root access fails.

This should work out of the box. How are you executing the command and what user are you using?
Normally when logged in as root user you do not need and username or password as this is supplied using some magic. You are sure you did not tamper with the MySQL root user password?

[RKB]

Sincere thanks for all replies, every one of them has been helpful and positive.
I now have access to phpmyadmin, the day has only just begun here so I am still working on the rest.

Is it possible, sensible or stupid to ad a link to phpmyadmin from the server-manager?

[cactus]

Sincere thanks for all replies, every one of them has been helpful and positive.
I now have access to phpmyadmin, the day has only just begun here so I am still working on the rest.

Did you have to do anything to fix you issues or was it just a matter of reading up? For future reference to other users.

Is it possible, sensible or stupid to ad a link to phpmyadmin from the server-manager?

It might be possible, but please request new feature requests against this contrib in the server-manager so they do not get lost in the forums. Not sure if it is sensible as you can just as well type in https://server/phpmyadmin as you can https://server/server-manager of course.

[RKB]

I have only resolved the phpmyadmin issue, stupidly I was calling phpmysqladmin and not phpmyadmin and I did not 'twig' to the problem as I was being presented with a logon screen.

I will report progress back here.

[electroman00]

My second question is; I have the SME server setup as a server / gateway and I have SpeedStream router 10.0.0.138 for Internet access, I don,t seem to be able to get through the SME server to get to the Router to make adjustments, should I be able to.

If you enter into your browser 10.0.0.1 you should get a (111) Connection refused.
That tells you that your ISP's upstream router is refusing the connection as it should.
That also tells you that your ISP is using that address space as most do.

What's the model # of the router?

DSL or Cable?

Business or Residential account?

The 10.0.0.138 address space is reserved for WAN's not Lan's, so if your using that address space for the Lan Zone (SME gateway) then expect problems.

It's not likely you will need 16 million address as the 10.0.0.0 space provides.

192.168.0.0 provides 65,535 address, more then you will likely need.... ever.

Your ISP is more then likely using the 10.0.0.0 address space.

If your ISP is handing out the 10.0.0.0 to you, then they need to learn how to setup their network and equipment properly.

You should be using the 192.168.0.0 address space Lan side or 172.16.0.0 on the DMZ side.

You also will not be able to setup SME in server-gateway mode on a Lan Zone, DMZ yes, Lan NO.

Server-only mode on a Lan Zone.

Server-only or Server-gateway mode on a DMZ Zone.

What's your network setup look like?

modem > SpeedStream > switch > SME > clients
or
SpeedStream > SME > clients

or ??

Note: Never setup a external access server of any kind/type on a Lan Zone that maintains client systems.

The only exception to that rule is if the server is ONLY providing local LAN access (no Router port FORWARDS), if there are port forwards to a lan sever then the server needs to be on the DMZ Zone.

Basic Network Security 101

[Stefano]

@electroman:

almost Alcatel's router have internal ip set to 10.0.0.138/8 since... well, 2001.. it's not a ISP setup, it's a factory default

@RKB: set your SME's wan ip to 10.0.0.1/8 and default GW to 10.0.0.138
you should be able to see router's web interface from every pc in lan.. if not, there should be some issues with your router..

ciao

Stefano

[RKB]

Thanks for all of the feedback.
I have moved on a bit, ditched the SpeedStream Router replaced with NetGear NB5V2
The External side refuses to connect to the internet.
The local side is fine I can see it on the network.

I have read of others having this issue so I will do some move reading.

The bit I am confused about is the Extenal IP address.

Cheers

Ron

[electroman00]

Why do I get the feeling it's not a Netgear NB5 v2??

[RKB]

We I guess the only reason is that when I put the network into the Router it all works fine. ?

Cheers

Ron

[electroman00]

We I guess the only reason is that when I put the network into the Router it all works fine. ?
Cheers
Ron

Well when I searched the Netgear support site & Google, that model wasn't available, so..... is it only available in Australia and a unit so new that Netgear hasn't updated their site yet??

Or is it a NetComm NB5 because that is available??

Also since you state "it all works fine" does that mean we can assume you have rectified all your problems?

As a side note it's important to provide imperative information i.e. model #'s since most here have a limited crystal ball range, usually less then a few hundred miles in most cases.

Since Alcatel, Netgear, NetComm produces many different products, it help's to narrow it down a bit to a specific model #.

In which case it might provide a specific answer to a specific question about a specific model, leading to a specific solution.

In your OP you state for example.....

I have the SME server setup as a server / gateway and I have SpeedStream router

Well they make the Series: 5100, 5200, 5400, 5500 just to name a few all of which are different.

IOW it's like going into a auto parts store and saying I need brakes for my Chevy.

If you said SpeedStream 1000 would we know exactly what your model is?

I have about 8 different model SpeedStream units here.

All of which have various issues, which solution do you want.

I have many Netgear products, all with various issues, which solution do you want.

I can't find any info on a Netgear NB5V2....to my knowledge they don't make one.

I know of a NetComm NB5.

What solution do you want.

or

You don't have anymore problems/issues and we can consider this a closed issue?

[RKB]

Thanks for the reply,
The SpeedStream is a 4200
The Router currently in place is a NetGear DG834 V2
The Switch is a Cisco Catalyst 1900

The SME server will connect to the internet in Server Only mode, no problem.
The Network side works fine.

My ISP has allocated my Static IP of 60.240.199.106, Sub 255.255.255.255 the ISP Gateway server is 202.7.162.162

When I try to do this from the manual,
'If you have a static IP address and your ISP does not offer DHCP or PPPoE, then your ISP will give you the static IP address, subnet mask (or netmask), and the gateway IP address of the device that your server should connect to in order to communicate with the Internet. Assuming you have this information on hand, you can go ahead and select Option 4. Successive screens will prompt you to enter each parameter. the SME Server / Gateway will not except the above values.'

When I select Static IP and enter 60.240.199.106, 255.255.255.255 SME forces Gateway IP to 60.240.199.1 and if I change the sub to 255.255.255.0 then the IP is forced to 60.240.199.107.

Regardless no internet connection

Any idea's gratefully received