Main issue is that I do not know what steps are needed and how to check if the steps have veen compleated ok.
I have windows xp.
I had mysql installed ( i removed it during one of the retry iterations)
I have postgres installed and I would prefer to use it.
I have now installed python 2.6 (it might need it?)
I have downloaded and run fpdbenvinstall
I have downloaded and installed fpdb-1.0_alpha9
When I run the fpdb.py I get a brief dos windown telling me that graphics failed to load. please install mumby ant matplotlib if you wish to use craphics.
uuuhh.. ?? where am I and where should I go from here?
When I open pgadminIII I see database server up and running on localholst. I do not see any databases thou I might look at wrong place.
I have not touched any of the config files manualy.
So help on install needed.
to wish list.. list of things/steps needed and how to verify that this thing/step is as it should be.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
There is a new version of fpdbenvinstall. The 0.2 version is available and it does not try to install mysql. If you have already run it once, you should have everything you need installed. The installer will install python 2.5 and might make a mess of your python 2.6. fpdb has never been tested on python 2.6--it _should_ run OK.
The message you saw about numpy and matplotlib are only warnings. The graphing routines will not work unless those libraries are installed.
If you have previously run the environment installer, then you should have pygtk, etc installed and should be good to go after you set up the postgres database.
Please let me know if you have problems with that postgres procedure or afterwords.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I figured Out I have issues with postgres
I had tested out oterh trackers and installed it earlier.
I unistalled it (went ok unlike mysql which did not have uninstal/ remove)
when I tried to reinstal postgres I got error where it asked postgres password. .. hmmm...
Checking user accounts under controlpanel > users (using my admin account. the only account in my home computer). I only see the account I use and inactive guest account. No postgres.
Yet the postgress installer refuses to create account because it says there is one. and it keeps on demanding password. I have tried the likely password canditates without success.
Checking internet I noted that there is related windows issue. Issue is under "known issue" status in MS so I
indicates that this is know issue. I tried workaround and got stuck at step 3. I get the MMC running. There just is nothing to expand. I can see nothing relating to user accounts or a way to get to step 4.
I am filled with despair, discust, loathing and envy regarding M$. Please inset apropiate rant here.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I can't see user postgres in users
I can't create user postgres - user exists
I can create user test
I can change user test into user postgres (interesting...)
after reboot I can log on as postgres
I still can't install postgres because I do not have the password. (At this point I seem to have two postgres users... hmmm... Ghost in a shell?)
user postgres deleted and only the ghost user postgres remains.
Total whipeout and reinstal of windows might solve this issue.. I really whant to avoid this.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have the postgress up and running. Info for others who might find this therad.
1) After getting rid of the postgres user ghost I tried to install postgres as a program. I also moved from one click installation packet to the other one. This is a key poit!!
Plan was to start db before starting tracker. This way I figured out I could save cpu & memory while I did not require postgres.
Postgres can't be run by user with admin priviledges. I found this out after few reinstal cycles and only when I entered command prompt to run postgres. windows might have written error messages somewhere but I did not see any.
Regarding user control in windows I felt that the lost cpu & memory is a small price to pay for protecting my sanity. (Yes.. I do have issues with windows design and implementation)
So I got the postgres up and running.
I connected to the postgres service.
I created fpdb database.
I edited the HUD_config.xml to refer to database correctly.
Now I feel that next step would be to run fpdb.pv ? as I run it I get parse errors regarding HUD_config.xml
the content of HUD-error.txt is:
Traceback (most recent call last):
File "C:\src\fpdb\pyfpdb\Configuration.py", line 226, in __init__
doc = xml.dom.minidom.parse(file)
File "C:\Python25\lib\xml\dom\minidom.py", line 1913, in parse
return expatbuilder.parse(file)
File "C:\Python25\lib\xml\dom\expatbuilder.py", line 924, in parse
result = builder.parseFile(fp)
File "C:\Python25\lib\xml\dom\expatbuilder.py", line 207, in parseFile
parser.Parse(buffer, 0)
ExpatError: not well-formed (invalid token): line 194, column 42
Once again thank you guys for the pointers. My posts are bit long. I do this so that I give you as much relevant info as I car regarding the problem. Second reason is to provide support for people who encounter similar issues.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I go the config file error sorted out. As I look at it on a web browser its format is intact. Clicking fpdb.py generates fpdb-error-log.txt (note that there is no hud-error.log anymore) which contains:
Traceback (most recent call last):
File "C:\src\fpdb\pyfpdb\fpdb.py", line 448, in <module>
me = fpdb()
File "C:\src\fpdb\pyfpdb\fpdb.py", line 361, in __init__
self.load_profile()
File "C:\src\fpdb\pyfpdb\fpdb.py", line 266, in load_profile
self.db.connect(self.settings['db-backend'], self.settings['db-host'], self.settings['db-databaseName'], self.settings['db-user'], self.settings['db-password'])
File "C:\src\fpdb\pyfpdb\fpdb_db.py", line 46, in connect
self.db = psycopg2.connect(host = host, user = user, password = password, database = database)
psycopg2.OperationalError: FATAL: database "fpdb" does not exist
For some reason the fpdb I created with pgadmin III did work. I created a new fpdb from psql commandline [create database fpdb owner postgres;] postgres is a poor choise for db owner. at this poit I will live with it.
Now pgadmin shows two fpdb s. It will not allow me to delete the forst one saying someone is using it.
now the fpdb.py runs, warns me that tablespaces are a mess .. I used the recreate command in tools.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
sounds like you have corrupt postgres tables and maybe a dead process locking one of your databases. I think you need to get rid of that first fpdb database--actually get rid of both of them and make a new one. Maybe you can get rid of the first one by stopping and restarting postgres. (Right click on "My Computer", select manage, services, find postgresql--then stop and start.) Then delete all dbs name fpdb, create a new one and restart fpdb.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello. Cant get the software to work.
Main issue is that I do not know what steps are needed and how to check if the steps have veen compleated ok.
I have windows xp.
I had mysql installed ( i removed it during one of the retry iterations)
I have postgres installed and I would prefer to use it.
I have now installed python 2.6 (it might need it?)
I have downloaded and run fpdbenvinstall
I have downloaded and installed fpdb-1.0_alpha9
When I run the fpdb.py I get a brief dos windown telling me that graphics failed to load. please install mumby ant matplotlib if you wish to use craphics.
uuuhh.. ?? where am I and where should I go from here?
When I open pgadminIII I see database server up and running on localholst. I do not see any databases thou I might look at wrong place.
I have not touched any of the config files manualy.
So help on install needed.
to wish list.. list of things/steps needed and how to verify that this thing/step is as it should be.
Hi and welcome--
There is a new version of fpdbenvinstall. The 0.2 version is available and it does not try to install mysql. If you have already run it once, you should have everything you need installed. The installer will install python 2.5 and might make a mess of your python 2.6. fpdb has never been tested on python 2.6--it _should_ run OK.
The message you saw about numpy and matplotlib are only warnings. The graphing routines will not work unless those libraries are installed.
I wrote a very quick and dirtly postgres set up how to here:
http://forumserver.twoplustwo.com/showthread.php?p=7400963#poststop
If you have previously run the environment installer, then you should have pygtk, etc installed and should be good to go after you set up the postgres database.
Please let me know if you have problems with that postgres procedure or afterwords.
I figured Out I have issues with postgres
I had tested out oterh trackers and installed it earlier.
I unistalled it (went ok unlike mysql which did not have uninstal/ remove)
when I tried to reinstal postgres I got error where it asked postgres password. .. hmmm...
Checking user accounts under controlpanel > users (using my admin account. the only account in my home computer). I only see the account I use and inactive guest account. No postgres.
Yet the postgress installer refuses to create account because it says there is one. and it keeps on demanding password. I have tried the likely password canditates without success.
Checking internet I noted that there is related windows issue. Issue is under "known issue" status in MS so I
http://archives.postgresql.org/pgsql-cygwin/2005-03/msg00009.php
Describes similar (=same) issue and points to following workaroun:
http://support.microsoft.com/default.aspx?scid=kb;en-us;298252
indicates that this is know issue. I tried workaround and got stuck at step 3. I get the MMC running. There just is nothing to expand. I can see nothing relating to user accounts or a way to get to step 4.
I am filled with despair, discust, loathing and envy regarding M$. Please inset apropiate rant here.
The default postgres password is "" and the default user is postgres.
If PT3 installed postgres, they have posted the default password they use in the monster thread in the software forum on 2+2
I can't see user postgres in users
I can't create user postgres - user exists
I can create user test
I can change user test into user postgres (interesting...)
after reboot I can log on as postgres
I still can't install postgres because I do not have the password. (At this point I seem to have two postgres users... hmmm... Ghost in a shell?)
user postgres deleted and only the ghost user postgres remains.
Total whipeout and reinstal of windows might solve this issue.. I really whant to avoid this.
postgres password issue solved:
http://forumserver.twoplustwo.com/45/software/postgresql-109615/
Then, quoted from PTPat on the PT forums.
Quote:
From the Start menu select Run. Type COMMAND to open a DOS window. Type the following:
net user postgres /delete
and hit ENTER. Then type EXIT to close the DOS window.
When you install, you should only be entering the password, do not change the user name or the domain name.
Thank you for the help. installing postgres now
For the record, the default password for that PT3 uses for postgres is "dbpass"
ok, status report.
I have the postgress up and running. Info for others who might find this therad.
1) After getting rid of the postgres user ghost I tried to install postgres as a program. I also moved from one click installation packet to the other one. This is a key poit!!
Plan was to start db before starting tracker. This way I figured out I could save cpu & memory while I did not require postgres.
Postgres can't be run by user with admin priviledges. I found this out after few reinstal cycles and only when I entered command prompt to run postgres. windows might have written error messages somewhere but I did not see any.
Regarding user control in windows I felt that the lost cpu & memory is a small price to pay for protecting my sanity. (Yes.. I do have issues with windows design and implementation)
So I got the postgres up and running.
I connected to the postgres service.
I created fpdb database.
I edited the HUD_config.xml to refer to database correctly.
Now I feel that next step would be to run fpdb.pv ? as I run it I get parse errors regarding HUD_config.xml
the content of HUD-error.txt is:
Traceback (most recent call last):
File "C:\src\fpdb\pyfpdb\Configuration.py", line 226, in __init__
doc = xml.dom.minidom.parse(file)
File "C:\Python25\lib\xml\dom\minidom.py", line 1913, in parse
return expatbuilder.parse(file)
File "C:\Python25\lib\xml\dom\expatbuilder.py", line 924, in parse
result = builder.parseFile(fp)
File "C:\Python25\lib\xml\dom\expatbuilder.py", line 207, in parseFile
parser.Parse(buffer, 0)
ExpatError: not well-formed (invalid token): line 194, column 42
Once again thank you guys for the pointers. My posts are bit long. I do this so that I give you as much relevant info as I car regarding the problem. Second reason is to provide support for people who encounter similar issues.
This part of the error message:
ExpatError: not well-formed (invalid token): line 194, column 42
indicates that you've made a small error editing the config file. Line 194 in the example config that went out in alpha9 is this:
<database db_name="fpdb" db_server="mysql" db_ip="localhost" db_user="fpdb" db_pass="YOUR MYSQL PASSWORD" db_type="fpdb"> </database>
Compare your database line with this one--look for unmatched quotes, etc.
You can see what that line looks like in context here: http://trac-git.assembla.com/fpdb/browser/pyfpdb/HUD_config.xml.example
You nearly have it!
Yes.. getting sooooo close.. yet soooo far away.
I go the config file error sorted out. As I look at it on a web browser its format is intact. Clicking fpdb.py generates fpdb-error-log.txt (note that there is no hud-error.log anymore) which contains:
Traceback (most recent call last):
File "C:\src\fpdb\pyfpdb\fpdb.py", line 448, in <module>
me = fpdb()
File "C:\src\fpdb\pyfpdb\fpdb.py", line 361, in __init__
self.load_profile()
File "C:\src\fpdb\pyfpdb\fpdb.py", line 266, in load_profile
self.db.connect(self.settings['db-backend'], self.settings['db-host'], self.settings['db-databaseName'], self.settings['db-user'], self.settings['db-password'])
File "C:\src\fpdb\pyfpdb\fpdb_db.py", line 46, in connect
self.db = psycopg2.connect(host = host, user = user, password = password, database = database)
psycopg2.OperationalError: FATAL: database "fpdb" does not exist
For some reason the fpdb I created with pgadmin III did work. I created a new fpdb from psql commandline [create database fpdb owner postgres;] postgres is a poor choise for db owner. at this poit I will live with it.
Now pgadmin shows two fpdb s. It will not allow me to delete the forst one saying someone is using it.
now the fpdb.py runs, warns me that tablespaces are a mess .. I used the recreate command in tools.
sounds like you have corrupt postgres tables and maybe a dead process locking one of your databases. I think you need to get rid of that first fpdb database--actually get rid of both of them and make a new one. Maybe you can get rid of the first one by stopping and restarting postgres. (Right click on "My Computer", select manage, services, find postgresql--then stop and start.) Then delete all dbs name fpdb, create a new one and restart fpdb.