freebsd上怎么安装SQLite?

33 views
Skip to first unread message

小花喵

unread,
Jul 7, 2012, 8:05:29 AM7/7/12
to sh...@googlegroups.com
单独安装SQLite3
那位可以手把手下。

~盛开如夏莲,美丽动人~
~شکوفه مانند لوتوس تابستان، زیبا~
Me.Sina 
小花(Jyu..)谨上

XiaoQI Ge

unread,
Jul 7, 2012, 10:36:44 AM7/7/12
to sh...@googlegroups.com
啥叫单独?
9.0-STABLE或者更高 pkg install sqlite3
全系列 pkg_add -rv sqlite3或者 cd /usr/ports/databases/sqlite3 &&make install clean


2012/7/7 小花喵 <she....@gmail.com>
-- You received this message because you are subscribed to the Google Groups Shanghai Linux User Group group. To post to this group, send email to sh...@googlegroups.com. To unsubscribe from this group, send email to shlug+un...@googlegroups.com. For more options, visit this group at https://groups.google.com/d/forum/shlug?hl=zh-CN



--
个人主页 http://7axu.com

小花喵

unread,
Jul 7, 2012, 1:09:38 PM7/7/12
to sh...@googlegroups.com
pkg install 提示没有这个命令。
pkg_add 到是有了,可是sqlite好像没安装上啊。内嵌图片 1


~盛开如夏莲,美丽动人~
~شکوفه مانند لوتوس تابستان، زیبا~
Me.Sina 
小花(Jyu..)谨上



2012/7/7 XiaoQI Ge <g...@7axu.com>
QQ截图20120708010850.png

小花喵

unread,
Jul 7, 2012, 1:09:58 PM7/7/12
to sh...@googlegroups.com
内嵌图片 1

~盛开如夏莲,美丽动人~
~شکوفه مانند لوتوس تابستان، زیبا~
Me.Sina 
小花(Jyu..)谨上



2012/7/8 小花喵 <she....@gmail.com>
QQ截图20120708010850.png
QQ截图20120708010850.png

Leo Li

unread,
Jul 9, 2012, 3:32:06 AM7/9/12
to sh...@googlegroups.com, 小花喵
cd /usr/ports/databases/sqlite3

直接用ports安装!要么就pkg_add -r sqllite3试试看.

-Leo

On Sun Jul 8 01:09:58 2012, 小花喵 wrote:
> 内嵌图片 1
> *
> *
> *~*盛开如夏莲,美丽动人*~
> **~شکوفه مانند لوتوس تابستان، زیبا~
> *Me.Sina <http://t.sina.com.cn/wolfanenator>
> 小花(Jyu..)谨上
>
>
>
> 2012/7/8 小花喵 <she....@gmail.com <mailto:she....@gmail.com>>
>
> pkg install 提示没有这个命令。
> pkg_add 到是有了,可是sqlite好像没安装上啊。内嵌图片 1
>
> *
> *
> *~*盛开如夏莲,美丽动人*~
> **~شکوفه مانند لوتوس تابستان، زیبا~
> *Me.Sina <http://t.sina.com.cn/wolfanenator>
> 小花(Jyu..)谨上
>
>
>
> 2012/7/7 XiaoQI Ge <g...@7axu.com <mailto:g...@7axu.com>>
>
> 啥叫单独?
> 9.0-STABLE或者更高 pkg install sqlite3
> 全系列 pkg_add -rv sqlite3或者 cd
> /usr/ports/databases/sqlite3 &&make install clean
>
>
> 2012/7/7 小花喵 <she....@gmail.com <mailto:she....@gmail.com>>
>
> 单独安装SQLite3
> 那位可以手把手下。
> *
> *
> *~*盛开如夏莲,美丽动人*~
> **~شکوفه مانند لوتوس تابستان، زیبا~
> *Me.Sina <http://t.sina.com.cn/wolfanenator>
> 小花(Jyu..)谨上
>
> -- You received this message because you are subscribed to
> the Google Groups Shanghai Linux User Group group. To post
> to this group, send email to sh...@googlegroups.com
> <mailto:sh...@googlegroups.com>. To unsubscribe from this
> group, send email to shlug+un...@googlegroups.com
> <mailto:shlug%2Bunsu...@googlegroups.com>. For more
> options, visit this group at
> https://groups.google.com/d/forum/shlug?hl=zh-CN
>
>
>
>
> --
> 个人主页 http://7axu.com
>
> -- You received this message because you are subscribed to the
> Google Groups Shanghai Linux User Group group. To post to this
> group, send email to sh...@googlegroups.com
> <mailto:sh...@googlegroups.com>. To unsubscribe from this
> group, send email to shlug+un...@googlegroups.com
> <mailto:shlug%2Bunsu...@googlegroups.com>. For more

XiaoQI Ge

unread,
Jul 9, 2012, 6:00:28 AM7/9/12
to sh...@googlegroups.com
他是cjb上的,没root权限
看起来只能手动编译了

2012/7/9 Leo Li <yaol...@gmail.com>
            group, send email to shlug+unsubscribe@googlegroups.com
            <mailto:shlug%2Bunsubscribe@googlegroups.com>. For more

            options, visit this group at
            https://groups.google.com/d/forum/shlug?hl=zh-CN




        --
        个人主页 http://7axu.com

        -- You received this message because you are subscribed to the
        Google Groups Shanghai Linux User Group group. To post to this
        group, send email to sh...@googlegroups.com
        <mailto:sh...@googlegroups.com>. To unsubscribe from this
        group, send email to shlug+unsubscribe@googlegroups.com
        <mailto:shlug%2Bunsubscribe@googlegroups.com>. For more

        options, visit this group at
        https://groups.google.com/d/forum/shlug?hl=zh-CN



-- You received this message because you are subscribed to the Google
Groups Shanghai Linux User Group group. To post to this group, send
email to sh...@googlegroups.com. To unsubscribe from this group, send
email to shlug+unsubscribe@googlegroups.com. For more options, visit

-- You received this message because you are subscribed to the Google Groups Shanghai Linux User Group group. To post to this group, send email to sh...@googlegroups.com. To unsubscribe from this group, send email to shlug+unsubscribe@googlegroups.com. For more options, visit this group at https://groups.google.com/d/forum/shlug?hl=zh-CN



--
个人主页 http://7axu.com

小花喵

unread,
Jul 9, 2012, 6:45:48 AM7/9/12
to sh...@googlegroups.com
求手把手。


~盛开如夏莲,美丽动人~
~شکوفه مانند لوتوس تابستان، زیبا~
Me.Sina 
小花(Jyu..)谨上



2012/7/9 XiaoQI Ge <g...@7axu.com>
-- You received this message because you are subscribed to the Google Groups Shanghai Linux User Group group. To post to this group, send email to sh...@googlegroups.com. To unsubscribe from this group, send email to shlug+un...@googlegroups.com. For more options, visit this group at https://groups.google.com/d/forum/shlug?hl=zh-CN

依云

unread,
Jul 9, 2012, 10:46:27 AM7/9/12
to sh...@googlegroups.com
花喵把手递过来呀 ^_^

On Mon, Jul 09, 2012 at 06:45:48PM +0800, 小花喵 wrote:
> 求手把手。
>
> *
> *
> *~*盛开如夏莲,美丽动人*~
> **~شکوفه مانند لوتوس تابستان، زیبا~
> *Me.Sina <http://t.sina.com.cn/wolfanenator>
> 小花(Jyu..)谨上
>
>
>
> 2012/7/9 XiaoQI Ge <g...@7axu.com>
>
> > 他是cjb上的,没root权限
> > 看起来只能手动编译了
> >
> >
> > 2012/7/9 Leo Li <yaol...@gmail.com>
> >
> >> cd /usr/ports/databases/sqlite3
> >>
> >> 直接用ports安装!要么就pkg_add -r sqllite3试试看.
> >>
> >> -Leo
> >>
> >> On Sun Jul 8 01:09:58 2012, 小花喵 wrote:
> >>
> >>> 内嵌图片 1
> >>> *
> >>> *
> >>> *~*盛开如夏莲,美丽动人*~
> >>> **~شکوفه مانند لوتوس تابستان، زیبا~
> >>> *Me.Sina <http://t.sina.com.cn/**wolfanenator<http://t.sina.com.cn/wolfanenator>
> >>> >
> >>> 小花(Jyu..)谨上
> >>>
> >>>
> >>>
> >>> 2012/7/8 小花喵 <she....@gmail.com <mailto:she....@gmail.com>>
> >>>
> >>> pkg install 提示没有这个命令。
> >>> pkg_add 到是有了,可是sqlite好像没安装上啊。内嵌图片 1
> >>>
> >>> *
> >>> *
> >>> *~*盛开如夏莲,美丽动人*~
> >>> **~شکوفه مانند لوتوس تابستان، زیبا~
> >>> *Me.Sina <http://t.sina.com.cn/**wolfanenator<http://t.sina.com.cn/wolfanenator>
> >>> >
> >>> 小花(Jyu..)谨上
> >>>
> >>>
> >>>
> >>> 2012/7/7 XiaoQI Ge <g...@7axu.com <mailto:g...@7axu.com>>
> >>>
> >>> 啥叫单独?
> >>> 9.0-STABLE或者更高 pkg install sqlite3
> >>> 全系列 pkg_add -rv sqlite3或者 cd
> >>> /usr/ports/databases/sqlite3 &&make install clean
> >>>
> >>>
> >>> 2012/7/7 小花喵 <she....@gmail.com <mailto:she....@gmail.com>>
> >>>
> >>> 单独安装SQLite3
> >>> 那位可以手把手下。
> >>> *
> >>> *
> >>> *~*盛开如夏莲,美丽动人*~
> >>> **~شکوفه مانند لوتوس تابستان، زیبا~
> >>> *Me.Sina <http://t.sina.com.cn/**wolfanenator<http://t.sina.com.cn/wolfanenator>
> >>> >
> >>> 小花(Jyu..)谨上
> >>>
> >>> -- You received this message because you are subscribed to
> >>> the Google Groups Shanghai Linux User Group group. To post
> >>> to this group, send email to sh...@googlegroups.com
> >>> <mailto:sh...@googlegroups.com**>. To unsubscribe from this
> >>> group, send email to shlug+unsubscribe@**googlegroups.com<shlug%2Bunsu...@googlegroups.com>
> >>> <mailto:shlug%2Bunsubscribe@**googlegroups.com<shlug%252Buns...@googlegroups.com>>.
> >>> For more
> >>> options, visit this group at
> >>> https://groups.google.com/d/**forum/shlug?hl=zh-CN<https://groups.google.com/d/forum/shlug?hl=zh-CN>
> >>>
> >>>
> >>>
> >>>
> >>> --
> >>> 个人主页 http://7axu.com
> >>>
> >>> -- You received this message because you are subscribed to the
> >>> Google Groups Shanghai Linux User Group group. To post to this
> >>> group, send email to sh...@googlegroups.com
> >>> <mailto:sh...@googlegroups.com**>. To unsubscribe from this
> >>> group, send email to shlug+unsubscribe@**googlegroups.com<shlug%2Bunsu...@googlegroups.com>
> >>> <mailto:shlug%2Bunsubscribe@**googlegroups.com<shlug%252Buns...@googlegroups.com>>.
> >>> For more
> >>> options, visit this group at
> >>> https://groups.google.com/d/**forum/shlug?hl=zh-CN<https://groups.google.com/d/forum/shlug?hl=zh-CN>
> >>>
> >>>
> >>>
> >>> -- You received this message because you are subscribed to the Google
> >>> Groups Shanghai Linux User Group group. To post to this group, send
> >>> email to sh...@googlegroups.com. To unsubscribe from this group, send
> >>> email to shlug+unsubscribe@**googlegroups.com<shlug%2Bunsu...@googlegroups.com>.
> >>> For more options, visit
> >>> this group at https://groups.google.com/d/**forum/shlug?hl=zh-CN<https://groups.google.com/d/forum/shlug?hl=zh-CN>
> >>>
> >>
> >> -- You received this message because you are subscribed to the Google
> >> Groups Shanghai Linux User Group group. To post to this group, send email
> >> to sh...@googlegroups.com. To unsubscribe from this group, send email to
> >> shlug+unsubscribe@**googlegroups.com<shlug%2Bunsu...@googlegroups.com>.
> >> For more options, visit this group at https://groups.google.com/d/**
> >> forum/shlug?hl=zh-CN <https://groups.google.com/d/forum/shlug?hl=zh-CN>
> >
> >
> >
> >
> > --
> > 个人主页 http://7axu.com
> >
> > -- You received this message because you are subscribed to the Google
> > Groups Shanghai Linux User Group group. To post to this group, send email
> > to sh...@googlegroups.com. To unsubscribe from this group, send email to
> > shlug+un...@googlegroups.com. For more options, visit this group at
> > https://groups.google.com/d/forum/shlug?hl=zh-CN
>
> -- You received this message because you are subscribed to the Google Groups Shanghai Linux User Group group. To post to this group, send email to sh...@googlegroups.com. To unsubscribe from this group, send email to shlug+un...@googlegroups.com. For more options, visit this group at https://groups.google.com/d/forum/shlug?hl=zh-CN

--
Best regards,
lilydjwg

Linux Vim Python 我的博客:
http://lilydjwg.is-programmer.com/
--
A: Because it obfuscates the reading.
Q: Why is top posting so bad?

ghosTM55

unread,
Jul 9, 2012, 10:47:47 AM7/9/12
to sh...@googlegroups.com
人家是男的,你们的节操在哪里
Thomas
Shanghai Linux User Group
GitCafe - Share a cup of open source

http://ghosTunix.org
Twitter: @ghosTM55

MildC

unread,
Jul 9, 2012, 12:47:09 PM7/9/12
to sh...@googlegroups.com

吃掉了

Yiling Cao

unread,
Jul 9, 2012, 1:31:23 PM7/9/12
to sh...@googlegroups.com
登陆root,用ports 装,如果还不会:
你还是用你后台的windows把,而且freebsd不是 linux ! 应该 [OT]

小花喵

unread,
Jul 9, 2012, 4:20:42 PM7/9/12
to sh...@googlegroups.com
有root就不来问了。
人家是想在CJB.net上装个SQLite


~盛开如夏莲,美丽动人~
~شکوفه مانند لوتوس تابستان، زیبا~
Me.Sina 
小花(Jyu..)谨上



2012/7/10 Yiling Cao <yilin...@gmail.com>

z7z8th

unread,
Jul 9, 2012, 10:07:50 PM7/9/12
to sh...@googlegroups.com
到freebsd的ftp找到编译好的sqlite包,解压出来,如果要用到.so的,设一下LD_LIBRARY_PATH。
9.0:
http://ftp.freebsd.org/pub/FreeBSD/releases/i386/9.0-RELEASE/packages/databases/sqlite3-3.7.9.tbz

2012/7/10 小花喵 <she....@gmail.com>

依云

unread,
Jul 10, 2012, 12:59:27 AM7/10/12
to sh...@googlegroups.com
小花不是「she」么……

On Mon, Jul 09, 2012 at 10:47:47PM +0800, ghosTM55 wrote:
> 人家是男的,你们的节操在哪里
>
> On Mon, Jul 9, 2012 at 10:46 PM, 依云 <lily...@gmail.com> wrote:
> > 花喵把手递过来呀 ^_^
> >
> > On Mon, Jul 09, 2012 at 06:45:48PM +0800, 小花喵 wrote:
> >> 求手把手。

XiaoQI Ge

unread,
Jul 10, 2012, 8:21:24 AM7/10/12
to sh...@googlegroups.com
http://www.7axu.com/sqlite3.tar.xz.asc

亲。。。直接下编译好的?解压后make install就行了

编译流程
tar -xvf sqlite*
cd sqlite*
./configure --prefix=$HOME
make 
make install
结束
rm -r sqlite*

--------------
cjb上会编译出错,所以自己找个VPS/虚拟机 编译一下就行
ENABLE_FTS3 -DSQLITE_ENABLE_RTREE -g -O2 -MT sqlite3.lo -MD -MP -MF .deps/sqlite3.Tpo -c sqlite3.c  -fPIC -DPIC -o .libs/sqlite3.o

cc1: out of memory allocating 8388608 bytes after a total of 0 bytes
*** Error code 1
-------------
2012/7/10 依云 <lily...@gmail.com>
-- You received this message because you are subscribed to the Google Groups Shanghai Linux User Group group. To post to this group, send email to sh...@googlegroups.com. To unsubscribe from this group, send email to shlug+un...@googlegroups.com. For more options, visit this group at https://groups.google.com/d/forum/shlug?hl=zh-CN



--
个人主页 http://7axu.com

Yiling Cao

unread,
Jul 10, 2012, 8:51:18 AM7/10/12
to sh...@googlegroups.com
你的title有说你没root吗?title好弱,你可以在有root的环境静态连接编译好,考上去。

XiaoQI Ge

unread,
Jul 10, 2012, 9:26:09 AM7/10/12
to sh...@googlegroups.com
我也是交谈中知道他说的是cjb上安装的。。。好麻烦的说。还好sqlite这娃没什么依赖
个人主页 http://7axu.com

Xunzhen Quan

unread,
Jul 10, 2012, 10:32:29 AM7/10/12
to sh...@googlegroups.com
弱问 cjb 是啥……

2012/7/10 XiaoQI Ge <g...@7axu.com>

XiaoQI Ge

unread,
Jul 10, 2012, 9:20:48 PM7/10/12
to sh...@googlegroups.com

CJB.NET

www.cjb.net/ - 网页快照 - 翻译此页
CJB.NET offers domain names, web hosting, shell accounts, and VPN services.
Reply all
Reply to author
Forward
0 new messages