Synology Development Server?

Does anyone have any experience with setting up a website development server using Synology’s Disk manager software? I’m currently using Mamp Pro, but I’d like to take advantage of my new DiskStation 1512+. I’m hoping that if I set it up properly I can allow client access to work-in-progress.

The process looks fairly straightforward, but every time I say that things end up being a lot more complicated than I expected. Any advice or tips are greatly appreciated.

Thanks guys.


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Well after about 2 days and a whole lot of research I finally got this to work. No more MAMP Pro and now I don’t need separate development and staging servers. Plus, my clients can view work in progress via the Internet. The only thing I can’t figure out is how to access my MySQL databases on the Synology DiskStation with Sequel Pro. I’ve tried everything I can think of but I can’t get it to work.


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

At 20:40 -0500 7/2/13, RavenManiac wrote:

Well after about 2 days and a whole lot of research I finally got
this to work. No more MAMP Pro and now I don’t need separate
development and staging servers. Plus, my clients can view work in
progress via the Internet. The only thing I can’t figure out is how
to access my MySQL databases on the Synology DiskStation with Sequel
Pro. I’ve tried everything I can think of but I can’t get it to work.

A quick check on the Synology site for Sequel Pro draws a blank. Are
you sure that the PHP library included with the web server on the
Synology box includes the Sequel Pro routines?

David - who wishes he could afford a Synology box.


David Ledger - Freelance Unix Sysadmin in the UK.
email@hidden
www.ivdcs.co.uk


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Sequel Pro is a desktop MySQL admin tool. It connects over the usual port (or ssh if you prefer/require) and performs all the same functions that you might use the command shell or phpMyAdmin to do.

Walter

On Feb 8, 2013, at 11:59 AM, David Ledger wrote:

At 20:40 -0500 7/2/13, RavenManiac wrote:

Well after about 2 days and a whole lot of research I finally got this to work. No more MAMP Pro and now I don’t need separate development and staging servers. Plus, my clients can view work in progress via the Internet. The only thing I can’t figure out is how to access my MySQL databases on the Synology DiskStation with Sequel Pro. I’ve tried everything I can think of but I can’t get it to work.

A quick check on the Synology site for Sequel Pro draws a blank. Are you sure that the PHP library included with the web server on the Synology box includes the Sequel Pro routines?

David - who wishes he could afford a Synology box.


David Ledger - Freelance Unix Sysadmin in the UK.
email@hidden
www.ivdcs.co.uk


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Hey Walter. Yeah, I just contacted Synology. Not being familiar with this particular NAS I’m sure I have something misconfigured. Here’s the info I sent Synology via their Tech Support form. I also sent a screenshot of my phpMyAdmin control panel.

-------Sent to Synology Tech Support--------
I need helping configuring my DiskStation so I can use Sequel Pro (http://www.sequelpro.com) to log into several MySQL databases which are stored on it. The local IP address for my DiskStation is 10.0.1.209. I’ve configured Sequel Pro with the following information to connect to my DiskStation, but I have something wrong:

Name: (optional)
Host: 10.0.1.209
Username: root
Password: …
Database: (optional)
Port: 3306

I’m getting the following error message:

Access denied!
Unable to connect to host 10.0.1.209 because access was denied.

Double-check your username and password and ensure that access from your current location is permitted.

MySQL said: Access denied for user ‘root’@‘10.0.1.201’ (using password: YES)

The username and password I’m entering are the same one I use to access phpMyAdmin. I also have the Firewall configured to allow access. Please help.

Thanks!


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Surprisingly, I have no problem connecting to my MySQL databases on GoDaddy.

FWIW, I found the GoDaddy Superbowl commercial featuring Bar Rafaeli quite disturbing. I can see why many forum members don’t like GoDaddy. I’ll probably transition all of my stuff as soon as my contract expires.


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

BUT, on the upside the RAVENS won! Woohoo!


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

There’s a preference you have to set on the MySQL server (you do this using the MySQL interface for people and permissions). You need to allow the root user to connect from another machine, not just the localhost (which in this setup is the Synology box itself).

Walter

On Feb 8, 2013, at 12:29 PM, RavenManiac wrote:

Hey Walter. Yeah, I just contacted Synology. Not being familiar with this particular NAS I’m sure I have something misconfigured. Here’s the info I sent Synology via their Tech Support form. I also sent a screenshot of my phpMyAdmin control panel.

-------Sent to Synology Tech Support--------
I need helping configuring my DiskStation so I can use Sequel Pro (http://www.sequelpro.com) to log into several MySQL databases which are stored on it. The local IP address for my DiskStation is 10.0.1.209. I’ve configured Sequel Pro with the following information to connect to my DiskStation, but I have something wrong:

Name: (optional)
Host: 10.0.1.209
Username: root
Password: …
Database: (optional)
Port: 3306

I’m getting the following error message:

Access denied!
Unable to connect to host 10.0.1.209 because access was denied.

Double-check your username and password and ensure that access from your current location is permitted.

MySQL said: Access denied for user ‘root’@‘10.0.1.201’ (using password: YES)

The username and password I’m entering are the same one I use to access phpMyAdmin. I also have the Firewall configured to allow access. Please help.

Thanks!


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

On 8 Feb 2013, 4:41 pm, waltd wrote:

There’s a preference you have to set on the MySQL server (you do this using the MySQL interface for people and permissions). You need to allow the root user to connect from another machine, not just the localhost (which in this setup is the Synology box itself).

Walter

I didn’t see that option in the root settings so I tried adding a new user with the host address of 10.0.1.201 (my MacBook Pro) and that didn’t work either. I’m sure it’s something simple. :slight_smile:


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

BTW, I really don’t understand the term host as it applies here. Is host the name/IP of the NAS or the system that’s accessing the NAS?


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

The latter. When you set up a user that is able to connect from multiple hosts, they are known as

username@%

When you bind someone to connect from a particular host, they are

username@localhost
username@192.168.1.4

or similar.

I don’t have a copy of PMA running here so I can quote you the precise control name, but I recall seeing the ability to create and edit users in a PMA that is connected at the root level (not a “jailed” user, only able to access certain tables).

Walter

On Feb 8, 2013, at 1:09 PM, RavenManiac wrote:

BTW, I really don’t understand the term host as it applies here. Is host the name/IP of the NAS or the system that’s accessing the NAS?


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Okay, I figured this out. Basically I had my user permissions set wrong, specifically my user login Information. I updated everything with phpMyAdmin and I’m good to go.

With Sequel Pro, Host is the IP address of the server you’re trying to access. Not sure why they did this because in phpMyAdmin, Host is the IP address of the computer trying to access the server. Very confusing.

BTW, is there anything wrong with leaving Host in phpMyAdmin set to Any Host (%) provided I’ve passworded my account or should I change this to the specific local machine that’ll be accessing my MySQL databases?


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options