Open Dental

Ok just got done setting up my Linux box and I got it completely working. Fixed and released.

I went ahead and fixed the particular section of Database Maint that was failing for you. There might be more so I'm installing a Linux box to do some testing, but since you seem to be compiling feel free to do an svn update and recompile (11.1.5 alpha) and hopefully that was the only issue with DBM.

drtech

I just got this issue trying to run Database Maint on 11.1.4alpha (compiled 10/10/2011 at 7am CT) Linux Server See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** MySql.Data.MySqlClient.MySqlException ...

drtech

This exception occurs every time we try to make a recall appt using the recall button in V 11.1. Linux server. Making an appointment by hand works fine. My first thought is it is a capitalization problem since it says the table does exist. ************** Exception Text ...

Roy A Bloom

... I tried mypatient schedular which required VM ware because of connectors. Basically I think it has something to to with the program running on a Linux. I looked into getting a dedicated server at Rackspace ans it was 800 a month. Part of the beauty of my practice is virtually no overhead other ...

murmsk

Because I have a linux server I can't follow the upgrade path through 5.0 as described in the manual.

I did a test datadump out of 4.1 and restored to 5.5 seems to work fine. Before I trust it am I missing something?

steve

... learning curve for security issues. The pain will be less if you have used Vista very much. It will certainly be less painful than doing it in Linux. It is not guaranteed to play nicely with WinXP, but then again, neither is Linux.

murmsk

I finally bought a new server and am now considering setup options. I have around 10 computers that will connect. Linux - I currently use a linux server that has operated flawlessly since 2004 but it took me 3 weeks to figure out the permissions etc all of which I have forgotten. ...

drtech

I could not get it to install from the tar ball ( I really don't know how to manually install things in linux if I don't have a script to run)

sprange

XVlite technically doesn't need a server, but simply installed on a host that is accessible to the other peers (makes sense to have it on the computer that hosts mysql). I was even able to install xvlite on a linux host (using wine) but any update could easily break this configuration.

drtech

If you are and Ubuntu linux user, you know that for some reason, MySQL is not distributing a new installer package for debian based systems and after more than a year, no one has made a .deb file to use! After some headaches and trial ...

murmsk

I have no trouble running OD with a linux server w/o internet.

steve

stjames70

I am rubbing it in. Switch to Macs -- osx is pretty close to linux but Apple has kind of worked out most network issues if you use their 'expensive' hardware. The time you are now spending fixing your network issues is costing you time and money. Vertical ...

tmv2

I'm running MySQL 5.0.51 on Linux. I granted "ALL PRIVILEGES ON *.*" for the OD DB user. I don't think it's a permission issue else version 7.3.9 would have the same problem. Do you have a setup where a separate MySQL server and multiple ...

We did change to a newer version of the MySQL connector. That's the program that connects Open Dental to the database. So the behavior is sometimes a little different. Are you using Linux for your mysql server? What version of mysql?

... all involved in the Choose Database window. Try right click, Run as Admin. Suspect username/password issues with the mysql server if you are using Linux and did not, therefore, install the grant tables using our installer. I'm trying to think what changed between those two versions. I will have ...

murmsk

Now don't laugh but this will show most anything will work. Server - linux server setup in 2004 runs redhat 2? I can't remember the specs but it was a strong machine 6 years ago. I open the door to make sure the lights are on at least every 6 months . I also ...

teethdood

1) Server Config: Desktop 8GB RAM with two-2TB hard drives set up in RAID1 mirror under Ubuntu Linux. Then Virtualbox with Windows Server 2008 running on top of Ubuntu. Pro: inexpensive, easy backups (just copy the virtualbox image to another computer/USB drive). You can ...

drtech

... setup your own secure remote server at home and use secure and encrypted SSL to transfer your files for remote backup. This is done with two Linux servers...one at home and one at your office. They can be physical machines or virtual machines. I do it at my office and once it is setup, you ...

We plan on rewriting it. It does that because of compromises that we made for compatibility with Linux. We no longer have that limitation.

enamelrod

In order to run vs 7.8 what version of mysql should we have running on a linux machine?

Linux 5.5 should be just fine if that's what you prefer.

teethdood

... server ---> 20 client computers no matter the OS windows XP peer-to-peer server --> 10 client computers no matter the OS Some other docs here use Linux to gain unlimited CALs, or a mixture of Linux/Windows virtual servers. However, I think most offices won't outgrow the 20-client limit so win7 ...

enamelrod

nsparks are saying yes od now works with 5.5mysql and if so is it yes it works with linux 5.5 mysql or no stay on 5.0

enamelrod

so is it yes it works with linux 5.5 mysql or no stay on 5.0

garretwcox

... to just access directly (which is easy peezy thanks to them using mySQL), we can use whatever framework we want. I can even have the server run linux instead of windows, since opendental doesn't even have to be ran and .net isn't required. If, however, that's a bad idea (and again, it'd take ...

drtech

OK, that didn't fix the problem...I had the same error again today. Still not sure if it is because of using MySQL 5.1 or not, guess I will try to install and old ubunu version with old MySQL 5.0 and test it for a few days and see if it happens again. Here is the error: Unhandled exception: Out of r...

drtech

... 5.0 version would be my opinion, I am only "forced" to run v 5.1 because 5.0 is no longer supported and maintained as a viable package in modern linux distributions as it is so old. But if you wanted to download 5.1 and you have 64 bit windows, then the 64 bit would be the way to go. You can't ...

drtech

As far as I know, this error ONLY applies to LINUX servers, NOT WINDOWS as most everyone uses for simplicity with Open Dental. Linux gives you must more power, excellent automatic backup methods, flexibility, and it comes at a great price (free)... ...

drtech

... anything you think would improve OD performance? MySQL 5.0 is no longer even supported by Oracle, therefore I can't even install it easily on linux because it has been depreciated...so I think it would be a good idea to get it up and running on a new version for windows too since it is technically ...

drtech

When I run the offending query in SQLyog I get this result: (Both with windows mySQL 5.0 and linux mySQL 5.1) SELECT tasklist.*,(SELECT COUNT(*) FROM taskancestor,task WHERE taskancestor.TaskListNum=tasklist.TaskListNum AND task.TaskNum=taskancestor.TaskNum AND EXISTS(SELECT ...

drtech

Once you learn it, there is nothing like the power and simplicity of linux...networking and backup in my opinion, there is nothing comparable to rsync in windows. I have my files backing up between three locations with secure SSH everyday automatically and ...

drtech

linux

are you saying i should go to a windows server or just wondering?

JrGong

... in the future. Another consideration to make, and there are people on this forum more knowledgeable than me regarding setting it up is using linux machines, no licensing requirements at all. *edit* For spelling

JrGong

I like your style Justin, persistance in gettin OD to work in linux. I am looking at helping my mothers office run as a linux only shop......hope you don't mind me picking your brain when I get to that point!

JrGong

... make sure its solid. Now that doesn't mean you are stuck using a Type 2 hypervisor, luckily there are 2 very powerful hypervisors that work with linux. The first is XEN which is a Type 1 hypervisor, it has been around a long tima nd is very stable and powerful, as well a feature packed. Some ...

teethdood

... day's worth of down time. I would rather have 5 minutes of down time, that's why I was looking into virtualization. I know about ZFS and btrfs in Linux, but I didn't know about NTFS having snapshots too. Unfortunately ZFS is not in the kernel but in userland only, and btrfs isn't finalized yet, ...

alkhaef

... still something I lose sleep over on occasion :P. Best regards, Al PS, FYI, filesystems these days support native snapshotting (a couple under Linux, as well as NTFS under newer Windows Server releases). But taking advantage of those to the level you're suggesting could be arguably more complex ...

teethdood

I have since decided to go with my original plan of running Ubuntu Linux as HostOS, and win server 2008 as guestOS using virtualbox. Here are the advantages: * backup (part 1) in case server hardware literally burns up is going to be super easy. Simply copy ...

Justin Shafer

Dang! I almost forgot who I got that working. You have to install the DirectXSDK in winetricks for it too work! Its a large download from Microsoft.

teethdood

Bill, Thanks for your input. What do you recommend I run as the host OS? (you mentioned windows server 2008/linux as VMs) If I do windows server 2008 as Host, then I can't run another instance of 2008 as VM due to licensing issues. And the ease of having a single-file VM to backup ...

teethdood

... do you think about the setup below? Pretty solid or can I do better? New server: No name Dell with 2-2TB drives running in RAID1 mirror. Ubuntu Linux running virtualbox with windows server 2003 or 2008 as GuestOS. (2003 has been kind to me. Any reason to switch to 2008?) RAID1 safeguards against ...

drtech

looks like lower_case_table_names=0 on mine right now which is the linux default. If I change it to 1, that would be the windows default. Doing this would eliminate the problem it looks like, but maybe I will leave it this way and only change that if I run ...

If you use Linux, it's easy to set a server variable in your my.ini file so that it will no longer be case sensitive. Then, if we let a capitalization issue through, you won't be affected.

enamelrod

thanks for the heads up i was almost ready to upgrade my office server which is linux. ive been playing with the beta at home but its on a window machine.

drtech

I solved the problem. Capitalization standards were not followed in the new insplan changes. This showed up only on a Linux server of course since windows doesn't care. I just did a replacement for the whole word "insSub" with "inssub" and all the 114 or so replacements made corrected ...

drtech

I am having issues too:
Linux server with MySQL 5.1.49...insplan errors

viewtopic.php?f=2&t=3166

mowgli

Dates in custom RDL reports were broken and displayed as "SystemByte()" by the new MySQL connector employed in v7.4. Tested data on a Linux server where MySQL 5.1.49 was installed, and the symptom disappeared. Apparently MySql.Data.dll version 6.2.4 must have MySQL 5.1 in order for the function ...

Justin Shafer

Yes but I didnt tell you guys how to get 7.4.4 to run... but its still in beta so I will wait for it to be stable... You shouldnt be running 7.4.4.. be sure you have direct rendering enabled with opengl and linux... glxinfo is the command..

murmsk

WOW!!!!! Thanks all

steve

drtech

great!

Justin Shafer

Got 7.4.4 to run under wine...

Justin Shafer

Okay Here is a rough draft on how to get it working in Wine. You dont need to compile anything as of 7.2.46 Havent tried anything below that and I am not going too. :lol: 1. Install Wine. 2. get winetricks and install dotnet20 d3dx9 gdiplus glut vcrun2008 ddr=opengl 3. Run the program in a path wine...

Justin Shafer

Got the Tooth Chart working for DirectX in Linux! =) Thanks Jordan! It works PERFECTLY. I think.. Dont use it in vmware though or its slow... I didnt have to do much to make this work. But I will get back to you guys.. I am comparing running this ...

Justin Shafer

Pretty sure I just got this working without VMWare, etc... I am testing in VMWare and right now I am in linux and Open Dental detects my DirectX and OpenGL... give you a hint.. not using Mono..... Time to take this out of VMWare..

Justin Shafer

... found in OpenTK.Compatibility.dll. The first is a clone of Tao's SimpleOpenGLControl layered on top of OpenTK.GLControl (so it supports Windows, Linux, Mac OS X), while the latter is a full copy of Tao's OpenGL bindings that work well with OpenTK. You will need to get rid of Tao.Platform.Windows, ...

Justin Shafer

... isnt too bad... Or just use mysql-cluster and samba and drbd.... Still have the X-Serve? I messed with reading up on having the 3d tooth chart in Linux and currently give up.. As you need to change up some stuff to make it work.. or wish a guy named "The Fiddler" would make his script work on ...

Justin Shafer

So it looks like we need to switch from using GraphicalToothChartControl:CodeBase.OpenGLWinFormsControl{//.SimpleOpenGlControl I notice SimpleOpenGLControl is written only for Windows with GetDC and AutoFinish, etc... So we need to switch to OpenTK.GLControl.... I would say its stable in its 1.X ver...

Justin Shafer

viewtopic.php?f=2&t=3057&p=13125#p13125

Yay!

Justin Shafer

... and I had to rip out do some crazy stuff... 1. Compile OpenDental in Visual Studio 2008.. Keep OpenDentalBusiness.dll handy.. move it to linux. 2. Get Linux.. and the latest Mono.. Dont know if it helps but Im running 2.8 3. Download SVN of OD 4. Open MonoDevelop and Rip out OpenDentalBusiness. ...

wjstarck

... for kicks, you could also try compiling OD in windows and then copy everything in the /bin/Release folder over to /usr/local/OpenDental on your Linux box. Then just $ mono OpenDental.exe and see if it launches. Saves you from alot of dependency hell trying to compile on Linux, and will give ...

snecklifter

... MonoDevelop and get the same error using Mono 2.4 or 2.6.7 For interest, I reverted to an older version of CDT.dll (back when it was compiling on Linux) and got a different error. The error message indicates to me that it's finding CDT.dll just fine. It's the dependent file OpenDentBusiness.dll ...

The error message indicates to me that it's finding CDT.dll just fine. It's the dependent file OpenDentBusiness.dll that it's having trouble finding.

wjstarck

Sneck- I had tried to compile it on Ubuntu 10.4 before I answered your question just to see what had changed since the last time a tried (somewhere it the fives or sixes) and it was a no-go. I can't remember what the exact error was, but if I have time tomorrow I'll give it another go. Justin Shafer...

snecklifter

... with lack of resources for maintaining two versions by the Open Dental developer, and the end result it that it just isn't realistic to support Linux at this point in time. Market share with Linux is another factor. If anything, it would be more logical to support an OS X flavor of OD. Then ...

drtech

-updated to 7.2.26 ...no change -updated my linux MySQL database to 5.1....no effect ---I am not seeing pts today and therefore my schedule has about 50 "note" appointments of things to take care of with no regular appointments. It works lightning ...

drtech

... and switches (sing gigibit eithernet) - Have not yet tried changing the slq.ini...going to have to figure out where the equivalant that is on a linux server. Anyone else having issues?

wjstarck

... with lack of resources for maintaining two versions by the Open Dental developer, and the end result it that it just isn't realistic to support Linux at this point in time. Market share with Linux is another factor. If anything, it would be more logical to support an OS X flavor of OD. Then ...

snecklifter

... looks to be more of an issue with the mono compiler an may not have been an issue for as long as that. I am interested in getting this running on Linux again (kiosk/patient check-in mode for example!) and if anyone else is please feel free to comment here. I am part of the Fedora Mono project ...

snecklifter

... MySQL has had more than 70 vulnerabilities. Third party Security Innovations found that SQL Server on Windows is more secure than MySQL on Linux, with 46% fewer vulnerabilities and 48% fewer days of risk. ESG reported that SQL Server is “years ahead” than MySQL... SQLServer is integrated ...

sergiogm2000

... networks (note: this will only work on windows machines); the second option will be a more compatible across OS and could be run smoothly on Linux, Apple's OSX, BSD etc., this option will drain more server's resources but we need not to care much about security since almost everyone will ...

Justin Shafer

any updates to this thread? Is DRBD8 with Heartbeat2 in Ubuntu doable? or are there many hurdles? I've dabled in linux for a while but don't want to go down this road if ya'll of much higher knowledge suggest not worth the trouble. I really really need a cluster scenario to avoid ...

Justin Shafer

... a Virtual Machine highly available with DRBD, CoroSync\OpenAIS, and Xen.. either KVM or Xen. Havent tested this yet... This is next. That is the linux world. Microsoft world works pretty well. I have tested Failover Server 2008 in Windows 2008 Enterprise and everything works pretty well. Except ...

sushil_india2000

... and the United States Census Bureau, among many others. In my region, doctor has widely appreciated dental software and they like availability on Linux operating system as well. In this direction MONO team is doing job to run windows application on Linux. I am doubtful, if Microsoft will consider ...

enamelrod

... automatic monthly credit card processing, Payroll integration, online statement generation just to name a few) . THere is also movement away from linux support also but few are fighting that. I dont see what the big deal would be to have a tighter integration OPTION available for Word and QB users. ...

enamelrod

... of any accidental deletions. i think jordan said the archival of folders and security on folder levels has limits because of the limitations of linux and this feature would be hard to accomplish.

michael_k

... MySQL has had more than 70 vulnerabilities. Third party Security Innovations found that SQL Server on Windows is more secure than MySQL on Linux, with 46% fewer vulnerabilities and 48% fewer days of risk. ESG reported that SQL Server is “years ahead” than MySQL... SQLServer is integrated ...

peterskuben

Biggest advantage of a web version is that you can use it on any device.............Windows, Mac, Linux, Your mobile phone, iPad...basically anything you haven't even thought of...you could use Open Dental if it were in a web browser.

Justin Shafer

... but its nice too. You could just install mysql on another workstation and update it, and recreate the shares on the workstation, etc, etc... With linux, I would really just create a fresh box from scratch and then set it up to be the server, configuring samba, mysql, etc... Wouldnt take that long, ...

Justin Shafer

I used to have this problem upgrading the database with the linux server. I had to reset the grant tables in mysql I think.. was a couple of years ago... Restoring the database shouldnt affect the grant tables in mysql though.. could be a conversion problem.. ...

DrT

Thank you for your quick reply.
Yes, I install MySQl 5 on Ubuntu (Linux) as a file server. I converted an existing database (ver. 5.6) to ver. 5.9, 6.2 and 6.3 successfully. And when I converted the database from ver. 6.3 to ver. 6.4, I got the error message mentioned above.

Is your MySQL username and password still root and (blank)? Those were the defaults that the program shipped with
http://www.opendental.com/manual/choosedatabase.html

Did you install MySQL using our installer, or did you do it yourself separately? Are you using Linux?

drtech

Jordan...no I was not aware of that...prob should do that... but then who would find the Linux server bugs!

drtech

can the capitalization be fixed? won't run on Linux server...all table names should be lower cases (paysplit is the only one i know causes and error...don't know if there are any more)...thanks..looks promising!

drtech

i don't ever use that...I have mysql dumps automatically on my linux server every hour...and I just restored a backup from 3-16-10 using SQLyog.... I checked the paths there and they are to inaccurate paths from when I first started using OD on a windows ...

apollonia

... SUPER privileges to the OD user account, so it throws a privileges error. but i really don't want to let OD stuff dead squirrels into my.cnf (linux). i'm hoping this is just a random choice, and not crucial. otherwise i'm going to have to recompile every update version, or in the alternative ...

Someone else submitted the same bug. I see now that Adjustment is improperly capitalized, which is only a problem if your server is Linux.

medicusjim

You could separate the application stack even more by running two Linux VMs, one for the database server, and the other for the folders. Then keep you web services on the Windows box. This provides good database security and protects it from IIS a bit better.

-Jim

ajoshi

... for MySQL (http://www.mysql.com/products/connector/net/) - I would imagine that is stable. Disclaimer: My self interest is in seeing Opendental on Linux (having started to try and compile it just today). Amit

drtech

... found there is no reason to do that in our office. What do you need to be part of domain for in a dental office? Works fine with networking to my linux server or a windows peer to peer server.......don't know if you have to have domains on windows server 2003 or 2008....prob would still work fine ...

We phased out Linux for workstations a long time ago. I think my comments were that we don't plan on returning to try that again. Linux will, of course, continue to work fine for the database server if the user wishes. But we won't encourage it due to difficulties supporting it remotely.

drtech

... back development trying to wait for the mono folks to keep up with .net I think mainly...and he just moved over to DirectX from OpenGL, so I think linux compatibility is no longer really feasible. ...i am a big Linux guy...but mainly for the server...too many driver issues with digital x-rays, ...

enamelrod

is open dental moving away from linux support ? I read a post that leads me to believe that OD is phasing out Linux and is going with a tighter integration with windows? Is this true?

drtech

... Just make sure you don't use any VIsta computers with either setup in my opinion, will run into trouble, esp with your printing. I use an Ubuntu Linux server. Been working great for 4 years...no problems. No software cost and more stable than either windows server, but hard to initially set up.

... existing feature requests related to this topic. Part of the clumsy feel of the tree list is because we were trying to make it compatible with Linux a few years back. Now that we don't care about Linux, we can make it have a nicer look and feel. We track the interest level through the feature ...

drtech wrote:yep I got the whole thing...tried it again...I do have a linux server...capitalization problem?

Yes, capitalization. Patient should be patient in the query.

drtech

yep I got the whole thing...tried it again...I do have a linux server...capitalization problem?

V Suite

... It is open source, BSD licensed, and is much closer to Oracle than any of the other open source databases. It runs well on Windows as well as Linux. The similarity to Oracle especially should provide you with an easier time supporting that DB. Jordan, I get the impression from the OpenDental ...

Good call. The spam you refer to is now gone, which I hope doesn't cause confusion. It was right above yours.

wjstarck

I dunno...quit spamming forums?

richardwaite

Please consider PostgresQL. It is open source, BSD licensed, and is much closer to Oracle than any of the other open source databases. It runs well on Windows as well as Linux. The similarity to Oracle especially should provide you with an easier time supporting that DB.

wjstarck

... be the first time a company deliberately purchased another to eliminate the competition. We virtualize Windows 2008 server inside an Ubuntu Linux box running 9.10 and it's quite fast, stable and robust. Our mail server and DNS run on Linux, so we have the best of both worlds. Our web server ...

drtech

... mainly to not get locked into windows. I know this argument has been gone through before, so the main thing I want to know is can MS sql run on a linux server? I am sure it can't. I love linux for a server (never will work for a desktop without major improvements) but I think that would be a bad ...

dentexgroup

... we're going to connect all branches including mobile ones to the Main office), and by using Hyper-V install on same hardware (HP Proliant d320 G6) Linux platform for sharing AtoZ folder. Any suggestions ? Thanks. Genady, SysAdmin - Dentex Dental Group

richardwaite

The one thing that I always notice in flamewars like this is that people forget is that there is always lock in, in one way or another. Software written for Linux can depend on POSIX forking and pipe behavior and all sorts of Unixy weirdness.

The fact that it took 9! versions before anyone noticed tells you a little bit about exactly how many users are interested in this capability.

Kollin

R.I.P.

drtech

http://www.opendental.com/manual/clinuxmac.html

Kollin

... to pay microsoft tax for using dental management system! :roll: Are there any plans for correcting this or should I say RIP for Opendental for linux platform ? :cry:

Kollin

OMG

v5.6 is the last that can be compiled in linux(with mono)? Is that what you are saying?

drtech

as far as I know the latest versions cannont run in linux (and if you are trying you should just compile an older linux compatible version v5.6 or less in windows and copy over the files). Unless you are going to try to fix it that is the last working version.

Kollin

** (/usr/lib/mono/2.0/gmcs.exe:29839): WARNING **: The following assembly referenced from /home/kollin/development/opendental/Required dlls/CDT.dll could not be loaded: Assembly: OpenDentBusiness (assemblyref_index=2) Version: 5.0.0.0 Public Key: (none) The assembly was not found in the Global Asse...

wjstarck

... that has run nonstop since 2002. I've had to replace one failed drive in the XServe about 6 months ago. The XServe is connected to an Ubuntu Linux Dual Processor Xeon box. Inside we run Windows Server 2008 as a VmWare virtual machine. Windows Server 2008 is very robust and fast, even running ...

Hersheydmd

We've been really happy with our decision to go with dot net. In fact, we continue to move away from Linux in other areas as well. We just purchased a file server computer for $2000. Did we use Linux? No. we are using Windows Storage Server, an OEM product that powers file ...

gouravshah

Has anyone tried to use OD on linux with Wine (http://www.winehq.org/)

rah

... add more features or simple to adapt to a specific situation. That was Jordan's idea from the beginning. I'm not worry at all for the lack of Linux (or other OS) support, because I know that some people are interested on that and we all can make it work on Linux, Mac or what we think is more ...

wjstarck

... I learn about the project, the more I'm sad and disappointed. Why? Because, in my opinion, that statement began to crumble the moment you forgot linux and bet on Microsoft. I think you are mischaracterizing the decision as a "bet on Microsoft". I have written code for and managed Mac, BeOS, Linux ...

SmilingPatient

What is the point of this argument? Is the argument 'I want a Choice of OS's' or 'I want Linux only'? There are a limited amount of resources to any project. Focusing on Windows leaves more resources to develop functionality, integration, and features for EXISTING CUSTOMERS. ...

Rickliftig

... and my ease of use. OD is stable as "all get out" and I like it that way. Plus, like it or hate it, MS Windows is a standard and well-defined. Linux is anything you want it to be and almost anything you want to incorporate into it. Perhaps it's not unlike the Mac vs. PC debate of about five ...

rah

... one doesn't rule out the other. One example.Internet Browsing: You can use Firefox for years in Windows, but you can tomorrow start using it on Linux or Mac if you wish. But if you only use IE, and everybody expects you to that, websites will not for sure follow standards at 100%. So you'll ...

drtech

... ways, Windows (or Mac) is the only way to go in the dental office with digital radiography, scanners, other technical stuff that runs on windows. Linux is great for servers. The desktop is still dominated by windows. But with finally a good product in Win7, I am more inclined than ever to go with ...

mowgli

... doesn't run in a vacuum. Like it or not, Microsoft has approximately 92% of the operating system market share, followed by Mac at about 5% and Linux at a mere 1%. Within that 1%, you have various distributions that don't standardize important tasks, limiting widespread adoption by non-technical ...

drtech

Jordan, when you say home editions won't connect to server versions....does that mean to MS server or something? I have 15 computers all with home edition in my office, and they all connect fine to my server...but it is linux...

We do not recommend using Linux. Yes, it's certainly possible, but it does not make anything easier or cheaper. Server Foundation is an entry level server platform which would work great. I love the fact that it supports 15 computers and ...

We will not be switching to MS-SQL, because as you said, it requires paying for a license. I would like to point out that we did try to use Linux for a number of years. We found it very difficult to manage, difficult to upgrade, and just really really annoying. Using Windows saves us much frustration ...

rah

Jordan; I'm sorry to hear that. That means that Linux (and Mac) support are virtually dead. Could OD run in a system different from Microsoft's? Maybe, but the problems and difficulties will discourage the users to do it. So I decided to abandon ...

drtech

... know someone who can help you set it up, you will have much more flexibility and unlimited users by buying one with no OS and have someone install LINUX for you (ubuntu is what I use)

We've been really happy with our decision to go with dot net. In fact, we continue to move away from Linux in other areas as well. We just purchased a file server computer for $2000. Did we use Linux? No. we are using Windows Storage Server, an OEM product that powers file ...

rah

... I learn about the project, the more I'm sad and disappointed. Why? Because, in my opinion, that statement began to crumble the moment you forgot linux and bet on Microsoft. I'm aware that Microsoft systems are the most installed, and also that they are more user friendly (partly because of the ...

Trevorlawrence

Hello,
I saw on the internet this excellent open source program for dental offices called Open Dental. I wonder if there is a way to port it to Linux since that would be a great strategy to attract small business owners to the open source world. If so what do I need to learn to do it.
Thank you.

mowgli

... would work better. Another factor is whether "root" user is allowed to connect to MySQL from any host; restrictions may be set up, especially in Linux implementations of MySQL. If Open Dental is running somewhere, the query "select * from mysql.user" should show this; "%" is a wild card for any ...

ugach

Thanks Justin,

I will try compiling. I never had luck with precompiled windows executable. One time it would not take / for path so I could not use shared images folder on windows machine, these days it fails to start, complaining about cups printing (asking for it even though it is there).

Some sort of security issue with the manifest file on the server? This may be a good enough reason to switch to a Windows 'file server' or an embedded Linux NAS so that you don't have to deal with permission issues. I don't know.

enamelrod

ok jordan i figured this one out. And i have talked to you and nathan about this before. when i go to update it downloads the latest copy to my linux server but all the workstation computers thinks its on a different version. the manifest on the workstations vary and are reading 6.6.21-6.7.24 ...

Justin Shafer

I havent tried lately.. but OD has ran on Mono before... Search google for Open Dental and Mono... Here were my directions for OD 5.something and Ubuntu 7.10.. I think... =) These commands compiled mono from source. The actual binary OpenDental.exe is compiled on visual studio.. so you should just b...

drtech

any windows version 98, XP, Vista, Win7 will work. There is really no requirement (although I agree, never vista!). mySQL just has to install. I use ubuntu linux. Works great and never goes down.

ugach

... I could throw VMWare Workstation on the server... that way I dont have to worry about mono running the latest version of Open Dental.... All for linux.... Justin, Thanks for the tips. I thought about that too but then realized that most of the manufactures for wireless cards, printers, scanners, ...

Justin Shafer

I guess I could throw VMWare Workstation on the server... that way I dont have to worry about mono running the latest version of Open Dental.... All for linux....

Justin Shafer

Here is a script to setup the workstation backup.... "c:\Program Files\MySQL\MySQL Server 5.1\bin\mysqldump" --host linuxserver --user root opendental > c:\data\opendental.sql "c:\Program Files\MySQL\MySQL Server 5.1\bin\mysql" --host joeloftus-pc --user root opendental < c:\data\opendental.sql xcop...

Justin Shafer

Remember that if you go with a linux server there is always, ALWAYS the disadvantage of... A server is no good when it cant "serve" out the info to workstations. If the network switch goes down, then the server cannot talk to worstations. ...

Justin Shafer

... to try it out.. I would like a guy named Aguilar to be this guy.... But if not, I would like someone else too. Or I could always take down the linux server at the Open Dental office I work with and do this... but I would prefer to leave that linux box alone.... With a cluster, we do our backups ...

Justin Shafer

I should start building some linux server that have all this done and then you guys can buy them...

Justin Shafer

I just built a Linux Server with raid 1. Got all opendentimages and mysql data moved. Then I looked at backup! There is nothing wrong with current method. It works fine for windows machine. I have been able to backup and restore ...

murmsk

Thats the beauty of open dental you can make any workstation act as a backup server. Just install mysql on it and turn off the service. backup the data whenever you want . If the main server goes to crap .... turn on the service and your up and running. Some other ideas. You can rsync data home ever...

ugach

One thing about the datadump with mysqladmin. If the database changes through a version change ie: new tables ...... you have to edit your backup schedule to include the new tables it works well tho steve Thanks Steve, I will keep database updates in mind. I also found free alternative to replicato...

murmsk

One thing about the datadump with mysqladmin.

If the database changes through a version change ie: new tables ...... you have to edit your backup schedule to include the new tables

it works well tho

steve

ugach

... computer. This computer is also my backup server. mysqladmin is a free downlad from mysql and will run on any flavor of machine (windows ,linux/apple) We use karens replicator on a windows machine to move data between computers as it only moves new and changed files. everyday the image ...

Tables do not need to be locked before backing up. I did that for a few years, but then gradually stopped. I haven't locked tables for about 4 years now, and I have never had a corrupt backup. I restore backups very regularly to other machines. Never any problem. It's during the restore process that...

murmsk

... computer. This computer is also my backup server. mysqladmin is a free downlad from mysql and will run on any flavor of machine (windows ,linux/apple) We use karens replicator on a windows machine to move data between computers as it only moves new and changed files. everyday the image ...

ugach

I just built a Linux Server with raid 1. Got all opendentimages and mysql data moved. Then I looked at backup! There is nothing wrong with current method. It works fine for windows machine. I have been able to backup and restore ...

drtech

you mean outside of Dental Senders just to set up a linux server for your open dental database? I setup a LAMP server with UBUNTU server and then install webmin to configuration. Then you have to configure SAMBA for your file sharing. I can send you ...

Anthony J Turner

I am in the precess of doing the same but have not got my linux server up. Which instructions did you use for the linux server?

Tony

drtech

Anyone else successful setting up DentalSenders lately to connect to a linux server? I have had it running for quite a while on an old version, but when I went to reinstall a computer today, it won't connect to my database and says I have to have to install ...

It would only work if we didn't allow rotations. I suppose that's not a bad idea.

richardwaite

Have you considered using a table of static images for the tooth chart? Rotations, etc. would require different images but I don't think you would need too many.

The 3D tooth chart never did work on Linux due to limitations of Mono. The Mono team took many more years than they promised to build the framework. We basically got tired of waiting for them and moved on to greener pastures. Haven't even tried ...

benjap

Can anyone tell me if OpenDental runs on Linux out of the box. I tried to install it on a CentOS 5.3 box and got all kinds of errors dealing with MONO. It is not well documented anywhere on this site how to do this nor is it in the manual. Does anybody provide this service for a fee.

Justin Shafer

Runs well. Run it with 2 VMWare Workstations running Linux to acheive a Linux-HA Cluster. That is 2 servers acting as one, to increase redundancy.

Oh I am supposed to call you. I will reply to your email...

ilizaran

Hi Steve,

You need install some library of mono (winforms), you have to do:

Ubuntu: sudo apt-get install mono-winforms*

Regard.

Nacho

abelaguilar

any updates to this thread? Is DRBD8 with Heartbeat2 in Ubuntu doable? or are there many hurdles? I've dabled in linux for a while but don't want to go down this road if ya'll of much higher knowledge suggest not worth the trouble. I really really need a cluster scenario to avoid ...

murmsk

... OD runs faster if the data files are kept locally. You could backup to the NAS on a regular basis? What did you plan to use the NAS for? I use a linux server with 12 computers and a NAS as a backup and central storage. I also use an offsite internet backup service. steve

mattclar

seems to be pretty close to hitting the 1.0 mile stone to me 0.9.9-0 seems very close to a major release and there seems to be talk about compatibility of this version with the 1.0 release. Seems worthwhile

OpenTK seems to be a new development since I last looked. But I'm not going to bother with something that still has a major version number of 0. Not worth my time.

mattclar

Did some further searching not sure if this addresses your problem but perhaps it does ...again Im not a programer lol

http://go-mono.com/forums/#nabble-td20831321

drtech

If only we could get it working under linux...the days of rebuilding my windows boxes every year would be over....

... the beginning and continue to use it in order to make OpenGL work with Windows. But that's not the same as making OpenGL work with Winforms on Linux. There's a hardware interface here and nobody has been willing to go to the effort to make OpenGL work with Winforms. It won't work. I'm 99% sure. ...

mattclar

I have got Open Dental working under Ubuntu linux using mono 2.4. But my problem is that I cant enable the 3D tooth chart, yes I know it doesn't work on Linux but wouldnt it be nice just to try it out at least? see if new versions of mono that ...

Not quite. It's a MySQL database capable of being connected directly from any Windows workstation as well as any web service CLIENT. I suppose it wouldn't be too hard to extend it to the model you are asking about, but that's not the current model. I think the only place where there's that limitatio...

mimai

I thought the model was that a MySQL database capable of being connected directly from any Windows workstation as well as ANY web service server. Then, any work station can connect to any Web Service Server. Am I mistaken?

Our application was built under the assumption that there would be only one web server, not multiple. However, I think there are tools to make multiple computers behave like one virtual web server, and then our application should work fine. A couple of posts were lost here. I remember that you were ...

mimai

In a Linux MySQL server and Windows Web Service setup which computer need more processing power? Can multiple Web Service servers run simultaneously for load distribution and redundancy? How do we handle billing for multiple ...

... not be a problem. You won't be able to put your image folder on the Windows computer due to 10 connection limit. But you can just leave it on your Linux server or on a NAS device running Linux embedded. I totally agree that this solution would be better than daisy chain replication. We're going ...

mimai

Can Web Service be run on a Linux Server? We have MySQL and Samba ( for image folder) running under Linux and they are working extremely well. We wish to replace chain replication some day with Web service as the solution to Multiple Offices. ...

murmsk

... rsync Crashplan will send a copy home. Mozy encrypts the data before it leaves my computer and works unattended. Cost is less that $100 a year. No linux support. Crashplan is sort of interesting. It will allow you to backup your data to any predesignated computer attached to the internet. It loads ...

ugokind

ok.. I wait 'til you give me a feedback.. but let me ask you .. you use exe files in mac? ? with crossover or wine? I thinked that the linuxrelease (and makefile) was made for using Opendental in a linux/unix distro. I tried also ti compile with debian and the great commercial novell Enterprise ...

murmsk

I am getting the following error when I try and start OD in linux ** (OpenDental.exe:23941): WARNING **: The following assembly referenced from /home/steven/Desktop/ODProg/OpenDental.exe could not be loaded: Assembly: System.Windows.Forms (assemblyref_index=0) ...

mnpbds

... http://www.markpreston.co.uk/fonts/palmer5.png shows how,once installed, they can be used in OpenOffice 2.4 (under Linux in this case). OpenOffice can also export the file as html - see http://www.markpreston.co.uk/fonts/palmer6.png (FreePalmer fonts need to be installed ...

ugokind

Hy Jordan.. I'm guido I'm trying to compile on MAC the linux release.. but the last svn gave only one error and one warning. the erorr is there!! [Task:File=....../Opendental640/OpenDentBusiness/Imaging/ImageHelper.cs, Line=146, Column=41, Type=Error, ...

... Honestly, copying the files over from a Windows computer is as good as it's going to get. There may be a bug. It's been a while since we tested on Linux. But we also had lousy luck trying to get any kind of file sharing working. We're just not very skilled with Linux. To directly answer your question, ...

ugach

OK. Let us try a different approach then. I am thinking that native compiled version may handle Linux style disk mapping correctly. If I download source and compile based on information on this board, will it be compatible with database version of our paid stable version ...

I don't know.

ugach

All it took was the screenshot. Forward slashes are not valid Samba delimiters. Use back slashes. The screenshot is from Linux workstation. As you know, path does use forward slashes in Unix/Linux as opposed to back slashes in windows. But, I did try what you suggested in hope that ...

All it took was the screenshot. Forward slashes are not valid Samba delimiters. Use back slashes.

ugach

... xp was reccomended over vista for OD, so I special ordered Dell with xp. Any way, without getting in to any OS fights, please help me solve this linux issue. Today we had a crash on XP machine and tech. suport remotely installed 6.3.8.0 after few tries. I promptly copied that to llinux and now ...

Once I got used to the windows popping up to "Allow", I have found Vista to be very enjoyable. No problem with viruses.

ugach

Have you considered avoiding all this hassle and simply using a Windows computer? Yes, but as Linux users would tell you, it is one time hassle (or few more while setting up) and forever bliss once done. In an office where the dentist thinks that the letter is stored ...

... It has nothing to do with the override below. You don't need to do anything in the computers window. Just out of curiousity, do you see your Linux computer in that list? The datapath information is stored in the preference table and in the computerpref table. Have you considered avoiding ...

Yes, you enter a payment of zero and make a note.

ugach

... of OD, does it bring up your images? I think your path is wrong. Yes, I can browse to the path and view all the images, pdf files, everything from Linux machine. I also use that folder for transfering other files back and forth. Does having additional files or folders in images folder affect OD? ...

ugach

Thanks Dr. Sparks. With low volume in insurnace claims, I did not want to spend money on nea-fast. I guess it is paper claims then. Why can't insurance companies accept e-mails? Public key encrypted e-mails are supported by lot of e-mail applications these days. It would be easy to implement. I thin...

You will wait for the primary claim to come back, edit your estimates, and then send a copy of the primary eob with the secondary claim. This means paper mail, or electronic attachments.

Don't check the box for multiple paths. Just use the "override path for this computer". If you put that path in a file explorer outside of OD, does it bring up your images? I think your path is wrong. In Setup, Computer, you will see a few extra machines. That's harmless. I think you can even delete...

ugach

I ended up with emdeon on windows XP machine to avoid any complications. (And finger pointing ;-) ) I have managed to open just the port for emdeon while still blocking web surfing and e-mail to outside world from that computer. It is working fine. Now, how does one send a secondary insurance claim ...

ugach

Anybody here using mixed linux/windows environment? I have one XP home machine (dual-core CPU big SATA hard drive new Dell hardware) running mysql and open-dent client on dot net. Images folder on this machine is shared on the intranet. ...

drtech

I set up my computer to back up to a computer at my home every night over the internet using something called rsync with linux...working like a charm for about two years now and I don't have to do anything except check and make sure it is working everyone once in a while. it takes ...

Justin Shafer

... that is a cluster with file replication. Shared Storage can be even more expensive... depending if the shared storage is redundant or not. With Linux, the cost is just 2 Servers, and labor. No software to buy. So its more around $3000.00 without the IT guy.

Justin Shafer

... waiting for Server2 to come back up.... If Server1 goes down, Server 2 becomes primary and waits for Server1 to become healthy. I used Ubuntu Linux 8.10, DRBD8 and Heartbeat2. Right now I have the configured for automatic recovery which in the real world I may not have done. So lets say if ...

The Claim Connect functionality should still work fine on Linux.

ugach

Anybody doing e-claims on Linux machine? If yes, what do you use? I have creative front desk and computer illiterate dentist hence I have disabled Internet access on front desk machine hosting open-dent database. (running XP). I am running ...

fdscadmin

You don't have problems on Linux getting all the dependencies installed correctly when you upgrade a program? It's a messy messy chain of dependencies. If you don't get just the right version of such-and-such package installed correctly, ...

Search found 578 matches: linux