读取ftp上传过来的xls 之 ftp上传文件权限问题

最新推荐文章于 2024-08-15 11:26:59 发布

weixin_34267123

最新推荐文章于 2024-08-15 11:26:59 发布

阅读量650

点赞数

文章标签： java python

原文链接：https://my.oschina.net/yizhichao/blog/1611465

版权

2019独角兽企业重金招聘Python工程师标准>>>

[/RSS_DATA/omc172_0_0_110/deviceOffLineAndOnlineDuration/DeviceOffLineAndOnlineDuration_20180119.1.xls] is not existed
2018-01-22 22:32:45.004 *ERROR* [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-7] com.allcam.adapter.utils.excel.XLSProxy Line:145 - Exception
java.io.FileNotFoundException: /RSS_DATA/omc172_0_0_13/deviceOffLineDetail/DeviceOffLineDetail_20180119.xls (权限不够)

vi /etc/vsftpd.conf

改成012或者002

要重启ftp服务
rcvsftpd restart

测试ftp上传文件

ftp

open 172.0.0.95 9041

输入账号

输入密码

dir

put "c:\test.txt"

可以看到上传成功：

权限

rw-rw-r--

-rw-rw-r--

一共有10位数，其中：

最前面那个 - 代表的是类型
中间那三个 rw- 代表的是所有者（user）
然后那三个 rw- 代表的是组群（group）
最后那三个 r-- 代表的是其他人（other）

-rw------- (600) 只有所有者才有读和写的权限
-rw-r--r-- (644) 只有所有者才有读和写的权限，组群和其他人只有读的权限
-rwx------ (700) 只有所有者才有读，写，执行的权限
-rwxr-xr-x (755) 只有所有者才有读，写，执行的权限，组群和其他人只有读和执行的权限
-rwx--x--x (711) 只有所有者才有读，写，执行的权限，组群和其他人只有执行的权限
-rw-rw-rw- (666) 每个人都有读写的权限
-rwxrwxrwx (777) 每个人都有读写和执行的权限

   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
2018-01-22 22:32:40.031 *ERROR* [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-6] com.allcam.adapter.rss.system.job.SyncDataJob Line:117 - XLSProxy.readXls(CameraOffLineAndOnlineDurationInfo.class.getName(), readOnlineDuration) pathOnlineDuration [/RSS_DATA/omc172_0_0_110/deviceOffLineAndOnlineDuration/DeviceOffLineAndOnlineDuration_20180119.1.xls] is not existed
2018-01-22 22:32:45.004 *ERROR* [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-7] com.allcam.adapter.utils.excel.XLSProxy Line:145 - Exception
java.io.FileNotFoundException: /RSS_DATA/omc172_0_0_13/deviceOffLineDetail/DeviceOffLineDetail_20180119.xls (权限不够)
   at java.io.RandomAccessFile.open0(Native Method)
   at java.io.RandomAccessFile.open(RandomAccessFile.java:316)
   at java.io.RandomAccessFile.<init>(RandomAccessFile.java:243)
   at org.apache.poi.poifs.nio.FileBackedDataSource.newSrcFile(FileBackedDataSource.java:161)
   at org.apache.poi.poifs.nio.FileBackedDataSource.<init>(FileBackedDataSource.java:64)
   at org.apache.poi.poifs.filesystem.NPOIFSFileSystem.<init>(NPOIFSFileSystem.java:219)
   at org.apache.poi.poifs.filesystem.NPOIFSFileSystem.<init>(NPOIFSFileSystem.java:167)
   at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:254)
   at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:226)
   at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:205)
   at com.allcam.adapter.utils.excel.XLSProxy.readXls(XLSProxy.java:54)
   at com.allcam.adapter.rss.system.job.SyncDataJob.readXlsCameraOnOffLine(SyncDataJob.java:188)
   at com.allcam.adapter.rss.system.job.SyncDataJob.reportOnOffLineDetailProc(SyncDataJob.java:144)
   at com.allcam.adapter.rss.system.job.SyncDataJob.syncDataJob(SyncDataJob.java:66)
   at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:498)
   at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:265)
   at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:257)
   at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
2018-01-22 22:32:45.005 *ERROR* [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-7] com.allcam.adapter.rss.system.job.SyncDataJob Line:192 - XLSProxy.readXls(CameraOnOffLineInfo.class.getName(), readOffLineDetail) Exception
java.lang.Exception: 导入出错，请检查Excel格式
   at com.allcam.adapter.utils.excel.XLSProxy.readXls(XLSProxy.java:150)
   at com.allcam.adapter.rss.system.job.SyncDataJob.readXlsCameraOnOffLine(SyncDataJob.java:188)
   at com.allcam.adapter.rss.system.job.SyncDataJob.reportOnOffLineDetailProc(SyncDataJob.java:144)
   at com.allcam.adapter.rss.system.job.SyncDataJob.syncDataJob(SyncDataJob.java:66)
   at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:498)
   at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:265)
   at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:257)
   at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)