RE: [CentOS] Recommendations for a “real RAID 1 card on Centos box
You can turn on write back caching if you have a UPS as well (provided your UPS is wired into your system for a graceful shutdown) Hopefully you have a redundant PS unit. Having a UPS is not going to help if your PS fails. That's a very good point never thought of that. Acrtually this RAID 1 setup I'm planning is for my desktop machine, problem is is's not built like a server so there is not the traditional slid in bay for a second PS as do many 1 and 2u rack servers have. Unless there is some specialty product available that somehow fits in to a tower case. Could you reccomend a redundant PS for a desktop machine (if they exist)? _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Recommendations for a “real RAID 1 card on Centos box
You can turn on write back caching if you have a UPS as well (provided your UPS is wired into your system for a graceful shutdown) Hopefully you have a redundant PS unit. Having a UPS is not going to help if your PS fails. redundant power supplies connected to redundant UPS's. I've seen more UPS failures than I've ever had failed PSUs on proper server grade hardware. This might be getting a bit elaborate for a desktop machine. I really want RAID because I'm tired every couple years of hard drive crashes and having to start from scratch and spending a week setting up new drives and getting my design software back on line and trying to recover data. What do you think of alternative back up systems, such as a tape backup with bare metal restore software? I'd go that route instead if I could fine a solution which would allow me to restore to different hardware, i.e. if my motherboard dies and I need to buy a different brand or model MB. I know Storix back up software has this capability - I use storix on my Linux server with RAID 1. @ home I have one Linux and one Windows desktop machine. _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Recommendations for a “real RAID 1 ca rd on Centos box
That is true, buy high quality stuff up front for fewer problems down the road. Not a sure bet, but a better one. In the half dozen systems I've been running at home for the past several years none of them have suffered a hardware failure of any kind(fortunately). I've been running PC Power and Cooling power supplies for about 9 years now, really high quality PSUs(last one I bought was about 4 years ago, can't speak for their quality now). So for a top quality power supply for a mission critical desktop machine, which brand(s) would you reccomend? One of the towers I have is a Thermaltake Xaser 3 with lots of room, and I just bought a new Antec Sonata III tower with a 500 watt PS. So BBU is certainly a nice thing to have but at least in my experience isn't absolutely critical. Then for a Mission critical desktop machine, if you had to make a choice, would you go with a good quality UPS and/or redundant power supplies, or a BBU instead? Of course for absolutely critical things I don't use server-based RAID anyways. Multiple redundant controllers, multiple redundant paths(to both the disks and to the hosts), is the way to go(assuming your application(s) aren't built to be able to run on something like a distributed file system). I've seen that some of the latest HP servers have dual ported SAS disks, which sounds pretty neat. I assume they still only have one controller though. As an alternative to RAID1 for a mission critical desktop machine @ home, what would you reccomend? Maybe a bare metal restore solution able to restore to different hardware, (i.e. if a motherboard dies and drive crashes due to power spike or some catastrophe, I'm screwed if I can't find the exact same make - model)? _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Recommendations for a “real RAID 1 card on Centos box
That's a very good point never thought of that. Acrtually this RAID 1 setup I'm planning is for my desktop machine, problem is is's not built like a server so there is not the traditional slid in bay for a second PS as do many 1 and 2u rack servers have. Unless there is some specialty product available that somehow fits in to a tower case. Could you reccomend a redundant PS for a desktop machine (if they exist)? The whole system needs to be designed for dual supplies. You can't just plop down two power supplies in parallel without some circuitry that attempts to monitor balance them out. Yes I realize that thanks, just wondered if there was some new product combo out there for existing towers, i.e. dual power supplies with controller boards, from your comment I assume there is not. I'd be willing to migrate all of my hardware, i.e. motherboard, monitor card etc, to a new case, if I could find a case which includes a controller card for the power supplies, or a case that comes complete with such. I'm curious - why does your desktop needs so much redundancy ? Because I use the desktop machines about ten hours a day, I work out of home, doing graphic design, web design, uploading files to server, managing server, etc. The home desktop machines are just as mission critical as the server I upload to is. Maybe more so, because if there is a problem server side, I need remote access to it 24/7. _ Climb to the top of the charts! Play the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Recommendations for a “real RAID 1 card on Centos box
You can turn on write back caching if you have a UPS as well (provided your UPS is wired into your system for a graceful shutdown) Hopefully you have a redundant PS unit. Having a UPS is not going to help if your PS fails. That's a very good point never thought of that. Acrtually this RAID 1 setup I'm planning is for my desktop machine, problem is is's not built like a server so there is not the traditional slid in bay for a second PS as do many 1 and 2u rack servers have. Unless there is some specialty product available that somehow fits in to a tower case. Could you reccomend a redundant PS for a desktop machine (if they exist)? The whole system needs to be designed for dual supplies. You can't just plop down two power supplies in parallel without some circuitry that attempts to monitor balance them out. I'm curious - why does your desktop needs so much redundancy ? Just for fun, the first hit on a google for redundant atx power supply http://www.directron.com/tc400r8.html Seems you can just plop one into your std atx chassis . . . Hey thank's that's pretty cool, I'll check it out! _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Recommendations for a “real RAID 1 ca rd on Centos box
This is getting OT and you are going to end up spending more on redundancy then if you just called Dell and ordered another computer. I agree with you in that it's cheaper to buy another home computer than to design a system with redundancy. However that new conputer I would order from Dell probabally would not have the redundancy I need in a a workstation, and I would just end up back where I started anyway. _ Helping your favorite cause is as easy as instant messaging. You IM, we give. http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Recommendations for a real RAID 1 card on Centos box
This is getting OT and you are going to end up spending more on redundancy then if you just called Dell and ordered another computer. I agree with you in that it's cheaper to buy another home computer than to design a system with redundancy. However that new conputer I would order from Dell probabally would not have the redundancy I need in a a workstation, and I would just end up back where I started anyway. I think you missed my point. If workstation A fails, call Dell and have another one overnighted, or call Dell today and order a second workstation to have as a backup or act as a secondary workstation. Their Vostros line is cheap (in appearance, components and price), but is functional, performs well and did I say cheap already, so you can get 2 for the price of 1 highly redundant system. Ah I got it now thanks. Does the Vostros come with either a bare metal restore tape backup system or RAID ( which is required for my situation)? _ Climb to the top of the charts! Play the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Recommendations for a “real RAID 1 card on Centos box
You are definitely making your life more difficult then is needed for a desktop machine. You said you have 4 hard disks. Make a software RAID1 out of the first two. Make a software RAID1 out of the second two and your good to go. You can use dump/restore to backup the logical volumes on the second RAID set to an LV on the first. No need for bare metal restore. Just need to get some working Linux distro to be able to read your files. Going HW RAID for your desktop is going to get in the way of you getting things going and if your HW RAID card fails then what? Your drives will only work with another identical HW RAID card. -Ross That makes total sense Ross, I think I may end up going with software raid and investing in a good hot swap redundant power supply that would fit into an ATX case, combined with a good UPS. That brings up a last question on possiblity of either a 3ware or acrea RAID 1 cards. I'm wondering how long I would be able to order a replacement RAID card from either of 3ware or areea. Anyone know if 3ware or acrea stock identical replacement cards for their SATA 4 port raid cards for several years out? Do they stock past the three year warranty period? _ Helping your favorite cause is as easy as instant messaging. You IM, we give. http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Recommendations for a “real RAID 1 card on Centos box
Date: Fri, 14 Mar 2008 10:33:29 -0400 You are definitely making your life more difficult then is needed for a desktop machine. You said you have 4 hard disks. Make a software RAID1 out of the first two. Make a software RAID1 out of the second two and your good to go. You can use dump/restore to backup the logical volumes on the second RAID set to an LV on the first. No need for bare metal restore. Just need to get some working Linux distro to be able to read your files. Going HW RAID for your desktop is going to get in the way of you getting things going and if your HW RAID card fails then what? Your drives will only work with another identical HW RAID card. -Ross That makes total sense Ross, I think I may end up going with software raid and investing in a good hot swap redundant power supply that would fit into an ATX case, combined with a good UPS. That brings up a last question on possiblity of either a 3ware or acrea RAID 1 cards. I'm wondering how long I would be able to order a replacement RAID card from either of 3ware or areea. Anyone know if 3ware or acrea stock identical replacement cards for their SATA 4 port raid cards for several years out? Do they stock past the three year warranty period? ACTUALLY I totally forgot. I absoluteluy can not use software raid. Because I use Adobe products. Adobe products do not install well on software raid systems, and tend to crash on software raid beacuse of their activation process. If I go raid, I absolutely need a hardware raid which is entirely transparent to the operating system, at least as far as adobe products are concerned. _ Climb to the top of the charts! Play the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Recommendations for a “real RAID 1 card on Centos box
No, read this: my previous thread... Sorry, I can't access your Windows Live Hotmail inbox . . . Ah haha sorry was not paying attention, it's here: :) http://lists.centos.org/pipermail/centos/2008-March/096054.html _ Need to know the score, the latest news, or you need your Hotmail®-get your fix. http://www.msnmobilefix.com/Default.aspx___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Recommendations for a “real RAID 1 card on Centos box
Sorry, I can't access your Windows Live Hotmail inbox . . . Ah haha sorry was not paying attention, it's here: :) http://lists.centos.org/pipermail/centos/2008-March/096054.html OOPS - I need some more coffee this am - HERE is the correct thread: http://lists.centos.org/pipermail/centos/2008-March/096063.html _ Climb to the top of the charts! Play the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Recommendations for a real RAID 1 card on Centos box
I have two home workstation machines. One is Centos, and one is Windows (the one I use Adobe on). I'd prefer if possible to have the same type of RAID cards on both machines, because easier to manage and if I ever decide to sell or give away one machine, I can pull the raid card and use it as a backup. I've always considered this a huge advantage of software raid1. Even if everything on a machine melts except for one drive, you can recover the data from it and you don't need a special controller to do it. On windows, you need the server versions to do mirroring, though. If you can tolerate losing an hour's work or so, you could just schedule rsync commands to keep copies updated on another (perhaps external) drive or to another machine on the network - or get a Mac with it's 'time machine' backup. This approach is actually safer than RAID alone, since operator or software errors will wipe out your mirrored copy instantly as well with RAID. Unfortunately I can't use software RAID1 because of this: http://lists.centos.org/pipermail/centos/2008-March/096063.html _ Helping your favorite cause is as easy as instant messaging. You IM, we give. http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Re: Recommendations for a �card on Cento s box
Explain your definition of a mission critical desktop. Does the entire enterprise stop functioning if this desktop stops? I am THE tech support for my company, but my desktop could die right now, and although I would be heartbroken and a little peeved, I could just fire up my lappy and get back to work in a few minutes. I usually have 2 desktops running, just in case I need to put out fires while my main desktop is doing the windows reboot dance. If my linux machine stops functioning it's not as bad as the windows box going off line, but it still takes a day or two to get things back on line with the linux box with all the software I installed on it. If the windows machine stops functioning, then yes it's a pain, it's at least two days by the time I get back up and running because much of my work is graphic design and that's where all my adobe stuff is loaded on, and it takes a long time to get the OS re instlled, then grabbing my data, and re installing many many software applications etc. Because I am a one person company I just don't have time to spend days getting a machine back on line, and it's happened more than once. An hour or two however to get things runing again would not harm my work flow that much. _ Helping your favorite cause is as easy as instant messaging. You IM, we give. http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Re: Recommendations for a �ard on Centos box
You are definitely making your life more difficult then is needed for a desktop machine. You said you have 4 hard disks. Make a software RAID1 out of the first two. Make a software RAID1 out of the second two and your good to go. You can use dump/restore to backup the logical volumes on the second RAID set to an LV on the first. No need for bare metal restore. Just need to get some working Linux distro to be able to read your files. Going HW RAID for your desktop is going to get in the way of you getting things going and if your HW RAID card fails then what? Your drives will only work with another identical HW RAID card. -Ross That makes total sense Ross, I think I may end up going with software raid and investing in a good hot swap redundant power supply that would fit into an ATX case, combined with a good UPS. That brings up a last question on possiblity of either a 3ware or acrea RAID 1 cards. I'm wondering how long I would be able to order a replacement RAID card from either of 3ware or areea. Anyone know if 3ware or acrea stock identical replacement cards for their SATA 4 port raid cards for several years out? Do they stock past the three year warranty period? AFAIR (at least with 3ware) the newer cards will usually still support the older arrays. Yeah, check out this thread... http://lists.centos.org/pipermail/centos/2008-March/096073.html _ Helping your favorite cause is as easy as instant messaging. You IM, we give. http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Recommendations for a real RAID 1 card on Centos box
Unfortunately I can't use software RAID1 because of this: http://lists.centos.org/pipermail/centos/2008-March/096063.html First, you should probably get your applications from a company that doesn't hate its customers... But aside from that, this restriction should only apply to the place where you install the app, not where you store your own work. Why don't you ghost-image (or use the free and very nice clonezilla-live) your system disk for a quick bare-metal restore, and put your own work on a separate raid-mirrored partition? And since you seem to be very paranoid about your disks, use some other backup mechanism like rsync to another location at some frequent intervals too. Yeah I agree they are difficult to deal with sometimes. And expensive. I agree the restriction should only apply to the place where I install the application. I told them that two years ago and they said that's the way their software is designed, to prevent installation if RAID 1 is detected, that's what the tech support guy told me anyway. They want to prevent someone from taking a mirrored drive and giving it to someone else to use on a different machine. They told me this two years ago not sure if they have the same policy though - but my version is about two years old. I could clone just my data somehow on a seperate drive or backup (not the applications and OS), yet I also want to clone the entire OS and applications that's where most of the time goes into as far as restoring a disk or buying a new disk is concerned. I'm paranoid because I've had 3 crashes in the past 4 years and it's always a pain delays my work for days. SATA drives are made cheap compared to server grade SCSI's. _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Recommendations for a real RAID 1 card on Centos box
Ah I figured someone would ask that. I use pretty much all major adobe products, Photoshop, Illustrator, Flash, just about the entire suite. I have two home workstation machines. One is Centos, and one is Windows (the one I use Adobe on). I'd prefer if possible to have the same type of RAID cards on both machines, because easier to manage and if I ever decide to sell or give away one machine, I can pull the raid card and use it as a backup. If you are a graphic designer, I'm curious what you use the CentOS box for (or why you use Windows and not Mac :-) Good question when I started out I had windows so that's what I bought - Adobe windows versions. I'm considering migrating to Mac though because Adobe just started a new program where one can migrate to mac versions without paying full price for a new version - they used to charge full price for upgrades if one wanted to switch from Windows to mac. Now they just cancel out the windows version if one migrates to Mac. From experience I have learned that Photoshop will not install on software raid on my W2K machine - I tried it two years ago, could not get it to install, and after a few days trying to get it to work, called Adobe tech support and at that time the tech support person told me that their products don't run on software raid because they don't want people having multiple copies of one license on a second drive (unless it's for their second copy allowance for a laptop or second machine owned by same person, and only one or the other - the laptop or second desktop are run at the same time - my second copy is on a laptop ). The Photoshop support tech was just shrugging you off here because he didn't want to support you. There exists no such stipulation in Adobe's EULA. As long as it is running on the machine it was licensed for and that machine's OS is supported then you are good. Running on RAID has nothing to do with second copies and second machine allowance as the storage medium is not the key in licensing, the processor(s) are. Adobe needn't even be installed on the local HD if you can get away with a network install and all that registry crap, but it better have a license for the CPU it's running on. Just spoke with Adobe sales today checking into upgrade pricing. The sales guy said that the latest versions of all Adobe products would not install on software RAID systems, BUT he did say, if I bought a hardware raid system, then I would have no problem installing it because the OS and Adobe products do not see hardware raid. It may state in their EULA that there is no restriction running either software or hardware raid, but I have to go by what the sales department tells me. It's rediculous I know. I had run Adobe Photoshop on Windows 2000 Terminal Server running under software RAID with no problems (besides poor visual performance due to terminal services). That's great wish I could have gotten my apps to install a few years ago - at the time I tried doing it with the Adaptec 2120SA raid card which uses software raid drivers. It's a far cry from the 3ware true raid, yet I don't want to take the chance, set up true software raid, load my adobe products on disk and them find two or three years from now if I upgrade with a new version, that adobe has found a way to disable software raid compatability for all scenairos. Just curious, what version of photoshop were you using under your software raid setup? I tried it with Creative Suite 2 which includes photoshop. Also I may at some time migrate my adobe products to the Linux machine and run Adobe on WINE on the Linux box. Google just started working with the folks over @ WINE, and they want to make it so all adobe products run flawlessly on Linux - WINE, not just photoshop and illustrator. Today some adobe products run on wine well, some don't, in a few years they all will run well on a linux box using WINE. I'm not sure about running adobe using software raid on a linux box and WINE - never tried it, but going with hareware raid on the linux box eliminates another possible unknown. Don't bother. If you are a serious Adobe designer get yourself a Mac and dual boot it between OS X and CentOS or triple with Windows. Yes I think I will migrate over to mac instead of running adobe on wine, when I get the upgrade, makes much more sense. And set up a hardware RAID 1 on the new desktop mac. _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Recommendations for a real RAID 1 card on Centos box
Don't bother. If you are a serious Adobe designer get yourself a Mac and dual boot it between OS X and CentOS or triple with Windows. Or use parallels or vmware and run all 3 at once when you want... and let the built in time machine tool do backups to an external firewire or network drive. Yes, even better. I think VMware sells a version of workstation for OS X now too. Yes, and I think it will run VM's created under VMware server on linux or windows, although you may not be able to move them the other direction with some of the options you can use on the mac or windows workstation versions. I just called VMWare and the guy said that for what I wanted to do, a bare metal restore solution, that I would be better served by going with either hardware or software raid maybe combined with something like a tape backup solution, and that their desktop / workstation applications are not suited as a complete backup - bare metal restore solution. He said their system was mainly for taking system snapshots for development purposes. _ Helping your favorite cause is as easy as instant messaging. You IM, we give. http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Recommendations for a real RAID 1 card on Centos box
If you are a graphic designer, I'm curious what you use the CentOS box for (or why you use Windows and not Mac :-) Good question when I started out I had windows so that's what I bought - Adobe windows versions. I'm considering migrating to Mac though because Adobe just started a new program where one can migrate to mac versions without paying full price for a new version - they used to charge full price for upgrades if one wanted to switch from Windows to mac. Now they just cancel out the windows version if one migrates to Mac. I noticed you forgot to answer my question, but good to know Adobe has a trade-up program now ;-) OH yes did not read it all the way. To answer your question, I also use a Linux server for hosting sites I design for, it was just upgraded to Centos from an old version of RH, and for several reasons I set up the centos box @ home. I wanted to get up to speed quicker on Centos 5 and thought this would help. Plus I feel that it is more secure to use my linux machine at home to both surf the net and upload files to server, more secure for email, etc. I plan on using the Windows machine only for graphic design and not browse with it, use the linux box for surfing. And experiment with some of the Linux graphic design applications to see if they measure up to adobe - maybe some day I could dump adobe all together. _ Need to know the score, the latest news, or you need your Hotmail®-get your fix. http://www.msnmobilefix.com/Default.aspx___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Re: SSH, SCP connections to remote MySQL Database using OpenOffice Possible?
It *is* possible to do this with the OOo Calc in centos, but it takes a bit of muscle to get working... You'll also need jta, which unfortunately is non-free, and only available as an srpm from jpackage ( in the 1.6 non-free tree. I haven't seen it appear yet in 1.7). You talking about two pieces of the Java Transaction API (JTA) at: http://java.sun.com/products/jta/index.html and http://jpackage.org/ Where is the 1.6 non free tree @ jpackage? I Could not find it. Is there any documentation for JTA install on jpackage.org site? ...then installing the sun-compat-java package from jpackage.org) Where on http://jpackage.org/ is info/download for sun-compat-java? Could not find it on either the 1.6 or 1.7 tree. This next bit assumes some minimal familiarity with building rpms. You'll have to change the cvs_version string from 1_0_1_B to 1_1 in the jta spec file, and download the jta class package from http://java.sun.com/products/jta/ I didn't bother to fix the documentation related portion of the spec, but rather cheated and built the rpm with '--without javadoc' If you or someone could expand on this a bit, maybe procedural cli steps then I think I could take it from there. I started this same thread over on a major OpenOffice Mail list did not get any new info on this SSH database connect issue. Guess I'm pretty much out of luck unless I can solve this via info from this forum. _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Re: SSH, SCP connections to remote MySQL Database using OpenOffice Possible?
Sounds like an OOo problem, then. When I briefly tried testing it, there was a couple of driver options to connect to MySQL, you might try using the one you're not (IIRC one was ODBC and the other was JDBC). Ah HA! That might be the problem, I'm using the JDBC driver and I don't have the ODBC driver installed. Do you know where i could download the ODBC driver? Or, is the ODBC driver the same as the sql-connector-java-5.0.8 driver? That one I do have; I set up OpenOffice to point to that one too as I did for the JDBC Driver. _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Re: SSH, SCP connections to remote MySQL Database using OpenOffice Possible?
yum search odbc What you're looking for is the unixODBC package. In CentOS it includes an ODBC driver for MySQL as well. Or, is the ODBC driver the same as the sql-connector-java-5.0.8 driver? That one I do have; I set up OpenOffice to point to that one too as I did for the JDBC Driver. No, anything with java in the name is JDBC, not ODBC. Google is your friend as well: http://www.google.ca/search?q=openoffice+odbc+linux The first one is a tutorial on how to connect OOo to MySQL, quite old though. The second one is an article in Linux.com with some information on JDBC vs. ODBC. In general, however, I agree with Matt that your problem is OOo related and asking on an OOo list would be more fruitful. Filipe Now why didn't I think of that?!? I will and if I find a solution I'll post it on this thread thanks. _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
[CentOS] SSH, SCP connections to remote MySQL Database using OpenOffice Possible?
I'm trying to find a way to get remote connections from my Linux Desktop machine to a remote Linux box which is hosting a MySQL database, via SSH port 22, and then once connection is established, log in to the database port 3306 and have either an SSH and or SCP connection established so I can securely do edits and queries. I am able to connect this way from my Windows machine to remote server using Navicat. Both the windows desktop and the server are set up this way. I just can't figure out how to get my Linux desktop and the remote Linux box to talk this way. I can connect to the remote database via Linux desktop, it's just via an un encrypted connection through port 3306. For obvious reasons I don't want to do it that way. I tried connecting to the remote database in the same way I use Konqueror for FTP over SSH, i.e., by connecting via the fish protocol over port 22 -by enterning into OpenOffice Base for the server URL: fish://[EMAIL PROTECTED]:22 and the error that comes up in either OO Base or Calc said I must specify a port number after the : , which I did, and it still won't connect that way. My question is, is OpenOffice Calc able to connect to remote databases via SSH and or SCP? If so, do I need a plug in for that, or need to configure calc to do that in some way? How would I do this, or which plug in(s) do I need? _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] SSH, SCP connections to remote MySQL Database using OpenOffice Possible?
I can connect to the remote database via Linux desktop, it's just via an un encrypted connection through port 3306. For obvious reasons I don't want to do it that way. My question is, is OpenOffice Calc able to connect to remote databases via SSH and or SCP? If so, do I need a plug in for that, or need to configure calc to do that in some way? How would I do this, or which plug in(s) do I need? No, but what you could do is use an ssh tunnel to accomplish this. Something along the lines of ssh -L 3307:database.example.net:3306 database.example.net This will tell your system to tunnel the local port 3307 through the database box, TO the database box on port 3306. From this point, after you connect via ssh with the above command, you can simply point your database software to the local 3307 port in plain text, and it'll travel over ssh to the remote box. I've probably done a bad job explaining this, so I'll go get some more coffee. Hehe THANKS Jim I need some too! So when I ssh -L 3307:database.example.net:3306, am I doing this via terminal prior to connecting with Calc (or base), then start up base and enter in just the regular database.example.net into the Server URL field in Clac or base? Or do I need to enter ssh -L 3307:database.example.net:3306 just once in to the Server URL FIeld from within OpenOffice Calc or VBase? _ Helping your favorite cause is as easy as instant messaging. You IM, we give. http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] SSH, SCP connections to remote MySQL Database using OpenOffice Possible?
I can connect to the remote database via Linux desktop, it's just via an un encrypted connection through port 3306. For obvious reasons I don't want to do it that way. My question is, is OpenOffice Calc able to connect to remote databases via SSH and or SCP? If so, do I need a plug in for that, or need to configure calc to do that in some way? How would I do this, or which plug in(s) do I need? No, but what you could do is use an ssh tunnel to accomplish this. Something along the lines of ssh -L 3307:database.example.net:3306 database.example.net This will tell your system to tunnel the local port 3307 through the database box, TO the database box on port 3306. From this point, after you connect via ssh with the above command, you can simply point your database software to the local 3307 port in plain text, and it'll travel over ssh to the remote box. I've probably done a bad job explaining this, so I'll go get some more coffee. Hehe THANKS Jim I need some too! So when I ssh -L 3307:database.example.net:3306, am I doing this via terminal prior to connecting with Calc (or base), then start up base and enter in just the regular database.example.net into the Server URL field in Clac or base? Or do I need to enter ssh -L 3307:database.example.net:3306 just once in to the Server URL FIeld from within OpenOffice Calc or VBase? You should enter localhost:3307. That connects to the local end of your SSH tunnel. OK this is what I tried - I opened up terminal on my local desktop machine, and I issued the command: ssh -L 3307:domain.name.of.DesktopLocalMySQLserver:3306 [EMAIL PROTECTED] Then I started up OpenOffice Calc, clicked on FileNewDatabase, and in the area where it asks for the ServerURL, I entered in: localhost:3307 and just below it where it asks for the port number I also entered in 3307 (the default is 3306). The error I got was Illegal Connection Port Value 3307:3307: and I could not connect. _ Need to know the score, the latest news, or you need your Hotmail®-get your fix. http://www.msnmobilefix.com/Default.aspx___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] SSH, SCP connections to remote MySQL Database using OpenOffice Possible?
Date: Mon, 10 Mar 2008 13:27:28 -0400 From: [EMAIL PROTECTED] To: centos@centos.org Subject: Re: [CentOS] SSH,SCP connections to remote MySQL Database using OpenOffice Possible? On Mon, Mar 10, 2008 at 12:38:34PM -0400, Therese Trudeau enlightened us: I can connect to the remote database via Linux desktop, it's just via an un encrypted connection through port 3306. For obvious reasons I don't want to do it that way. My question is, is OpenOffice Calc able to connect to remote databases via SSH and or SCP? If so, do I need a plug in for that, or need to configure calc to do that in some way? How would I do this, or which plug in(s) do I need? No, but what you could do is use an ssh tunnel to accomplish this. Something along the lines of ssh -L 3307:database.example.net:3306 database.example.net This will tell your system to tunnel the local port 3307 through the database box, TO the database box on port 3306. From this point, after you connect via ssh with the above command, you can simply point your database software to the local 3307 port in plain text, and it'll travel over ssh to the remote box. I've probably done a bad job explaining this, so I'll go get some more coffee. Hehe THANKS Jim I need some too! So when I ssh -L 3307:database.example.net:3306, am I doing this via terminal prior to connecting with Calc (or base), then start up base and enter in just the regular database.example.net into the Server URL field in Clac or base? Or do I need to enter ssh -L 3307:database.example.net:3306 just once in to the Server URL FIeld from within OpenOffice Calc or VBase? You should enter localhost:3307. That connects to the local end of your SSH tunnel. OK this is what I tried - I opened up terminal on my local desktop machine, and I issued the command: ssh -L 3307:domain.name.of.DesktopLocalMySQLserver:3306 [EMAIL PROTECTED] Then I started up OpenOffice Calc, clicked on FileNewDatabase, and in the area where it asks for the ServerURL, I entered in: localhost:3307 and just below it where it asks for the port number I also entered in 3307 (the default is 3306). The error I got was Illegal Connection Port Value 3307:3307: and I could not connect. I think what you really want is ssh -L 3307:localhost:3306 remote.db.server The host in the middle is relative to the end machine. You could also probably do ssh -L 3307:remote.db.server:3306 remote.db.server (for that matter, I don't see why you couldn't do ssh -L 3306:... as long as you don't have mysql running on your desktop) OK so you are saying to enter into Terminal, either: ssh -L 3307:localhost:3306 remote.db.server , OR enter into Terminal: ssh -L 3307:remote.db.server:3306 remote.db.server and substitute in my remote server address for remote.db.server Once I do that, what should I enter into the OpenOffice Calc Spreadsheet Application Dialog box, in order to get the OpenOffice Calc local applicationwhich resides on my desktop machine to read the remote database? _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] SSH, SCP connections to remote MySQL Database using OpenOffice Possible?
Date: Mon, 10 Mar 2008 15:12:31 -0400 From: [EMAIL PROTECTED] To: centos@centos.org Subject: Re: [CentOS] SSH,SCP connections to remote MySQL Database using OpenOffice Possible? On Mon, Mar 10, 2008 at 03:08:19PM -0400, Therese Trudeau enlightened us: Date: Mon, 10 Mar 2008 13:27:28 -0400 From: [EMAIL PROTECTED] To: centos@centos.org Subject: Re: [CentOS] SSH, SCP connections to remote MySQL Database using OpenOffice Possible? On Mon, Mar 10, 2008 at 12:38:34PM -0400, Therese Trudeau enlightened us: I can connect to the remote database via Linux desktop, it's just via an un encrypted connection through port 3306. For obvious reasons I don't want to do it that way. My question is, is OpenOffice Calc able to connect to remote databases via SSH and or SCP? If so, do I need a plug in for that, or need to configure calc to do that in some way? How would I do this, or which plug in(s) do I need? No, but what you could do is use an ssh tunnel to accomplish this. Something along the lines of ssh -L 3307:database.example.net:3306 database.example.net This will tell your system to tunnel the local port 3307 through the database box, TO the database box on port 3306. From this point, after you connect via ssh with the above command, you can simply point your database software to the local 3307 port in plain text, and it'll travel over ssh to the remote box. I've probably done a bad job explaining this, so I'll go get some more coffee. Hehe THANKS Jim I need some too! So when I ssh -L 3307:database.example.net:3306, am I doing this via terminal prior to connecting with Calc (or base), then start up base and enter in just the regular database.example.net into the Server URL field in Clac or base? Or do I need to enter ssh -L 3307:database.example.net:3306 just once in to the Server URL FIeld from within OpenOffice Calc or VBase? You should enter localhost:3307. That connects to the local end of your SSH tunnel. OK this is what I tried - I opened up terminal on my local desktop machine, and I issued the command: ssh -L 3307:domain.name.of.DesktopLocalMySQLserver:3306 [EMAIL PROTECTED] Then I started up OpenOffice Calc, clicked on FileNewDatabase, and in the area where it asks for the ServerURL, I entered in: localhost:3307 and just below it where it asks for the port number I also entered in 3307 (the default is 3306). The error I got was Illegal Connection Port Value 3307:3307: and I could not connect. I think what you really want is ssh -L 3307:localhost:3306 remote.db.server The host in the middle is relative to the end machine. You could also probably do ssh -L 3307:remote.db.server:3306 remote.db.server (for that matter, I don't see why you couldn't do ssh -L 3306:... as long as you don't have mysql running on your desktop) OK so you are saying to enter into Terminal, either: ssh -L 3307:localhost:3306 remote.db.server , OR enter into Terminal: ssh -L 3307:remote.db.server:3306 remote.db.server and substitute in my remote server address for remote.db.server Once I do that, what should I enter into the OpenOffice Calc Spreadsheet Application Dialog box, in order to get the OpenOffice Calc local applicationwhich resides on my desktop machine to read the remote database? Correct, that *should* work. Sadly I can't get OpenOffice Calc to connect that way, I keep getting those “Illegal Connection Port Value 3307:3307” errors from Calc when I enter in “localhost:3307” into Calc open new database box. _ Shed those extra pounds with MSN and The Biggest Loser! http://biggestloser.msn.com/___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] SSH, SCP connections to remote MySQL Database using OpenOffice Possible?
From: [EMAIL PROTECTED] To: centos@centos.org Subject: RE: [CentOS] SSH,SCP connections to remote MySQL Database using OpenOffice Possible? Date: Mon, 10 Mar 2008 16:33:49 -0400 Date: Mon, 10 Mar 2008 15:12:31 -0400 From: [EMAIL PROTECTED] To: centos@centos.org Subject: Re: [CentOS] SSH, SCP connections to remote MySQL Database using OpenOffice Possible? On Mon, Mar 10, 2008 at 03:08:19PM -0400, Therese Trudeau enlightened us: Date: Mon, 10 Mar 2008 13:27:28 -0400 From: [EMAIL PROTECTED] To: centos@centos.org Subject: Re: [CentOS] SSH, SCP connections to remote MySQL Database using OpenOffice Possible? On Mon, Mar 10, 2008 at 12:38:34PM -0400, Therese Trudeau enlightened us: I can connect to the remote database via Linux desktop, it's just via an un encrypted connection through port 3306. For obvious reasons I don't want to do it that way. My question is, is OpenOffice Calc able to connect to remote databases via SSH and or SCP? If so, do I need a plug in for that, or need to configure calc to do that in some way? How would I do this, or which plug in(s) do I need? No, but what you could do is use an ssh tunnel to accomplish this. Something along the lines of ssh -L 3307:database.example.net:3306 database.example.net This will tell your system to tunnel the local port 3307 through the database box, TO the database box on port 3306. From this point, after you connect via ssh with the above command, you can simply point your database software to the local 3307 port in plain text, and it'll travel over ssh to the remote box. I've probably done a bad job explaining this, so I'll go get some more coffee. Hehe THANKS Jim I need some too! So when I ssh -L 3307:database.example.net:3306, am I doing this via terminal prior to connecting with Calc (or base), then start up base and enter in just the regular database.example.net into the Server URL field in Clac or base? Or do I need to enter ssh -L 3307:database.example.net:3306 just once in to the Server URL FIeld from within OpenOffice Calc or VBase? You should enter localhost:3307. That connects to the local end of your SSH tunnel. OK this is what I tried - I opened up terminal on my local desktop machine, and I issued the command: ssh -L 3307:domain.name.of.DesktopLocalMySQLserver:3306 [EMAIL PROTECTED] Then I started up OpenOffice Calc, clicked on FileNewDatabase, and in the area where it asks for the ServerURL, I entered in: localhost:3307 and just below it where it asks for the port number I also entered in 3307 (the default is 3306). The error I got was Illegal Connection Port Value 3307:3307: and I could not connect. I think what you really want is ssh -L 3307:localhost:3306 remote.db.server The host in the middle is relative to the end machine. You could also probably do ssh -L 3307:remote.db.server:3306 remote.db.server (for that matter, I don't see why you couldn't do ssh -L 3306:... as long as you don't have mysql running on your desktop) OK so you are saying to enter into Terminal, either: ssh -L 3307:localhost:3306 remote.db.server , OR enter into Terminal: ssh -L 3307:remote.db.server:3306 remote.db.server and substitute in my remote server address for remote.db.server Once I do that, what should I enter into the OpenOffice Calc Spreadsheet Application Dialog box, in order to get the OpenOffice Calc local applicationwhich resides on my desktop machine to read the remote database? Correct, that *should* work. Sadly I can't get OpenOffice Calc to connect that way, I keep getting those “Illegal Connection Port Value 3307:3307” errors from Calc when I enter in “localhost:3307” into Calc open new database box. I'm wondering if it's related to this problem - I was able yesterday to get OpenOffice 2.3 Calc to connect un securely just by using the default port 3306 – just did that as a one time test. The problem I had when I did that though, was that when I open up a large table with 400 rows and maybe 25 columns in it (a table for products in an on line shopping cart), the scroll bars move through the table very slowly, and after a minute or two the table freezes up, as does OpenOffice, and I end up having to CtlAltDel and restart Open office. From a different desktop machine running Windows 2000 however, I am able to connect to the very same remote database using Navicat via first tunneling through port 22 SSH and then connecting to port 3306 via the SSH tunnel, and I don't have this problem, I can scroll through and edit data very fast with no crashing. I'm wondering if the problem is with the way I have my Linux desktop configured? _ Connect and share in new ways with Windows
RE: [CentOS] Re: SSH, SCP connections to remote MySQL Database using OpenOffice Possible?
To: centos@centos.org From: [EMAIL PROTECTED] Date: Mon, 10 Mar 2008 13:43:00 -0700 Subject: [CentOS] Re: SSH, SCP connections to remote MySQL Database using OpenOffice Possible? on 3-10-2008 1:33 PM Therese Trudeau spake the following: Date: Mon, 10 Mar 2008 15:12:31 -0400 From: [EMAIL PROTECTED] To: centos@centos.org Subject: Re: [CentOS] SSH, SCP connections to remote MySQL Database using OpenOffice Possible? On Mon, Mar 10, 2008 at 03:08:19PM -0400, Therese Trudeau enlightened us: Date: Mon, 10 Mar 2008 13:27:28 -0400 From: [EMAIL PROTECTED] To: centos@centos.org Subject: Re: [CentOS] SSH,SCP connections to remote MySQL Database using OpenOffice Possible? On Mon, Mar 10, 2008 at 12:38:34PM -0400, Therese Trudeau enlightened us: I can connect to the remote database via Linux desktop, it's just via an un encrypted connection through port 3306. For obvious reasons I don't want to do it that way. My question is, is OpenOffice Calc able to connect to remote databases via SSH and or SCP? If so, do I need a plug in for that, or need to configure calc to do that in some way? How would I do this, or which plug in(s) do I need? No, but what you could do is use an ssh tunnel to accomplish this. Something along the lines of ssh -L 3307:database.example.net:3306 database.example.net This will tell your system to tunnel the local port 3307 through the database box, TO the database box on port 3306. From this point, after you connect via ssh with the above command, you can simply point your database software to the local 3307 port in plain text, and it'll travel over ssh to the remote box. I've probably done a bad job explaining this, so I'll go get some more coffee. Hehe THANKS Jim I need some too! So when I ssh -L 3307:database.example.net:3306, am I doing this via terminal prior to connecting with Calc (or base), then start up base and enter in just the regular database.example.net into the Server URL field in Clac or base? Or do I need to enter ssh -L 3307:database.example.net:3306 just once in to the Server URL FIeld from within OpenOffice Calc or VBase? You should enter localhost:3307. That connects to the local end of your SSH tunnel. OK this is what I tried - I opened up terminal on my local desktop machine, and I issued the command: ssh -L 3307:domain.name.of.DesktopLocalMySQLserver:3306 [EMAIL PROTECTED] Then I started up OpenOffice Calc, clicked on FileNewDatabase, and in the area where it asks for the ServerURL, I entered in: localhost:3307 and just below it where it asks for the port number I also entered in 3307 (the default is 3306). The error I got was Illegal Connection Port Value 3307:3307: and I could not connect. I think what you really want is ssh -L 3307:localhost:3306 remote.db.server The host in the middle is relative to the end machine. You could also probably do ssh -L 3307:remote.db.server:3306 remote.db.server (for that matter, I don't see why you couldn't do ssh -L 3306:... as long as you don't have mysql running on your desktop) OK so you are saying to enter into Terminal, either: ssh -L 3307:localhost:3306 remote.db.server , OR enter into Terminal: ssh -L 3307:remote.db.server:3306 remote.db.server and substitute in my remote server address for remote.db.server Once I do that, what should I enter into the OpenOffice Calc Spreadsheet Application Dialog box, in order to get the OpenOffice Calc local applicationwhich resides on my desktop machine to read the remote database? Correct, that *should* work. Sadly I can't get OpenOffice Calc to connect that way, I keep getting those �Illegal Connection Port Value 3307:3307� errors from Calc when I enter in �localhost:3307� into Calc open new database box. _ If there is a separate port dialog box, don't put the port in twice. IE... In serverurl put localhost and in port put 3307. OK Some progress anyway, by not putting in the port twice I got a connecrtion. But as before, when I connected un securely, OpenOffice freezes up and crashes after about one minute, whether or not it's through port 3306, or through 3307 SSH. _ Shed those extra pounds with MSN and The Biggest Loser! http://biggestloser.msn.com/___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] SSH, SCP connections to remote MySQL Database using OpenOffice Possible?
Please edit your quotes, no need to quote the entire thread back in every email - just trim down to the required bits. OK Sorry :) _ Climb to the top of the charts! Play the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Re: SSH, SCP connections to remote MySQL Database using OpenOffice Possible?
Sounds like an OOo problem, then. When I briefly tried testing it, there was a couple of driver options to connect to MySQL, you might try using the one you're not (IIRC one was ODBC and the other was JDBC). I'm using both the Java Runtime Environment jre1.6.0_05 and the sql-connector-java-5.0.8 - they both tested out OK after install. _ Shed those extra pounds with MSN and The Biggest Loser! http://biggestloser.msn.com/___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] PROBLEM SOLVED -getting JavaRuntime Environmenti nstalledi nto OpenOffice
Sure I'll give that a try. I thought I had the latest release, just downloaded it a few days ago - did they just come out with a new one? If I install the latest, does the script un-install the previous version I just installed? I'm also wondering if I got the correct JRE? I got the JRE from here: http://java.sun.com/javase/downloads/index.jsp You can have multiple JREs installed, but since this one ain't working 100% may as well uninstall it manually with yum remove '*jre*' If you aren't doing Java development or hosting a JSP server there is no real need to have the JDK either. OK, I ran the un install (do not have JDK installed), un install apparently went fine, then I downloaded the jre-6u5-linux-x64-rpm.bin from http://java.sun.com/javase/downloads/index.jsp, Followed these instructions: http://java.sun.com/javase/6/webnotes/install/jre/install-linux.html#install then installed it. Ran a ls -l /usr/java, below is output: total 16 lrwxrwxrwx 1 root root 16 Mar 7 17:28 default - /usr/java/latest drwxr-xr-x 5 root root 4096 Mar 7 17:28 jre1.6.0_05 lrwxrwxrwx 1 root root 21 Mar 7 17:28 latest - /usr/java/jre1.6.0_05 Ran java -version, output is: java version 1.6.0_05 Java(TM) SE Runtime Environment (build 1.6.0_05-b13) Java HotSpot(TM) 64-Bit Server VM (build 10.0-b19, mixed mode) Tried to find it in the OO Calc ToolsOptions dialog box, only Free Software Foundation v 1.4.2 Maybe I'm not using ToolsOptions correctly? I meant to say above - only Free Software Foundation v 1.4.2 shows up in dialog box, the new JRE is not showing. Is there a specific Java filename I am supposed to be searching for and entering in to the OpenOffice CalcToolsOptions dialoge box? And or the file path? Or is ToolsOptions supposed to automatically find the JRE and display it in the dialog box for me to select or not select? Ross Walker was right, there is a problem with the 64 bit version of OpenOffice. I found out from another list that the 64 bit version of the JRE is definitely not compatible with OpenOffice 2.3. I Uninstaled the 64 bit version, installed the 32 bit version and all works well. Also found that if you leave the 64 bit versionn on PC, the 32 bit version won't install correctly. Thanks to everyone on List for assistance. _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] OpenOffice now automagically works: One last question...
I'll study up on it. Can you reccomend a good URL or reading material for setroubleshoot? http://fedoraproject.org/wiki/SELinux Thanks, I'll check it out. _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] OpenOffice now automagically works: One last question...
So is there a way I can set SELinux to permissive, and still be secure while using Calc to connect remotely to a MySQL database? Or is there a way to leave SELinux enforced while also using Calc to connect remotely to a MySQL database? Sure, there is iptables (firewall). selinux, in my opinion, works best in locked-down application server environments where you have several applications running and their access patterns are completely predictable. On a general workstation or development system, not very well, well not if you don't mind tweaking it all the time... -Ross OK Thanks. _ Need to know the score, the latest news, or you need your Hotmail®-get your fix. http://www.msnmobilefix.com/Default.aspx___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] OpenOffice now automagically works: One last question...
Therese, the setroubleshoot package mentioned here was installed by default on my system. If you go to that after you have had a failure it generally tells you what it saw as a threat, and what to do about it if it should be allowed. Usually it's just a matter of copy and paste a line of command. Thanks Anne, Will setting to permissive prevent real time threats, or just tell me what happened after the fact of a failure? I'm no expert on this, Therese, but I doubt the advice you've been given that setting to permissive is the same as having it disabled. Why? Because I had quite a number of problems with it set to permissive, mainly ones that stopped samba working. Once I had sorted out the necessary commands samba has behaved without problems. If it was as ineffective as setting it to disabled I would not have had to do this. I'd say set it to permissive, use setroubleshooter, and if you still can't sort it, either post here what setroubleshooter says about it or google for parts of the message. Thanks Anne, Just a note that I re enabled SELinux, and even though I was not able to get a connection to a MySQL database in OpenOffice 2.3 earlier with SELinux set to enforcing, now I am able to connect with SELinux set to enforcing. This may have been due to a separate issue related to the JRE problem I had, which has been resolved. What I don't understand now, is that when I run a /usr/sbin/sestatus, I get the below output: SELinux status: enabled SELinuxfs mount:/selinux Current mode: permissive Mode from config file: enforcing Policy version: 21 Policy from config file:targeted And when I run: selinuxenabled echo $? I get zero for output...: 0 ...which I assume means that selinux is enabled - set to enforcing. How is it possible that Selinux is set to Enforcing and is ALSO showing a current mode of Permissive? Can anyone give me some insights on this? _ Helping your favorite cause is as easy as instant messaging. You IM, we give. http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
[CentOS] Recommendations for a “real RAID 1 card on Centos box
Hi, I'm considering setting up my Centos Desktop machine for RAID 1. I read a lot of good info at this site:http://linuxmafia.com/faq/Hardware/sata.html#intel-vitesse about differences in fakeraid and real raid cards. The hardware I plan on installing this RAID card into is an Intel DP35DP motherboard with the Intel E4500 dual core processor, and I have two Mator 500 gig SATA hard drives. Can anyone recommend a good “real raid” card for my Linux? What I am looking for is to plug in a RAID controller card out of the box, and without having to load any drivers onto my Centos 5.1 box, have the Real hardware RAID card automatically do all the work, mirror my hard drive onto the second backup drive and do all the work for me. Do such cards exist? If so which model /manufacturers do you recommend? Any experiences/info/insights on hardware RAID cards good or bad on centos boxes would be appreciated. _ Climb to the top of the charts! Play the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Recommendations for a “real RAID 1 c ard on Centos box
Do such cards exist? If so which model /manufacturers do you recommend? Any experiences/info/insights on hardware RAID cards good or bad on centos boxes would be appreciated. 3Ware 8000-series cards are probably the most compatible going back at least 3 years. 9000-series cards are faster/better and CentOS 5.1 should have full support for them. For me, in SATA RAID cards it's 3ware or nothing. Been using them for more than 8 years now. I picked up a extra 8006-2 (2-port RAID) a couple weeks ago for about $120 as a spare for my home system that has a 8006-2. nate So these cards are just plug n play? Just plug them in, no software or drivers required, all mirroring is managed by firmware built into the card RAID card itself? _ Helping your favorite cause is as easy as instant messaging. You IM, we give. http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Recommendations for a “real RAID 1 card on Centos box
So these cards are just plug n play? Just plug them in, no software or drivers required, all mirroring is managed by firmware built into the card RAID card itself? Drivers are required for all storage adapters(RAID or not). 3Ware handles raid in hardware, not in software, it has a bios which you'd typically use to configure the array, you can boot off of the array, etc. 3Ware also offers a management tool for linux (CLI and/or web based) which allows for monitoring, and controlling the adapter's configuration settings. 3Ware has had their linux drivers in the kernel for at least... 8 years now? maybe longer. So any linux distro should have no trouble detecting the card. The latest 9650 cards are pretty new and use a new driver, which may or may not be supported, CentOS 5.1 should work with it fine though(support for CentOS 4 was added almost a year ago, I think with v4.5) They also support hot swap, provided the interface to the disk supports it(typically a hot swap backplane). Great thanks for that info Nate, I just checked out their web site, looks like the 9500S-4LP would suit my needs for a desktop machine. I've been leary about desktop RAID cards because a few years ago, I bought an adaptec 1210SA RAID card which supposedly does RAID 1 I never could get the darn thing to work in my old windows machine and years later found out it is really a fake raid card. It's been collecting dust ever since may as well throw it out. The drivers it required never worked with W2K. But the Centos server I use has adaptec SCSI RAID controller in it, I guess on the high end for SCSI RAID, adaptec is known for good raid cards, but the one I bought sure did nothing for me for my desktop. _ Need to know the score, the latest news, or you need your Hotmail®-get your fix. http://www.msnmobilefix.com/Default.aspx___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Recommendations for a “real RAID 1 car d on Centos box
I would'nt bother with a 3ware 8000 or a 3ware 9000 card these days, if you really do want to get 3ware, get atleast a 9650. And anything less than a 9550 should be considered only if you get a really good deal off ebay. And remember that battery backup unit. I'm just really looking for a RAID card that will do RAID 1, with four drive capacity, i.e., a master drive with the OS and applications installed and mirrored, and a slave drive for data and photos, graphic design, video, etc also mirrored. What would battery built into a RAID card do for me? For me, in SATA RAID cards it's 3ware or nothing. Been using them for more than 8 years now. I used to think the same for a long time, till I started using Areca raid cards. Now, I rate 3ware well behind Areca on performance, reliability and ease of use. If you are doing raid-5 or raid-6 the performance difference is quite noticeable ( I've just recently switched my desktop from a 3ware 9650 to Areca 1220, and got a near 8% improvement in write performance, and 12% on read - raid5 5 spindles ). So you reccomend Areca, good thanks I'll check them out too. How are they for RAID 1? So these cards are just plug n play? Just plug them in, no software or drivers required, all mirroring is managed by firmware built into the card RAID card itself? Drivers for both 3ware and Areca are included in the CentOS-5.1 kernels. Btw, you might want to keep an eye on some of the not-that-expensive highpoint rocketraid, hey have some fairly decent stuff coming out these days. The issues with them however, the drivers have only recently gone into the mainline upstream kernel - and their userland tools are not quite there yet. But if you need something for 2 to 5 drivers, they are an option worth considering ( they do have drivers for centos-4 and centos-5 on their website ). Will check them out too Thanks Karanbir _ Need to know the score, the latest news, or you need your Hotmail®-get your fix. http://www.msnmobilefix.com/Default.aspx___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Recommendations for a “real RAID 1 car d on Centos box
I'm just really looking for a RAID card that will do RAID 1, with four drive capacity, i.e., a master drive with the OS and applications installed and mirrored, and a slave drive for data and photos, graphic design, video, etc also mirrored. What would battery built into a RAID card do for me? the whole point of a BBU is that you can turn on write back caching - and get a fair win in write performance on regular tasks. Pardon my ignorance, what is write back caching and BBU? Also, make sure whatever raid hardware you decide to invest in supports multiple raid sets ( thats what you seem to want - and not all raid cards do that ) - both 3ware and Areca do support this. Do you mean by multiple raid sets a raid card that can do either RAID 0, RAID 1, RAID 5 etc? Are you considering using this as a backup system and not doing any off machine backups ? if so, consider the possibility of actually loosing the raid card itself : Ideally you want the raid metadata sitting on the disks rather than the raid card, so you can replace the card and be back in action. Again, not all cards support this out of the box. Yes, this is just to back up my hard drives on my desktop machine, no remote backups. Do both the 3ware and the Areca store meta data on disk? So you reccomend Areca, good thanks I'll check them out too. How are they for RAID 1? To be honest, its been a very long time since I used a raid-1 setup, and I am not sure if I'd bother with it now. If you have 4 drives, might as well raid-5 them. You still get the ability to loose 1 drive at a time, and have a hot-spare : while ending up with the same storage capacity. Again pardon my ignorance, what is a hot spare? A blank drive connected in the RAID 5 setup that can be written to in case one of the other 3 drives fail? btw, if you have 4 drives, make sure they are as similar in specifications as possible - however, try and get different batch numbers / production runs. Drives that were made in the same batch, have been stored and stock under the exact same conditions, shipped out together, used and put into production together - have a very very high probability of also failing together :D OK Will do that for sure when I set this up. _ Need to know the score, the latest news, or you need your Hotmail®-get your fix. http://www.msnmobilefix.com/Default.aspx___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Recommendations for a “real RAID 1 card on Centos box
I'm considering setting up my Centos Desktop machine for RAID 1. I read a lot of good info at this site:http://linuxmafia.com/faq/ Hardware/sata.html#intel-vitesse about differences in fakeraid and real raid cards. Discontinued chipset but works fine: http://www.newegg.com/Product/Product.aspx?Item=N82E16816110002 Nice price! $35/ 5 SATA drive support. Fewer drives is a $21 card. No drivers, you run the RAID from BIOS, it shows as an IDE volume for linux. See the NewEgg comments for some tips. Depending on the speed you need, it could be just great. You need Windows to update the firmware. Supports a handful of RAID types, but not RAID 5. True hardware RAID though. All the firmwares, manuals, utils are at: http://www.soft-port.dk/ Hey thanks much I'll check it out! One question on this card - does it write the raid metadata onto the disks rather than store them on the card itself? I ask because Karanbir (in this thread) reccomends to get that kind. If it does, maybe I'll buy two or three of these in case one card fails (since they are out of business). _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Recommendations for a “real RAID 1 car d on Centos box
the whole point of a BBU is that you can turn on write back caching - and get a fair win in write performance on regular tasks. Pardon my ignorance, what is write back caching and BBU? Write Back Caching means the card will cache writes in its onboard storage, and let the OS continue immediately ...this is only 'safe' if the card has a 'battery backup unit' to protect the cache during power failures so that the cached write data can be written to the disks when the power resumes.Some raid cards even allow you to remove the battery still attached to the cache along with the disks and install them on a different but similar machine in case of a total server failure, this is a feature on many HP SmartArray cards. A battery backed Write Back Cache can hugely speed up random writes such as from a relational database server. Ah that makes total sense now, thanks. Do the 3wire and the Areca cards allow you to remove battery/cache/disk and install into similar motherboard? Also when you say remove battery and cache, do you mean remove the entire RAID card with battery attached to it as complete assembly with accompaying drive and slap them all onto a new motherboard? Again pardon my ignorance, what is a hot spare? A blank drive connected in the RAID 5 setup that can be written to in case one of the other 3 drives fail? exactly. a hot spare sits unused until one of the RAID members fails, then its used to replace the failed drive by remirroring or restriping the parity, once this is finished, and the original failed drive is replaced it can become the new hot spare. So if I understand correctly, RAID 5 is three active drives and one blank drive connected to a RAID 5 card, and if one of the three active drives fails, the fourth empty drive is automatically written to? If correct, what happens if the drive that fails loses all it's data before the blank drive has a chance to grab it? _ Climb to the top of the charts! Play the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Recommendations for a “real RAID 1 car d on Centos box
Ah that makes total sense now, thanks. Do the 3wire and the Areca cards allow you to remove battery/cache/disk and install into similar motherboard? Also when you say remove battery and cache, do you mean remove the entire RAID card with battery attached to it as complete assembly with accompaying drive and slap them all onto a new motherboard? I /think/ with the 3ware you remove and swap the whole card, along with the drives. On many server grade systems, such as the the HP DL380 series, with on board SmartArray, the cache ram module and battery are separate detachable components. in the dl380 they are actually two pieces with a cord between them. you unclip and remove the battery from the chassis without messing with the wire, then you pull the cache module out of its special slot, these can then be installed in another HP smartarray, along with the drives from the original system, and when that new DL380 powers up, the raid controller will verify the drives, and flush its cache, insureing data integrity, then boot up your environment. Again pardon my ignorance, what is a hot spare? A blank drive connected in the RAID 5 setup that can be written to in case one of the other 3 drives fail? exactly. a hot spare sits unused until one of the RAID members fails, then its used to replace the failed drive by remirroring or restriping the parity, once this is finished, and the original failed drive is replaced it can become the new hot spare. So if I understand correctly, RAID 5 is three active drives and one blank drive connected to a RAID 5 card, and if one of the three active drives fails, the fourth empty drive is automatically written to? If correct, what happens if the drive that fails loses all it's data before the blank drive has a chance to grab it? with a 3 drive raid 5, you write two drives worth of data across the 3... every third 'block' is a 'parity block' calculated by bit-wise exclusive or (XOR) of the other two blocks.on a 3 drive RAID-5, this parity block alternates across all three drives drive: 012 === data01 0x1 blocks 2x3 23 4 4x5 5 67 6x7 8x9 89 . each of those 'blocks' is like 32K bytes, 64 x 512 byte sectors (this is the stride of the raid, configured when you create the raid). the ones that are just numbers are your data blocks, while the 0x1 is (block_0 XOR block_1) eg, the parity block for that stripe. if any one drive, /dies/ abruptly with no warning, you can still read all the data from the remaining drives, the missing drive is the XOR of the other drives, so the controller can reconstruct it on the fly and you will continue operating in a degraded performance mode. if you have a spare drive, or when you replace the failed drive, the raid controller begins a rebuild where it reads ALL the blocks of the working drives, XOR's them together, and writes this to the spare/new drive. when its done, things revert to normal full performance and redundant operation. raid controllers can do this while the logical volume is still in use and online, many let you set the priority of this to lower the performance impact from raid rebuilds you can extend this with a reasonable number of drives, for instance, 5 drives might look like... drive: 01234 = data0123P blocks P4567 8P9 10 11 where the P's are XOR's of /all/ the other blocks on the same line. p0 = b0 X b1 X b2 X b3. p1 = b4 X b5 X b6 X b7, etc. there's tons of material online explaining this stuff far better than a centos list can. http://en.wikipedia.org/wiki/RAID Ah great i'll check out the URL thanks. One thing, an earlier poster reccomended RAID 5 instead of RAID 1. I guess if one only has 2 drives RAID 1 is the way to go but if I have 4 drives he said go with RAID 5 over RAID 1. Isn't RAID 1 mirroring a better solution for a 4 drive array or am I missing something here? _ Need to know the score, the latest news, or you need your Hotmail®-get your fix. http://www.msnmobilefix.com/Default.aspx___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] OpenOffice won't start up
That's highly unusual, because I have never seen that error caused by anything other than selinux. What does this tell you when you type it at a command line: /usr/sbin/sestatus I get - SELinux status: disabled _ Shed those extra pounds with MSN and The Biggest Loser! http://biggestloser.msn.com/___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] OpenOffice won't start up
Well, I have. For third-party applications installed to some obscure places in opt/, and not included in the PATH :oD I bet my whole Aretha Franklin CD collection that adding the correct path will solve the problem. Therese: open a Terminal, su - to root (which means: type 'su -' and then enter your root password) and type: # find / -name 'swriter' Ah maybe on to something :) OK, the output is: /home/nadsab/.openoffice.org2.0/user/config/soffice.cfg/modules/swriter /root/.openoffice.org2.0/user/config/soffice.cfg/modules/swriter _ Need to know the score, the latest news, or you need your Hotmail®-get your fix. http://www.msnmobilefix.com/Default.aspx___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] OpenOffice won't start up
Suggestion for future faster finds: After installing/removing components, run updatedb. Then instead of find, you can locate swriter. You'll probably need to filter the output as locate's match seems to be very regex-generalized. Also, if updating components that have control files, locate rpmsave and rpmnew so you can see if any of your configuration files need to be examined. Thanks on that, I can see I have much to learn...:) _ Climb to the top of the charts! Play the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] OpenOffice won't start up
Therese: open a Terminal, su - to root (which means: type 'su -' and then enter your root password) and type: # find / -name 'swriter' On my 4.0 CentOS, OO 2.0, swriter is a lib component. Try oowriter. WFM. OK, for output of find / -name 'oowriter', I get no output. _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] OpenOffice now automagically works - how could that happen?
Well, I have. For third-party applications installed to some obscure places in opt/, and not included in the PATH :oD I bet my whole Aretha Franklin CD collection that adding the correct path will solve the problem. Therese: open a Terminal, su - to root (which means: type 'su -' and then enter your root password) and type: # find / -name 'swriter' Ah maybe on to something :) OK, the output is: /home/nadsab/.openoffice.org2.0/user/config/soffice.cfg/modules/swriter /root/.openoffice.org2.0/user/config/soffice.cfg/modules/swriter OH Gosh now all of the sudden it automagically works! How could that happen? Last night I did a few restarts on the PC after installing, and OO would not start up. Then I just shut down the PC completely and went to bed - woke up this am, turned on PC and then tried starting once more (after replying to all the helpful advice here :)) and now all OO apps are working. Is there a difference between restarting PC and completely shutting down as far as what's considered a reboot? Isn't a restart same as a reboot in Linux? _ Need to know the score, the latest news, or you need your Hotmail®-get your fix. http://www.msnmobilefix.com/Default.aspx___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] OpenOffice now automagically works: One last question...
Well, I have. For third-party applications installed to some obscure places in opt/, and not included in the PATH :oD I bet my whole Aretha Franklin CD collection that adding the correct path will solve the problem. Therese: open a Terminal, su - to root (which means: type 'su -' and then enter your root password) and type: # find / -name 'swriter' Ah maybe on to something :) OK, the output is: /home/nadsab/.openoffice.org2.0/user/config/soffice.cfg/modules/swriter /root/.openoffice.org2.0/user/config/soffice.cfg/modules/swriter OH Gosh now all of the sudden it automagically works! How could that happen? Last night I did a few restarts on the PC after installing, and OO would not start up. Then I just shut down the PC completely and went to bed - woke up this am, turned on PC and then tried starting once more (after replying to all the helpful advice here :)) and now all OO apps are working. Is there a difference between restarting PC and completely shutting down as far as what's considered a reboot? Isn't a restart same as a reboot in Linux? Also one last issue in this thread and I think I'm done on this issue (and by the way thanks for all the wonderful help on this list everyone, this is a great community here). I tried re enabling SELinux and OO won't start, so I assume that I must have SE Linux disabled in order for OpenOffice to run - is this correct? if correct, is there a way I can still keep my system secure and run OpenOffice 2.3? I want to run OO 2.3 because I need to run Base for remote MySQL database connections with Calc. _ Climb to the top of the charts! Play the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] OpenOffice now automagically works: One last question...
I tried re enabling SELinux and OO won't start, so I assume that I must have SE Linux disabled in order for OpenOffice to run - is this correct? if correct, is there a way I can still keep my system secure and run OpenOffice 2.3? You do not have to keep selinux disabled. You can re-enable it; however, you may get a couple selinux failures. This is what happens on my system when running in Enforcing mode. 1. Selinux complains about a memory access by /opt/openoffice.org2.3/program/libvclplug_gen680li.so.1.1 2. Selinux complains about openoffice attempting to change the memory access protection on the heap. To solve number 1. on my system: sudo chcon -t textrel_shlib_t /opt/openoffice.org2.3/program/libvclplug_gen680li.so.1.1 Please mind the line wrapping. To solve issue 2. on my system: sudo setsebool -P allow_execheap=1 I am not entirely sure that it is wise to perform the second step, as it affects all applications that run on the system. So it seems a bit of a sledgehammer. To view what selinux is complaining about you may want to install the setroubleshoot package from yum and view what it is complaining about exactly. It will also give you suggestions on how to fix the selinux complaints. OK Thanks. I'm wondering if a secure alternative would be to run SELinux in permissive mode instead of disabled? _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
[CentOS] Problem getting Java Runtime Environment installed into OpenOffice
Hi, I'm having trouble getting my new install of OpenOffice 2.31 to find my newly installed Java Runtime Environment version jre1.6.0_04 (downloaded from Sun). I tried installing it via ToolsOptionsJava (am using OpenOffice Calc to try to set it up). The options dialog box is finding the Free Software Foundation version 1.4.2, but it won't find the new JRE file. I tried clicking on Add and tried just about every directory I could think of and it's just not finding the JRE. I believe after doing a search, that the newly installed JRE is located in the /usr/java/jre1.6.0_04 directory, and went to that dir in the options dialog box in Calc, and tried every dir and sub dir in that main dir, and Calc is still is not seeing it. Can anyone please give me an idea as to how to find JRE and get it plugged in to OpenOffice? _ Climb to the top of the charts! Play the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Problem getting Java Runtime Environment installed intoOpenOffice
Look at the thread from today about Firefox and Java plugin. In particular the posts concerning the use of 'alternatives' Hi, Thanks Ross, OK I ran your commands: # Remove Sun added links rm -f /usr/bin/javaws rm -f /usr/bin/jcontrol # Add Sun Java to alternatives alternatives --install /usr/bin/java java /usr/java/default/bin/java 1000 --slave /usr/lib/jvm/jre jre /usr/java/default --slave /usr/bin/javaws javaws /usr/java/default/bin/javaws --slave /usr/bin/jcontrol jcontrol /usr/java/default/bin/jcontrol --slave /usr/bin/rmiregistry rmiregistry /usr/java/default/bin/rmiregistry # Set Sun Java as the preferred Java environment alternatives --set java /usr/java/default/bin/java And then I rebooted, started up OpenOffice Calc again, and i'm still not finding the new JRE. And the Free Software Foundation is still showing, don't know if that matters though. Were your commands intended to get OpenOffice to automatically have the JRE show up in the dialog box? Or do I still need to hunt for it somewhere? [EMAIL PROTECTED] bin]# /usr/sbin/alternatives --display java java - status is manual. link currently points to /usr/java/default/bin/java /usr/lib/jvm/jre-1.4.2-gcj/bin/java - priority 1420 slave javaws: (null) slave jcontrol: (null) slave keytool: /usr/lib/jvm/jre-1.4.2-gcj/bin/keytool slave rmiregistry: /usr/lib/jvm/jre-1.4.2-gcj/bin/rmiregistry slave jre_exports: /usr/lib/jvm-exports/jre-1.4.2-gcj slave jre: /usr/lib/jvm/jre-1.4.2-gcj /usr/java/default/bin/java - priority 1000 slave javaws: /usr/java/default/bin/javaws slave jcontrol: /usr/java/default/bin/jcontrol slave keytool: (null) slave rmiregistry: /usr/java/default/bin/rmiregistry slave jre_exports: (null) slave jre: /usr/java/default Current `best' version is /usr/lib/jvm/jre-1.4.2-gcj/bin/java. [EMAIL PROTECTED] bin]# _ Climb to the top of the charts! Play the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] OpenOffice now automagically works: One last question...
Therese, the setroubleshoot package mentioned here was installed by default on my system. If you go to that after you have had a failure it generally tells you what it saw as a threat, and what to do about it if it should be allowed. Usually it's just a matter of copy and paste a line of command. Thanks Anne, Will setting to permissive prevent real time threats, or just tell me what happened after the fact of a failure? _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Problem getting Java Runtime Environment installedintoOpenOffice
What's the output of: # ls -l /usr/java Lets see if it is installed and where it is installed, maybe it's installing in /opt now. -Ross Thanks for your assistance Ross I really appreciate it! Output of ls -l /usr/java is: lrwxrwxrwx 1 root root 16 Mar 4 07:46 default - /usr/java/latest drwxr-xr-x 5 root root 4096 Mar 7 11:56 jre1.6.0_04 lrwxrwxrwx 1 root root 21 Mar 4 07:46 latest - /usr/java/jre1.6.0_04 _ Climb to the top of the charts! Play the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] OpenOffice now automagically works: One last question...
Will setting to permissive prevent real time threats, or just tell me what happened after the fact of a failure? http://lists.centos.org/pipermail/centos/2008-March/095637.html Thanks on that Frank. So is there a way I can set SELinux to permissive, and still be secure while using Calc to connect remotely to a MySQL database? Or is there a way to leave SELinux enforced while also using Calc to connect remotely to a MySQL database? _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Problem getting Java Runtime EnvironmentinstalledintoOpenOffice
Directory structure looks good, what does: # java -version Give you? [EMAIL PROTECTED] bin]# java -version java version 1.6.0_04 Java(TM) SE Runtime Environment (build 1.6.0_04-b12) Java HotSpot(TM) 64-Bit Server VM (build 10.0-b19, mixed mode) _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] OpenOffice now automagically works: One last question...
So is there a way I can set SELinux to permissive, and still be secure while using Calc to connect remotely to a MySQL database? There is a difference between running selinux in enforcing mode and being secure. The second does not necessarily require or originate from the first. Or is there a way to leave SELinux enforced while also using Calc to connect remotely to a MySQL database? Yes. You can use setroubleshoot to set it up. Thanks Frank, I'll study up on it. Can you reccomend a good URL or reading material for setroubleshoot? _ Helping your favorite cause is as easy as instant messaging. You IM, we give. http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Problem getting Java Runtime EnvironmentinstalledintoOpenOffice
Directory structure looks good, what does: # java -version Give you? [EMAIL PROTECTED] bin]# java -version java version 1.6.0_04 Java(TM) SE Runtime Environment (build 1.6.0_04-b12) Java HotSpot(TM) 64-Bit Server VM (build 10.0-b19, mixed mode) Problem is, when I find /usr/java/jre1.6.0_04 in the OpenOffice Calc ToolsOptions dialogue box by clicking the Add button and choosing the file, it won't show up in the JRE already installed window. Only the Free Software Foundation 1.4.2 shows. _ Helping your favorite cause is as easy as instant messaging. You IM, we give. http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Problem getting JavaRuntime Environment installed into OpenOffice
Directory structure looks good, what does: # java -version Give you? [EMAIL PROTECTED] bin]# java -version java version 1.6.0_04 Java(TM) SE Runtime Environment (build 1.6.0_04-b12) Java HotSpot(TM) 64-Bit Server VM (build 10.0-b19, mixed mode) Problem is, when I find /usr/java/jre1.6.0_04 in the OpenOffice Calc ToolsOptions dialogue box by clicking the Add button and choosing the file, it won't show up in the JRE already installed window. Only the Free Software Foundation 1.4.2 shows. Funny, OOo picked my java up no problem, only difference between your Java and mine is I'm running 1.6.0_02, but in 32-bit... I wonder if there is a problem with 64-bit OOo and/or 64-bit Java... -Ross Just checked to make sure - I ran dmidecode and the Core 2 Duo E4500 processors came up. They are the 64 bit processors I believe. Oh yeah, I didn't mean there was a problem with your machine's setup, just there may be a compatibility problem between OOo 2.0.4 64-bit and Sun Java 6.0.4 64-bit. Want to try Java 6.0.5? -Ross Do you mean java 1.6.0_05? Is that a beta or stable release? _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Problem getting JavaRuntime Environment installed intoOpenOffice
Directory structure looks good, what does: # java -version Give you? [EMAIL PROTECTED] bin]# java -version java version 1.6.0_04 Java(TM) SE Runtime Environment (build 1.6.0_04-b12) Java HotSpot(TM) 64-Bit Server VM (build 10.0-b19, mixed mode) Problem is, when I find /usr/java/jre1.6.0_04 in the OpenOffice Calc ToolsOptions dialogue box by clicking the Add button and choosing the file, it won't show up in the JRE already installed window. Only the Free Software Foundation 1.4.2 shows. Funny, OOo picked my java up no problem, only difference between your Java and mine is I'm running 1.6.0_02, but in 32-bit... I wonder if there is a problem with 64-bit OOo and/or 64-bit Java... -Ross Just checked to make sure - I ran dmidecode and the Core 2 Duo E4500 processors came up. They are the 64 bit processors I believe. Oh yeah, I didn't mean there was a problem with your machine's setup, just there may be a compatibility problem between OOo 2.0.4 64-bit and Sun Java 6.0.4 64-bit. Want to try Java 6.0.5? -Ross Do you mean java 1.6.0_05? Is that a beta or stable release? It's the latest stable release off of www.java.com -Ross Sure I'll give that a try. I thought I had the latest release, just downloaded it a few days ago - did they just come out with a new one? If I install the latest, does the script un-install the previous version I just installed? _ Helping your favorite cause is as easy as instant messaging. You IM, we give. http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Problem getting JavaRuntime Environment installed intoOpenOffice
From: [EMAIL PROTECTED] To: centos@centos.org Subject: RE: [CentOS] Problem getting JavaRuntime Environment installed intoOpenOffice Date: Fri, 7 Mar 2008 16:44:34 -0500 Directory structure looks good, what does: # java -version Give you? [EMAIL PROTECTED] bin]# java -version java version 1.6.0_04 Java(TM) SE Runtime Environment (build 1.6.0_04-b12) Java HotSpot(TM) 64-Bit Server VM (build 10.0-b19, mixed mode) Problem is, when I find /usr/java/jre1.6.0_04 in the OpenOffice Calc ToolsOptions dialogue box by clicking the Add button and choosing the file, it won't show up in the JRE already installed window. Only the Free Software Foundation 1.4.2 shows. Funny, OOo picked my java up no problem, only difference between your Java and mine is I'm running 1.6.0_02, but in 32-bit... I wonder if there is a problem with 64-bit OOo and/or 64-bit Java... -Ross Just checked to make sure - I ran dmidecode and the Core 2 Duo E4500 processors came up. They are the 64 bit processors I believe. Oh yeah, I didn't mean there was a problem with your machine's setup, just there may be a compatibility problem between OOo 2.0.4 64-bit and Sun Java 6.0.4 64-bit. Want to try Java 6.0.5? -Ross Do you mean java 1.6.0_05? Is that a beta or stable release? It's the latest stable release off of www.java.com -Ross Sure I'll give that a try. I thought I had the latest release, just downloaded it a few days ago - did they just come out with a new one? If I install the latest, does the script un-install the previous version I just installed? I'm also wondering if I got the correct JRE? I got the JRE from here: http://java.sun.com/javase/downloads/index.jsp _ Climb to the top of the charts! Play the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Problem getting JavaRuntime Environment installedintoOpenOffice
Sure I'll give that a try. I thought I had the latest release, just downloaded it a few days ago - did they just come out with a new one? If I install the latest, does the script un-install the previous version I just installed? I'm also wondering if I got the correct JRE? I got the JRE from here: http://java.sun.com/javase/downloads/index.jsp You can have multiple JREs installed, but since this one ain't working 100% may as well uninstall it manually with yum remove '*jre*' If you aren't doing Java development or hosting a JSP server there is no real need to have the JDK either. OK, I ran the un install (do not have JDK installed), un install apparently went fine, then I downloaded the jre-6u5-linux-x64-rpm.bin from http://java.sun.com/javase/downloads/index.jsp, Followed these instructions: http://java.sun.com/javase/6/webnotes/install/jre/install-linux.html#install then installed it. Ran a ls -l /usr/java, below is output: total 16 lrwxrwxrwx 1 root root 16 Mar 7 17:28 default - /usr/java/latest drwxr-xr-x 5 root root 4096 Mar 7 17:28 jre1.6.0_05 lrwxrwxrwx 1 root root 21 Mar 7 17:28 latest - /usr/java/jre1.6.0_05 Ran java -version, output is: java version 1.6.0_05 Java(TM) SE Runtime Environment (build 1.6.0_05-b13) Java HotSpot(TM) 64-Bit Server VM (build 10.0-b19, mixed mode) Tried to find it in the OO Calc ToolsOptions dialog box, only Free Software Foundation v 1.4.2 Maybe I'm not using ToolsOptions correctly? _ Need to know the score, the latest news, or you need your Hotmail®-get your fix. http://www.msnmobilefix.com/Default.aspx___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Problem getting JavaRuntime Environment installedintoOpenOffice
Sure I'll give that a try. I thought I had the latest release, just downloaded it a few days ago - did they just come out with a new one? If I install the latest, does the script un-install the previous version I just installed? I'm also wondering if I got the correct JRE? I got the JRE from here: http://java.sun.com/javase/downloads/index.jsp You can have multiple JREs installed, but since this one ain't working 100% may as well uninstall it manually with yum remove '*jre*' If you aren't doing Java development or hosting a JSP server there is no real need to have the JDK either. OK, I ran the un install (do not have JDK installed), un install apparently went fine, then I downloaded the jre-6u5-linux-x64-rpm.bin from http://java.sun.com/javase/downloads/index.jsp, Followed these instructions: http://java.sun.com/javase/6/webnotes/install/jre/install-linux.html#install then installed it. Ran a ls -l /usr/java, below is output: total 16 lrwxrwxrwx 1 root root 16 Mar 7 17:28 default - /usr/java/latest drwxr-xr-x 5 root root 4096 Mar 7 17:28 jre1.6.0_05 lrwxrwxrwx 1 root root 21 Mar 7 17:28 latest - /usr/java/jre1.6.0_05 Ran java -version, output is: java version 1.6.0_05 Java(TM) SE Runtime Environment (build 1.6.0_05-b13) Java HotSpot(TM) 64-Bit Server VM (build 10.0-b19, mixed mode) Tried to find it in the OO Calc ToolsOptions dialog box, only Free Software Foundation v 1.4.2 Maybe I'm not using ToolsOptions correctly? I meant to say above - only Free Software Foundation v 1.4.2 shows up in dialog box, the new JRE is not showing. _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] Problem getting JavaRuntime Environment installedintoOpenOffice
Sure I'll give that a try. I thought I had the latest release, just downloaded it a few days ago - did they just come out with a new one? If I install the latest, does the script un-install the previous version I just installed? I'm also wondering if I got the correct JRE? I got the JRE from here: http://java.sun.com/javase/downloads/index.jsp You can have multiple JREs installed, but since this one ain't working 100% may as well uninstall it manually with yum remove '*jre*' If you aren't doing Java development or hosting a JSP server there is no real need to have the JDK either. OK, I ran the un install (do not have JDK installed), un install apparently went fine, then I downloaded the jre-6u5-linux-x64-rpm.bin from http://java.sun.com/javase/downloads/index.jsp, Followed these instructions: http://java.sun.com/javase/6/webnotes/install/jre/install-linux.html#install then installed it. Ran a ls -l /usr/java, below is output: total 16 lrwxrwxrwx 1 root root 16 Mar 7 17:28 default - /usr/java/latest drwxr-xr-x 5 root root 4096 Mar 7 17:28 jre1.6.0_05 lrwxrwxrwx 1 root root 21 Mar 7 17:28 latest - /usr/java/jre1.6.0_05 Ran java -version, output is: java version 1.6.0_05 Java(TM) SE Runtime Environment (build 1.6.0_05-b13) Java HotSpot(TM) 64-Bit Server VM (build 10.0-b19, mixed mode) Tried to find it in the OO Calc ToolsOptions dialog box, only Free Software Foundation v 1.4.2 Maybe I'm not using ToolsOptions correctly? I meant to say above - only Free Software Foundation v 1.4.2 shows up in dialog box, the new JRE is not showing. Is there a specific Java filename I am supposed to be searching for and entering in to the OpenOffice CalcToolsOptions dialoge box? And or the file path? Or is ToolsOptions supposed to automatically find the JRE and display it in the dialog box for me to select or not select? _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
[CentOS] OpenOffice won't start up
Hi, I just ran an install of OpenOffice 2.31 on Centos 5.1 using these instructions - http://www.melvilletheatre.com/articles/openoffice-fedora/index.html Install seemed to go fine until I finished and then tried to start up K writer and none of the OO apps will start up from the menu. even though they are all showing up in start menu that 2.3 is installed. I'm using KDE mostly but have gnome installed also. Can anyone give me an idea as to how to correct? Thanks. _ Helping your favorite cause is as easy as instant messaging. You IM, we give. http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
[CentOS] OpenOffice won't start up
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: [CentOS] OpenOffice won't start up Date: Fri, 7 Mar 2008 00:10:48 -0500 K Writer? That sounds very much like Koffice, which is a completely different program than OpenOffice. You won't be able to use Koffice if you haven't installed Koffice. Oh I'm sorry, I didn't mean k-writer,I meant OpenOffice 2.3 Writer - it' right off the OO menu. What happens when you type ooffice or soffice at a terminal window prompt? When I type in ooffice I get command not found, and when I type soffice I get no suitable windowing system found, exiting. _ Need to know the score, the latest news, or you need your Hotmail®-get your fix. http://www.msnmobilefix.com/Default.aspx _ Need to know the score, the latest news, or you need your Hotmail®-get your fix. http://www.msnmobilefix.com/Default.aspx___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] OpenOffice won't start up
When I type in ooffice I get command not found, and when I type soffice I get no suitable windowing system found, exiting. Disable selinux, as the article tells you to. Oh...I must not be seeing that in the article, I searched it and could not find that anywhere - seaarched for disable and selinux. could you please quote that part or indicate how I would do that? _ Shed those extra pounds with MSN and The Biggest Loser! http://biggestloser.msn.com/___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] OpenOffice won't start up
http://sysdigg.blogspot.com/2008/01/how-to-disable-selinux-in-centos-5.html OK I just disabled SeLinux and rebooted, still none of the OpenOffice applications will start. _ Need to know the score, the latest news, or you need your Hotmail®-get your fix. http://www.msnmobilefix.com/Default.aspx___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
RE: [CentOS] OpenOffice won't start up
What happens when you type ooffice or soffice at a terminal window prompt? Same as before - command not found and no suitable windowing system found, exiting. _ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos