Re: web-ERP-users Digest, Vol 42, Issue 6

View: New views

1 Messages — Rating Filter: Alert me

Re: web-ERP-users Digest, Vol 42, Issue 6

by Hussein Maruan :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Tim,

Yes I did read it but I missed out assigning the tax group assignment.
Thanks for your help, much appreciated.

Hussein 'Lyon' Maruan

-----Original Message-----
From: web-erp-users-request@...
[mailto:web-erp-users-request@...]
Sent: Saturday, November 07, 2009 4:27 AM
To: web-erp-users@...
Subject: web-ERP-users Digest, Vol 42, Issue 6

Send web-ERP-users mailing list submissions to
web-erp-users@...

To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/web-erp-users
or, via email, send a message with subject or body 'help' to
web-erp-users-request@...

You can reach the person managing the list at
web-erp-users-owner@...

When replying, please edit your Subject line so it is more specific
than "Re: Contents of web-ERP-users digest..."

Today's Topics:

1. Re: Unable to Print Quotations (Tim Schofield)
2. Re: Security with VPN (tlie)
3. Re: Security with VPN (tlie)
4. Re: Security with VPN (AESE)
5. Re: Security with VPN (Phil Daintree)

----------------------------------------------------------------------

Message: 1
Date: Fri, 6 Nov 2009 11:22:37 +0000
From: Tim Schofield <tim.schofield1960@...>
Subject: Re: [webERP-users] Unable to Print Quotations
To: For the general discussion of webERP project
<web-erp-users@...>
Message-ID:
<1cafbfd40911060322p44f2781fi7611d934e1e042ab@...>
Content-Type: text/plain; charset=ISO-8859-1

Hi,

The tax system on webERP is very flexible, but this can mean that the
setup is not always easy. Check that you have tax authorities setup, I
think you have, and then select `Edit Rates` from that screen. Here is
where you put in those rates.

Have you read the manual on taxes?

Thanks
Tim

2009/11/4 Hussein Maruan <wambchops@...>:
> Hi all,
>
> Im quite new to webERP and am setting up a test system. I have run into a
> problem where after entering the required details to generate a quotation
i
> get this in red:
>
> Database SQL Failure : The SQL that failed was
> SELECT * FROM taxauthrates WHERE dispatchtaxprovince=1 AND taxcatid=4 AND
> taxauthority=
>
> I am unsure whats causing this problem, I think I should have setup the
tax
> items/groups correctly. Hope anyone can help as i've tried searching the
> mailing list for clues as well as google.
>
> Best regards,
> --
> Hussein 'LYON' Maruan
>
>
>
----------------------------------------------------------------------------
--
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
30-Day

> trial. Simplify your report design, integration and deployment - and focus
> on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now. ?http://p.sf.net/sfu/bobj-july
> _______________________________________________
> web-ERP-users mailing list
> web-ERP-users@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>
>

------------------------------

Message: 2
Date: Fri, 6 Nov 2009 08:31:39 -0800 (PST)
From: tlie <thomas.lie@...>
Subject: Re: [webERP-users] Security with VPN
To: web-erp-users@...
Message-ID: <26230817.post@...>
Content-Type: text/plain; charset=UTF-8

Thanks for your reply & info
Sorry for my late reply as i had a power blackout for the whole day

i see from windows xp, it can easily setup vpn server & making a new
connection to vpn server
but it looks like it's using PPTP.

1) if say i decide to setup IPSEC with VPN server in ubuntu,
will it be easy for windows client to connect (just like PPTP)?

2) does anyone ever setup VPN for weberp? any available guide in the net?

thanks,
tlie

Javier de Lorenzo-C?ceres wrote:

>
> Hi T.Lie,
>
> Yes. You are right, that is exactly the most famous use of VPN. There are
> 3 levels of VPN Tunnels: 1) PPTP, 2) L2TP and 3) IPSEC.
>
> Nowadays only IPSEC (IP Security) is used. To explain it shortly, what it
> does is simply to encrypt the traffic between to IP nodes (tunneling is a
> metaphor).
>
> There are 2 different deployments called: 1) Point to Point and, 2)
> Roaming.
>
> Point to Point may be configured using: option 1) Certificates, option 2)
> Shared Keys.
>
>
> Regards,
>
> Javier de Lorenzo-C?ceres
> aese, aplicaciones software, s.l.
> Canary Islands - Spain
>
> ----- Original Message -----
> From: Thomas Timothy Lie
> To: web-erp-users@...
> Sent: Friday, November 06, 2009 6:21 AM
> Subject: [webERP-users] Security with VPN
>
>
> Hi weberp community,
>
> is it possible to setup weberp securely with vpn?
>
> for example, if my weberp & apache webserver are at homei'd like people
> at the office can connect safely to home via vpn. then from there they can
> just type a local ip, eg. http://192.168.2.1 to access weberp.
>
> i'm quite new with vpn, so i'm not sure if that's right what can be
> achieved with vpn. if yes, anyone know the procedure to setup vpn server
> with ubuntu 9.10?
>
> thanks,
> tlie
>
>
>
>

----------------------------------------------------------------------------
--
>
>
>
>
----------------------------------------------------------------------------
--
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
> 30-Day
> trial. Simplify your report design, integration and deployment - and
> focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>
>
>
----------------------------------------------------------------------------
--
>
>
> _______________________________________________
> web-ERP-users mailing list
> web-ERP-users@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>
>
----------------------------------------------------------------------------
--

> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
> 30-Day
> trial. Simplify your report design, integration and deployment - and focus
> on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now. http://p.sf.net/sfu/bobj-july
> _______________________________________________
> web-ERP-users mailing list
> web-ERP-users@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>
>

--
View this message in context:
http://old.nabble.com/Security-with-VPN-tp26227459p26230817.html
Sent from the web-erp-users mailing list archive at Nabble.com.

------------------------------

Message: 3
Date: Fri, 6 Nov 2009 08:32:08 -0800 (PST)
From: tlie <thomas.lie@...>
Subject: Re: [webERP-users] Security with VPN
To: web-erp-users@...
Message-ID: <26230818.post@...>
Content-Type: text/plain; charset=UTF-8

Thanks for your reply & info, Javier
Sorry for my late reply as i had a power blackout for the whole day

i see from windows xp, it can easily setup vpn server & making a new
connection to vpn server
but it looks like it's using PPTP.

1) if say i decide to setup IPSEC with VPN server in ubuntu,
will it be easy for windows client to connect (just like PPTP)?

2) does anyone ever setup VPN for weberp? any available guide in the net?

thanks,
tlie

Javier de Lorenzo-C?ceres wrote:

--
View this message in context:
http://old.nabble.com/Security-with-VPN-tp26227459p26230818.html
Sent from the web-erp-users mailing list archive at Nabble.com.

------------------------------

Message: 4
Date: Fri, 6 Nov 2009 18:09:33 -0000
From: AESE, S.L., Javier de Lorenzo-C?ceres. <info@...>
Subject: Re: [webERP-users] Security with VPN
To: "For the general discussion of webERP project"
<web-erp-users@...>
Message-ID: <6D234D721BE7469B894632245490FC5C@AS11>
Content-Type: text/plain; format=flowed; charset="utf-8";
reply-type=original

Hi T. Lie

> i see from windows xp, it can easily setup vpn server & making a new
> connection to vpn server
> but it looks like it's using PPTP.

Windows XP can also make IPSec Tunneling because Microsoft bought the
necessary Windows IPSec implementation license to Cisco. To configure it,
the user must do it through Local Security Policies under Administrative
Tools (the Cisco copyright is shown), but not through Network Connections.

Through Network Connections, the user may configure the VPN Client to use
PPTP or L2TP, but Microsoft limited the use of L2TP to Certificates.

(Note that any of the above three cases are Clients, not Servers. A server
is designed to listen to client requests and accept or reject them following

an Access Control List (ACL) and a certain quantity of tunnels)

For your questions:

Q1) No, the Windows XP IPSec Client it's not intuitive or assisted, even
more, the GUI for that subject is not very good, so you must know very well
what you are doing, i.e., less than being guided you will be confused even
for the subjects you may known well. I did it to a D-Link NetDefend DFL-700,

it works, it's very slow (keepalives doesn't seem up and running), then I
bought another D-Link NetDefend DFL-200. But I, despite the fact of being a
Cisco partner, will recommend you a Cisco 1801-K9 for server and a 857 for
every remote LAN and Cisco VPN Client software for Roaming users, an
excellent software. D-Link sell the client software apart and it's very odd.

Also, you will find two implementations that can work as Ciso VPN clients
for Linux. The another BIG is Cytrix. I've tested all the most famous
software, including (in alphabetical order) Checkpoint, Clavister (the one
licensed to be used by D-Link), Kiwi, Nortel, SafeNet, GreenBow, etc. Also
you may find some hardware servers from 3Com, Symantec and others. Linux is
right as server and client, but VPN is close related to Public IP and
firewalls so they are good in the perimeter and I prefer WebERP in the
Back-Office, so, for this setup two boxes are needed.

Q2) VPN is like a network connection, it's not related to server, clients or

peer to peer applications, once up and running is like an UTP Network Cable.

As you well said, it permits to see the private remote LAN as if it was
connected directly to the local network, hence the term Private; it's
Virtual because indeed it's an Internet connection but since it's being
crypted with only Private Keys or Certificates, nobody else can have access
to it.

Once you have a VPN connection up and running, you will find it transparent
to all protocols. Indeed VPN is more useful to unsecure protocols like SMB
(NetBIOS or NBT(NetBIOS over TCP)) or IPX. For WebERP you may use https, a
Public Key infraestructure system like those used by Banks.

Q3) You will find a lot of information on the net regarding both VPN
Standards as GRE (see IP Protocols from IANA), etc. and also Propietary (and

no standard) Implementations as those made by Cisco Systems.

Appendix
The main 2 practical differences between using Windows XP PPTP or L2TP VPN
Clients against using the Windows XP IPSec Client are:
1) the first two get an IP address from the remote LAN they are connecting
to, whilst the latter retains its own Local Private IP Address.
2) IPsec is more secure.

Regards,
Javier de Lorenzo-C?ceres
aese, aplicaciones software, s.l.
Canary Islands - Spain

----- Original Message -----
From: "tlie" <thomas.lie@...>
To: <web-erp-users@...>
Sent: Friday, November 06, 2009 4:31 PM
Subject: Re: [webERP-users] Security with VPN

>
> Thanks for your reply & info
> Sorry for my late reply as i had a power blackout for the whole day
>
> i see from windows xp, it can easily setup vpn server & making a new
> connection to vpn server
> but it looks like it's using PPTP.
>
> 1) if say i decide to setup IPSEC with VPN server in ubuntu,
> will it be easy for windows client to connect (just like PPTP)?
>
> 2) does anyone ever setup VPN for weberp? any available guide in the net?
>
> thanks,
> tlie
>
>
>
> Javier de Lorenzo-C?ceres wrote:
>>
>> Hi T.Lie,
>>
>> Yes. You are right, that is exactly the most famous use of VPN. There are
>> 3 levels of VPN Tunnels: 1) PPTP, 2) L2TP and 3) IPSEC.
>>
>> Nowadays only IPSEC (IP Security) is used. To explain it shortly, what it
>> does is simply to encrypt the traffic between to IP nodes (tunneling is a
>> metaphor).
>>
>> There are 2 different deployments called: 1) Point to Point and, 2)
>> Roaming.
>>
>> Point to Point may be configured using: option 1) Certificates, option 2)
>> Shared Keys.
>>
>>
>> Regards,
>>
>> Javier de Lorenzo-C?ceres
>> aese, aplicaciones software, s.l.
>> Canary Islands - Spain
>>
>> ----- Original Message -----
>> From: Thomas Timothy Lie
>> To: web-erp-users@...
>> Sent: Friday, November 06, 2009 6:21 AM
>> Subject: [webERP-users] Security with VPN
>>
>>
>> Hi weberp community,
>>
>> is it possible to setup weberp securely with vpn?
>>
>> for example, if my weberp & apache webserver are at homei'd like people
>> at the office can connect safely to home via vpn. then from there they
>> can
>> just type a local ip, eg. http://192.168.2.1 to access weberp.
>>
>> i'm quite new with vpn, so i'm not sure if that's right what can be
>> achieved with vpn. if yes, anyone know the procedure to setup vpn server
>> with ubuntu 9.10?
>>
>> thanks,
>> tlie
>>
>>
>>
>>

----------------------------------------------------------------------------
--
>>
>>
>>
>>
----------------------------------------------------------------------------
--
>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
>> 30-Day
>> trial. Simplify your report design, integration and deployment - and
>> focus on
>> what you do best, core application coding. Discover what's new with
>> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>>
>>
>>
----------------------------------------------------------------------------
--
>>
>>
>> _______________________________________________
>> web-ERP-users mailing list
>> web-ERP-users@...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>>
>>
----------------------------------------------------------------------------
--

>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
>> 30-Day
>> trial. Simplify your report design, integration and deployment - and
>> focus
>> on
>> what you do best, core application coding. Discover what's new with
>> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>> _______________________________________________
>> web-ERP-users mailing list
>> web-ERP-users@...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>>
>>
>
> --
> View this message in context:
> http://old.nabble.com/Security-with-VPN-tp26227459p26230817.html
> Sent from the web-erp-users mailing list archive at Nabble.com.
>
>
>

----------------------------------------------------------------------------
--
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
> 30-Day
> trial. Simplify your report design, integration and deployment - and focus

> on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now. http://p.sf.net/sfu/bobj-july
> _______________________________________________
> web-ERP-users mailing list
> web-ERP-users@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>

------------------------------

Message: 5
Date: Sat, 07 Nov 2009 09:29:22 +1200
From: Phil Daintree <phil@...>
Subject: Re: [webERP-users] Security with VPN
To: For the general discussion of webERP project
<web-erp-users@...>
Message-ID: <4AF49532.80900@...>
Content-Type: text/plain; charset=UTF-8; format=flowed

The best way to ensure that communications and data is encrypted over
http is the secure sockets layer (SSL) - this just needs some
configuration of your web-server and then calling the pages with

https://your_web_server_domain/webERP/index.php

There is a setting in webERP configuration that ensures that only https
connections can be made from

Setup->configuuration Settings

Only allow secure socket connections: set to Yes

You can also configure apache to only serve pages over SSL too.

In my view it is appropriate to only use webERP over SSL all installs
should be using it - since data going over the wire is otherwise visible
to all and sundry!

For the paranoid, you can also add http authentication to ensure that
only valid users can access your web-server - this adds another layer of
security over the built in webERP authentication. If users always
connect from a particular machine (or from the same LAN that uses a
proxy) then it is also possible to setup apache to allow from a specific
IP address to bypass this second (http authentication) layer if the
connection is from a friendly LAN or computer.

Phil

tlie wrote:

> Thanks for your reply & info, Javier
> Sorry for my late reply as i had a power blackout for the whole day
>
> i see from windows xp, it can easily setup vpn server & making a new
> connection to vpn server
> but it looks like it's using PPTP.
>
> 1) if say i decide to setup IPSEC with VPN server in ubuntu,
> will it be easy for windows client to connect (just like PPTP)?
>
> 2) does anyone ever setup VPN for weberp? any available guide in the net?
>
> thanks,
> tlie
>
>
>
> Javier de Lorenzo-C?ceres wrote:
>> Hi T.Lie,
>>
>> Yes. You are right, that is exactly the most famous use of VPN. There are
>> 3 levels of VPN Tunnels: 1) PPTP, 2) L2TP and 3) IPSEC.
>>
>> Nowadays only IPSEC (IP Security) is used. To explain it shortly, what it
>> does is simply to encrypt the traffic between to IP nodes (tunneling is a
>> metaphor).
>>
>> There are 2 different deployments called: 1) Point to Point and, 2)
>> Roaming.
>>
>> Point to Point may be configured using: option 1) Certificates, option 2)
>> Shared Keys.
>>
>>
>> Regards,
>>
>> Javier de Lorenzo-C?ceres
>> aese, aplicaciones software, s.l.
>> Canary Islands - Spain
>>
>> ----- Original Message -----
>> From: Thomas Timothy Lie
>> To: web-erp-users@...
>> Sent: Friday, November 06, 2009 6:21 AM
>> Subject: [webERP-users] Security with VPN
>>
>>
>> Hi weberp community,
>>
>> is it possible to setup weberp securely with vpn?
>>
>> for example, if my weberp & apache webserver are at homei'd like people
>> at the office can connect safely to home via vpn. then from there they

can

>> just type a local ip, eg. http://192.168.2.1 to access weberp.
>>
>> i'm quite new with vpn, so i'm not sure if that's right what can be
>> achieved with vpn. if yes, anyone know the procedure to setup vpn server
>> with ubuntu 9.10?
>>
>> thanks,
>> tlie
>>
>>
>>
>>

>> on
>> what you do best, core application coding. Discover what's new with
>> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>> _______________________________________________
>> web-ERP-users mailing list
>> web-ERP-users@...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>>
>>
>

------------------------------

----------------------------------------------------------------------------
--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus
on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july

------------------------------

_______________________________________________
web-ERP-users mailing list
web-ERP-users@...
https://lists.sourceforge.net/lists/listinfo/web-erp-users

End of web-ERP-users Digest, Vol 42, Issue 6
********************************************

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
web-ERP-users mailing list
web-ERP-users@...
https://lists.sourceforge.net/lists/listinfo/web-erp-users