Re: iCal modules
Ricardo SIGNES wrote: * Mike Schienle [EMAIL PROTECTED] [2006-08-10T00:11:07] Thanks for the suggestion, I didn't even consider that. The Mac::Glue installation process is definitely one of the more entertaining ones I've seen/heard. I just scanned through the module docs. I see in the ToDo list is More examples (iCal, iPhoto, iTunes). I don't suppose you have an iCal example laying around you've been waiting to put in there. This used to work, and probably still does, though I haven't used it lately for obvious reasons: http://rjbs.manxome.org/hacks/perl/bdcal Thanks Ricardo. Seeing a little iCal syntax definitely helps. I found a little touch of irony in this line :-) die nobody found! unless @people; -- Mike Schienle
iCal modules
Hi all - I'm checking out modules for working with iCal. I want to scrape a financial calendar web site at http://www.briefing.com/Investor/ Public/MarketAnalysis/Calendars/EconomicCalendar.htm and put the dates into an iCal calendar. I checked http://www.icalshare.com/ and there were a couple financial ones from previous years, but nothing current. Apple's iCal section on their site didn't have any financial calendars listed. Does this exist already for this or a similar calendar? Data::iCal looks like an appropriate module to use. Any pros/cons or more appropriate modules to consider? If you'd like to subscribe to the resulting calendar when I'm done, just drop me a line. I'm creating the iCal calendar by hand at the moment, so it's already available. Thanks for any ideas. Mike Schienle
Re: Spreadsheet::WriteExcel and ODBC
On Jun 8, 2006, at 7:19 AM, Joel Rees wrote: Up front caveat, I don't have a lot of experience with this kind of thing, but, ... On 2006.6.8, at 02:36 AM, Mike Schienle wrote: Celeste Suliin Burris wrote: I'm a bit confused as to why you need to use ODBC. I just connect to the remote MySQL server via the DBI when I'm using Perl. I have my Linux machine running MySQL 5.0. Hi Celeste - I'm working on a program that will update a database throughout the day and provide the customer with a spreadsheet of the results. I'd rather have the customer be able to open the spreadsheet any time and get the latest data rather than having to create a new spreadsheet each time the data updates. I should be able to accomplish that by putting the ODBC connections directly in the spreadsheet. Why? Would it make more sense, perchance, to use a web browser as your front-end instead of MSOffice? Hi Joel - There is already a web-based charting package being used (Visual Engineering's KavaChart), but I know/expect some of the customers will want to do some additional analysis of the results beyond what the charting on the web page will provide. I did a similar package with a different data set for a customer a few years ago and have a decent idea of what they did with it in Excel. Basically, I'm just trying to anticipate the customer's needs on this, as well as remove a potential load on the server. The KavaChart package can dynamically build the data using multiple URLs, so I don't have to build the results for it each time the data needs updating. I'm trying to figure out how to get Excel to do the same kind of thing. I have no problem doing the DBI connection from Perl, which is what I've been doing for quite some time. What I'm after is a way to do the connection from an Excel spreadsheet that has been written by WriteExcel. How often does this spreadsheet need to be (mechanically, I assume) rebuilt? (That's the only reason I can think of for building such a spreadsheet from a perl script.) Every 15 minutes if I rebuild it each time data gets processed. If I provide a spreadsheet they can open whenever they want and it grabs the latest data off the server, I suspect it would probably happen a couple times a day, or thereabouts. I can also just build the spreadsheet from the web interface on demand and have them download it. So, this isn't a hard requirement, more of a wish list item. The program is for multiple customers, so I want/need to be able to write a spreadsheet that is for the particular customer. I might be able to do this as an Excel template, also. That would be Plan B or C. Oh. That's another reason, I suppose. My guess is you're going to be flying by the seat of your pants on this project with no radio. And no compass and poor visibility :-) I think I'd try to sell the customers on pushing the interface to MSOffice back a ways, doing the tables in HTML on a local-access- only server, and only dumping the relatively static results to Excel at the stage where things go to the archive. (Nursing the customers off of MSOffice as an archive format is also something I'd recommend, but one thing at a time.) The current plan is to keep things on the server and provide a couple ways for them to view the results. The basic view would be with KavaChart. Excel would be used for some additional things like trend analysis and other statistical stuff. From: Mike Schienle [EMAIL PROTECTED] Organization: Custom Visuals, LLC Date: Wed, 07 Jun 2006 16:51:36 +0100 To: macosx@perl.org Subject: Spreadsheet::WriteExcel and ODBC Hi all - I need to write some Excel files with ODBC access to a MySQL database. I've used Spreadsheet::WriteExcel in the past for writing formulas, formatting, etc., with no problems, but the ODBC connection is new to me. I tried it manually (just opening a blank spreadsheet and connecting to a remote MySQL server) last night using Actual's ODBC client demo and that worked fine. The WriteExcel docs are a bit vague [to me] on connecting to an ODBC source, though. Has anyone done this via Spreadsheet::WriteExcel? Do you mind passing along a couple hints? Would this require any customer/client to have an ODBC client on their system for this to work? If so, I may just go with static data and have the customer pick up a new spreadsheet each time. Also, as mentioned above I'm using Actual's ODBC client. Is there a better client out there? Or an Open Source one that's competitive? Thanks. -- Mike Schienle -- Mike Schienle Mike Schienle
Spreadsheet::WriteExcel and ODBC
Hi all - I need to write some Excel files with ODBC access to a MySQL database. I've used Spreadsheet::WriteExcel in the past for writing formulas, formatting, etc., with no problems, but the ODBC connection is new to me. I tried it manually (just opening a blank spreadsheet and connecting to a remote MySQL server) last night using Actual's ODBC client demo and that worked fine. The WriteExcel docs are a bit vague [to me] on connecting to an ODBC source, though. Has anyone done this via Spreadsheet::WriteExcel? Do you mind passing along a couple hints? Would this require any customer/client to have an ODBC client on their system for this to work? If so, I may just go with static data and have the customer pick up a new spreadsheet each time. Also, as mentioned above I'm using Actual's ODBC client. Is there a better client out there? Or an Open Source one that's competitive? Thanks. -- Mike Schienle
Re: Spreadsheet::WriteExcel and ODBC
Celeste Suliin Burris wrote: I'm a bit confused as to why you need to use ODBC. I just connect to the remote MySQL server via the DBI when I'm using Perl. I have my Linux machine running MySQL 5.0. Hi Celeste - I'm working on a program that will update a database throughout the day and provide the customer with a spreadsheet of the results. I'd rather have the customer be able to open the spreadsheet any time and get the latest data rather than having to create a new spreadsheet each time the data updates. I should be able to accomplish that by putting the ODBC connections directly in the spreadsheet. I have no problem doing the DBI connection from Perl, which is what I've been doing for quite some time. What I'm after is a way to do the connection from an Excel spreadsheet that has been written by WriteExcel. The program is for multiple customers, so I want/need to be able to write a spreadsheet that is for the particular customer. I might be able to do this as an Excel template, also. That would be Plan B or C. From: Mike Schienle [EMAIL PROTECTED] Organization: Custom Visuals, LLC Date: Wed, 07 Jun 2006 16:51:36 +0100 To: macosx@perl.org Subject: Spreadsheet::WriteExcel and ODBC Hi all - I need to write some Excel files with ODBC access to a MySQL database. I've used Spreadsheet::WriteExcel in the past for writing formulas, formatting, etc., with no problems, but the ODBC connection is new to me. I tried it manually (just opening a blank spreadsheet and connecting to a remote MySQL server) last night using Actual's ODBC client demo and that worked fine. The WriteExcel docs are a bit vague [to me] on connecting to an ODBC source, though. Has anyone done this via Spreadsheet::WriteExcel? Do you mind passing along a couple hints? Would this require any customer/client to have an ODBC client on their system for this to work? If so, I may just go with static data and have the customer pick up a new spreadsheet each time. Also, as mentioned above I'm using Actual's ODBC client. Is there a better client out there? Or an Open Source one that's competitive? Thanks. -- Mike Schienle -- Mike Schienle
Re: Storable problem on Intel Mac Mini
On Fri, May 12, 2006 7:05 am, Joel Rees wrote: On 2006.5.12, at 10:01 AM, Mike Schienle wrote: Hi all - I just installed an Intel Mac Mini as a replacement for a dual 1.8 GHz G5 at my colocation place a couple days ago. Can I ask a silly question in public, or would off-list be more appropriate? I thought that would raise an eyebrow :-) The G5 began having stability problems. It would stop authenticating users (email, ftp, logins, etc. would fail, but web server would continue) after anywhere from 2 to 24 hours. I have two internal disks, 80 GB for OS and 250 GB for DB and web sites, and two external disks that are essentially backups for the internals (all 7200 RPM). I ran disk checks on all of them. I cloned internals to externals one at a time and had the exact same issues. After many attempts to hunt down the root cause (from launchd to securityd and a few other areas), it was time for stabs in the dark. I replaced the OS on the external, which was an upgrade from 10.3.x to a fresh install of 10.4. That actually made things worse, it went from failing to authenticate to complete lockups within a few minutes, so back to the original setup thanks to being able to shuffle things around with the spare disks. The next attempt was to start swapping/rotating RAM modules (I had recently gone from 1.25 GB to 4 GB), to see if one was flaky. No change. The current guess is a problem with the power supply. At this point I just needed to put something stable in place and fix the problem behind the scenes. As soon as that happens I expect to put the G5 back. I'm definitely happy with the Intel (dual core) Mac Mini so far. Database access is about 15% slower for a couple long queries (20+ minutes), which I'm assuming is because they went from a FW800 attachment to FW400, though it might be because of the internal Mac Mini disk being a 5400 RPM laptop drive. The mysql executable is on the internal drive, but the data lives on the external drive. I'd appreciate some thoughts on that. The Mini has 2 GB RAM, the G5 had 4 GB, though the speed of the long queries was the same with 1.25 GB, 2 GB or 4 GB on the G5. I don't have any real benchmarks other than the long DB queries. Overall, it feels faster than the G5. It serves up CGI's and pages, processes files, runs programs, etc. as fast as the G5. Mike Schienle
Re: Storable problem on Intel Mac Mini
On Fri, May 12, 2006 10:03 pm, Joel Rees wrote: On 2006.5.12, at 08:54 PM, Mike Schienle wrote: On Fri, May 12, 2006 7:40 am, Mike Schienle wrote: On Fri, May 12, 2006 7:05 am, Joel Rees wrote: On 2006.5.12, at 10:01 AM, Mike Schienle wrote: Hi all - I just installed an Intel Mac Mini as a replacement for a dual 1.8 GHz G5 at my colocation place a couple days ago. Can I ask a silly question in public, or would off-list be more appropriate? I thought that would raise an eyebrow :-) Heh. Some trolls, at any rate, are not evil. The G5 began having stability problems. It would stop authenticating users (email, ftp, logins, etc. would fail, but web server would continue) after anywhere from 2 to 24 hours. My instant reaction to that would have been putting a stripped-down whitebox running OpenBSD as a logging firewall between the G5 and the 'net, to check for attacks on the mail and ftp subsystems. Attempts to install a trojan for the wrong processor might have been causing DOS on the attacked services? I can't rule anything out since I haven't nailed the solution yet. There were the occasional attempts at breaking in, but nothing concerted and none of the attempts succeeded or corresponded to the problem times. One thing that seems odd to me is that if I did a lot of things either interactively or via cron that continued to authenticate, such as ssh and ftp, it would typically stay up longer than if I let it just idle. It wasn't consistent though. It could stay up for 24 hours, an hour, or anywhere in between, but it tended toward the longer time frame. I'm not completely convinced this is a hardware issue, but the colocation guys and a couple other folks who play with hardware and systems often enough have said that it appears to be RAM or PSU. We eliminated the RAM issue last week. (I should check whether OpenBSD has drivers for IP over firewire or for the USB to ethernet converters. If so, a Mini might do as well as a whitebox with two NICs.) That actually made things worse, it went from failing to authenticate to complete lockups within a few minutes, so back to the original setup thanks to being able to shuffle things around with the spare disks. Could be an unrelated problem? A definite maybe. My wife is a massage therapist and has gifted hands. She's cured a couple printers and some bike computers in her time, not to mention several hundred backs and shoulders. Unfortunately, the G5 went from the colo in Dallas, flew home to Chicago, and is now with me in Maine after a couple days of driving, without ever getting out of the box for her to lay hands on it. I have a new gig here in Maine starting Monday, the original message in this thread was from an undisclosed/unknown location in Ohio. As soon as that happens I expect to put the G5 back. And here I was thinking that someone in your organization had requested the G5 for the art department. ;:-/ Well, the organization consists of my wife and I. No recent requests have come through, other than replace that POS with something we don't have to worry about. This was after a week or so of wondering what the hell was going on and a couple weeks of actively trying to solve it. I feel like I bet the farm when I picked up the Mini. That could have gone wrong so many different ways, but has worked out fine so far. Another swag might be the CPU or the heat sink? Thanks. I'll add those to the dart board. Yeah, the notebook grade disk will slow the thing down, about 15% would not be unexpected. RAM reduction will tend to have more drastic effects when it has effects. I'm not familiar enough with FW400 to hazard a guess, although I have a gut feeling the difference is not that big unless there's constant bulk (100MB) raw data motion. 20 minutes is a long query, indeed. I'd be tempted, once you have the G5 back up, to keep the Mini on-line and run the DB on the one and the web server on the other. One of the things that squelches that temptation is the colocation fee for a 2nd system, but yeah, that would be nice. Regarding the query length, I've done what I can with setting up indexes, but I haven't studied MySQL's plan for it. The application finished up about the same time this problem showed up (the authentication problem still occurs whether this program runs or not, and predates the program by a couple weeks). I'm sure I'll find a couple things in there to speed it up, hopefully in a big way. At the moment, it just gets kicked off at dawn, so there's no real time rush, but it's always nice to have an optimal solution. One reason I was interested, if you were planning to keep the Mini on line, I'd be interested in what strategies you have for wear and tear, my experience being that notebook-grade disks running full-time tend to burn out after about a year. Without really giving it much thought, I just considered the Mini not a server and didn't want to leave it there indefinitely
Storable problem on Intel Mac Mini
Hi all - I just installed an Intel Mac Mini as a replacement for a dual 1.8 GHz G5 at my colocation place a couple days ago. All seems to be going fine with one exception so far. This error is showing up in my web error logs: [Thu May 11 19:21:18 2006] [error] [client 67.155.17.98] Byte order is not compatible at blib/lib/Storable.pm (autosplit into blib/lib/auto/Storable/_retrieve.al) line 331, DATA line 4, at /Library/Tenon/WebServer/WebSites/blosxom/plugins/calendar line 322, referer: http://www.customvisuals.com/ This is from the blosxom weblog program, so it was a simple matter of just turning off the calendar function for now. However, the issue with Storable.pm still remains. Has anyone run into this? Mike Schienle
Re: What Perl editor do you recommend?
On Wed, March 2, 2005 12:43 pm, Wiggins d'Anconia said: Ted Zeng wrote: Hi, Thanks for the help here. I am almost finishing my first tool on OS X. Vim. Steep learning curve, learn once, use forever, anywhere. http://danconia.org I'm a vim and BBEdit user. If you're interested in a collaborative environment, you can check out SubEthaEdit at http://www.codingmonkeys.de/subethaedit/ -- Mike Schienle
Hiding warning from module
Hi all -
I'm using the Spreadsheet::ParseExcel::Simple module to extract data
from some Excel files. Everything is running nicely, but I'm getting a
warning from the module when I read one of the Excel files, but not
with all of them. I haven't had the time to find out the exact cause,
but it is not causing problems with the processing. Can someone help
out with a way to correct the error or suppress the warning? I'm
getting about 100 warnings on a file with 11,000 records. I'm
developing on MacOS X, but the error is also showing up on a Windows
2000 target.
I'm running the entire thing with strict and warnings on, as usual. Can
I turn that off for a module?
Here's the message when I run the program:
Character in 'C' format wrapped in pack at
/usr/local/cb/perl5.8.4/lib/site_perl/5.8.4/Spreadsheet/ParseExcel/
FmtDefault.pm line 68.
Here is the section of the module that is generating the error:
63: # TextFmt (for Spreadsheet::ParseExcel::FmtDefault)
64:
#---
---
65: sub TextFmt($$;$) {
66: my($oThis, $sTxt, $sCode) [EMAIL PROTECTED];
67: return $sTxt if((! defined($sCode)) || ($sCode eq '_native_'));
68: return pack('C*', unpack('n*', $sTxt));
69: }
Here's a chunk of data from the Excel file (5 records, 6 fields each):
A5139 Power Passion Murder Michelle Pfeiffer $2.50 A-9537
A5149 Rage: 20 Yrs Of Punk Rock West Coast Style Dead Kennedys/Circle
Jerks/Germs/Christian Death $3.50 A-9538
A549 Secret Agent Dir: Alfred Hitchcock Robert Young/Peter Lorre/John
Gielgud $1.50 A-9539
A5619 Songs Of Cassavetes (BW Indie Rock Doc) Sleater-Kinney/Dub
Narcotic Sound System/Peeches $3.50 A-9540
A5689 Sound Of Jazz: 1957 TV Show B Holiday/Count Basie/L Young/C
Hawkins/Red Allen $3.50 A-9541
And here's the code in my program. The errors show up on the read
statement.
foreach (@xlFiles) {
$xls = Spreadsheet::ParseExcel::Simple-read($_);
foreach $sheet ($xls-sheets) {
while ($sheet-has_data) {
Any help or ideas would be greatly appreciated.
Mike Schienle
Re: Hiding warning from module
On May 06, 2004, at 10:00 AM, Mike Schienle wrote:
Here's the message when I run the program:
Character in 'C' format wrapped in pack at
/usr/local/cb/perl5.8.4/lib/site_perl/5.8.4/Spreadsheet/ParseExcel/
FmtDefault.pm line 68.
Getting a little further along here. It looks like these are being
generated by high-ascii characters (is that the right term?). Ellipses
and apostrophes (not single quotes) are causing the errors. The
ellipses show up on the terminal as ampersands. I put the following
line between lines 67 and 68 which stopped the messages caused by the
ampersands (ellipses), but didn't stop the messages caused by
apostrophes.
return $sTxt if ($sTxt =~ '');
Is there some generic way to convert these to their equivalent ASCII
character?
Here is the section of the module that is generating the error:
63: # TextFmt (for Spreadsheet::ParseExcel::FmtDefault)
64:
#--
65: sub TextFmt($$;$) {
66: my($oThis, $sTxt, $sCode) [EMAIL PROTECTED];
67: return $sTxt if((! defined($sCode)) || ($sCode eq '_native_'));
68: return pack('C*', unpack('n*', $sTxt));
69: }
Mike Schienle
Archive::Zip
Hi all -
I just put together an application using Archive::Zip that intercepts
emails sent to an address on my MacOS X 10.2.8 system. It works just
fine when the files are sent from another Mac using the built-in
archive command. However, my client is using WinZip from his system and
it's going through an MS Exchange server en route to my Mac server and
an error occurs when the email is processed. Is there something
particular to WinZip vs. Mac's archive command that is causing the
error below? Is there a better way of using Archive::Zip than the way I
have it in the code below? I'm digging through the Archive::Zip docs,
but nothing is jumping out at me.
# begin returned message from email
- The following addresses had permanent fatal errors -
|/Users/test1/bin/mailExpenses.pl
(reason: 255)
(expanded from: [EMAIL PROTECTED])
- Transcript of session follows -
Can't call method path on an undefined value at
/usr/adm/sm.bin/mailExpenses.pl line 94.
554 5.3.0 unknown mailer error 255
# end returned message from email
# begin section of code where error occurs
use Archive::Zip qw(:ERROR_CODES :CONSTANTS);
# loop through the file attachments
for ($i = 0; $i $num_parts; $i++) {
$part = $entity-parts($i);
$content_type = $part-mime_type;
$body = $part-as_string;
$bh = $part-bodyhandle;
$filename = $bh-path; # line 94
# end section of code where error occurs
Mike Schienle
Re: Archive::Zip
On Mar 18, 2004, at 01:03 PM, Wiggins d Anconia wrote: The error you are getting isn't related to Archive::Zip it appears to be related to the message parsing, MIME::Entity/MIME-Tools maybe? You haven't shown us code for Archive::Zip other than the use, at least that I can tell. Doh! You're absolutely right. I have use MIME::Parser; use MIME::Entity; That's what I get for rushing to finish something when a vacation to Alaska tomorrow is on my mind :-) I'll deal with the MIME stuff using the comments you provided below and see if I can get that straightened out. Many thanks. I would suggest checking out the MIME headers for the messages for the different sending servers, Exchange could definitely be using different headers. Can you show us more message parsing code? And is the attachment getting nested? A cursory glance at the docs suggest this might be a 'message/' versus 'multipart/' issue in how Exchange builds its headers. I am also not sure if you can call 'path' on what 'bodyhandle' returns, from the docs it indicates that it contains the data directly rather than a file/path. Mike Schienle
MIME::Entity (Re: Archive::Zip)
Hi all - The problem turned out to be sending the files in HTML instead of plain text. As soon as I switched the message type to plain text everything worked. Sorry for the confusion with the wrong subject line earlier. Mike Schienle
Re: Installing DBD::mysql
On Feb 04, 2004, at 01:13 PM, Jan Eden wrote: Thanks, I read your post carefully. MySQL and the Perl DBI module are installed. I am still stuck, though. The command perl Makefile.PL for DBD::mysql tells me my setting looks good and uses mysql_config to determine various flags. make / make test give me an error: That's in the archives at http://www.mail-archive.com/[EMAIL PROTECTED]/msg05738.html Mike Schienle, Custom Visuals, LLC http://www.customvisuals.com/
HTML to PDF converter
Hi all - I need to batch convert a hundred or so HTML pages to PDF on a regular basis. I've looked on the web a bit, CPAN and the last year or so of The Perl Journal, but I'm getting more confused the longer I search :-) It looks like HTML::HTMLDoc is the way to go at this point. Can someone give me an idea if that's the most appropriate module? If not, are there other recommendations? Mike Schienle
JPG to Quicktime
Hi all - I have a webcam and am using EvoCam to generate JPG's from it. EvoCam will also generate QuickTime movies, but it takes too long on my old Pismo (500 MHz G3) and I would rather have the JPG's than the movies. I also have QuickTime Pro, which will allow you to make movies from a directory of JPG's, but you have to open QuickTime Pro to do that. Is there some way to make movies from the command line? I looked through the table of contents and index of Perl Graphics Programming but didn't see any mention of QuickTime. I'd prefer using Perl, of course, but pointers to AppleScript or shell are certainly welcome. Mike Schienle
Re: DBI and DBD::MySQL (Panther)
On Friday, August 8, 2003, at 8:35 AM, Mike Schienle wrote: On Friday, August 8, 2003, at 7:28 AM, John Delacour wrote: At 4:09 pm -0600 7/8/03, Mike Schienle wrote: I'm having some trouble with DBI and DBD::MysqlPP (and DBD::MySQL) on 10.3. Can I get a sanity check response that some people are able to run one of these? 10.3 is not that important for what I'm working on, but MySQL is, so I can roll back to older versions of MacOS X, MySQL, etc., if necessary. I never got DBD::MySQL to make so I tried MySQLPP today, which installed fine. I'm about to check out DBI::PurePerl, as well. Any hints on getting this working so I don't have to roll back would be greatly appreciated. I haven't tried yet on Panther, but I guess nothing has changed and that you'll have to install Perl without threads in you wand to use DBI and MySQL. http://nathan.torkington.com/mac/ Thanks for the link, John. I'm also going to move back from an Alpha MySQL 4.1 to 4.0. I'll report back if anything works. Using MySQL 4.0, DBI 1.37 and DBD::mysqlPP worked for me. I'm getting a compile error with DBD::mysql listed below (I can spend a little time troubleshooting this, but not much): cpan install DBD::mysql Running install for module DBD::mysql Running make for R/RU/RUDY/DBD-mysql-2.9002.tar.gz ... Removing previously used /Users/mschienle/.cpan/build/DBD-mysql-2.9002 CPAN: Module::Signature security checks disabled because Module::Signature not installed. Please consider installing the Module::Signature module. CPAN.pm: Going to build R/RU/RUDY/DBD-mysql-2.9002.tar.gz I will use the following settings for compiling and testing: cflags(mysql_config) = -I'/usr/local/include/mysql' libs (mysql_config) = -L/usr/local/lib/mysql -lmysqlclient -lz -lm nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 0 testdb(default ) = test testhost (default ) = testpassword (default ) = testuser (default ) = To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Argument 6.10_03 isn't numeric in numeric ge (=) at Makefile.PL line 89, PIPE line 58. Checking if your kit is complete... Looks good Using DBI 1.37 installed in /Library/Perl/5.8.1/darwin-thread-multi-2level/auto/DBI Writing Makefile for DBD::mysql cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm cp lib/Mysql.pm blib/lib/Mysql.pm cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm cc -c -I/Library/Perl/5.8.1/darwin-thread-multi-2level/auto/DBI -I'/usr/local/include/mysql' -g -pipe -pipe -fno-common -no-cpp-precomp -fno-strict-aliasing -Os -DVERSION=\2.9002\ -DXS_VERSION=\2.9002\ -I/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE dbdimp.c /usr/local/bin/perl -p -e s/~DRIVER~/mysql/g /Library/Perl/5.8.1/darwin-thread-multi-2level/auto/DBI/Driver.xst mysql.xsi /usr/local/bin/perl /System/Library/Perl/5.8.1/ExtUtils/xsubpp -typemap /System/Library/Perl/5.8.1/ExtUtils/typemap mysql.xs mysql.xsc mv mysql.xsc mysql.c Warning: duplicate function definition 'do' detected in mysql.xs, line 193 Warning: duplicate function definition 'rows' detected in mysql.xs, line 291 cc -c -I/Library/Perl/5.8.1/darwin-thread-multi-2level/auto/DBI -I'/usr/local/include/mysql' -g -pipe -pipe -fno-common -no-cpp-precomp -fno-strict-aliasing -Os -DVERSION=\2.9002\ -DXS_VERSION=\2.9002\ -I/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE mysql.c Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.bundle LD_RUN_PATH=/usr/local/lib/mysql:/usr/lib /usr/local/bin/perl myld MACOSX_DEPLOYMENT_TARGET=10.3 cc -bundle -undefined dynamic_lookup -L/usr/local/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.bundle -L/usr/local/lib/mysql -lmysqlclient -lz -lm make: *** [blib/arch/auto/DBD/mysql/mysql.bundle] Error 1 /usr/bin/make -- NOT OK Running make test Can't test without successful make Running make install make had returned bad status, install seems impossible Mike Schienle
Re: DBI and DBD::MySQL (Panther)
On Friday, August 8, 2003, at 7:28 AM, John Delacour wrote: At 4:09 pm -0600 7/8/03, Mike Schienle wrote: I'm having some trouble with DBI and DBD::MysqlPP (and DBD::MySQL) on 10.3. Can I get a sanity check response that some people are able to run one of these? 10.3 is not that important for what I'm working on, but MySQL is, so I can roll back to older versions of MacOS X, MySQL, etc., if necessary. I never got DBD::MySQL to make so I tried MySQLPP today, which installed fine. I'm about to check out DBI::PurePerl, as well. Any hints on getting this working so I don't have to roll back would be greatly appreciated. I haven't tried yet on Panther, but I guess nothing has changed and that you'll have to install Perl without threads in you wand to use DBI and MySQL. http://nathan.torkington.com/mac/ Thanks for the link, John. I'm also going to move back from an Alpha MySQL 4.1 to 4.0. I'll report back if anything works. Mike Schienle
Re: DBI and DBD::MySQL (Panther)
On Friday, August 8, 2003, at 10:07 AM, Robert Whittle wrote: Does this mean that the version of perl installed on Panther will not support DBI and DBD::MySQL? I wouldn't try to read into my situation too much. I'm also using MySQL Alpha release 4.1.x. So, an alpha DB on a beta OS. I think I just walked past the edge. Mike Schienle
DBI and DBD::MySQL (Panther)
Hi all -
I'm having some trouble with DBI and DBD::MysqlPP (and DBD::MySQL) on
10.3. Can I get a sanity check response that some people are able to
run one of these? 10.3 is not that important for what I'm working on,
but MySQL is, so I can roll back to older versions of MacOS X, MySQL,
etc., if necessary. I never got DBD::MySQL to make so I tried MySQLPP
today, which installed fine. I'm about to check out DBI::PurePerl, as
well.
Any hints on getting this working so I don't have to roll back would be
greatly appreciated.
Here's the message I'm getting:
Use of uninitialized value in concatenation (.) or string at
/Library/Perl/5.8.1/darwin-thread-multi-2level/DBI.pm line 584.
DBI connect('RSI','www',...) failed: at
/Users/mschienle/landsat7/landsat7gain.pl line 173
(in cleanup) Can't call method close on an undefined value at
/Library/Perl/5.8.1/DBD/mysqlPP.pm line 314.
My connect string at line 173 is:
$dbh = DBI-connect(dbi:mysqlPP:RSI, myuser, mypass, \%attr) or
die Cannot connect to $dsn;
And from the command line:
[EMAIL PROTECTED](53)% mysql rsi
mysql show tables;
+---+
| Tables_in_rsi |
+---+
| landsat7gain |
| landsat7param |
+---+
Mike Schienle
OT: Re: please end this (Re: A .. by anyother name...)
On Sunday, March 16, 2003, at 11:05 AM, Puneet Kishor wrote: 2. I did not mean any disrespect to Tim. Now I realize that some can be offended by it, however, I would feel justifiably reprimanded _only_ if the reprimand came from Tim. Many folks on this list had harsh words for me, directly or indirectly, even though I did nothing to besmirch their name or character. I never said any unkind words to any of you. Perhaps this quote will help you understand Randal's response. In Germany they came first for the Communists, and I didnt speak up because I wasnt a Communist. Then they came for the Jews, and I didnt speak up because I wasnt a Jew. Then they came for the trade unionists, and I didnt speak up because I wasnt a trade unionist. Then they came for Catholics, and I didnt speak up because I was a Protestant. Then they came for me, and by that time no one was left to speak up. Protestant minister Martin Neimoller, reflecting on Germanys fall to the Nazis Maybe that will help you reconsider if the reprimand was justified. 5. I made the original posting on the list, not to any one person privately. All responses to that should be made to the list. I disagree with your interpretation of netiquette, and this is not being sent privately solely for that reason. Mike Schienle
Re: OT: Re: please end this (Re: A .. by anyother name...)
On Sunday, March 16, 2003, at 03:11 PM, Geoffrey F. Green wrote: On 3/16/03 4:56 PM, Mike Schienle [EMAIL PROTECTED] wrote: Protestant minister Martin Neimoller, reflecting on Germanys fall to the Nazis Maybe that will help you reconsider if the reprimand was justified. Now I'm offended. Jews subjugated by the Nazis. Tim O'Reilly called Tim O Really. Not equivalent in my mind. The point is that Randal spoke up for Tim, who wasn't present. Puneet said he would only accept a reprimand from Tim. Not intended to be equivalent, but the reason for not excusing bad behavior ought to be clear. Mike Schienle
Re: fix_prebinding ?
Has there been any news on this? I installed Nat's Perl 5.8 DMG on 10.2.4 a couple days ago and am seeing the same error in system.log. On Wednesday, January 15, 2003, at 08:07 AM, Ken Williams wrote: On Wednesday, January 15, 2003, at 12:55 AM, Jeff Kolber wrote: Hi list. each time I invoke Perl (5.8 on os x 10.2.3) I get this action seen is syslog; /usr/libexec/fix_prebinding: /usr/bin/perl could not be launched prebound. /usr/libexec/fix_prebinding: /usr/bin/perl couldn't be prebound in the past, and probably can't be prebound now. /usr/libexec/fix_prebinding: 2003-01-15 00:51:22 -0500: prebinding for perl done. ... I can't comment on how to get fix_prebinding to work, but your analysis about FCGI is correct - the penalty for not prebinding only happens at application startup, and doesn't affect things thereafter. So FCGI would help, but I do recommend figuring out what's wrong with perl and fixing it anyway. Mike Schienle
Re: BBEdit 7.0 - Not Impressed
On Thu, 14 Nov 2002 08:09:43 -0600 Pete Prodoehl wrote: jEdit anyone? http://jedit.org/ Open-source, customizable, hackable, extendable, good community, responsive developers, lots of plugins, multi-platform, etc... True, it's slower than BBEdit (since it's written in Java) but it's also more open, if that's important to you. I plan to upgrade BBEdit tonight or tomorrow as soon as I hunt down the license keys. However, I've been dealing with gvim on a PC (and occasionally on my Mac) on a fairly regular basis and it offers a language mode for IDL, something I've been asking the folks at Research Systems and BareBones to consider for quite a while. It's not the only reason to choose an editor, but it does make my life a little easier, and I'm more than comfortable with vi and its relatives. I'll be working at Research Systems in a couple weeks - maybe I can get something started along those lines one day. Mike Schienle Interactive Visuals, Inc. http://www.ivsoftware.com - This message sent using EMUmail -- http://www.emumail.com - Jumping through hoops to get E-mail on the road? You've got two choices: Join the circus, or use MollyMail. Molly Mail -- http://www.mollymail.com
