From: walter t. <sta...@gm...> - 2007-03-05 08:47:13
|
Hi I'm testing latest branch image, there is sqlite3 and I want to use it for CDR, but... no cdr_sqlite.so is created in modules, and this document http://www.voip-info.org/wiki/view/Asterisk+cdr+SQLite explain that if sqlite is installed, cdr_sqlite.so is created automatically. Any idea how to solve this problem? And is there a good way to menage CDR on astlinux? Best Regards Walter |
From: Darrick H. <dha...@dj...> - 2007-03-05 13:30:47
|
walter trucci wrote: > Hi I'm testing latest branch image, there is sqlite3 and I want to use > it for CDR, but... no cdr_sqlite.so is created in modules, and this > document > http://www.voip-info.org/wiki/view/Asterisk+cdr+SQLite explain that if > sqlite is installed, cdr_sqlite.so is created automatically. Any idea > how to solve this problem? And is there a good way to menage CDR on > astlinux? Walter, I'll look into that. I need to force sqlite to be compiled before asterisk. Darrick -- Darrick Hartman DJH Solutions, LLC http://www.djhsolutions.com |
From: walter t. <sta...@gm...> - 2007-03-05 13:37:19
|
Thanks a lot. I see that maybe there is some errors on sqlite compiling, when I run sqlite3 there are some errors. 2007/3/5, Darrick Hartman <dha...@dj...>: > > walter trucci wrote: > > Hi I'm testing latest branch image, there is sqlite3 and I want to use > > it for CDR, but... no cdr_sqlite.so is created in modules, and this > > document > > http://www.voip-info.org/wiki/view/Asterisk+cdr+SQLite explain that if > > sqlite is installed, cdr_sqlite.so is created automatically. Any idea > > how to solve this problem? And is there a good way to menage CDR on > > astlinux? > Walter, > > I'll look into that. I need to force sqlite to be compiled before > asterisk. > > Darrick > > -- > Darrick Hartman > DJH Solutions, LLC > http://www.djhsolutions.com > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Astlinux-users mailing list > Ast...@li... > https://lists.sourceforge.net/lists/listinfo/astlinux-users > > Donations to support AstLinux are graciously accepted via PayPal to > pa...@kr.... > |
From: Darrick H. <dha...@dj...> - 2007-03-05 13:42:49
|
walter trucci wrote: > Thanks a lot. I see that maybe there is some errors on sqlite > compiling, when I run sqlite3 there are some errors. Please provide the errors so I can correct them. sqlite was added as a request, but the developers currently don't use it. It appears to compile cleanly. Darrick -- Darrick Hartman DJH Solutions, LLC http://www.djhsolutions.com |
From: walter t. <sta...@gm...> - 2007-03-05 21:37:31
|
This are the errors pbx ~ # sqlite3 /usr/bin/sqlite3: line 46: /home/dhartman/astlinux/branches/0.4/toolchain_build_i586/bin/sed: No such file or directory /usr/bin/sqlite3: line 50: /home/dhartman/astlinux/branches/0.4/toolchain_build_i586/bin/sed: No such file or directory /usr/bin/sqlite3: line 87: cd: /home/dhartman/astlinux/branches/0.4/build_i586/sqlite-3.3.13: No such file or directory /usr/bin/sqlite3: line 87: /home/dhartman/astlinux/branches/0.4/build_i586/staging_dir/bin/i586-linux-uclibc-gcc: No such file or directory 2007/3/5, Darrick Hartman <dha...@dj...>: > > walter trucci wrote: > > Thanks a lot. I see that maybe there is some errors on sqlite > > compiling, when I run sqlite3 there are some errors. > Please provide the errors so I can correct them. sqlite was added as a > request, but the developers currently don't use it. It appears to > compile cleanly. > > Darrick > > -- > Darrick Hartman > DJH Solutions, LLC > http://www.djhsolutions.com > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Astlinux-users mailing list > Ast...@li... > https://lists.sourceforge.net/lists/listinfo/astlinux-users > > Donations to support AstLinux are graciously accepted via PayPal to > pa...@kr.... > |
From: Darrick H. <dha...@dj...> - 2007-03-05 21:42:07
|
walter trucci wrote: > This are the errors > > pbx ~ # sqlite3 > /usr/bin/sqlite3: line 46: > /home/dhartman/astlinux/branches/0.4/toolchain_build_i586/bin/sed: No > such file or directory > /usr/bin/sqlite3: line 50: > /home/dhartman/astlinux/branches/0.4/toolchain_build_i586/bin/sed: No > such file or directory > /usr/bin/sqlite3: line 87: cd: > /home/dhartman/astlinux/branches/0.4/build_i586/sqlite-3.3.13: No such > file or directory > /usr/bin/sqlite3: line 87: > /home/dhartman/astlinux/branches/0.4/build_i586/staging_dir/bin/i586-linux-uclibc-gcc: > No such file or directory > Thanks. These are helpful. Looks like sqlite is linking against stuff improperly. I haven't used it, only started building it at the request of others. Darrick -- Darrick Hartman DJH Solutions, LLC http://www.djhsolutions.com |
From: Darrick H. <dha...@dj...> - 2007-03-05 22:08:04
|
Darrick Hartman wrote: > walter trucci wrote: > >> This are the errors >> >> pbx ~ # sqlite3 >> /usr/bin/sqlite3: line 46: >> /home/dhartman/astlinux/branches/0.4/toolchain_build_i586/bin/sed: No >> such file or directory >> /usr/bin/sqlite3: line 50: >> /home/dhartman/astlinux/branches/0.4/toolchain_build_i586/bin/sed: No >> such file or directory >> /usr/bin/sqlite3: line 87: cd: >> /home/dhartman/astlinux/branches/0.4/build_i586/sqlite-3.3.13: No such >> file or directory >> /usr/bin/sqlite3: line 87: >> /home/dhartman/astlinux/branches/0.4/build_i586/staging_dir/bin/i586-linux-uclibc-gcc: >> No such file or directory >> >> > Thanks. These are helpful. Looks like sqlite is linking against stuff > improperly. I haven't used it, only started building it at the request > of others. > I found the problem and will take care of it tomorrow. I almost have the cdr_sqlite stuff right too. Darrick -- Darrick Hartman DJH Solutions, LLC http://www.djhsolutions.com |
From: walter t. <sta...@gm...> - 2007-03-06 05:34:27
|
You are great! 2007/3/5, Darrick Hartman <dha...@dj...>: > > Darrick Hartman wrote: > > walter trucci wrote: > > > >> This are the errors > >> > >> pbx ~ # sqlite3 > >> /usr/bin/sqlite3: line 46: > >> /home/dhartman/astlinux/branches/0.4/toolchain_build_i586/bin/sed: No > >> such file or directory > >> /usr/bin/sqlite3: line 50: > >> /home/dhartman/astlinux/branches/0.4/toolchain_build_i586/bin/sed: No > >> such file or directory > >> /usr/bin/sqlite3: line 87: cd: > >> /home/dhartman/astlinux/branches/0.4/build_i586/sqlite-3.3.13: No such > >> file or directory > >> /usr/bin/sqlite3: line 87: > >> > /home/dhartman/astlinux/branches/0.4/build_i586/staging_dir/bin/i586-linux-uclibc-gcc: > >> No such file or directory > >> > >> > > Thanks. These are helpful. Looks like sqlite is linking against stuff > > improperly. I haven't used it, only started building it at the request > > of others. > > > > I found the problem and will take care of it tomorrow. I almost have > the cdr_sqlite stuff right too. > > Darrick > > -- > Darrick Hartman > DJH Solutions, LLC > http://www.djhsolutions.com > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Astlinux-users mailing list > Ast...@li... > https://lists.sourceforge.net/lists/listinfo/astlinux-users > > Donations to support AstLinux are graciously accepted via PayPal to > pa...@kr.... > |
From: Darrick H. <dha...@dj...> - 2007-03-06 07:58:37
|
walter trucci wrote: > You are great! I don't think I'd go quite that far...more notes below. > > 2007/3/5, Darrick Hartman <dha...@dj... > <mailto:dha...@dj...>>: > > Darrick Hartman wrote: > > walter trucci wrote: > > > Thanks. These are helpful. Looks like sqlite is linking > against stuff > > improperly. I haven't used it, only started building it at the > request > > of others. > > > > I found the problem and will take care of it tomorrow. I almost have > the cdr_sqlite stuff right too. > > After some further digging, it appears that asterisk-1.2x will only support sqlite2 (not sqlite3--which compiles so nicely. sqlite2 requires a patch to do cross-compiling). sqlite3 may or may not be supported by asterisk-1.4. (The mantis bug tracker wasn't exactly clear on this.) For my purposes in the 0.4 branch, sqlite2 is the way we have to go since we'll be staying with asterisk-1.2 in that branch. I'm redoing the sqlite package in 0.4 branch and will have that and the cdr stuff ready to go tomorrow. Assuming it builds cleanly (building right now), I just need to clean up the hacks I put in the asterisk.mk file. Darrick -- Darrick Hartman DJH Solutions, LLC http://www.djhsolutions.com |
From: Darrick H. <dha...@dj...> - 2007-03-06 15:48:46
|
Pawel Pastuszak wrote: > Hi Darrick, > > Asterisk only supports sqlite 2 not sqlite 3 because of that i > modifited the orginal cdr_sqlite.c and full converted it to sqlite3 > because i useing it my self. > > So here are the file, all you need to do is patch the makefile the > patch is include in the zip file > Pawel, Thanks for the file and patch. I'm not sure we're going to use it in the 0.4 branch. Someone would have to give me a pretty convincing reason why sqlite3 is better than sqlite2. If there's really no good reason, I'm going to stay with sqlite2 for two reasons. 1). Less patches to maintain and 2). sqlite2 support is what is officially in asterisk 1.2. That being sadi, if you have a good reason to use sqlite3 instead of sqlite2, please let me know and I'll reconsider it. Kristian may want to include the sqlite3 module in trunk. That's totally up to him. I'll have versions of astlinux built from the 0.4 branch with properly compiled sqlite and cdr_sqlite (as well as cdr and apps for postgresql) shortly. Please test when it's out. Darrick > > Pawel Pastuszak > paw...@gm... <mailto:paw...@gm...> > > > > *From: * Darrick Hartman <dha...@dj... > <mailto:dha...@dj...>> >> *Date: * March 6, 2007 2:58:18 AM EST (CA) >> *To: * AstLinux Users Mailing List >> <ast...@li... >> <mailto:ast...@li...>> >> *Subject: * *Re: [Astlinux-users] sqlite cdr* >> *Reply-To: * AstLinux Users Mailing List >> <ast...@li... >> <mailto:ast...@li...>> >> >> walter trucci wrote: >>> You are great! >> I don't think I'd go quite that far...more notes below. >>> >>> 2007/3/5, Darrick Hartman < dha...@dj... >>> <mailto:dha...@dj...> >>> <mailto:dha...@dj... >>> <mailto:dha...@dj...>>>: >>> >>> Darrick Hartman wrote: >>>> walter trucci wrote: >>> >>>> Thanks. These are helpful. Looks like sqlite is linking >>> against stuff >>>> improperly. I haven't used it, only started building it at the >>> request >>>> of others. >>>> >>> >>> I found the problem and will take care of it tomorrow. I >>> almost have >>> the cdr_sqlite stuff right too. >>> >>> >> After some further digging, it appears that asterisk-1.2x will only >> support sqlite2 (not sqlite3--which compiles so nicely. sqlite2 >> requires a patch to do cross-compiling). sqlite3 may or may not be >> supported by asterisk-1.4. (The mantis bug tracker wasn't >> exactly clear >> on this.) For my purposes in the 0.4 branch, sqlite2 is the way >> we have >> to go since we'll be staying with asterisk-1.2 in that branch. >> >> I'm redoing the sqlite package in 0.4 branch and will have that >> and the >> cdr stuff ready to go tomorrow. Assuming it builds cleanly >> (building >> right now), I just need to clean up the hacks I put in the >> asterisk.mk <http://asterisk.mk> >> file. >> >> Darrick >> >> -- >> Darrick Hartman >> DJH Solutions, LLC >> http://www.djhsolutions.com >> >> >> ------------------------------------------------------------------------- >> Take Surveys. Earn Cash. Influence the Future of IT >> Join SourceForge.net's Techsay panel and you'll get the chance to >> share your >> opinions on IT & business topics through brief surveys-and earn cash >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >> <http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV> >> _______________________________________________ >> Astlinux-users mailing list >> Ast...@li... >> <mailto:Ast...@li...> >> https://lists.sourceforge.net/lists/listinfo/astlinux-users >> <https://lists.sourceforge.net/lists/listinfo/astlinux-users> >> >> Donations to support AstLinux are graciously accepted via PayPal >> to pa...@kr... <mailto:pa...@kr...>. > > > > --- Wojtek > > > > -- Darrick Hartman DJH Solutions, LLC http://www.djhsolutions.com |
From: <ast...@el...> - 2007-03-07 04:06:18
|
Darrick Hartman said: > walter trucci wrote: >> You are great! > I don't think I'd go quite that far...more notes below. >> >> 2007/3/5, Darrick Hartman <dha...@dj... >> <mailto:dha...@dj...>>: >> >> Darrick Hartman wrote: >> > walter trucci wrote: >> >> > Thanks. These are helpful. Looks like sqlite is linking >> against stuff >> > improperly. I haven't used it, only started building it at the >> request >> > of others. >> > >> >> I found the problem and will take care of it tomorrow. I almost >> have >> the cdr_sqlite stuff right too. >> >> > After some further digging, it appears that asterisk-1.2x will only > support sqlite2 (not sqlite3--which compiles so nicely. sqlite2 > requires a patch to do cross-compiling). sqlite3 may or may not be > supported by asterisk-1.4. (The mantis bug tracker wasn't exactly clear > on this.) For my purposes in the 0.4 branch, sqlite2 is the way we have > to go since we'll be staying with asterisk-1.2 in that branch. > > I'm redoing the sqlite package in 0.4 branch and will have that and the > cdr stuff ready to go tomorrow. Assuming it builds cleanly (building > right now), I just need to clean up the hacks I put in the asterisk.mk > file. > > Darrick Err, really? sqlite2 only? So the following http://svn.digium.com/view/asterisk-addons/branches/1.2/res_sqlite3/ is misleading then? |
From: Darrick H. <dha...@dj...> - 2007-03-07 04:19:18
|
ast...@el... wrote: >> After some further digging, it appears that asterisk-1.2x will only >> support sqlite2 (not sqlite3--which compiles so nicely. sqlite2 >> requires a patch to do cross-compiling). sqlite3 may or may not be >> supported by asterisk-1.4. (The mantis bug tracker wasn't exactly clear >> on this.) For my purposes in the 0.4 branch, sqlite2 is the way we have >> to go since we'll be staying with asterisk-1.2 in that branch. >> >> I'm redoing the sqlite package in 0.4 branch and will have that and the >> cdr stuff ready to go tomorrow. Assuming it builds cleanly (building >> right now), I just need to clean up the hacks I put in the asterisk.mk >> file. >> > > Err, really? sqlite2 only? So the following > > http://svn.digium.com/view/asterisk-addons/branches/1.2/res_sqlite3/ > > is misleading then? > The original request was for cdr data. The cdr_sqlite module that is in 1.2 only works with sqlite2. I did see the res_sqlite3 module in add-ons, but we currently don't include addons in the 0.4 branch and this module won't help for cdr. I'll talk with Kristian more about this and decide what is going to happen with trunk. For right now, the features that are in 0.4 branch are what will make it to the 0.4.5 release. 0.4.5 needs to get out. We've added several packages and there have been several upgrades since 0.4.4. I'm pretty much ready to call svn 709 a release candidate for 0.4.5. The only thing that may get in that's not currently enabled is the rhino zaptel support. It was temporarily removed due to a small problem with their ftp site. If Bryce can get me the update in the next day or so, we'll get that included. Otherwise, we're in a feature freeze for 0.4.5. Darrick -- Darrick Hartman DJH Solutions, LLC http://www.djhsolutions.com |