TeamCity service is started but cannot login from IDEA's TeamCity plugin

When I start my laptop and run IDEA, IDEA shows me a message that "Login fail" (http://www.geocities.com/t800t8/loginfail.png). But as I checked, the TeamCity Web Server was started. And after restarting the service manually (via Services window), I can login.

How can I "fix" the problem?

My laptop uses Windows XP Pro and Kaspersky Anti-Virus 7 (if it's related).

11 comments

I found that if I access TeamCity Web Server via browser, I have a 404 error (http://www.geocities.com/t800t8/404.png)

And C:\TeamCity\logs\stdout_[yyyymmdd].log contains some exceptions relate with Spring and MySQL.

Anybody have same problem?

0

Hello,

You probably did not put mysql driver into the TeamCity WEB-INF/lib folder:
http://www.jetbrains.net/confluence/display/TCD3/Installation#Installation-settingupMySql

--
Pavel Sher
Software Developer
JetBrains, Inc.
http://www.jetbrains.com
"Develop with pleasure!"



"t800t8" <no_reply@jetbrains.com> wrote in message
news:19065263.1197980756710.JavaMail.itn@is.intellij.net...
>I found that if I access TeamCity Web Server via browser, I have a 404
>error (http://www.geocities.com/t800t8/404.png)
>

And C:\TeamCity\logs\stdout_[yyyymmdd].log contains some exceptions relate
with Spring and MySQL.

>

Anybody have same problem?



0

Hello Pavel,

I put MySQL driver into TeamCity WEB-INF/lib folder.

I attached a log file here so you can check it (http://www.geocities.com/t800t8/stdout_20071218.log)

T.

0

Hello,

Is it a new installation? It seems that on first startup TeamCity failed to
create necessary tables, now it tries to do this again, but some tables are
already exist. I would suggest you to recreate database and then try to
start server again.

In the log you sent me I saw this message:
Caused by: java.sql.SQLException: Can't create/write to file 'C:\Program
Files\MySQL\MySQL Server 5.0\Data\#sql_190_0.MYI' (Errcode: 13)

Probably because of this error TeamCity failed to create database for the
first time. One of the possible reasons: insufficient access rights (if you
are starting TeamCity as service make sure user configured for this service
has necessary rights).

--
Pavel Sher
Software Developer
JetBrains, Inc.
http://www.jetbrains.com
"Develop with pleasure!"



"t800t8" <no_reply@jetbrains.com> wrote in message
news:3340675.1197984573556.JavaMail.itn@is.intellij.net...

Hello Pavel,

>

I put MySQL driver into TeamCity WEB-INF/lib folder.

>

I attached a log file here so you can check it
(http://www.geocities.com/t800t8/stdout_20071218.log)

>

T.



0

Hi Pavel,

Yes, it's new installation.

I've just tried to recreate database, everything was fine. TeamCity Web Server can start, I can create administration account. But after restart my laptop, same problem happens (web server can start but I cannot browse TeamCity home page and Idea's TeamCity plugin cannot login)

For the permission, I don't think so. 'Cause my laptop only has one user, and it is an administrator, of course.

And one more question, why after stopping and starting web server service manually everything works fine?

T.

Message was edited by:
t800t8

0

Hello,

How do you start TeamCity and MySQL database? Are there any errors after the
laptop restart in the MySQL logs?

--
Pavel Sher
Software Developer
JetBrains, Inc.
http://www.jetbrains.com
"Develop with pleasure!"



"t800t8" <no_reply@jetbrains.com> wrote in message
news:11873568.1197988698844.JavaMail.itn@is.intellij.net...

Hi Pavel,

>

Yes, it's new installation.

>

I've just tried to recreate database, everything was fine. TeamCity Web
Server can start, I can create administration account. But after restart
my laptop, same problem happens.

>

For the permission, I don't think so. 'Cause my laptop only has one user,
and it is an administrator, of course.

>

And one more question, why after stopping and starting web server service
everything works fine?

>

T.



0

Hello Pavel,

Both of them were setup to run as services.

Sorry, where or how can I find the MySQL logs? I didn't find any log file in MySQL folder.

And here is the list of tables in TeamCity's database

agent
agent_build_type_access
agent_sources_version
build_checkout_rules
build_data_storage
build_labels
build_queue
build_revisions
build_type_vcs_change
canceled_info
comments
compiler_output
deleted_build_types
downloaded_artifacts
duplicate_diff
duplicate_fragments
duplicate_results
duplicate_stats
failed_tests_output
fragments
granted_license
history
ignored_tests
inspection_data
inspection_diff
inspection_fixes
inspection_info
inspection_results
inspection_stats
light_history
paused_build_types
personal_vcs_changes
personal_vcs_history
project_files
remember_me
remote_run_build_types
run_configuration_policy
running
server
server_property
statistics
stats_publisher_state
tc_build_tags
test_info
test_names
user_blocks
user_notification_events
user_projects_order
user_projects_visibility
user_property
user_roles
user_watch_type
users
vcs_changes
vcs_history
vcs_root_versions

0

Hello,

Usually MySQL stores some logs right in the data directory: /data (file with .err extension). -- Pavel Sher Software Developer JetBrains, Inc. http://www.jetbrains.com "Develop with pleasure!" "t800t8" ]]> wrote in message
news:14383952.1197991866573.JavaMail.itn@is.intellij.net...

Hello Pavel,

>

Both of them were setup to run as services.

>

Sorry, where or how can I find the MySQL logs? I didn't find any log file
in MySQL folder.

>

And here is the list of tables in TeamCity's database

>

agent
agent_build_type_access
agent_sources_version
build_checkout_rules
build_data_storage
build_labels
build_queue
build_revisions
build_type_vcs_change
canceled_info
comments
compiler_output
deleted_build_types
downloaded_artifacts
duplicate_diff
duplicate_fragments
duplicate_results
duplicate_stats
failed_tests_output
fragments
granted_license
history
ignored_tests
inspection_data
inspection_diff
inspection_fixes
inspection_info
inspection_results
inspection_stats
light_history
paused_build_types
personal_vcs_changes
personal_vcs_history
project_files
remember_me
remote_run_build_types
run_configuration_policy
running
server
server_property
statistics
stats_publisher_state
tc_build_tags
test_info
test_names
user_blocks
user_notification_events
user_projects_order
user_projects_visibility
user_property
user_roles
user_watch_type
users
vcs_changes
vcs_history
vcs_root_versions



0

Hello,

At the moment I can only suggest you to check file system permissions.
Errcode 13 which I saw in SQLException in TeamCity logs means that MySQL
server does not have permissions to create or write file. I do not
understand why restart of TeamCity helps, but I think the problem is not
related to TeamCity. Probably TeamCity starts too early, when MySQL server
is not yet initialized.

Please also submit a JIRA issue and attach TeamCity logs produced after the
laptop restart.

--
Pavel Sher
Software Developer
JetBrains, Inc.
http://www.jetbrains.com
"Develop with pleasure!"



"t800t8" <no_reply@jetbrains.com> wrote in message
news:17416654.1197994896882.JavaMail.itn@is.intellij.net...

Hi Pavel,

>

I didn't find any errors in .err file
(http://www.geocities.com/t800t8/t800t8.err.txt)

>

T.



0

Hi Pavel,

Maybe the reason is TeamCity service starts too early, before MySQL server service starts. Today I tried to restart my laptop 3 times, only one time everything works fine and I don't need to restart TeamCity service manually. And also as I checked, in the stdout_20071219.log, it doesn't contain any errors relate with create/write as previous log file.

Anyway, here is JIRA: http://www.jetbrains.net/jira/browse/TW-4141

Regards

T.

0

Please sign in to leave a comment.