|
Home > Archive > SQL Anywhere database replication > April 2005 > ACCESS DENIED
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| PRIYANKA 2005-04-13, 9:23 am |
| Hello,
I am using FTP message type to implement replication,
but it is giving problem that it is not able to connect the
folders which I am using to store message.
It is connecting to the host, open socket.
My Folder is on the location where we have installed FTP
Server.
Guide me what can be the problem
Regards,
| |
| Joshua Savill 2005-04-13, 9:23 am |
| This sounds like a file permission problem. Make sure the user has the
ability to read and write to the folder on the FTP Server.
SQL Remote User's Guide
SQL Remote Administration
Using message types
The ftp message system
Troubleshooting ftp problems
Online:
http://www.ianywhere.com/developer/...n9/00000218.htm
--
Joshua Savill
iAnywhere Solutions - Product Support Analyst
<PRIYANKA> wrote in message news:425d26fb.74d3.1681692777@sybase.com...
> Hello,
>
> I am using FTP message type to implement replication,
> but it is giving problem that it is not able to connect the
> folders which I am using to store message.
>
> It is connecting to the host, open socket.
> My Folder is on the location where we have installed FTP
> Server.
>
> Guide me what can be the problem
> Regards,
| |
| PRIYANKA 2005-04-14, 9:23 am |
| I Have already gone through this, and also checked all the
things,I can ping the server.
I can connect to the FTP host through Dos with user name and
password.
Then if I see 'dir' after connecting to it and there I can
see that folder,so normally I have access to that folder.
I think passive mode is also working as it open socket,open
passive mode something like
227 Entering Passive Mode (10,40,40,16,11,22).
Tell me any other thing which I have to check.
Regards,
Priyanka
> This sounds like a file permission problem. Make sure the
> user has the ability to read and write to the folder on
> the FTP Server.
>
> SQL Remote User's Guide
> SQL Remote Administration
> Using message types
> The ftp message system
> Troubleshooting ftp problems
>
> Online:
>
http://www.ianywhere.com/developer/...n9/00000218.htm
>
> --
> Joshua Savill
> iAnywhere Solutions - Product Support Analyst
>
> <PRIYANKA> wrote in message
>
>
| |
| Chris Keating \(iAnywhere Solutions\) 2005-04-14, 11:24 am |
| Outside of replication, try to PUT a file at that location and GET a file
from that location.
<PRIYANKA> wrote in message news:425e6809.3ac.1681692777@sybase.com...[color=darkred]
>I Have already gone through this, and also checked all the
> things,I can ping the server.
> I can connect to the FTP host through Dos with user name and
> password.
> Then if I see 'dir' after connecting to it and there I can
> see that folder,so normally I have access to that folder.
>
> I think passive mode is also working as it open socket,open
> passive mode something like
>
> 227 Entering Passive Mode (10,40,40,16,11,22).
>
> Tell me any other thing which I have to check.
>
> Regards,
> Priyanka
>
>
> http://www.ianywhere.com/developer/...n9/00000218.htm
| |
| PRIYANKA 2005-04-18, 9:23 am |
| YES I can do that!
And one more question I have tried to write output file for
SQL Remote Log using the -o file option in dbremote,but it
does not work;
> Outside of replication, try to PUT a file at that location
> and GET a file that location.
>
>
> <PRIYANKA> wrote in message
> news:425e6809.3ac.1681692777@sybase.com... >I Have already
> folder. >
> the >> user has the ability to read and write to the
> folder on >> the FTP Server.
>
http://www.ianywhere.com/developer/...n9/00000218.htm
> , >> > but it is giving problem that it is not able to
> connect >> > the folders which I am using to store
> message. >> >
> FTP >> > Server.
>
>
| |
| Rob Waywell 2005-04-18, 11:23 am |
| Can you do a "select * from sys.sysremoteoptions" and post the values?
--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional
Sybase's iAnywhere Solutions
Please respond ONLY to newsgroup
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
<PRIYANKA> wrote in message news:4263baee.19fd.1681692777@sybase.com...
> YES I can do that!
> And one more question I have tried to write output file for
> SQL Remote Log using the -o file option in dbremote,but it
> does not work;
>
http://www.ianywhere.com/developer/...n9/00000218.htm[color=darkred]
| |
| Priyanka 2005-04-19, 3:23 am |
| I cannot give password here, but the result is something
like this.
type_name user_name
option setting
FILE PUBLIC director
y
FTP PUBLIC host 10.40.40.16
FTP PUBLIC user priyanka
FTP PUBLIC password
FTP PUBLIC root_dire
ctory msgs
FTP cons1 suppress_d
ialogs ON
FTP PUBLIC debug on
> Can you do a "select * from sys.sysremoteoptions" and post
> the values?
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
>
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available
> through the iAnywhere Developer Community at
> www.ianywhere.com/developer <PRIYANKA> wrote in message
>
http://www.ianywhere.com/developer/...n9/00000218.htm
>
>
| |
| Rob Waywell 2005-04-19, 7:23 am |
| 1) Try turning off "suppress_dialogs", this will let you see if you are
being prompted for something.
2) Try turning on "active_mode", the default is "off" which means it uses
passive mode, so try changing it.
3) Show us your command line for dbremote including the -o parameter. Once
we can get the output then we'll have a lot more information to work with.
--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional
Sybase's iAnywhere Solutions
Please respond ONLY to newsgroup
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
<Priyanka> wrote in message news:4264bf31.5ee6.1681692777@sybase.com...
> I cannot give password here, but the result is something
> like this.
>
> type_name user_name option setting
> FILE PUBLIC directory
> FTP PUBLIC host 10.40.40.16
> FTP PUBLIC user priyanka
> FTP PUBLIC password
> FTP PUBLIC root_directory msgs
> FTP cons1 suppress_dialogs ON
> FTP PUBLIC debug on
>
>
>
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
>
http://www.ianywhere.com/developer/...n9/00000218.htm[color=darkred]
| |
| Priyanka 2005-04-20, 9:23 am |
| Hi,
I have done what you said me but then also it is working in
passive mode only when I run it by dbremote.
> 3) Show us your command line for dbremote including the -o
> parameter. Once we can get the output then we'll have a
> lot more information to work with.
And I done this also with -o i have given file name also but
it does not store anything on that location ,how it works
can you explain me.
Tell me what more I can check and try
> 1) Try turning off "suppress_dialogs", this will let you
> see if you are being prompted for something.
> 2) Try turning on "active_mode", the default is "off"
> which means it uses passive mode, so try changing it.
> 3) Show us your command line for dbremote including the -o
> parameter. Once we can get the output then we'll have a
> lot more information to work with.
>
>
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
>
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available
> through the iAnywhere Developer Community at
> www.ianywhere.com/developer <Priyanka> wrote in message
> this. >
>
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
>
http://www.ianywhere.com/developer/...n9/00000218.htm
>
>
| |
|
|
| Priyanka 2005-04-22, 7:23 am |
| this is the result when I use
(dbremote -c -o priya " uid=dba;pwd=sql;dbf=
P:\")
is this
I. 04/22 12:37:55. SQL Remote Message Link Version
8.0.2.3601
I. 04/22 12:37:55. socket
I. 04/22 12:37:55. connect ftp
I. 04/22 12:37:55. Getting server response:
I. 04/22 12:37:55. 220 Microsoft FTP Service
I. 04/22 12:37:55. USER priyanka_kohli
I. 04/22 12:37:55. Getting server response:
I. 04/22 12:37:55. 331 Password required for priyanka_kohli
I. 04/22 12:37:55. User accepted with a password needed.
I. 04/22 12:37:55. PASS
I. 04/22 12:37:55. Getting server response:
I. 04/22 12:37:55. 230 User priyanka_kohli logged in.
I. 04/22 12:37:55. Password Accepted.
I. 04/22 12:37:55. PWD
I. 04/22 12:37:55. Getting server response:
I. 04/22 12:37:55. 257 "/" is current directory.
I. 04/22 12:37:55. TYPE A N
I. 04/22 12:37:55. Getting server response:
I. 04/22 12:37:55. 200 Type set to A.
I. 04/22 12:37:55. Type set.
I. 04/22 12:37:55. PASV
I. 04/22 12:37:55. Getting server response:
I. 04/22 12:37:55. 227 Entering Passive Mode
(10,40,40,16,12,159)
.
I. 04/22 12:37:55. PASV command accepted.
I. 04/22 12:37:55. NLST msgs/cons/
I. 04/22 12:37:55. socket
I. 04/22 12:37:55. connect
I. 04/22 12:37:55. Getting server response:
I. 04/22 12:37:55. 125 Data connection already open;
Transfer starting.
I. 04/22 12:37:55. 0 byte read...socket is closed
I. 04/22 12:37:55. closesocket
I. 04/22 12:37:55. Getting server response:
I. 04/22 12:37:55. 226 Transfer complete.
I. 04/22 12:37:55. closesocket
I. 04/22 12:37:55.
I. 04/22 12:37:55. Scanning logs starting at offset
0655056372
I. 04/22 12:37:55. Sending message to "rem2"
(0-0000000000-0655066005-0)
I. 04/22 12:37:55. STOR "msgs/rem1/.cons"
I. 04/22 12:37:55. TYPE I
I. 04/22 12:37:55. Getting server response:
I. 04/22 12:37:55. 200 Type set to I.
I. 04/22 12:37:55. Type set.
I. 04/22 12:37:55. PASV
I. 04/22 12:37:55. Getting server response:
I. 04/22 12:37:55. 227 Entering Passive Mode
(10,40,40,16,12,160)
.
I. 04/22 12:37:55. PASV command accepted.
I. 04/22 12:37:55. STOR msgs/rem1/.cons
I. 04/22 12:37:55. socket
I. 04/22 12:37:55. connect
I. 04/22 12:37:55. Getting server response:
I. 04/22 12:37:55. 550 msgs/rem1/.cons: Access is denied.
I. 04/22 12:37:55. Data Transfer Failed.
I. 04/22 12:37:55. closesocket
I. 04/22 12:37:55. STOR Failed!
I. 04/22 12:37:55. DELE msgs/rem1/.cons
I. 04/22 12:37:55. Getting server response:
I. 04/22 12:37:55. 550 msgs/rem1/.cons: The system cannot
find the file specified.
I. 04/22 12:37:55. Server denied permission to DELE file.
I. 04/22 12:37:55. QUIT
I. 04/22 12:37:55. Getting server response:
I. 04/22 12:37:55. 221
I. 04/22 12:37:55. Socket Closed in FTPClose.
I. 04/22 12:37:55. closesocket
I. 04/22 12:37:56. socket
I. 04/22 12:37:56. connect ftp
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 220 Microsoft FTP Service
I. 04/22 12:37:56. USER priyanka_kohli
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 331 Password required for priyanka_kohli.
I. 04/22 12:37:56. User accepted with a password needed.
I. 04/22 12:37:56. PASS
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 230 User priyanka_kohli logged in.
I. 04/22 12:37:56. Password Accepted.
I. 04/22 12:37:56. STOR "msgs/rem1/.cons"
I. 04/22 12:37:56. TYPE I
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 200 Type set to I.
I. 04/22 12:37:56. Type set.
I. 04/22 12:37:56. PASV
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 227 Entering Passive Mode
(10,40,40,16,12,161)
.
I. 04/22 12:37:56. PASV command accepted.
I. 04/22 12:37:56. STOR msgs/rem1/.cons
I. 04/22 12:37:56. socket
I. 04/22 12:37:56. connect
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 550 msgs/rem1/.cons: Access is denied.
I. 04/22 12:37:56. Data Transfer Failed.
I. 04/22 12:37:56. closesocket
I. 04/22 12:37:56. STOR Failed!
I. 04/22 12:37:56. DELE msgs/rem1/.cons
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 550 msgs/rem1/.cons: The system cannot
find the file specified.
I. 04/22 12:37:56. Server denied permission to DELE file.
I. 04/22 12:37:56. QUIT
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 221
I. 04/22 12:37:56. Socket Closed in FTPClose.
I. 04/22 12:37:56. closesocket
I. 04/22 12:37:56. socket
I. 04/22 12:37:56. connect ftp
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 220 Microsoft FTP Service
I. 04/22 12:37:56. USER priyanka_kohli
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 331 Password required for priyanka_kohli.
I. 04/22 12:37:56. User accepted with a password needed.
I. 04/22 12:37:56. PASS
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 230 User priyanka_kohli logged in.
I. 04/22 12:37:56. Password Accepted.
I. 04/22 12:37:56. STOR "msgs/rem1/.cons"
I. 04/22 12:37:56. TYPE I
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 200 Type set to I.
I. 04/22 12:37:56. Type set.
I. 04/22 12:37:56. PASV
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 227 Entering Passive Mode
(10,40,40,16,12,162)
.
I. 04/22 12:37:56. PASV command accepted.
I. 04/22 12:37:56. STOR msgs/rem1/.cons
I. 04/22 12:37:56. socket
I. 04/22 12:37:56. connect
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 550 msgs/rem1/.cons: Access is denied.
I. 04/22 12:37:56. Data Transfer Failed.
I. 04/22 12:37:56. closesocket
I. 04/22 12:37:56. STOR Failed!
I. 04/22 12:37:56. DELE msgs/rem1/.cons
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 550 msgs/rem1/.cons: The system cannot
find the file specified.
I. 04/22 12:37:56. Server denied permission to DELE file.
I. 04/22 12:37:56. QUIT
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 221
I. 04/22 12:37:56. Socket Closed in FTPClose.
I. 04/22 12:37:56. closesocket
I. 04/22 12:37:56. socket
I. 04/22 12:37:56. connect ftp
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 220 Microsoft FTP Service
I. 04/22 12:37:56. USER priyanka_kohli
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 331 Password required for priyanka_kohli.
I. 04/22 12:37:56. User accepted with a password needed.
I. 04/22 12:37:56. PASS
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 230 User priyanka_kohli logged in.
I. 04/22 12:37:56. Password Accepted.
I. 04/22 12:37:56. STOR "msgs/rem1/.cons"
I. 04/22 12:37:56. TYPE I
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 200 Type set to I.
I. 04/22 12:37:56. Type set.
I. 04/22 12:37:56. PASV
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 227 Entering Passive Mode
(10,40,40,16,12,163)
.
I. 04/22 12:37:56. PASV command accepted.
I. 04/22 12:37:56. STOR msgs/rem1/.cons
I. 04/22 12:37:56. socket
I. 04/22 12:37:56. connect
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 550 msgs/rem1/.cons: Access is denied.
I. 04/22 12:37:56. Data Transfer Failed.
I. 04/22 12:37:56. closesocket
I. 04/22 12:37:56. STOR Failed!
I. 04/22 12:37:56. DELE msgs/rem1/.cons
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 550 msgs/rem1/.cons: The system cannot
find the file specified.
I. 04/22 12:37:56. Server denied permission to DELE file.
I. 04/22 12:37:56. QUIT
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 221
I. 04/22 12:37:56. Socket Closed in FTPClose.
I. 04/22 12:37:56. closesocket
I. 04/22 12:37:56. socket
I. 04/22 12:37:56. connect ftp
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 220 Microsoft FTP Service
I. 04/22 12:37:56. USER priyanka_kohli
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 331 Password required for priyanka_kohli.
I. 04/22 12:37:56. User accepted with a password needed.
I. 04/22 12:37:56. PASS
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 230 User priyanka_kohli logged in.
I. 04/22 12:37:56. Password Accepted.
I. 04/22 12:37:56. STOR "msgs/rem1/.cons"
I. 04/22 12:37:56. TYPE I
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 200 Type set to I.
I. 04/22 12:37:56. Type set.
I. 04/22 12:37:56. PASV
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 227 Entering Passive Mode
(10,40,40,16,12,164)
.
I. 04/22 12:37:56. PASV command accepted.
I. 04/22 12:37:56. STOR msgs/rem1/.cons
I. 04/22 12:37:56. socket
I. 04/22 12:37:56. connect
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 550 msgs/rem1/.cons: Access is denied.
I. 04/22 12:37:56. Data Transfer Failed.
I. 04/22 12:37:56. closesocket
I. 04/22 12:37:56. STOR Failed!
I. 04/22 12:37:56. DELE msgs/rem1/.cons
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 550 msgs/rem1/.cons: The system cannot
find the file specified.
I. 04/22 12:37:56. Server denied permission to DELE file.
I. 04/22 12:37:56. QUIT
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 221
I. 04/22 12:37:56. Socket Closed in FTPClose.
I. 04/22 12:37:56. closesocket
I. 04/22 12:37:56. socket
I. 04/22 12:37:56. connect ftp
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 220 Microsoft FTP Service
I. 04/22 12:37:56. USER priyanka_kohli
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 331 Password required for priyanka_kohli.
I. 04/22 12:37:56. User accepted with a password needed.
I. 04/22 12:37:56. PASS
I. 04/22 12:37:56. Getting server response:
I. 04/22 12:37:56. 230 User priyanka_kohli logged in.
I. 04/22 12:37:56. Password Accepted.
I. 04/22 12:37:56. Resend requests are being queued
I. 04/22 12:37:57. QUIT
I. 04/22 12:37:57. Getting server response:
I. 04/22 12:37:57. 221
I. 04/22 12:37:57. Socket Closed in FTPClose.
I. 04/22 12:37:57. closesocket
I. 04/22 12:37:57. Execution completed
>
>
> Alternatively you should open a case with Tech Support to
> work through this manner in a timely, interactive manner.
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
>
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available
> through the iAnywhere Developer Community at
> www.ianywhere.com/developer <Priyanka> wrote in message
>
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
>
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
> does not work; Outside of replication, try to PUT a file
>
http://www.ianywhere.com/developer/...n9/00000218.htm
>
>
| |
| priyanka 2005-04-22, 7:23 am |
| and on remote server it is
giving this result
I. 04/22 12:59:08.
I. 04/22 12:59:08. Scanning logs starting at offset
0655053302
I. 04/22 12:59:08. Processing transaction logs from
directory "C:\TRS\"
I. 04/22 12:59:08. Processing transactions from active
transaction log
I. 04/22 12:59:09. Sending message to "cons1"
(0-0000000000-0655059134-0)
I. 04/22 12:59:09. STOR Failed!
I. 04/22 12:59:09. Server denied permission to DELE file.
I. 04/22 12:59:09. STOR Failed!
I. 04/22 12:59:09. Server denied permission to DELE file.
I. 04/22 12:59:09. STOR Failed!
I. 04/22 12:59:09. Server denied permission to DELE file.
I. 04/22 12:59:09. STOR Failed!
I. 04/22 12:59:09. Server denied permission to DELE file.
I. 04/22 12:59:09. STOR Failed!
I. 04/22 12:59:09. Server denied permission to DELE file.
I. 04/22 12:59:09. Resend requests are being queued
I. 04/22 12:59:09. Execution completed
> this is the result when I use
> (dbremote -c -o priya " uid=dba;pwd=sql;dbf=
P:\")
> is this
>
> I. 04/22 12:37:55. SQL Remote Message Link Version
> 8.0.2.3601
> I. 04/22 12:37:55. socket
> I. 04/22 12:37:55. connect ftp
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 220 Microsoft FTP Service
> I. 04/22 12:37:55. USER priyanka_kohli
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 331 Password required for
> priyanka_kohli I. 04/22 12:37:55. User accepted with a
> password needed. I. 04/22 12:37:55. PASS
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 230 User priyanka_kohli logged in.
> I. 04/22 12:37:55. Password Accepted.
> I. 04/22 12:37:55. PWD
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 257 "/" is current directory.
> I. 04/22 12:37:55. TYPE A N
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 200 Type set to A.
> I. 04/22 12:37:55. Type set.
> I. 04/22 12:37:55. PASV
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 227 Entering Passive Mode
> (10,40,40,16,12,159)
.
> I. 04/22 12:37:55. PASV command accepted.
> I. 04/22 12:37:55. NLST msgs/cons/
> I. 04/22 12:37:55. socket
> I. 04/22 12:37:55. connect
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 125 Data connection already open;
> Transfer starting.
> I. 04/22 12:37:55. 0 byte read...socket is closed
> I. 04/22 12:37:55. closesocket
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 226 Transfer complete.
> I. 04/22 12:37:55. closesocket
> I. 04/22 12:37:55.
> I. 04/22 12:37:55. Scanning logs starting at offset
> 0655056372
> I. 04/22 12:37:55. Sending message to "rem2"
> (0-0000000000-0655066005-0)
> I. 04/22 12:37:55. STOR "msgs/rem1/.cons"
> I. 04/22 12:37:55. TYPE I
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 200 Type set to I.
> I. 04/22 12:37:55. Type set.
> I. 04/22 12:37:55. PASV
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 227 Entering Passive Mode
> (10,40,40,16,12,160)
.
> I. 04/22 12:37:55. PASV command accepted.
> I. 04/22 12:37:55. STOR msgs/rem1/.cons
> I. 04/22 12:37:55. socket
> I. 04/22 12:37:55. connect
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 550 msgs/rem1/.cons: Access is denied.
> I. 04/22 12:37:55. Data Transfer Failed.
> I. 04/22 12:37:55. closesocket
> I. 04/22 12:37:55. STOR Failed!
> I. 04/22 12:37:55. DELE msgs/rem1/.cons
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 550 msgs/rem1/.cons: The system cannot
> find the file specified.
> I. 04/22 12:37:55. Server denied permission to DELE file.
> I. 04/22 12:37:55. QUIT
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 221
> I. 04/22 12:37:55. Socket Closed in FTPClose.
> I. 04/22 12:37:55. closesocket
> I. 04/22 12:37:56. socket
> I. 04/22 12:37:56. connect ftp
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 220 Microsoft FTP Service
> I. 04/22 12:37:56. USER priyanka_kohli
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 331 Password required for
> priyanka_kohli. I. 04/22 12:37:56. User accepted with a
> password needed. I. 04/22 12:37:56. PASS
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 230 User priyanka_kohli logged in.
> I. 04/22 12:37:56. Password Accepted.
> I. 04/22 12:37:56. STOR "msgs/rem1/.cons"
> I. 04/22 12:37:56. TYPE I
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 200 Type set to I.
> I. 04/22 12:37:56. Type set.
> I. 04/22 12:37:56. PASV
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 227 Entering Passive Mode
> (10,40,40,16,12,161)
.
> I. 04/22 12:37:56. PASV command accepted.
> I. 04/22 12:37:56. STOR msgs/rem1/.cons
> I. 04/22 12:37:56. socket
> I. 04/22 12:37:56. connect
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 550 msgs/rem1/.cons: Access is denied.
> I. 04/22 12:37:56. Data Transfer Failed.
> I. 04/22 12:37:56. closesocket
> I. 04/22 12:37:56. STOR Failed!
> I. 04/22 12:37:56. DELE msgs/rem1/.cons
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 550 msgs/rem1/.cons: The system cannot
> find the file specified.
> I. 04/22 12:37:56. Server denied permission to DELE file.
> I. 04/22 12:37:56. QUIT
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 221
> I. 04/22 12:37:56. Socket Closed in FTPClose.
> I. 04/22 12:37:56. closesocket
> I. 04/22 12:37:56. socket
> I. 04/22 12:37:56. connect ftp
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 220 Microsoft FTP Service
> I. 04/22 12:37:56. USER priyanka_kohli
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 331 Password required for
> priyanka_kohli. I. 04/22 12:37:56. User accepted with a
> password needed. I. 04/22 12:37:56. PASS
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 230 User priyanka_kohli logged in.
> I. 04/22 12:37:56. Password Accepted.
> I. 04/22 12:37:56. STOR "msgs/rem1/.cons"
> I. 04/22 12:37:56. TYPE I
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 200 Type set to I.
> I. 04/22 12:37:56. Type set.
> I. 04/22 12:37:56. PASV
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 227 Entering Passive Mode
> (10,40,40,16,12,162)
.
> I. 04/22 12:37:56. PASV command accepted.
> I. 04/22 12:37:56. STOR msgs/rem1/.cons
> I. 04/22 12:37:56. socket
> I. 04/22 12:37:56. connect
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 550 msgs/rem1/.cons: Access is denied.
> I. 04/22 12:37:56. Data Transfer Failed.
> I. 04/22 12:37:56. closesocket
> I. 04/22 12:37:56. STOR Failed!
> I. 04/22 12:37:56. DELE msgs/rem1/.cons
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 550 msgs/rem1/.cons: The system cannot
> find the file specified.
> I. 04/22 12:37:56. Server denied permission to DELE file.
> I. 04/22 12:37:56. QUIT
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 221
> I. 04/22 12:37:56. Socket Closed in FTPClose.
> I. 04/22 12:37:56. closesocket
> I. 04/22 12:37:56. socket
> I. 04/22 12:37:56. connect ftp
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 220 Microsoft FTP Service
> I. 04/22 12:37:56. USER priyanka_kohli
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 331 Password required for
> priyanka_kohli. I. 04/22 12:37:56. User accepted with a
> password needed. I. 04/22 12:37:56. PASS
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 230 User priyanka_kohli logged in.
> I. 04/22 12:37:56. Password Accepted.
> I. 04/22 12:37:56. STOR "msgs/rem1/.cons"
> I. 04/22 12:37:56. TYPE I
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 200 Type set to I.
> I. 04/22 12:37:56. Type set.
> I. 04/22 12:37:56. PASV
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 227 Entering Passive Mode
> (10,40,40,16,12,163)
.
> I. 04/22 12:37:56. PASV command accepted.
> I. 04/22 12:37:56. STOR msgs/rem1/.cons
> I. 04/22 12:37:56. socket
> I. 04/22 12:37:56. connect
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 550 msgs/rem1/.cons: Access is denied.
> I. 04/22 12:37:56. Data Transfer Failed.
> I. 04/22 12:37:56. closesocket
> I. 04/22 12:37:56. STOR Failed!
> I. 04/22 12:37:56. DELE msgs/rem1/.cons
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 550 msgs/rem1/.cons: The system cannot
> find the file specified.
> I. 04/22 12:37:56. Server denied permission to DELE file.
> I. 04/22 12:37:56. QUIT
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 221
> I. 04/22 12:37:56. Socket Closed in FTPClose.
> I. 04/22 12:37:56. closesocket
> I. 04/22 12:37:56. socket
> I. 04/22 12:37:56. connect ftp
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 220 Microsoft FTP Service
> I. 04/22 12:37:56. USER priyanka_kohli
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 331 Password required for
> priyanka_kohli. I. 04/22 12:37:56. User accepted with a
> password needed. I. 04/22 12:37:56. PASS
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 230 User priyanka_kohli logged in.
> I. 04/22 12:37:56. Password Accepted.
> I. 04/22 12:37:56. STOR "msgs/rem1/.cons"
> I. 04/22 12:37:56. TYPE I
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 200 Type set to I.
> I. 04/22 12:37:56. Type set.
> I. 04/22 12:37:56. PASV
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 227 Entering Passive Mode
> (10,40,40,16,12,164)
.
> I. 04/22 12:37:56. PASV command accepted.
> I. 04/22 12:37:56. STOR msgs/rem1/.cons
> I. 04/22 12:37:56. socket
> I. 04/22 12:37:56. connect
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 550 msgs/rem1/.cons: Access is denied.
> I. 04/22 12:37:56. Data Transfer Failed.
> I. 04/22 12:37:56. closesocket
> I. 04/22 12:37:56. STOR Failed!
> I. 04/22 12:37:56. DELE msgs/rem1/.cons
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 550 msgs/rem1/.cons: The system cannot
> find the file specified.
> I. 04/22 12:37:56. Server denied permission to DELE file.
> I. 04/22 12:37:56. QUIT
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 221
> I. 04/22 12:37:56. Socket Closed in FTPClose.
> I. 04/22 12:37:56. closesocket
> I. 04/22 12:37:56. socket
> I. 04/22 12:37:56. connect ftp
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 220 Microsoft FTP Service
> I. 04/22 12:37:56. USER priyanka_kohli
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 331 Password required for
> priyanka_kohli. I. 04/22 12:37:56. User accepted with a
> password needed. I. 04/22 12:37:56. PASS
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 230 User priyanka_kohli logged in.
> I. 04/22 12:37:56. Password Accepted.
> I. 04/22 12:37:56. Resend requests are being queued
> I. 04/22 12:37:57. QUIT
> I. 04/22 12:37:57. Getting server response:
> I. 04/22 12:37:57. 221
> I. 04/22 12:37:57. Socket Closed in FTPClose.
> I. 04/22 12:37:57. closesocket
> I. 04/22 12:37:57. Execution completed
>
>
> manner. >
> all >
>
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
>
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
>
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
>
http://www.ianywhere.com/developer/...n9/00000218.htm[color=darkred]
| |
| Rob Waywell 2005-04-22, 7:23 am |
| The connection parameters need to immediately follow the -c parameter:
dbremote -c " uid=dba;pwd=sql;dbf=
P:\" -o priya
You also need to properly specify the database *file* for the dbf parameter.
dbf=P:\ does not specify the file name, it should be something like
dbf=P:\mydatabasefil
enamehere.db
These lines of output:
....
> I. 04/22 12:37:55. 550 msgs/rem1/.cons: Access is denied.
....
> I. 04/22 12:37:56. 550 msgs/rem1/.cons: Access is denied.
....
clearly show that the FTP server is telling us that this user id does not
have permissions to write the message file to that directory location. When
you manually tested the PUT command from a command prompt FTP utility did
you specifically try to put a file to the "msgs/rem1" directory?
These lines of output shows that dbremote is connecting to the FTP server
using the user ID "priyanka_kohli"
> I. 04/22 12:37:55. USER priyanka_kohli
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 331 Password required for priyanka_kohli
> I. 04/22 12:37:55. User accepted with a password needed.
Earlier in the thread you said that you were using the user ID "priyanka".
When you tested putting the file manually to the FTP server which user ID
did you test with? Have you specifically tested the permissions of the user
ID "priyanka_kohli"?
The output also shows that "rem2" appears to be assigned the ftp directory
of "msgs/rem1"
> I. 04/22 12:37:55. Sending message to "rem2"
> (0-0000000000-0655066005-0)
> I. 04/22 12:37:55. STOR "msgs/rem1/.cons"
Is this intentional? If so, then what message directory is "rem1" using?
Dbremote assumes that all messages in the inbox/incoming directory belong to
the current database, you can not share a directory between multiple nodes
in a SQL Remote environment.
--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional
Sybase's iAnywhere Solutions
Please respond ONLY to newsgroup
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
<Priyanka> wrote in message news:4268d61e.e0b.1681692777@sybase.com...
> this is the result when I use
> (dbremote -c -o priya " uid=dba;pwd=sql;dbf=
P:\")
> is this
>
> I. 04/22 12:37:55. SQL Remote Message Link Version
> 8.0.2.3601
> I. 04/22 12:37:55. socket
> I. 04/22 12:37:55. connect ftp
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 220 Microsoft FTP Service
> I. 04/22 12:37:55. USER priyanka_kohli
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 331 Password required for priyanka_kohli
> I. 04/22 12:37:55. User accepted with a password needed.
> I. 04/22 12:37:55. PASS
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 230 User priyanka_kohli logged in.
> I. 04/22 12:37:55. Password Accepted.
> I. 04/22 12:37:55. PWD
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 257 "/" is current directory.
> I. 04/22 12:37:55. TYPE A N
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 200 Type set to A.
> I. 04/22 12:37:55. Type set.
> I. 04/22 12:37:55. PASV
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 227 Entering Passive Mode
> (10,40,40,16,12,159)
.
> I. 04/22 12:37:55. PASV command accepted.
> I. 04/22 12:37:55. NLST msgs/cons/
> I. 04/22 12:37:55. socket
> I. 04/22 12:37:55. connect
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 125 Data connection already open;
> Transfer starting.
> I. 04/22 12:37:55. 0 byte read...socket is closed
> I. 04/22 12:37:55. closesocket
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 226 Transfer complete.
> I. 04/22 12:37:55. closesocket
> I. 04/22 12:37:55.
> I. 04/22 12:37:55. Scanning logs starting at offset
> 0655056372
> I. 04/22 12:37:55. Sending message to "rem2"
> (0-0000000000-0655066005-0)
> I. 04/22 12:37:55. STOR "msgs/rem1/.cons"
> I. 04/22 12:37:55. TYPE I
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 200 Type set to I.
> I. 04/22 12:37:55. Type set.
> I. 04/22 12:37:55. PASV
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 227 Entering Passive Mode
> (10,40,40,16,12,160)
.
> I. 04/22 12:37:55. PASV command accepted.
> I. 04/22 12:37:55. STOR msgs/rem1/.cons
> I. 04/22 12:37:55. socket
> I. 04/22 12:37:55. connect
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 550 msgs/rem1/.cons: Access is denied.
> I. 04/22 12:37:55. Data Transfer Failed.
> I. 04/22 12:37:55. closesocket
> I. 04/22 12:37:55. STOR Failed!
> I. 04/22 12:37:55. DELE msgs/rem1/.cons
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 550 msgs/rem1/.cons: The system cannot
> find the file specified.
> I. 04/22 12:37:55. Server denied permission to DELE file.
> I. 04/22 12:37:55. QUIT
> I. 04/22 12:37:55. Getting server response:
> I. 04/22 12:37:55. 221
> I. 04/22 12:37:55. Socket Closed in FTPClose.
> I. 04/22 12:37:55. closesocket
> I. 04/22 12:37:56. socket
> I. 04/22 12:37:56. connect ftp
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 220 Microsoft FTP Service
> I. 04/22 12:37:56. USER priyanka_kohli
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 331 Password required for priyanka_kohli.
> I. 04/22 12:37:56. User accepted with a password needed.
> I. 04/22 12:37:56. PASS
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 230 User priyanka_kohli logged in.
> I. 04/22 12:37:56. Password Accepted.
> I. 04/22 12:37:56. STOR "msgs/rem1/.cons"
> I. 04/22 12:37:56. TYPE I
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 200 Type set to I.
> I. 04/22 12:37:56. Type set.
> I. 04/22 12:37:56. PASV
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 227 Entering Passive Mode
> (10,40,40,16,12,161)
.
> I. 04/22 12:37:56. PASV command accepted.
> I. 04/22 12:37:56. STOR msgs/rem1/.cons
> I. 04/22 12:37:56. socket
> I. 04/22 12:37:56. connect
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 550 msgs/rem1/.cons: Access is denied.
> I. 04/22 12:37:56. Data Transfer Failed.
> I. 04/22 12:37:56. closesocket
> I. 04/22 12:37:56. STOR Failed!
> I. 04/22 12:37:56. DELE msgs/rem1/.cons
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 550 msgs/rem1/.cons: The system cannot
> find the file specified.
> I. 04/22 12:37:56. Server denied permission to DELE file.
> I. 04/22 12:37:56. QUIT
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 221
> I. 04/22 12:37:56. Socket Closed in FTPClose.
> I. 04/22 12:37:56. closesocket
> I. 04/22 12:37:56. socket
> I. 04/22 12:37:56. connect ftp
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 220 Microsoft FTP Service
> I. 04/22 12:37:56. USER priyanka_kohli
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 331 Password required for priyanka_kohli.
> I. 04/22 12:37:56. User accepted with a password needed.
> I. 04/22 12:37:56. PASS
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 230 User priyanka_kohli logged in.
> I. 04/22 12:37:56. Password Accepted.
> I. 04/22 12:37:56. STOR "msgs/rem1/.cons"
> I. 04/22 12:37:56. TYPE I
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 200 Type set to I.
> I. 04/22 12:37:56. Type set.
> I. 04/22 12:37:56. PASV
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 227 Entering Passive Mode
> (10,40,40,16,12,162)
.
> I. 04/22 12:37:56. PASV command accepted.
> I. 04/22 12:37:56. STOR msgs/rem1/.cons
> I. 04/22 12:37:56. socket
> I. 04/22 12:37:56. connect
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 550 msgs/rem1/.cons: Access is denied.
> I. 04/22 12:37:56. Data Transfer Failed.
> I. 04/22 12:37:56. closesocket
> I. 04/22 12:37:56. STOR Failed!
> I. 04/22 12:37:56. DELE msgs/rem1/.cons
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 550 msgs/rem1/.cons: The system cannot
> find the file specified.
> I. 04/22 12:37:56. Server denied permission to DELE file.
> I. 04/22 12:37:56. QUIT
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 221
> I. 04/22 12:37:56. Socket Closed in FTPClose.
> I. 04/22 12:37:56. closesocket
> I. 04/22 12:37:56. socket
> I. 04/22 12:37:56. connect ftp
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 220 Microsoft FTP Service
> I. 04/22 12:37:56. USER priyanka_kohli
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 331 Password required for priyanka_kohli.
> I. 04/22 12:37:56. User accepted with a password needed.
> I. 04/22 12:37:56. PASS
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 230 User priyanka_kohli logged in.
> I. 04/22 12:37:56. Password Accepted.
> I. 04/22 12:37:56. STOR "msgs/rem1/.cons"
> I. 04/22 12:37:56. TYPE I
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 200 Type set to I.
> I. 04/22 12:37:56. Type set.
> I. 04/22 12:37:56. PASV
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 227 Entering Passive Mode
> (10,40,40,16,12,163)
.
> I. 04/22 12:37:56. PASV command accepted.
> I. 04/22 12:37:56. STOR msgs/rem1/.cons
> I. 04/22 12:37:56. socket
> I. 04/22 12:37:56. connect
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 550 msgs/rem1/.cons: Access is denied.
> I. 04/22 12:37:56. Data Transfer Failed.
> I. 04/22 12:37:56. closesocket
> I. 04/22 12:37:56. STOR Failed!
> I. 04/22 12:37:56. DELE msgs/rem1/.cons
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 550 msgs/rem1/.cons: The system cannot
> find the file specified.
> I. 04/22 12:37:56. Server denied permission to DELE file.
> I. 04/22 12:37:56. QUIT
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 221
> I. 04/22 12:37:56. Socket Closed in FTPClose.
> I. 04/22 12:37:56. closesocket
> I. 04/22 12:37:56. socket
> I. 04/22 12:37:56. connect ftp
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 220 Microsoft FTP Service
> I. 04/22 12:37:56. USER priyanka_kohli
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 331 Password required for priyanka_kohli.
> I. 04/22 12:37:56. User accepted with a password needed.
> I. 04/22 12:37:56. PASS
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 230 User priyanka_kohli logged in.
> I. 04/22 12:37:56. Password Accepted.
> I. 04/22 12:37:56. STOR "msgs/rem1/.cons"
> I. 04/22 12:37:56. TYPE I
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 200 Type set to I.
> I. 04/22 12:37:56. Type set.
> I. 04/22 12:37:56. PASV
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 227 Entering Passive Mode
> (10,40,40,16,12,164)
.
> I. 04/22 12:37:56. PASV command accepted.
> I. 04/22 12:37:56. STOR msgs/rem1/.cons
> I. 04/22 12:37:56. socket
> I. 04/22 12:37:56. connect
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 550 msgs/rem1/.cons: Access is denied.
> I. 04/22 12:37:56. Data Transfer Failed.
> I. 04/22 12:37:56. closesocket
> I. 04/22 12:37:56. STOR Failed!
> I. 04/22 12:37:56. DELE msgs/rem1/.cons
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 550 msgs/rem1/.cons: The system cannot
> find the file specified.
> I. 04/22 12:37:56. Server denied permission to DELE file.
> I. 04/22 12:37:56. QUIT
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 221
> I. 04/22 12:37:56. Socket Closed in FTPClose.
> I. 04/22 12:37:56. closesocket
> I. 04/22 12:37:56. socket
> I. 04/22 12:37:56. connect ftp
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 220 Microsoft FTP Service
> I. 04/22 12:37:56. USER priyanka_kohli
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 331 Password required for priyanka_kohli.
> I. 04/22 12:37:56. User accepted with a password needed.
> I. 04/22 12:37:56. PASS
> I. 04/22 12:37:56. Getting server response:
> I. 04/22 12:37:56. 230 User priyanka_kohli logged in.
> I. 04/22 12:37:56. Password Accepted.
> I. 04/22 12:37:56. Resend requests are being queued
> I. 04/22 12:37:57. QUIT
> I. 04/22 12:37:57. Getting server response:
> I. 04/22 12:37:57. 221
> I. 04/22 12:37:57. Socket Closed in FTPClose.
> I. 04/22 12:37:57. closesocket
> I. 04/22 12:37:57. Execution completed
>
>
>
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
>
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
>
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
>
http://www.ianywhere.com/developer/...n9/00000218.htm[color=darkred]
| |
| Priyanka 2005-04-25, 8:24 pm |
|
Yes you are right, I didn't have permission to access that
folder.
I change permission to full control then also it is not
working!!!
What kind of permission I should have!
Do I have to make that folder shareable?
>When you manually tested
> the PUT command from a command prompt FTP utility did you
> specifically try to put a file to the "msgs/rem1"
> directory?
Yes I am using Priyanka_Kohli user name for both.
> The output also shows that "rem2" appears to be assigned
> the ftp directory of "msgs/rem1"
Yes I have given address of "rem2" directory to "rem1".
I have made a directory at ftp root called "msgs" and under
that created two subdirectory called "rem1" and "cons"
So assigned address of " rem1" to rem2
and address of "cons1" to cons.
>Dbremote assumes that all messages in the
> inbox/incoming directory belong to the current database,
> you can not share a directory between multiple nodes in a
> SQL Remote environment. --
I didn't understand that
regards,
Priyanka
> The connection parameters need to immediately follow the
> -c parameter:
>
> dbremote -c " uid=dba;pwd=sql;dbf=
P:\" -o priya
>
> You also need to properly specify the database *file* for
> the dbf parameter. dbf=P:\ does not specify the file name,
> it should be something like
> dbf=P:\mydatabasefil
enamehere.db
>
> These lines of output:
> ...
> denied. ....
> denied. ....
>
> clearly show that the FTP server is telling us that this
> user id does not have permissions to write the message
> file to that directory location. When you manually tested
> the PUT command from a command prompt FTP utility did you
> specifically try to put a file to the "msgs/rem1"
> directory?
>
> These lines of output shows that dbremote is connecting to
> the FTP server using the user ID "priyanka_kohli"
>
> password needed.
>
> Earlier in the thread you said that you were using the
> user ID "priyanka". When you tested putting the file
> manually to the FTP server which user ID did you test
> with? Have you specifically tested the permissions of the
> user ID "priyanka_kohli"?
>
> The output also shows that "rem2" appears to be assigned
> the ftp directory of "msgs/rem1"
>
>
> Is this intentional? If so, then what message directory is
> "rem1" using? Dbremote assumes that all messages in the
> inbox/incoming directory belong to the current database,
> you can not share a directory between multiple nodes in a
> SQL Remote environment. --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
>
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available
> through the iAnywhere Developer Community at
> www.ianywhere.com/developer <Priyanka> wrote in message
>
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
>
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
> ----------------------------------------------- Robert
>
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
>
http://www.ianywhere.com/developer/...n9/00000218.htm
> news:425d26fb.74d3.1681692777@sybase.com... Hello , >> >
> connecting to the host, open socket. >> > My Folder is on
>
>
| |
|
|
| Priyanka 2005-04-26, 8:23 pm |
| Yes I said that because I understand it in general term if I
try to connect to the ftp server through dos I am able to do
that and once I am connected.
If now I use the "dir" command it return me all the
directory which is there so I thought I can read the
content.
But now I tried the "put" and "get" command it does not
work it give the same error "155: permission denied".
Regards
> You need to be able to navigate to the folder and be able
> to read and write content there.
>
> I am a little surprised that you were able to read/write a
> file to that site if you did not have the necessary
> permissions (my initial post in this thread).
>
> <Priyanka> wrote in message
> news:426d419c.17fc.1681692777@sybase.com... >
> you >> specifically try to put a file to the "msgs/rem1"
> assigned >> the ftp directory of "msgs/rem1"
> "rem1". >
> "cons" >
> , >> you can not share a directory between multiple nodes
> in a >> SQL Remote environment. --
> the >> -c parameter:
> for >> the dbf parameter. dbf=P:\ does not specify the
> file name, >> it should be something like
> this >> user id does not have permissions to write the
> message >> file to that directory location. When you
> manually tested >> the PUT command from a command prompt
> FTP utility did you >> specifically try to put a file to
> the "msgs/rem1" >> directory?
> to >> the FTP server using the user ID "priyanka_kohli"
> a >> password needed.
> the >> user ID "priyanka_kohli"?
> assigned >> the ftp directory of "msgs/rem1"
> is >> "rem1" using? Dbremote assumes that all messages in
> the >> inbox/incoming directory belong to the current
> database, >> you can not share a directory between
> multiple nodes in a >> SQL Remote environment. --
> all >>
>
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
> Status >> http://my.sybase.com/detail?id=1002288
> the >> > result when I use (dbremote -c -o priya "uid=dba
> a >> > password needed. I. 04/22 12:37:55. PASS
> a >> > password needed. I. 04/22 12:37:56. PASS
> a >> > password needed. I. 04/22 12:37:56. PASS
> a >> > password needed. I. 04/22 12:37:56. PASS
> a >> > password needed. I. 04/22 12:37:56. PASS
> a >> > password needed. I. 04/22 12:37:56. PASS
> including >> > > > the -o parameter. Once we can get the
> output then >> > > > we'll have a lot more information to
> work with. >> > >
> Support >> > > to work through this manner in a timely,
> interactive >> > manner. >
> 8 >> > > Sybase Certified Professional
> to >> > all >
>
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
> available >> > > through the iAnywhere Developer Community
> at >> > > www.ianywhere.com/developer <Priyanka> wrote in
> news:426669f8.3b2a.1681692777@sybase.com... >> > > Hi, >
> to >> > > work with. >
> name >> > > > also but it does not store anything on that
> location >> > > > ,how it works can you explain me.
> will >> > > > > let you see if you are being prompted for
> mode, >> > > > > so try changing it. 3) Show us your
> command line >> > > > > for dbremote including the -o
> parameter. Once we >> > > > > can get the output then
> we'll have a lot more >> > > > information to work with. >
> frame' >> > > > to all >
>
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
> http://downloads.sybase.com >> > > > > > > choose SQL
> Anywhere Studio >> change 'time >> > > > > > frame' to all
>
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
> all >> > > > > > > available through the iAnywhere
> Developer >> > > > > > > Community at
> www.ianywhere.com/developer >> > > > > > > > <PRIYANKA>
> wrote in message >> > > > > > > >
> news:4263baee.19fd.1681692777@sybase.com... >> > > > > > >
> ,but it does not work; Outside of replication, >> > > > >
> news:425e6809.3ac.1681692777@sybase.com... >> > > > > > >
> on >> > > > > > > > > >> the FTP Server. >>
>
http://www.ianywhere.com/developer/...n9/00000218.htm
> Support >> > > > > > > > > Analyst >>
> using >> > > > > > > > > to store message. >> > >> > It is
> on >> > > > > > > > > the location where we have installed
> FTP >> > > > > > > > > >> > Server. >> >
>
>
|
|
|
|
|