zhao0 / ipapk-server Goto Github PK

更新了sqlite3以后 首页展示数据发生错误.
sqlite3更新到3.24以后
首页展示数据通过

select * from info where platform='ios' group by bundleID order by uploadTime desc limit 0,5

这条语句无法正确执行.
根据代码观察
应该替换成如下sql

select *
from (select id,
             guid,
             bundleID,
             version,
             build,
             name,
             uploadTime,
             platform,
             changelog,
             row_number() over (partition by bundleID order by uploadTime desc) number
      from info
      where platform = ?) t
where number between ? and ?

{"error":{"errno":-2,"code":"ENOENT","syscall":"rename","path":"/root/.ipapk-server/icon/c136d94f-3786-479d-9bce-097d4ef95db4_tmp.png","dest":"/root/.ipapk-server/icon/c136d94f-3786-479d-9bce-097d4ef95db4.png"}}

the iOS's package can't download.

android's package can't upload

     buffer.js:977
throw new RangeError('Index out of range');
^

RangeError: Index out of range
at checkOffset (buffer.js:977:11)
at Buffer.readUInt16LE (buffer.js:1023:5)
at parseExtra (/usr/local/lib/node_modules/ipapk-server/node_modules/_adm-zip@0.4.7@adm-zip/zipEntry.js:152:30)
at Object.set extra [as extra] (/usr/local/lib/node_modules/ipapk-server/node_modules/_adm-zip@0.4.7@adm-zip/zipEntry.js:209:13)
at readEntries (/usr/local/lib/node_modules/ipapk-server/node_modules/_adm-zip@0.4.7@adm-zip/zipFile.js:40:29)
at readMainHeader (/usr/local/lib/node_modules/ipapk-server/node_modules/_adm-zip@0.4.7@adm-zip/zipFile.js:72:9)
at new module.exports (/usr/local/lib/node_modules/ipapk-server/node_modules/_adm-zip@0.4.7@adm-zip/zipFile.js:18:9)
at new module.exports (/usr/local/lib/node_modules/ipapk-server/node_modules/_adm-zip@0.4.7@adm-zip/adm-zip.js:17:20)
at /usr/local/lib/node_modules/ipapk-server/ipapk-server.js:356:17
at parseOutput (/usr/local/lib/node_modules/ipapk-server/node_modules/[email protected]@apk-parser3/lib/index.js:42:10)

pngdefry : seen 1 file(s), wrote 1 file(s)
/usr/local/lib/node_modules/ipapk-server/ipapk-server.js:302
var data = info[0];
^

TypeError: Cannot read property '0' of undefined
at /usr/local/lib/node_modules/ipapk-server/ipapk-server.js:302:22
at f (/usr/local/lib/node_modules/ipapk-server/node_modules/once/once.js:25:25)
at ZipFile. (/usr/local/lib/node_modules/ipapk-server/node_modules/ipa-extract-info/index.js:52:33)
at emitNone (events.js:106:13)
at ZipFile.emit (events.js:208:7)
at Immediate._onImmediate (/usr/local/lib/node_modules/ipapk-server/node_modules/yauzl/index.js:246:12)
at runCallback (timers.js:789:20)
at tryOnImmediate (timers.js:751:5)
at processImmediate [as _immediateCallback] (timers.js:722:5)

部分Android游览器不支持不信任证书下载 导致apk无法下载 想添加证书也没办法从服务器下载 最好支持也支持http

curl 上传文件后报错：

.nvm/versions/node/v5.6.0/lib/node_modules/ipapk-server/ipapk-server.js:209
      var obj = files.package[0];
                             ^
TypeError: Cannot read property '0' of undefined
    at /Users/herui/.nvm/versions/node/v5.6.0/lib/node_modules/ipapk-server/ipapk-server.js:209:30
    at /Users/herui/.nvm/versions/node/v5.6.0/lib/node_modules/ipapk-server/node_modules/multiparty/index.js:129:9
    at /Users/herui/.nvm/versions/node/v5.6.0/lib/node_modules/ipapk-server/node_modules/multiparty/index.js:108:9
    at nextTickCallbackWith0Args (node.js:453:9)
    at process._tickCallback (node.js:382:13)

安装的时候，有个依赖好像缺失了，报警告了：

npm WARN [email protected] requires a peer of browserify@>= 2.3.0 < 14 but none was installed.

module.js:328
throw err;
^

Error: Cannot find module 'Guid'
at Function.Module._resolveFilename (module.js:326:15)
at Function.Module._load (module.js:277:25)
at Module.require (module.js:354:17)
at require (internal/module.js:12:17)
at Object. (/usr/local/lib/node_modules/ipapk-server/ipapk-server.js:18:12)
at Module._compile (module.js:410:26)
at Object.Module._extensions..js (module.js:417:10)
at Module.load (module.js:344:32)
at Function.Module._load (module.js:301:12)
at Function.Module.runMain (module.js:442:10)

如题。

但是在iOS9.3和iOS8上就是正常的。请问是什么原因？

EACCES attempting to reinstall using temporary dev dir "/root/node-v8.11.2-linux-x86/lib/node_modules/ipapk-server/node_modules/sqlite3/.node-gyp"

the iOS's package can't download

the android's package can't upload

[root@ip-172-31-34-220 apk]# ipapk-server
internal/modules/cjs/loader.js:638
throw err;
^

Error: Cannot find module '/opt/apk/ipapk-server/node_modules/sqlite3/lib/binding/node-v64-linux-x64/node_sqlite3.node'
at Function.Module._resolveFilename (internal/modules/cjs/loader.js:636:15)
at Function.Module._load (internal/modules/cjs/loader.js:562:25)
at Module.require (internal/modules/cjs/loader.js:692:17)
at require (internal/modules/cjs/helpers.js:25:18)
at Object. (/opt/apk/ipapk-server/node_modules/sqlite3/lib/sqlite3-binding.js:4:15)
at Module._compile (internal/modules/cjs/loader.js:778:30)
at Object.Module._extensions..js (internal/modules/cjs/loader.js:789:10)
at Module.load (internal/modules/cjs/loader.js:653:32)
at tryModuleLoad (internal/modules/cjs/loader.js:593:12)
at Function.Module._load (internal/modules/cjs/loader.js:585:3)
[root@ip-172-31-34-220 apk]# vim internal/modules/cjs/loader.js

ios app upload成功，且在safari中点击安装了自签名证书，点击下载无响应

处理 icon 的时候报错：

/Users/herui/.ipapk-server/icon/46bf9893-685e-40d0-bbcf-8826e57fc867.png : not an -iphone crushed PNG file

应该是 extractIpaIcon 这个函数里面 fs.writeFile报的错。

我的尝试：

1. 确保 icon 是 png，同时试了上传微信的 ipa 包还是报这个错误
2. ios-ipa-server 项目是可以成功显示图片的，我看了下，他用的是 fs.writeFileSync，但是也会有报警：libpng warning: Input PNG is not optimized for iPhone OS. Copying source file to destination...

还是说我的 libpng 版本有问题？

node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
node-pre-gyp ERR! Pre-built binaries not found for [email protected] and [email protected] (node-v72 ABI) (falling back to source compile with node-gyp)
node-pre-gyp ERR! Tried to download(undefined): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
node-pre-gyp ERR! Pre-built binaries not found for [email protected] and [email protected] (node-v72 ABI) (falling back to source compile with node-gyp)

[1/2] scripts.install sqlite3@^3.1.8 run "node-pre-gyp install --fallback-to-build", root: "/usr/local/lib/node_modules/ipapk-server/node_modules/[email protected]@sqlite3"
node-pre-gyp http GET https://cdn.npm.taobao.org/dist/sqlite3/v3.1.13/node-v72-darwin-x64.tar.gz
node-pre-gyp http 404 https://cdn.npm.taobao.org/dist/sqlite3/v3.1.13/node-v72-darwin-x64.tar.gz
node-pre-gyp ERR! Tried to download(404): https://cdn.npm.taobao.org/dist/sqlite3/v3.1.13/node-v72-darwin-x64.tar.gz
node-pre-gyp ERR! Pre-built binaries not found for [email protected] and [email protected] (node-v72 ABI) (falling back to source compile with node-gyp)
node-pre-gyp http 404 status code downloading tarball https://cdn.npm.taobao.org/dist/sqlite3/v3.1.13/node-v72-darwin-x64.tar.gz
node-pre-gyp ERR! Tried to download(undefined): https://cdn.npm.taobao.org/dist/sqlite3/v3.1.13/node-v72-darwin-x64.tar.gz
node-pre-gyp ERR! Pre-built binaries not found for [email protected] and [email protected] (node-v72 ABI) (falling back to source compile with node-gyp)
node-pre-gyp http Connection closed while downloading tarball file

直接npm install -g ipapk-server 无法找到资源文件下载
使用taobao镜像 3.1.13版本下载没有node-v72-win32-x64.tar.gz文件

没见到错误日志 没有任何提示 就是 一直 正在载入...下载进度没任何增加
apk 下载 是好的 请问 会有什么可能吗

在centos7上安装的，安装到一半的时候无限循环报警告：gyp WARN EACCES attempting to reinstall using temporary dev dir "/usr/local/lib/node_modules/ipapk-server/node_modules/sqlite3/.node-gyp"
gyp WARN EACCES user "root" does not have permission to access the dev dir "/usr/local/lib/node_modules/ipapk-server/node_modules/sqlite3/.node-gyp/8.9.4"，这个要怎么解决呢

上传 apk 到 windows 服务器 报错
提示 parseApk Unkonwn OS!
请问 是不支持 windows 平台吗

{"error":{"errno":-18,"code":"EXDEV","syscall":"rename","path":"/tmp/dyXE5JGusg4UcNGGd6_IGVy6.apk","dest":"/home/hp/.ipapk-server/apk/1ea77120-d8e1-4fb3-bdca-8a1f411a5a6a.apk"}}

adHoc iPA里有 [email protected] 这个文件，但是上传一直不成功，提示{"error":"can not find icon "}

curl 'https://172.16.88.236:1234/upload' -F "package=@/Users/PandaApe/Desktop/untitledfolder/SIT-2017-03-04-19-28.ipa" -F "changelog=test" --insecure

传AppStore版本就是正常的。

macOS Sierra 10.12.3 安装后进入含有ipa包的文件夹运行

ipapk-server

出现如下错误

module.js:598
  return process.dlopen(module, path._makeLong(filename));
                 ^

Error: dlopen(/usr/local/lib/node_modules/ipapk-server/node_modules/sqlite3/lib/binding/node-v51-darwin-x64/node_sqlite3.node, 1): no suitable image found.  Did find:
	/usr/local/lib/node_modules/ipapk-server/node_modules/sqlite3/lib/binding/node-v51-darwin-x64/node_sqlite3.node: truncated mach-o error: segment __TEXT extends to 1609728 which is past end of file 152064
    at Object.Module._extensions..node (module.js:598:18)
    at Module.load (module.js:488:32)
    at tryModuleLoad (module.js:447:12)
    at Function.Module._load (module.js:439:3)
    at Module.require (module.js:498:17)
    at require (internal/module.js:20:19)
    at Object.<anonymous> (/usr/local/lib/node_modules/ipapk-server/node_modules/sqlite3/lib/sqlite3.js:4:15)
    at Module._compile (module.js:571:32)
    at Object.Module._extensions..js (module.js:580:10)
    at Module.load (module.js:488:32)

the iOS's package can't download

the android's package can't upload