Open Dental Forum

abelaguilar

Anyone know if its possible to add a username and password to SQL? I am trying to use a backup program that backups sql databases but it needs sql to have a username and password in order for it to access the database. How can it be done and will it cause problems? I called open dental and the suppo...

abelaguilar

Thanks I'll try it.

abelaguilar

Hello: Called open dental to figure out what software they recommend for external drive backup and no one had a clue. Yes, we do off site on line backup. What i'm looking for is a good piece of software that will backup or sync my server files to external usb drive. I've been using karen replicator ...

abelaguilar

Great to hear!! The reason why I want to transition to vmware is to avoid any downtime in case of server hardware failure. so, the plan would be to have opendental running in vmware. Backup every day the entire vmware file to another computer. If I come in monday morning and my server is down due to...

abelaguilar

wondering if anyone has tried running open dental withing a virtual server environment.

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 any down time. Put ...

abelaguilar

Anyone know if its possible to have a dual mirrored server scenario.

If one server goes down becuase of hardware failure the second server takes over for the benefit of 0 down time.

Is this being done?

abelaguilar

wondering how do I get opendental to see my mysql data that was moved from the old server to a new server using windows 2003 server.

Not sure how to restart mysql.

abelaguilar

Hi all:

Wondering if anyone is willing to share their icons. I need implant and abutment icons. My system onlyshows about 7 default icons to chose from. I'm on version 6.2.12. Dont know wether upgrading is going to make a difference.

Thanks !!!!

abelaguilar

Hello all: Maybe i've over looked this report. I'm looking for a report that will give me % for hygiene, % of restorative, % of crown and bridge/ % endo, %perio, % removable pro/ % oral surgery.

Is there such a report?

Thanks

abelaguilar

Great thanks. Were defining an active patient as having visited our office at least 2 or more appintments. That's really what i'm trying to find out. HOw many active patients we have for a given date range.

abelaguilar

Anyone know of a query report that will give me the number of hygiene patients or hygiene provider patients that came in the past year at least 2 or more times?

Thanks

abelaguilar

Anyone know if its still not possible to scan double sided directly into open dental. we use a fujitsu 5120C

abelaguilar

we have some patients that we need specific pop ups to remind us about their insurance and other special information that we don't want to overlook. so, if the pop up is attached to the patient. then wen the girls select the patient either throught the patient list or from the schedule my assumption...

abelaguilar

Are these pop ups global per patient wether the patient is scheduled for treatment or not scheduled?

abelaguilar

Question:

Is there a way to setup a popup that is attached to a specific patient versus a patient that is scheduled?

situation: the girls would like to have a popup for specific patients that remind them about important insurance notes and other information that must not be forgotten.

Thanks!!

abelaguilar

Thanks i'll try it.

abelaguilar

Hello all:

Wondering how can I generate a report listing new patients to the office.

Thanks

abelaguilar

Hello:

We use xcharge and it work great with open dental. Honestly, I haven't loooked into detail as to the rates compared to my prior merchant provider.

We use the dymo label printer with it and works nice.

abelaguilar

I have a working setup of 3cx pbx at home using windows xp, linksys spa3102 and a polycom 501.

The sound quality is great and the features of this system allow for plenty of flexibility.

From what I understand this uses a light version of mysql database.

abelaguilar

in my case it works better using apteryx's software capture button. so I have the assistant click the button for me.

There is another driver that will allow me to capture via the button, but I loose other funtionality such as select the tooth number and multiple capture imports.

abelaguilar

Yes I have them as well. definitely worth the 100 bucks I spent on ebay. I have 2 of these. I've sold many crowns with this thing. integrates into apteryx pretty well.

abelaguilar

HEy guys I came across this asterisk alternative, windows based and thought I would send you the link. i'll be testing it soon.

http://www.3cx.com/

abelaguilar

Can someone post a query that will give me a monthly production report by provider?

Currently you have to run a report separately by provider which is a PIA. especially since I need to go back and do 4 months.

abelaguilar

I agree. I would never buy those 600+ camera's after using the 1.3 megapixel fro ebay. I bought two of them. At first I would simply show the patient the broken tooth. press the button to capture the image and then just press the print screen button on the keyboard. Now with apteryx I can easily use...

abelaguilar

any tesia users?

abelaguilar

Hello all:

Wondering what are the benefits of switching from emdeon to Tesia? I hear there is better integration with open dental.

abelaguilar

well just found out how to change that. in ubuntu you get a admin password window before admin changes are allowed. Its supposed to be a security measure to prevent use of root and compromise security for computers connected to the WWW.

abelaguilar

no for some reason ubuntu does not allow the system administrator to log in, but there must be a way. i'll have to check google for that one.

abelaguilar

Jordan when I right click on a folder in ubuntu distro I don't have the option to change permissions. Even when I R click , properties, and permissions tab is greyed out.

abelaguilar

R U doing this in linux? can you be more specific?

abelaguilar

can you post the commands you use to give this new database folder the correct permissions?

abelaguilar

the folder is /var/lib/mysql

I want to have access to databases within mysql which are in separate folders.

abelaguilar

so do I use chmod or chown?

abelaguilar

When the report is generated for incomplete procedure notes, how do I zoom in to get a better look at text?

I can't find this option

abelaguilar

Wondering why samba will give me access to the specified folder in smb.cnf but not access to all subfolders from windows.

abelaguilar

OH really? I thought I had to use mysql admin to backup the database and then restore using mysql admin.

abelaguilar

interesting. I don't have a problem working with ubuntu. I just don't want to find out later that I should have been using something else. Also, any suggestions on how I can bring my opendental backup from work and quickly restore to ubuntu to make sure my backups are working? In windows its just a ...

abelaguilar

thanks again for all your help

Question: I feel like the ubuntu distribution was missing many packages that came with others like suse.

Is there a preference as far as distributions go?

abelaguilar

FINALLY!!! ok guys, I finally got everything running. now what inthe world happened? I think the problem was in the database backup that I made. restoring and backing up somehow got messed up. I went ahead and re did a backup and restore into ubuntu and was able to access everything. Now if I could ...

abelaguilar

How would you guys recommend transfering my current windows mysql backup to my linux mysql server

abelaguilar

ok update

I redid the backup from an empty opendental database. ( no patients in list) and restored to mysql in ubuntu and set opendental to point to that mysql database and i worked.

now I will try an old REAL backup with all my real patients to see if that works.

abelaguilar

no cannot connect. maybe I over complicted things but here is what I did. I backedup my existing opendental database in windows. then copied it over to ubuntu. Restored that backup using mysql admin. then go into opendental, select the ubuntu server and then the database which is called opendental i...

abelaguilar

no cannot connect. maybe I over complicted things but here is what I did. I backedup my existing opendental database in windows. then copied it over to ubuntu. Restored that backup using mysql admin. then go into opendental, select the ubuntu server and then the database which is called opendental i...

abelaguilar

Yes I was able to input these commands and restart mysql

abelaguilar

OK where do you want me to enter and create this query? mysadmin has a component that allows you to create queries called mysqlquerybrowser.

abelaguilar

Frederick: you mentioned can I modify the data from within windows. I could possibly try to add a table using mysqladmin in windows and see if it allows me to do that. I think this is an issue with permission, but I can't seem to find the solution. If you look at earlier posts, you'll see where I po...

abelaguilar

ok great service package installed and I can start and stop mysql.

you would think ubuntu has this already installed.

abelaguilar

i'll have to install the service package. I know i've not done that which explains why the command won't work.

mysql database is on my ubuntu box. I can connect to it from my windows mysql admin program.

abelaguilar

I made the change and added skip-grant-tables to the mysqld section . still can't get access here is the output to the folder permission. abelaguilar@ubuntu:/var/lib/mysql$ ls -l total 20540 -rw-r--r-- 1 mysql mysql 0 2007-10-02 18:52 debian-5.0.flag -rw-rw---- 1 mysql mysql 10485760 2007-10-03 09:2...

abelaguilar

ok i'll try that.

any other ways to get mysql to restart. I can't use the sudo service mysql restart command. It says that command is not available. i'll have to restart the computer since I have no other way.

abelaguilar

still no luck. When I set in open dental the server as ubuntu and the database as opendental, it seems to connect. howver, it needs to modify the database becuase the version on my computer is different from the version that is stored in mysql. that's when I get this error access denied for user 'ab...

abelaguilar

total 20540 -rw-r--r-- 1 mysql mysql 0 2007-10-02 18:52 debian-5.0.flag -rw-rw---- 1 mysql mysql 10485760 2007-10-02 20:37 ibdata1 -rw-rw---- 1 mysql mysql 5242880 2007-10-02 20:44 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 2007-09-30 00:59 ib_logfile1 drwx------ 3 mysql mysql 4096 2007-10-02 20:4...

abelaguilar

just thought of something:

in samba i'm sharing my opendental folder that will store all images. Does the mysql folder somewhere else need access via samba?

In other words do I need to share the mysql folder so that windows can access it via samba?

abelaguilar

ok removed and reinstalled mysql server. and its running again. I just don't know how to fix this sock error when I get it so I just reinstall. mysql is back up and running and I can see my database opendenta. again typing sudo chown -R mysql:mysql /var/lib/mysql/ does not allow me to connect. i thi...

abelaguilar

Bill: I get an error when using sudo service mysql restart. it says command not found.

abelaguilar

Bill : Had mysql running yesterday on the server. Turned off the computer. turned it on today and now ther service is not starting up. This is what kills me about linux. anyways, when I try to manually connect to mysql I get the typical mysqld.sock error. "ERROR 2002 (HY000) Can't connect to local m...

abelaguilar

yes got ssh running.

still having a file folder permission problem.

I did try your chown command but still open dental can connect to sql but then I get a file permission error.

I need to give any computer on the network full access to the database

any suggestions?

Thanks this is fun stuff

abelaguilar

ok here is what i've accomplished: I have mysql running. I backed up a sample database from windows using mysql admin and restored in mysql admin in ubuntu. I can see all my tables. samba is setup and I can access files and folders from windows. However, I cannot ssh into the linux box nor can I acc...

abelaguilar

thanks I will give it a try

abelaguilar

Can someone post detailed steps to installing and setting up mysql and mysql admin GUI for ubuntu? I will try sudo apt-get install mysql-admin I need to know how to create the database with the proper file permision changes to the folder. I have successfully setup file and folder sharing with window...

abelaguilar

I noticed when looking at the list of lab cases, open dental defaults the date to 01/01/001.

Is there any way to program this to default to todays date or at least a good pop up calendar instead of having to manually take the time to input the date range?

Thanks

abelaguilar

This is awesome. I'm a big linux believer, but what about other windows applications that are running on the workstations?

abelaguilar

I would recommend you give xcharge a call. Their tech people can help you and quickly solve this.

abelaguilar

I made the switch from softdent. No problem.

abelaguilar

Works Great!!! Automatically makes the entry into open dental. No problems once the setup was done correctly.

abelaguilar

OK here is the output of asterisk -vvvr [root@asterisk1 etc]# ztcfg -vvv Zaptel Configuration ====================== Channel map: Channel 01: FXS Kewlstart (Default) (Slaves: 01) Channel 02: FXS Kewlstart (Default) (Slaves: 02) Channel 03: FXS Kewlstart (Default) (Slaves: 03) Channel 04: FXS Kewlsta...

abelaguilar

sorry about my spelling. The scanner is Fuji scanner.

I'd like to learn what others are doing.

abelaguilar

Let me tell you what we do: WE have laminated all of our forms. Then we use eraseable market (thin point) and have them fill out all forms. Then scann into chart. Then run under water or wet wipe and re use. No paper to use. I learned this from another paperless office. Its works really nice. JUst m...

abelaguilar

Mike: I have made good progress. I modified the zapata.conf file and this allowed me to dial out. So, I can dial out from my polycom 501. Cannot receive yet. In free pbx I did notice that inbound routes is not configured. I think this might have something to do with this but not sure. I can only dia...

abelaguilar

Mike: Here is a copy of my post in trixbox forums: Hello all: I have a polycom 501 setup. trunks, extensions and outbound routes setup. HOwever, i cannot dial out. I get the " all circuits busy" recording. Here is the output of: asterisk -vvvr when I try to dial out: any help please?? [root@asterisk...

abelaguilar

Mike: I have a soft phone setup extension 260 and 1 polycom setup extension 250. I can dial each other but I get the answering machine stating "the person on extension 250 is unavailable, please leave a message" I can leave a message in either direction and retrieve voice mail, but the phones won't ...

abelaguilar

Mike:

Thanks for the tips. i'll get working on this again.

I was able to get a softphone and the polycoms to leave voice messages in the past.

By the way, what's the port I need to forward for remote access?

Talk to you soon.

abelaguilar

MIke: I've been trying to get my trix box off the grownnd with very little success. I've got a Rhino R4fxo for my 4 pstn lines going into the building. Its tough at home to get my polycom 501's to connect via my linksys wrt54g router. I've followed several online manuals and tutorials and still get ...

abelaguilar

Jordan:

Correct: now I haven't used it in open dental. but basically a window pops up with pre made buttons that have specific request and replys.

I'lll have to read how it works in open dental.

abelaguilar

Hello all: Wanted to tell you all about this little software we use in our office. Its called message pal and gives bluenote communicator a run for their money. For 10.00$ per computer you send setup custom buttons that allow you to send messages throught the computer network in the office. I have c...

abelaguilar

Jordan: I have to agree with you. asterisk takes allot of work to setup. I've had partial success setting up trixbox with Rhino R4FXO card and polycom 501 phones. Luckily these polycom phones can have their firmware update to use on my current pbx system Talkswitch which has lots of cool features. J...

abelaguilar

for anyone interested: To configure dymo label writter 400. do not use a parrallel printer port to connect your printer. We had an old trusty laser. if you do have this. move it to a non xcharge computer and network share the printer. also, in open dental change your printers to your network printer...

abelaguilar

Wow this is cool. i'll have to look into this.

ps. im almost up and running in my trixbox asterisk pbx system.

abelaguilar

Hello all just wanted to say that we got the dymo label writter 400 working.

Xcharge and their technical support helped me change some settings and it works really nice and smooth.

abelaguilar

NOt good so far.

We still haven't figured out how to get the dymo label printer to work. You need a thermal printer to print the CC receipt that the patient signs.

abelaguilar

Yes I am also waiting to purchase Suni sensors as soon as its ready for prime time.

abelaguilar

Wondering if 4.9 is really for prime time. I thought someone mentioned to hold off until an update to 4.9.

Thanks

abelaguilar

Wondering if its possible to block certain users from braking appointments.

With so many people using workstations, I've noticed appointments broken by mistake possibly becuase everyone is moving so fast.

I would like to limit this feature to our front desk staff.

abelaguilar

Great can't wait!! Any ideas how its done?

abelaguilar

Thanks for the reply. How do I integrate the jpg into the simple letters?

Thanks

abelaguilar

Anyone know if its possible to attach our office logo into forms and reports generated by open dental. Mainly forms that are printed for patients.

Thanks

abelaguilar

Yes glad we're back on board!!!

Open Dental Forum

Search found 88 matches

SQL username and password

Re: software backup to external drive

software backup to external drive

Re: opendental within vmware or virtualbox

opendental within vmware or virtualbox

Re: Open Dental Cluster (dual servers)!

Dual server

mysql question on a new server migration

procedure Icons

procedure report breakdown

Re: hygiene report

hygiene report

Double Sided Scanning

Re: popups

Re: popups

popups

New patient report

3cx.com pbx phone system

asterisk alternative

monthly production by provider

Tesia versus Emdeon

Incomplete PRocedure NOtes

Basic linux/samba question

Ubuntu and Linux

Lab Cases

Progress Report

messagepal.com

broken appointment icon

Business Logo