search

SanDiegoBeck / pampa-j

Automatically exported from code.google.com/p/pampa-j
0 stars 0 forks source link

pampa1.0 mysqld isnt started #1

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
after first execute only apache starts. mysqld isnt working. after first 
manual attempt to start:
D:\web\PAMPA\mysql.32\bin>mysqld.exe
090126 16:09:17 [Warning] Can't create test file 
D:\web\PAMPA\mysql.32\data\esw2
14.lower-test
090126 16:09:17 [Warning] Can't create test file 
D:\web\PAMPA\mysql.32\data\esw2
14.lower-test
mysqld.exe: Can't change dir to 'D:\web\PAMPA\mysql.32\data\' (Errcode: 2)
090126 16:09:17 [ERROR] Aborting

090126 16:09:17 [Note] mysqld.exe: Shutdown complete

absent folder are created, second attempt to start mysqld. in 
data\esw214.err  writed next lines:

mysqld.exe: Table 'mysql.plugin' doesn't exist
090126 16:16:08 [ERROR] Can't open the mysql.plugin table. Please run 
mysql_upgrade to create it.
InnoDB: Log scan progressed past the checkpoint lsn 0 39548
090126 16:16:09  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 46409
090126 16:16:09  InnoDB: Starting an apply batch of log records to the 
database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 
20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 
45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 
70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 
95 96 97 98 99 
InnoDB: Apply batch completed
090126 16:16:10  InnoDB: Started; log sequence number 0 46409
090126 16:16:10 [ERROR] Fatal error: Can't open and lock privilege tables: 
Table 'mysql.host' doesn't exist

Original issue reported on code.google.com by vial...@gmail.com on 26 Jan 2009 at 2:16

GoogleCodeExporter commented 9 years ago 
Please try version 1.0b and tell me if the problem persist.
More details about your system version and PAMPA chose folder could help as 
well.
Thank you for this report.

Original comment by andrea.g...@gmail.com on 26 Jan 2009 at 10:05

GoogleCodeExporter commented 9 years ago 
I tried version 1.0c under win XP sp2 and problem is fixed, all works fine. but 
under
windows 7 similar problem is still here. Apache works fine, but mysqld isnt 
started.
i tried to start mysqld under Administrator with disabled UAC. First error - 
folder
"data" isnt exists. second error:

d:\pampa\PAMPA\mysql.32\bin\mysqld: Table 'mysql.plugin' doesn't exist
090127 21:06:41 [ERROR] Can't open the mysql.plugin table. Please run 
mysql_upgrade
to create it.
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
090127 21:06:41  InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
090127 21:06:42  InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
090127 21:06:42  InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
090127 21:06:43  InnoDB: Started; log sequence number 0 0
090127 21:06:43 [ERROR] Fatal error: Can't open and lock privilege tables: Table
'mysql.host' doesn't exist

Original comment by vial...@gmail.com on 27 Jan 2009 at 7:10

GoogleCodeExporter commented 9 years ago 
I cannot test Windows Seven so far ... I am sorry, but with a beta system that I
cannot test, it is really difficult to find a solution.
I wonder if there is anything in MySQL forum abut Windows 7 ... I leave this 
request
open waiting for some reply, otherwise I will close until the day I can test W$ 
7

Original comment by andrea.g...@gmail.com on 27 Jan 2009 at 10:34

GoogleCodeExporter commented 9 years ago 
changed priority

Original comment by andrea.g...@gmail.com on 27 Jan 2009 at 10:35

GoogleCodeExporter commented 9 years ago 
Exactly the same problem under windows Vista SP1. errlog file:
mysqld.exe: Table 'mysql.plugin' doesn't exist
090128 10:46:45 [ERROR] Can't open the mysql.plugin table. Please run 
mysql_upgrade 
to create it.
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
090128 10:46:46  InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
090128 10:46:48  InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
090128 10:46:49  InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
090128 10:46:55  InnoDB: Started; log sequence number 0 0
090128 10:46:55 [ERROR] Fatal error: Can't open and lock privilege tables: 
Table 
'mysql.host' doesn't exist

Original comment by vial...@gmail.com on 28 Jan 2009 at 8:54

GoogleCodeExporter commented 9 years ago 
can you tell me if everything is ok disabling InnoDb in pampa.ini ? Cheers

Original comment by andrea.g...@gmail.com on 28 Jan 2009 at 10:48

GoogleCodeExporter commented 9 years ago

Original comment by andrea.g...@gmail.com on 28 Jan 2009 at 10:49

GoogleCodeExporter commented 9 years ago

Original comment by andrea.g...@gmail.com on 28 Jan 2009 at 10:49

GoogleCodeExporter commented 9 years ago

Original comment by andrea.g...@gmail.com on 28 Jan 2009 at 10:49

GoogleCodeExporter commented 9 years ago 
Same issue, Win Vista SP1
InnoDB enabled or disabled, no difference

090703 18:01:34 [Warning] Can't create test file
D:\PAMPA\mysql.32\data\computername.lower-test
090703 18:01:34 [Warning] Can't create test file
D:\PAMPA\mysql.32\data\computername.lower-test
mysqld.exe: Can't change dir to 'D:\PAMPA\mysql.32\data\' (Errcode: 2)
090703 18:01:34 [ERROR] Aborting

090703 18:01:34 [Note] mysqld.exe: Shutdown complete

Original comment by olla.mai...@gmail.com on 3 Jul 2009 at 4:16

GoogleCodeExporter commented 9 years ago 
in windows 7 it seems to have problem with empty password...
there is a way to reset the password to default or change it?

Original comment by pugiam...@gmail.com on 26 Oct 2009 at 9:02

GoogleCodeExporter commented 9 years ago 
no problem with Vista

Original comment by pugiam...@gmail.com on 26 Oct 2009 at 9:05

GoogleCodeExporter commented 9 years ago 
On WINDOWS 7 same issue....MYSQL doesent start !
Same error....
[Can't create test file]
[Can't change dir...(err 2) ] 

Is there a way ti fix it ?

Original comment by gabriele...@gmail.com on 7 Jan 2010 at 9:45

GoogleCodeExporter commented 9 years ago 
Same problem now - windows 7 and windows vista.  Anyone have a fix?  This is
preventing us from using Pampa.

100331 15:44:32 [Note] Plugin 'InnoDB' disabled by command line option
100331 15:44:32 [Note] Event Scheduler: Loaded 0 events
100331 15:44:32 [Note] PAMPA\mysql.32\bin\mysqld.exe: ready for connections.
Version: '5.1.30-community'  socket: ''  port: 3307  MySQL Community Server 
(GPL)
100331 15:49:09 [Note] Plugin 'InnoDB' disabled by command line option
Can't start server: Bind on TCP/IP port: No such file or directory
100331 15:49:09 [ERROR] Do you already have another mysqld server running on 
port: 3307 ?
100331 15:49:09 [ERROR] Aborting

100331 15:49:09 [Note] PAMPA\mysql.32\bin\mysqld.exe: Shutdown complete

100331 15:49:11 [Note] Plugin 'InnoDB' disabled by command line option
Can't start server: Bind on TCP/IP port: No such file or directory
100331 15:49:11 [ERROR] Do you already have another mysqld server running on 
port: 3307 ?
100331 15:49:11 [ERROR] Aborting

100331 15:49:11 [Note] PAMPA\mysql.32\bin\mysqld.exe: Shutdown complete

100331 15:49:13 [Note] Plugin 'InnoDB' disabled by command line option
Can't start server: Bind on TCP/IP port: No such file or directory
100331 15:49:13 [ERROR] Do you already have another mysqld server running on 
port: 3307 ?
100331 15:49:13 [ERROR] Aborting

100331 15:49:13 [Note] PAMPA\mysql.32\bin\mysqld.exe: Shutdown complete

Original comment by jdgc...@gmail.com on 31 Mar 2010 at 9:55