Problem with Open-Source Python with MySQL Program

**dm01** · 05-28-2009, 12:13 AM

I am having a small problem with an open-source veterinary management software. The compiled win32exe, linux tarball, and source code are available here: http://sourceforge.net/project/showf...kage_id=203713

The software is written in Python, and uses MySQL tables to store information. The problem is, somehow the default password was changed and I want to know the best way to: (a) delete the password so I can put in my own, or (b) re-set the default password.

I was able to use this software last night with no problems, this issue arose when I tried to open it this morning. I have posted on the project forums, but since the last reply from the project admin was a while ago, I am not hopeful. I have been bashing my head against the wall for most of the day, so any assistance is appreciated.

**jamiemac2005** · 05-28-2009, 04:09 AM

Hey, it runs of of your localhost's mySQL server, so the easiest way is just through a mysql console...

I went and ran the situation on my own pc:
- Opened Evette, went to Staff->Edit Users->Changed pass, closed.
- Opened CMD, i have mysql in my path variable so you'd have to find the full path to mysql:

Code:

   [path to mysql]/mysql.exe -u root

(this is if your mysql server's username is root and pass is blank (standard for this program))

- then in mysql the code goes something like:

Code:

mysql> use evette
   Database changed
mysql> UPDATE user SET Password="newPass" WHERE ID=1;
   Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

The new password must be 10 characters/less.

But that's the easiest way to go about it i think.

Cheers,
Jamey

**dm01** · 05-28-2009, 10:54 AM

Er, it spewed this back in my face:

Code:

Traceback (most recent call last):
  File "launch.py", line 165, in ButtonPressed
  File "launch.py", line 178, in LogIn
  File "db.pyc", line 155, in SendSQL
  File "MySQLdb\cursors.pyc", line 166, in execute
  File "MySQLdb\connections.pyc", line 35, in defaulterrorhandler
_mysql_exceptions.ProgrammingError: (1064, 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'newPass""\' at line 1')

Back to the drawing board I guess.

**jamiemac2005** · 05-28-2009, 11:00 AM

\'newPass""\'

What order were the quotes in when you input the sql? (that might have been the problem, but godknows). It should work.

Cheers,
Jamey

**dm01** · 05-28-2009, 06:36 PM

Now I've effed it. . . there doesn't seem to be any connection from Evette to the database, even though MySQL is running.

The "username" field is blank, and it won't accept the password anymore. I have no idea what happened, but I'm sure it's my fault :).

**jamiemac2005** · 05-28-2009, 06:42 PM

Haha, godknows, in mysql what does "show databases" return?... Can you not just re-install? ("drop database evette" then re-install that is, so that you don't have the same pw problem).

Cheers,
Jamey

**dm01** · 05-28-2009, 08:33 PM

Show databases does nothing.
drop database evette does nothing.

I think something's wrong, or else I'm being simple.

**jamiemac2005** · 05-29-2009, 12:43 AM

That sounds like your mysql server has killed itself, restart it(the service). Both should return an output whether they work or not.

**dm01** · 05-29-2009, 02:26 AM

Better this time. Instead of producing nothing, the stupid console gives me a ->, as if it wants more information.

**jamiemac2005** · 05-29-2009, 03:35 AM

throw a ";" at the end of it. multiline statements are ended in a semicolon =]

**dm01** · 05-29-2009, 10:33 AM

Er, right. I knew that.

Yay! It works now, I think. Some more editing of different tables may be necessary, but I think I can handle that now :).

Thank you very much!

**jamiemac2005** · 05-29-2009, 12:41 PM

Haha, glad it's sorted.

Cheers,
Jamey

05-28-2009, 12:13 AM	#1 (permalink)
dm01 Moderator: Design Join Date: Oct 2006 Location: Richmond, B.C.; Canada Posts: 1,422 OS: Windows XP [Version 5.1.2600] SP3 \| Ubuntu Jaunty Jackalope \| Windows 7 BETA My System	Problem with Open-Source Python with MySQL Program I am having a small problem with an open-source veterinary management software. The compiled win32exe, linux tarball, and source code are available here: http://sourceforge.net/project/showf...kage_id=203713 The software is written in Python, and uses MySQL tables to store information. The problem is, somehow the default password was changed and I want to know the best way to: (a) delete the password so I can put in my own, or (b) re-set the default password. I was able to use this software last night with no problems, this issue arose when I tried to open it this morning. I have posted on the project forums, but since the last reply from the project admin was a while ago, I am not hopeful. I have been bashing my head against the wall for most of the day, so any assistance is appreciated. __________________ Validate your Markup Validate your CSS Notepad++ Please use [html], [php], and [code] when posting code or markup. I do not help by Private Message or e-mail. If for some reason I have over-looked a reply to a thread that I have previously replied to, then send me a message. Last edited by dm01; 05-28-2009 at 12:14 AM. Reason: spleling

05-28-2009, 04:09 AM	#2 (permalink)
jamiemac2005 Design Team Member Join Date: Jul 2007 Location: Coventry, UK Posts: 1,874 OS: Vista, various linux distros	Re: Problem with Open-Source Python with MySQL Program Hey, it runs of of your localhost's mySQL server, so the easiest way is just through a mysql console... I went and ran the situation on my own pc: - Opened Evette, went to Staff->Edit Users->Changed pass, closed. - Opened CMD, i have mysql in my path variable so you'd have to find the full path to mysql: Code: [path to mysql]/mysql.exe -u root (this is if your mysql server's username is root and pass is blank (standard for this program)) - then in mysql the code goes something like: Code: mysql> use evette Database changed mysql> UPDATE user SET Password="newPass" WHERE ID=1; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 The new password must be 10 characters/less. But that's the easiest way to go about it i think. Cheers, Jamey __________________ Myspace Last edited by jamiemac2005; 05-28-2009 at 04:12 AM.

05-28-2009, 10:54 AM	#3 (permalink)
dm01 Moderator: Design Join Date: Oct 2006 Location: Richmond, B.C.; Canada Posts: 1,422 OS: Windows XP [Version 5.1.2600] SP3 \| Ubuntu Jaunty Jackalope \| Windows 7 BETA My System	Re: Problem with Open-Source Python with MySQL Program Er, it spewed this back in my face: Code: Traceback (most recent call last): File "launch.py", line 165, in ButtonPressed File "launch.py", line 178, in LogIn File "db.pyc", line 155, in SendSQL File "MySQLdb\cursors.pyc", line 166, in execute File "MySQLdb\connections.pyc", line 35, in defaulterrorhandler _mysql_exceptions.ProgrammingError: (1064, 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'newPass""\' at line 1') Back to the drawing board I guess. __________________ Validate your Markup Validate your CSS Notepad++ Please use [html], [php], and [code] when posting code or markup. I do not help by Private Message or e-mail. If for some reason I have over-looked a reply to a thread that I have previously replied to, then send me a message.

05-28-2009, 11:00 AM	#4 (permalink)
jamiemac2005 Design Team Member Join Date: Jul 2007 Location: Coventry, UK Posts: 1,874 OS: Vista, various linux distros	Re: Problem with Open-Source Python with MySQL Program \'newPass""\' What order were the quotes in when you input the sql? (that might have been the problem, but godknows). It should work. Cheers, Jamey __________________ Myspace

05-28-2009, 06:36 PM	#5 (permalink)
dm01 Moderator: Design Join Date: Oct 2006 Location: Richmond, B.C.; Canada Posts: 1,422 OS: Windows XP [Version 5.1.2600] SP3 \| Ubuntu Jaunty Jackalope \| Windows 7 BETA My System	Re: Problem with Open-Source Python with MySQL Program Now I've effed it. . . there doesn't seem to be any connection from Evette to the database, even though MySQL is running. The "username" field is blank, and it won't accept the password anymore. I have no idea what happened, but I'm sure it's my fault :). __________________ Validate your Markup Validate your CSS Notepad++ Please use [html], [php], and [code] when posting code or markup. I do not help by Private Message or e-mail. If for some reason I have over-looked a reply to a thread that I have previously replied to, then send me a message.

05-28-2009, 06:42 PM	#6 (permalink)
jamiemac2005 Design Team Member Join Date: Jul 2007 Location: Coventry, UK Posts: 1,874 OS: Vista, various linux distros	Re: Problem with Open-Source Python with MySQL Program Haha, godknows, in mysql what does "show databases" return?... Can you not just re-install? ("drop database evette" then re-install that is, so that you don't have the same pw problem). Cheers, Jamey __________________ Myspace

05-28-2009, 08:33 PM	#7 (permalink)
dm01 Moderator: Design Join Date: Oct 2006 Location: Richmond, B.C.; Canada Posts: 1,422 OS: Windows XP [Version 5.1.2600] SP3 \| Ubuntu Jaunty Jackalope \| Windows 7 BETA My System	Re: Problem with Open-Source Python with MySQL Program Show databases does nothing. drop database evette does nothing. I think something's wrong, or else I'm being simple. __________________ Validate your Markup Validate your CSS Notepad++ Please use [html], [php], and [code] when posting code or markup. I do not help by Private Message or e-mail. If for some reason I have over-looked a reply to a thread that I have previously replied to, then send me a message.

05-29-2009, 12:43 AM	#8 (permalink)
jamiemac2005 Design Team Member Join Date: Jul 2007 Location: Coventry, UK Posts: 1,874 OS: Vista, various linux distros	Re: Problem with Open-Source Python with MySQL Program That sounds like your mysql server has killed itself, restart it(the service). Both should return an output whether they work or not. __________________ Myspace

05-29-2009, 02:26 AM	#9 (permalink)
dm01 Moderator: Design Join Date: Oct 2006 Location: Richmond, B.C.; Canada Posts: 1,422 OS: Windows XP [Version 5.1.2600] SP3 \| Ubuntu Jaunty Jackalope \| Windows 7 BETA My System	Re: Problem with Open-Source Python with MySQL Program Better this time. Instead of producing nothing, the stupid console gives me a ->, as if it wants more information. __________________ Validate your Markup Validate your CSS Notepad++ Please use [html], [php], and [code] when posting code or markup. I do not help by Private Message or e-mail. If for some reason I have over-looked a reply to a thread that I have previously replied to, then send me a message.

05-29-2009, 03:35 AM	#10 (permalink)
jamiemac2005 Design Team Member Join Date: Jul 2007 Location: Coventry, UK Posts: 1,874 OS: Vista, various linux distros	Re: Problem with Open-Source Python with MySQL Program throw a ";" at the end of it. multiline statements are ended in a semicolon =] __________________ Myspace

05-29-2009, 10:33 AM	#11 (permalink)
dm01 Moderator: Design Join Date: Oct 2006 Location: Richmond, B.C.; Canada Posts: 1,422 OS: Windows XP [Version 5.1.2600] SP3 \| Ubuntu Jaunty Jackalope \| Windows 7 BETA My System	Re: Problem with Open-Source Python with MySQL Program Er, right. I knew that. Yay! It works now, I think. Some more editing of different tables may be necessary, but I think I can handle that now :). Thank you very much! __________________ Validate your Markup Validate your CSS Notepad++ Please use [html], [php], and [code] when posting code or markup. I do not help by Private Message or e-mail. If for some reason I have over-looked a reply to a thread that I have previously replied to, then send me a message.

05-29-2009, 12:41 PM	#12 (permalink)
jamiemac2005 Design Team Member Join Date: Jul 2007 Location: Coventry, UK Posts: 1,874 OS: Vista, various linux distros	Re: Problem with Open-Source Python with MySQL Program Haha, glad it's sorted. Cheers, Jamey __________________ Myspace