[Owasp-pantera] Error message when choosing "Project Management"

list at roseslabs.com list at roseslabs.com
Tue Dec 5 07:06:38 EST 2006


Great

Now you need to create the table :) and you should be ok...

SRF

> You got it!
> Error 1146 <42S02> Table 'panteradb.project_t' down't exist
> But I have 6 Tables inside panteradb
>
> Thanks mate
>
> On 12/5/06, list at roseslabs.com <list at roseslabs.com> wrote:
>> Looks to me that panteradb tables are not been created.
>>
>> Try these:
>>
>> - log onto your mysql using mysql.exe
>> - switch to panteradb
>>   mysql> use panteradb;
>> - execute the following cmd to get all tables:
>>   mysql> show tables;
>> - execute "desc" cmd to get colums from project table:
>>   mysql> desc project_t;
>>
>> If you get an error in any of theses means that the panteradb database
>> has
>> not been created properly.
>>
>> Are you using MySQL 5.0 ????
>>
>> Simon Roses Femerling
>>
>> > Hi Simon,
>> >
>> > I have just tried your method, but it still comes out
>> > The following is the console message when I just started Pantera, then
>> > choose "Project Management" directly:
>> >
>> >
>> > C:\Pantera_Release>rem Runme.bat for Pantera - Web Assessment Studio
>> (WAS)
>> >
>> > C:\Pantera_Release>PATH=C:\Program Files\MySQL\MySQL Server
>> > 5.0\bin\mysqld-nt\
>> >
>> > C:\Pantera_Release>echo "Running Win32 Pantera"
>> > "Running Win32 Pantera"
>> >
>> > C:\Pantera_Release>c:\python24\python pantera.py
>> >>>> Running Pantera - Web Assessment Studio (WAS) V 0.1.1
>> >>>> Roses Labs Innovations (RL+I)
>> >>>> http://www.roseslabs.com
>> >
>> >
>> > [Tue Dec 05 17:54:34 2006] : >>> Pantera UI V 0.2.1 Started
>> >
>> > Exception in thread Thread-2:
>> > Traceback (most recent call last):
>> >   File "C:\Python24\lib\threading.py", line 442, in __bootstrap
>> >     self.run()
>> >   File "pantera.py", line 1302, in run
>> >     response = self.sendRequest(myheader,mybody)
>> >   File "pantera.py", line 1559, in sendRequest
>> >     (response,serverheader,serverbody)=self.sendRequestRaw(myheader,mybody)
>> >   File "pantera.py", line 1712, in sendRequestRaw
>> >     return (self.myUI.handleRequest(myheader,mybody),None,None)
>> >   File "C:\Pantera_Release\panteraUI.py", line 842, in handleRequest
>> >     return self.addHeader(self.ProjectHTMLPage())
>> >   File "C:\Pantera_Release\panteraUI.py", line 3042, in
>> ProjectHTMLPage
>> >     str_page += "%s" % panterautils.printFormSelectMenuID("Select
>> > Project:","do_
>> > project",r,1)
>> >   File "C:\Pantera_Release\panterautils.py", line 716, in
>> > printFormSelectMenuID
>> >     for k,v in dict:
>> > TypeError: iteration over non-sequence
>> >
>> > At the same time, I ran MySQL.exe (the command line mode),
>> > SQLAdministrator.exe (the UI of MySQL) and login to both of them.
>> >
>> > Just during the import of pantera_sql_create.script.txt, there are
>> > some errors (For example: Script line: 217    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 '--GRANT
>> > INSERT,SELECT,UPDATE,DELETE ON extensions_t TO "panteradb"' at line 1
>> > )
>> >
>> > But I think these are only talking about those annotation format, note
>> > related to the creation of Database Tables....
>> >
>> > Sorry for that...too many problems
>> >
>> > William
>> > On 12/5/06, list at roseslabs.com <list at roseslabs.com> wrote:
>> >>
>> >> Try this:
>> >>
>> >> - delete the "SessionData" directory.
>> >> - run pantera_sql_create.script.txt to re-create database tables. Its
>> >> described in the documentation.
>> >>
>> >> Let me know if this helps...
>> >>
>> >> Simon Roses Femerling
>> >>
>> >> > Hi,
>> >> >
>> >> > Thanks very much for your prompt reply again, here is the entire
>> >> > message from console:
>> >> >
>> >> >
>> >> > project",r,1)
>> >> >   File "C:\Pantera_Release\panterautils.py", line 716, in
>> >> > printFormSelectMenuID
>> >> >     for k,v in dict:
>> >> > TypeError: iteration over non-sequence
>> >> >
>> >> > Exception in thread Thread-3:
>> >> > Traceback (most recent call last):
>> >> >   File "C:\Python24\lib\threading.py", line 442, in __bootstrap
>> >> >     self.run()
>> >> >   File "pantera.py", line 1302, in run
>> >> >     response = self.sendRequest(myheader,mybody)
>> >> >   File "pantera.py", line 1559, in sendRequest
>> >> >     (response,serverheader,serverbody)=self.sendRequestRaw(myheader,mybody)
>> >> >   File "pantera.py", line 1712, in sendRequestRaw
>> >> >     return (self.myUI.handleRequest(myheader,mybody),None,None)
>> >> >   File "C:\Pantera_Release\panteraUI.py", line 842, in
>> handleRequest
>> >> >     return self.addHeader(self.ProjectHTMLPage())
>> >> >   File "C:\Pantera_Release\panteraUI.py", line 3042, in
>> >> ProjectHTMLPage
>> >> >     str_page += "%s" % panterautils.printFormSelectMenuID("Select
>> >> > Project:","do_
>> >> > project",r,1)
>> >> >   File "C:\Pantera_Release\panterautils.py", line 716, in
>> >> > printFormSelectMenuID
>> >> >     for k,v in dict:
>> >> > TypeError: iteration over non-sequence
>> >> >
>> >> > I did not set any user in MySQL, using root as login, and also set
>> >> > inside the config xml files. MySQL host is localhost.
>> >> >
>> >> > Thanks and regards
>> >> > William
>> >> >
>> >> > On 12/5/06, list at roseslabs.com <list at roseslabs.com> wrote:
>> >> >> Hi,
>> >> >>
>> >> >> I assume you can use mysql.exe and mysqladmin.exe fine...
>> >> >>
>> >> >> Can you send me the entire console error, please.
>> >> >>
>> >> >> Sincerely,
>> >> >>
>> >> >> Simon Roses Femerling
>> >> >>
>> >> >> > Hi all
>> >> >> >
>> >> >> > Thank you Simon and Daniel for your prompt reply. The progress
>> >> seems
>> >> >> > to be moving forward. I found that I have missed out the .xml
>> and
>> >> the
>> >> >> > username password fields :P
>> >> >> >
>> >> >> > However, I found that when I continue to press "Project
>> >> management",
>> >> >> > the page load for a long time, then error message of "pages not
>> >> found"
>> >> >> > was on Internet Explorer, and inside the  OWASP command windows,
>> a
>> >> >> > sentense exist:
>> >> >> > TypeError: iteration over non-sequence
>> >> >> >
>> >> >> > I have ran mysql.exe and mysqlAdministrator.exe as you
>> recommended.
>> >> I
>> >> >> > think this should be something related to database
>> problem....but I
>> >> >> > don;t have any idea....:-(
>> >> >> >
>> >> >> > Thanks in advance
>> >> >> > _______________________________________________
>> >> >> > Owasp-pantera mailing list
>> >> >> > Owasp-pantera at lists.owasp.org
>> >> >> > http://lists.owasp.org/mailman/listinfo/owasp-pantera
>> >> >> >
>> >> >>
>> >> >>
>> >> >> _______________________________________________
>> >> >> Owasp-pantera mailing list
>> >> >> Owasp-pantera at lists.owasp.org
>> >> >> http://lists.owasp.org/mailman/listinfo/owasp-pantera
>> >> >>
>> >> >
>> >>
>> >>
>> >> _______________________________________________
>> >> Owasp-pantera mailing list
>> >> Owasp-pantera at lists.owasp.org
>> >> http://lists.owasp.org/mailman/listinfo/owasp-pantera
>> >>
>> >
>>
>>
>>
>




More information about the Owasp-pantera mailing list