Forums / Install & configuration / Manual database creation

Manual database creation

Author Message

Mark Stevenson

Tuesday 18 November 2003 12:45:21 am

Having tried to run through the wizard setup and it constantly timing out after entering the database details. I thought I'd do the manual setup as I'm fortunate enough to have telnet access to my site.

I configured site.ini and i18n.ini as per the manual configuration docs. But am I missing something or are there no instructions on how to manually run the SQL to create all the datbase tables!

I now get ...

kernel (50)
No database connection could be made, the system might not behave properly.

because theres nothing in the database!

Dariusz Wlodarczyk

Tuesday 18 November 2003 1:16:56 am

I think than you must create the database manualy and load kernel_schema.sql and clean_data.sql from kernel/sql/mysql or kernel/sql/postgresql (depending on your database type).

Mark Stevenson

Tuesday 18 November 2003 2:13:34 am

Thank you, that has certainly populated the database. I still get the same error when I go to the default page though?

Mark Stevenson

Tuesday 18 November 2003 4:55:15 am

Can anyone help.

I've done a manual installation into the root of my domain, and run kernel_schema.sql and cleandata.sql for MySQL. I can see that the database is populated.

I've uploaded settings/override/site.ini.append.php and I'm sure that the database settings for account/passwd are correct.

When I go to my front page I see the login dialogure boxes but above them it says....

kernel (50)
No database connection could be made, the system might not behave properly.

I've tried to login regardless with admin/publish (is that the default passwd?) but Iget "Could not login"

Mark Stevenson

Thursday 20 November 2003 7:18:52 am

I resolved this by re-doing the manual installation from scratch. I think it must have been a permission problem.

eZ debug

Timing: Jan 19 2025 03:28:48
Script start
Timing: Jan 19 2025 03:28:48
Module start 'content'
Timing: Jan 19 2025 03:28:48
Module end 'content'
Timing: Jan 19 2025 03:28:48
Script end

Main resources:

Total runtime0.1754 sec
Peak memory usage4,096.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0054 588.9766180.8281
Module start 'content' 0.00540.0067 769.804797.8984
Module end 'content' 0.01210.1633 867.7031526.5547
Script end 0.1753  1,394.2578 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00382.1412200.0002
Check MTime0.00140.8025200.0001
Mysql Total
Database connection0.00070.400810.0007
Mysqli_queries0.127872.82711410.0009
Looping result0.00150.83831390.0000
Template Total0.162992.910.1629
Template load0.00100.563210.0010
Template processing0.161992.299010.1619
Override
Cache load0.00080.436510.0008
Sytem overhead
Fetch class attribute can translate value0.00080.469110.0008
XML
Image XML parsing0.00030.162410.0003
General
dbfile0.00301.7343200.0002
String conversion0.00000.002430.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs