db.php file doesnt exist

[ajinkyagadewar]

Hello,

Is this repository working fine? DB.php file is missing in protected folder. Also, what is the password for admin?

[alikin11]

is this working? same here DB.php file is missing

[lucklegend]

Check again the repo mine have db.php but in case you still not find it. get it here. https://www.dropbox.com/s/5gbu3uz4xct39wm/db.php?dl=0

[redx88]

Yes it does. We purposely not to include the file so that it will not be included during synch. Just add the db.php file in the protected/config directory with the following code:

<?php
return array(
    'db'=>array(
        'connectionString' => 'mysql:host=localhost;dbname=ulimsportal',
        'emulatePrepare' => true,
        'username' => '',
        'password' => '',
        'charset' => 'utf8',
        //'tablePrefix' => '',
    ),

    'ulimsDb'=>array(
        'connectionString'=>'mysql:host=localhost;dbname=ulimslab',
        'username' => '',
        'password' => '',
        'class'=>'CDbConnection',
        'charset' => 'utf8',
        //'tablePrefix' => '',
    ),

    'cashierDb'=>array(
        'connectionString'=>'mysql:host=localhost;dbname=ulimscashiering',
        'username' => '',
        'password' => '',
        'class'=>'CDbConnection',
        'charset' => 'utf8',
        //'tablePrefix' => '',
    ),

    'accountingDb'=>array(
        'connectionString'=>'mysql:host=localhost;dbname=ulimsaccounting',
        'username' => '',
        'password' => '',
        'class'=>'CDbConnection',
        'charset' => 'utf8',
        //'tablePrefix' => '',
    ),

    'phAddressDb'=>array(
        'connectionString'=>'mysql:host=localhost;dbname=phaddress',
        'username' => '',
        'password' => '',
        'class'=>'CDbConnection',
        'charset' => 'utf8',
        //'tablePrefix' => '',
    ),

    'information_schema'=>array(
        'connectionString'=>'mysql:host=localhost;dbname=information_schema',
        'username' => 'root',
        'password' => '',
        'class'=>'CDbConnection',
        'charset' => 'utf8'
    )
);

[alikin11]

Hi Sir,

Ok, I try when get home..

thanks

On Wed, Mar 2, 2016 at 10:25 PM, Aris Moratalla notifications@github.com wrote:

Yes it does. We purposely not to include the file so that it will not be included during synch. Just add the db.php file in the protected/config directory with the following code:

<?php return array( 'db'=>array( 'connectionString' => 'mysql:host=localhost;dbname=ulimsportal', 'emulatePrepare' => true, 'username' => '', 'password' => '', 'charset' => 'utf8', //'tablePrefix' => '', ),

'ulimsDb'=>array(
    'connectionString'=>'mysql:host=localhost;dbname=ulimslab',
    'username' => '',
    'password' => '',
    'class'=>'CDbConnection',
    'charset' => 'utf8',
    //'tablePrefix' => '',
),

'cashierDb'=>array(
    'connectionString'=>'mysql:host=localhost;dbname=ulimscashiering',
    'username' => '',
    'password' => '',
    'class'=>'CDbConnection',
    'charset' => 'utf8',
    //'tablePrefix' => '',
),

'accountingDb'=>array(
    'connectionString'=>'mysql:host=localhost;dbname=ulimsaccounting',
    'username' => '',
    'password' => '',
    'class'=>'CDbConnection',
    'charset' => 'utf8',
    //'tablePrefix' => '',
),

'phAddressDb'=>array(
    'connectionString'=>'mysql:host=localhost;dbname=phaddress',
    'username' => '',
    'password' => '',
    'class'=>'CDbConnection',
    'charset' => 'utf8',
    //'tablePrefix' => '',
),

'information_schema'=>array(
    'connectionString'=>'mysql:host=localhost;dbname=information_schema',
    'username' => 'root',
    'password' => '',
    'class'=>'CDbConnection',
    'charset' => 'utf8'
)

);

— Reply to this email directly or view it on GitHub https://github.com/dost-onelab/ulims/issues/1#issuecomment-191257743.

[alikin11]

Hi Sir,

what about phaddress.sql? Where can i find it?

On Thu, Mar 3, 2016 at 5:26 PM, Almanzur manzaxelross2015@gmail.com wrote:

Hi Sir,

Ok, I try when get home..

thanks

On Wed, Mar 2, 2016 at 10:25 PM, Aris Moratalla notifications@github.com wrote:

Yes it does. We purposely not to include the file so that it will not be included during synch. Just add the db.php file in the protected/config directory with the following code:

<?php return array( 'db'=>array( 'connectionString' => 'mysql:host=localhost;dbname=ulimsportal', 'emulatePrepare' => true, 'username' => '', 'password' => '', 'charset' => 'utf8', //'tablePrefix' => '', ),

'ulimsDb'=>array(
    'connectionString'=>'mysql:host=localhost;dbname=ulimslab',
    'username' => '',
    'password' => '',
    'class'=>'CDbConnection',
    'charset' => 'utf8',
    //'tablePrefix' => '',
),

'cashierDb'=>array(
    'connectionString'=>'mysql:host=localhost;dbname=ulimscashiering',
    'username' => '',
    'password' => '',
    'class'=>'CDbConnection',
    'charset' => 'utf8',
    //'tablePrefix' => '',
),

'accountingDb'=>array(
    'connectionString'=>'mysql:host=localhost;dbname=ulimsaccounting',
    'username' => '',
    'password' => '',
    'class'=>'CDbConnection',
    'charset' => 'utf8',
    //'tablePrefix' => '',
),

'phAddressDb'=>array(
    'connectionString'=>'mysql:host=localhost;dbname=phaddress',
    'username' => '',
    'password' => '',
    'class'=>'CDbConnection',
    'charset' => 'utf8',
    //'tablePrefix' => '',
),

'information_schema'=>array(
    'connectionString'=>'mysql:host=localhost;dbname=information_schema',
    'username' => 'root',
    'password' => '',
    'class'=>'CDbConnection',
    'charset' => 'utf8'
)

);

— Reply to this email directly or view it on GitHub https://github.com/dost-onelab/ulims/issues/1#issuecomment-191257743.

[alikin11]

Hello Sir,

Everything is ok now but i cannot login to admin?

what is the username and password for admin?

On Thu, Mar 3, 2016 at 8:50 PM, lucklegend notifications@github.com wrote:

here some records it is not complete yet... but you can use this

https://www.dropbox.com/s/m4j96ff244guswa/phaddress.sql?dl=0

— Reply to this email directly or view it on GitHub https://github.com/dost-onelab/ulims/issues/1#issuecomment-192104528.

[alikin11]

i go to ulimsportal database at user table. . .i used entry there but still i cannot login. . .

On Fri, Mar 4, 2016 at 1:56 AM, Almanzur manzaxelross2015@gmail.com wrote:

Hello Sir,

Everything is ok now but i cannot login to admin?

what is the username and password for admin?

On Thu, Mar 3, 2016 at 8:50 PM, lucklegend notifications@github.com wrote:

here some records it is not complete yet... but you can use this

https://www.dropbox.com/s/m4j96ff244guswa/phaddress.sql?dl=0

— Reply to this email directly or view it on GitHub https://github.com/dost-onelab/ulims/issues/1#issuecomment-192104528.

[alikin11]

i go to ulimsportal database at user table. . .i used the entry there but still i cannot login. . .

On Fri, Mar 4, 2016 at 2:08 AM, Almanzur manzaxelross2015@gmail.com wrote:

i go to ulimsportal database at user table. . .i used entry there but still i cannot login. . .

On Fri, Mar 4, 2016 at 1:56 AM, Almanzur manzaxelross2015@gmail.com wrote:

Hello Sir,

Everything is ok now but i cannot login to admin?

what is the username and password for admin?

On Thu, Mar 3, 2016 at 8:50 PM, lucklegend notifications@github.com wrote:

here some records it is not complete yet... but you can use this

https://www.dropbox.com/s/m4j96ff244guswa/phaddress.sql?dl=0

— Reply to this email directly or view it on GitHub https://github.com/dost-onelab/ulims/issues/1#issuecomment-192104528.