Re: [WebDNA] Needing a new host....

This WebDNA talk-list message is from

2013

It keeps the original formatting. numero = 110543
interpreted = N
texte = --Apple-Mail=_51E1F7B0-3B84-4147-B518-76C8DEEF270DContent-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=iso-8859-1I can't guarantee these instructions but please let me know if you find =any errors:The notes are below:==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3DInstalling Ubuntu 12.04/WebDNA 6.2.1/Webmin/MySQL/ProFTPDUbuntu 12.04Apache2 & set apache to be non-case sensitive, optional.MySQLWebDNA 6.2.1 ServerWebmin 1.630ProFTPDFreeTDS - ODBC driverImagemagickwkhtnltopdf (dynamic pdf creation)************************************************ Connect to Ubuntu 12.04 server$ ssh root@(ipaddress)** Enter password** Update Ubuntu$ sudo apt-get update** Install Apache2$ sudo apt-get install apache2** Install MySQL$ sudo apt-get install mysql-server** Install WebDNA$ wget http://71.13.202.180/WebDNA_Server-Linux-6.2.1.tar.gz$ tar -xzf WebDNA_Server-Linux-6.2.1.tar.gz$ cd WebDNA-6.2.1$ ./install_WebDNA.sh** Accept defaults** reboot server$ reboot now** Prepare for Webmin$ sudo apt-get install perl libnet-ssleay-perl openssl =libauthen-pam-perl libpam-runtime libio-pty-perl apt-show-versions =python** Get the WebMin Package$ wget http://prdownloads.sourceforge.net/webadmin/webmin_1.630_all.deb** Installs the package$ sudo dpkg -i webmin_1.630_all.deb** reboot server$ reboot now** Check that you can connect to the ip address.http://(ipaddress)** Check WebDNA - case sensitivehttp://(ipaddress)/WebCatalog/** Login via browser using root & (password)https://(ipaddress):10000/************************************OPTIONAL************************************** Make Apache Case Insensitive=46rom the command line, type$ sudo suto get root privileges.** Edit speling.conf$ nano /etc/apache2/mods-available/speling.confAdd the lineCheckSpelling onthen hit ctrl-x, y to exit and save the file.** load apache2 config at commandline$ a2enmod$ spelingand hit enter.$ /etc/init.d/apache2 reload**Mistype a url to test it.************************************** Webmin - Others > File ManagerSet permissions on /var/wwwSet permissions on www directory and its contentsuser =3D www-datagroup =3D www-dataoctal 0775also check permissions on /usr/lib/cgi-bin/WebCatalogEngine** Webmin - Add a new user in System > Users and GroupsCreate a new user to use with FTP, make user group www-data and =directory "/"This allows the user access to the complete server so that they can =access all the componentsof WebDNA + www root** Webmin - Install ProFTPD ServerIn "Unused Modules" click on ProFTPD Server link and allow it to self =installGo to ProFTPD and open Virtual Server Options, open "User and Group"Run as Unix Group "www-data"Test the ftp connection.** Webmin - run updatesSelect "System Information" from left hand menu, check if any updates =are required.Run the updates** reboot server$ reboot now************************************OPTIONAL*************************************** INSTALL ODBC for MSSQL **** do some installs$ sudo apt-get install unixodbc unixodbc-dev freetds-dev tdsodbc$ apt-get install freetds-bin** Now configure some files--- /etc/freetds/freetds.conf ---[TS] <<<<< connection name which you refer to in the connection =belowhost =3D SERVER ADDRESSport =3D 1433tds version =3D 7.0client charset =3D UTF-8--- /etc/odbcinst.ini ---[FreeTDS]Description =3D tdsodbcDriver =3D /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.soSetup =3D /usr/lib/x86_64-linux-gnu/odbc/libtdsS.soFileUsage =3D 1CPTimeout =3D 5CPReuse =3D 5** Test the connection$ tsql -S (connection name) -U (db username) -P (db password)************************************ALL DONE :)********************************************************* Some other things of interest: *********************************************************s3cmd$ sudo apt-get install s3cmdhttp://s3tools.org/s3cmdS3cmd is a command line tool for uploading, retrieving and managing data =in Amazon S3.Create your .s3cfg file and then move it to the WebCatalogEngine =directory so that you can refer to and change it easily. Make sure the =file has correct permissions 0777 owner & group =3D www-data.Refering to the config files gives you the ability to have different =setups for different sites/situations on the one serverSample code:[shell]s3cmd put --acl-public /var/www/(local directory)/(File name to =upload) s3://(s3 container name)/(filename)/ =--config=3D"/usr/lib/cgi-bin/WebCatalogEngine/.s3cfg"[/shell]Some links:=http://www.whiteboardcoder.com/2012/11/reading-s3-via-s3cmd-from-ubuntu-12=04.htmlhttp://linux.die.net/man/1/s3cmd************************************************Imagemagick( you will need rpm to install this: $ apt-get install rpm)$ rpm -Uvh ImageMagick-6.8.5-7.i386.rpmhttp://www.imagemagick.orgImageMagick=AE is a software suite to create, edit, compose, or convert =bitmap images. It can read and write images in a variety of formats =(over 100) including DPX, EXR, GIF, JPEG, JPEG-2000, PDF, PhotoCD, PNG, =Postscript, SVG, and TIFF. Use ImageMagick to resize, flip, mirror, =rotate, distort, shear and transform images, adjust image colors, apply =various special effects, or draw text, lines, polygons, ellipses and =B=E9zier curves.************************************************Converting HTML page to PDF on the fly (dynamic pdf)=http://www.cyberciti.biz/open-source/html-to-pdf-freeware-linux-osx-window=s-software/http://code.google.com/p/wkhtmltopdf/==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3DOn 03/08/2013, at 12:18 AM, Brian B. Burton wrote:> I'm setting up another linode VPS today. I've documented the last few =and will follow my own guide to set this one up as a test run thru. =After correcting any errors I find, I'll post up exact instructions for =setting up WebDNA on linode Ubuntu 123.04 VPS quickly and easily.>=20> BBB>=20> On Jul 31, 2013, at 5:32 AM, Rich Kwas =wrote:>=20>> I'll check them out... took a quick look at their website just now...>> Thanks>>=20>> From: WebDNA >> To: talk@webdna.us=20>> Sent: Tuesday, July 30, 2013 7:57 PM>> Subject: Re: [WebDNA] Needing a new host....>>=20>> Richard>>=20>> I have been looking at different VPS setups for a while and a number =of times almost settled with one until I came across Linode =https://www.linode.com . After doing all the price calculations I was =billed far less than what I was expecting (from $20/month). Their admin =is pretty good and since setting up have not had to return to it. I have =built a couple of Ubuntu servers on the platform and have been very =happy with stability etc. I can even manage from my iPhone with their =App.>>=20>>=20>> Regards>>=20>> Stuart Tremain>> IDFK Web Developments>> AUSTRALIA>> webdna@idfk.com.au>>=20>>=20>>=20>>=20>> On 31/07/2013, at 10:32 AM, Rich Kwas =wrote:>>=20>>>=20>>> Looking for a new VPS to develop and host webdna using the lastest =version/fastcgi etc.>>> I have an MS server2008 box behaving quite well, and those sites =will stay on the old code 'cause I mange those as well and everyone is =happy over there....>>>=20>>> My Linux VPS host (VPS.net) is totally driving me crazy with the =redesign of their admin areas once logged in...>>> Twice now in the last week I "bought" additional services and =features just trying to see what OS images etc were available for a VPS =rebuild......>>> It's an upsell battlefield, makes GoDaddy look tame by =comparison.... Click on the wrong thing and you bought it, and they just =give you a "credit" unless you bitch to high heaven and demand the =charges get reversed..... It's totally instantaneous and on auto-pilot. =Ugh.>>> Used to be nice and friendly, and their support was real good over =the years.....>>>=20>>> Who's using what VPS where?>>> Recommendations???>>>=20>>> I'll be moving over to Ubuntu instead of the old Centos setup I had =for nearly 3 years now.....>>>=20>>> Thanks>>>=20>>> Richard>=20>=20> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us--Apple-Mail=_51E1F7B0-3B84-4147-B518-76C8DEEF270DContent-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=iso-8859-1I =can't guarantee these instructions but please let me know if you find =any errors:

The =notes are =below:

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D

I=nstalling Ubuntu 12.04/WebDNA =6.2.1/Webmin/MySQL/ProFTPD

Ubuntu =12.04

Apache2 & set apache to be non-case sensitive, =optional.

MySQL

WebDNA 6.2.1 Server

Webmin =1.630

ProFTPD

FreeTDS - ODBC =driver

Imagemagick

wkhtnltopdf (dynamic pdf =creation)

***************************************=*******

** Connect to Ubuntu 12.04 =server

$ ssh root@(ipaddress)

** =Enter password

** Update Ubuntu

$ =sudo apt-get update

** Install =Apache2

$ sudo apt-get install =apache2

** Install MySQL

$ sudo =apt-get install mysql-server

** Install =WebDNA

$ wget http://71.1=3.202.180/WebDNA_Server-Linux-6.2.1.tar.gz

$ =tar -xzf WebDNA_Server-Linux-6.2.1.tar.gz

$ cd =WebDNA-6.2.1

$ ./install_WebDNA.sh

** =Accept defaults

** reboot server

$ =reboot now

** Prepare for Webmin

$ =sudo apt-get install perl libnet-ssleay-perl openssl libauthen-pam-perl =libpam-runtime libio-pty-perl apt-show-versions =python

** Get the WebMin Package

$ =wget =http://prdownloads.sourceforge.net/webadmin/webmin_1.630_all.deb

=

** Installs the package

$ sudo dpkg -i =webmin_1.630_all.deb

** reboot =server

$ reboot now

** Check that you =can connect to the ip =address.

http://(ipaddress)

** Check =WebDNA - case =sensitive

http://(ipaddress)/WebCatalog/

** Login via browser using root & =(password)

https://(ipaddress):10000/

*=***********************************

OPTIONAL

*********=***************************

** Make Apache Case =Insensitive

=46rom the command line, type

$ sudo =su

to get root privileges.

** Edit =speling.conf

$ nano =/etc/apache2/mods-available/speling.conf

Add the =line

CheckSpelling on

then hit ctrl-x, y to exit and =save the file.

** load apache2 config at =commandline

$ a2enmod

$ speling

and hit =enter.

$ /etc/init.d/apache2 =reload

**

Mistype a url to test =it.

************************************

** Webmin - Others > File Manager

Set permissions on =/var/www

Set permissions on www directory and its =contents

user =3D www-data

group =3D =www-data

octal 0775

also check =permissions on =/usr/lib/cgi-bin/WebCatalogEngine

** Webmin - =Add a new user in System > Users and Groups

Create a new =user to use with FTP, make user group www-data and directory ="/"

This allows the user access to the complete server so that =they can access all the components

of WebDNA + www =root

** Webmin - Install ProFTPD =Server

In "Unused Modules" click on ProFTPD Server link and =allow it to self install

Go to ProFTPD and open Virtual Server =Options, open "User and Group"

Run as Unix Group ="www-data"

Test the ftp =connection.

** Webmin - run =updates

Select "System Information" from left hand menu, check =if any updates are required.

Run the =updates

** reboot server

$ reboot =now

************************************

OPTIONAL

************************************

*** =INSTALL ODBC for MSSQL ***

* do some installs

$ sudo =apt-get install unixodbc unixodbc-dev freetds-dev tdsodbc

$ =apt-get install freetds-bin

** Now configure =some files

--- /etc/freetds/freetds.conf ---

[TS] =    <<<<<  connection name which you refer =to in the  connection below

host =3D SERVER =ADDRESS

port =3D 1433

tds version =3D =7.0

client charset =3D UTF-8

--- =/etc/odbcinst.ini ---

[FreeTDS]

Description =3D =tdsodbc

Driver =3D =/usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so

Setup =3D =/usr/lib/x86_64-linux-gnu/odbc/libtdsS.so

FileUsage =3D =1

CPTimeout =3D 5

CPReuse =3D =5

** Test the connection

$ tsql -S =(connection name) -U (db username) -P (db =password)

************************************

=<=div>ImageMagick=AE is a software suite to create, edit, compose, or =convert bitmap images. It can read and write images in a variety of =formats (over 100) including DPX, EXR, GIF, JPEG, JPEG-2000, PDF, =PhotoCD, PNG, Postscript, SVG, and TIFF. Use ImageMagick to resize, =flip, mirror, rotate, distort, shear and transform images, adjust image =colors, apply various special effects, or draw text, lines, polygons, =ellipses and B=E9zier =curves.

***********************************=*************

Converting HTML page to PDF on =the fly (dynamic pdf)

=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

=